shikha1610

Please Help me,When I am running the job to fetch data from Oracle DB table and Insert into another Oracle DB table,1310000 records are being inserted succesfully.After that it is throwing the Error "Numeric Overflow".Below is the detailed Error Code. Please Solve it its Very Urgent. Thanks, Shikha Exception in component tOracleInput_1 java.sql.SQLException: Numeric Overflow at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797) at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121) at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489) at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567) at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212) at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128) Code:Exception in component tOracleInput_1java.sql.SQLException: Numeric Overflowat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)

Hi, While running an etl job i get the following error Exception in thread "main" java.lang.OutOfMemoryError: Java heap spaceHow to overcome this?Thanks in advanceShikha

Hi, Thanks for your quick reply. I am using Adhoc launcher of Jasper Server pro 3.0 for adhoc reporting and want to use logged in username in query. I tried this by export and import of domain into XML but it is not working. I also want to know how to get JRXML for a topic so that it can be modified using iReport to include your suggestion i.e. $P{LoggedInUser}.getUsername() Shikha

How to use Variable in Jasper Report? How to use variable in SQL of Jasper Report.If I want to use current user name or any other ariable in report for filter pupose then what is the way?How to get current user name? I am using windows OS,please suggest me the solution.I am waiting for your response. Thanks in advance. Shikha

I have generated a job in JasperETL all things are without any error but when I run it gives error "Stream has already been closed".Detailed error has been given below.Please solve this problem its urgent. Error:-------------------- Starting job Load_Parking_Dim3 at 20:42 05/11/2008. Exception in component tOracleInput_1 java.sql.SQLException: Stream has already been closed at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:166) at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:207) at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:362) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:362) at fontera_etl.load_parking_dim3.Load_Parking_Dim3.tOracleInput_1Process(Load_Parking_Dim3.java:1560) at fontera_etl.load_parking_dim3.Load_Parking_Dim3.runJobInTOS(Load_Parking_Dim3.java:1994) at fontera_etl.load_parking_dim3.Load_Parking_Dim3.main(Load_Parking_Dim3.java:1910) job Load_Parking_Dim3 ended at 20:42 05/11/2008. [exit code=1] Thanks, Shikha

I want to use current username in report i.e.in codition or variable.Is it possible to use username(session variable) in report for row level security? Where is stored current user name?How to access this name in report? Please reply ASAP its urgent. Thanks, Shikha

Hi, Can anyone plz tell me the steps of integrating weblogic 10 application server with jasperserver pro 3.0 Thanks in advance, Shikha