7 Replies Latest reply on Jun 15, 2015 10:59 AM by Chuggans-Oracle

    ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>

    1008490

      Hi All,

       

      I am trying to load data from oracle table to Hyperion planning account table. while executing the inter face i am getting below error. Please suggest me.

       

      org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 2, in <module>

      Planning Writer Load Summary:

        Number of rows successfully processed: 0

        Number of rows rejected: 0

       

       

        at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

        at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

        at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

        at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

        at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

        at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

        at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:376)

        at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:309)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:301)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865)

        at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)

        at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

        at java.lang.Thread.run(Thread.java:662)

       

      Thanks in advancs

       

       

      Regardas,

      Vinod

        • 1. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
          JohnGoodwin

          That is not really an error to be concerned about, it is the way the statistics are reported and the error can be ignored.

          The imported part is that 0 rows were processed and 0 rejected.

           

          Cheers

           

          John

          • 2. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
            1008490

            Thanks for your quick reply. Pls find detail information below..

             

            Log Information:

            2015-06-15 13:03:00,516 INFO  [SimpleAsyncTaskExecutor-42]: Successfully connected to the planning application.

            2015-06-15 13:03:00,517 INFO [SimpleAsyncTaskExecutor-42]: The load options for the planning load are

            Dimension Name: Account Sort Parent Child : false

            Load Order By Input : false

            Refresh Database : false

            2015-06-15 13:03:00,559 INFO [SimpleAsyncTaskExecutor-42]: Begining the load process.

            2015-06-15 13:03:00,563 DEBUG [SimpleAsyncTaskExecutor-42]: Number of columns in the source result set does not  match the number of planning target columns.

            2015-06-15 13:03:00,563 DEBUG [SimpleAsyncTaskExecutor-42]: Number of columns in the source result set does not  match the number of planning target columns.

             

             

            Error Information:

            • org.apache.bsf.BSFException: exception from Jython:

            Traceback (most recent call last):

              File "<string>", line 2, in <module>

            Planning Writer Load Summary:

            Number of rows successfully processed: 0

            Number of rows rejected: 0

             

            at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

            at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

            at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

            at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

            at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

            at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

            at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

            at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

            at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

            at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:376)

            at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

            at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:309)

            at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:301)

            at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865)

            at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)

            at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

            at java.lang.Thread.run(Thread.java:662)

            Caused by: Traceback (most recent call last):

             

             

            Thanks in advance...

            • 3. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
              JohnGoodwin

              There are still no problems on the information you have provided, did the interface run successful, yes, well it didn't load any records so you need to investigate to why, look at the SQL being generated in the operator and run against your source.

               

              Cheers

               

              John

              • 4. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
                1008490

                HI John, my interface successfully executed. i checked the sql query in database, it is executing successfully...

                 

                Sql Statement:

                sql= """select   H_ACCOUNT.ACCOUNT    "Account",H_ACCOUNT.PARENT    "Parent",H_ACCOUNT.DEFAULT_ALIAS    "Alias: Default",H_ACCOUNT.DATA_STORAGE    "Data Storage",H_ACCOUNT.TWO_PASS_CALCULATION    "Two Pass Calculation",H_ACCOUNT.MEMBER_FORMULA    "Formula",H_ACCOUNT.DATA_TYPE    "Data Type",H_ACCOUNT.OPERATION    "Operation",H_ACCOUNT.ACCOUNT_TYPE    "Account Type",H_ACCOUNT.TIME_BALANCE    "Time Balance",H_ACCOUNT.SKIP_VALUE    "Skip Value",H_ACCOUNT.EXCHANGE_RATE_TYPE    "Exchange Rate Type",H_ACCOUNT.VARIANCE_REPORTING    "Variance Reporting",H_ACCOUNT.SOURCE_PLAN_TYPE    "Source Plan Type",H_ACCOUNT.AGGREGATION    "Aggregation (Consol)" from BISAMPLE.H_ACCOUNT   H_ACCOUNT  where  (1=1)  """ 
                • 5. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
                  JohnGoodwin

                  So you are saying if you run the SQL generated by ODI directly against the database it is returning records but the same SQL in ODI is not returning any records, I would be surprised.

                  • 7. Re: ODI Error: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last):   File "<string>", line 2, in <module>
                    Chuggans-Oracle

                    Given that you're seeing 0 rows processed and 0 rows rejected that sounds to me like no rows were loaded on to the staging area (or they're getting filtered out at a later stage). What do you see in the 'Row Count' column if you check the ODI Operator log on the 'Load data' step?

                    If you're seeing 0 rows then that just sounds to me like no rows of data are making it as far as the staging table possibly. If data really is being extracted from the source then you need to concentrate on the step where the rows of data which have been imported get filtered out (i.e. the first step where you see 0 rows).

                     

                    Regards

                     

                    Craig