Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Issue - java.sql.SQLException: Unexpected token: ) in statement [select ..]

AravindhKAug 6 2015 — edited Aug 7 2015

Hi,

I am using ODI 10.1.3.6.10 and getting below error message while running a package. This package is used to load the  Please could you help me to resolve this issue.

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

Traceback (innermost last):

  File "<string>", line 24, in ?

java.sql.SQLException: Unexpected token: ) in statement [select ...]

Also I am getting below exception in another package although it is running without failure.

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

Traceback (innermost last):

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

Essbase Data Extract Summary:

  Number of rows successfully processed: 1344

  Number of rows rejected: 0

Thanks,

Aravindh K
This post has been answered by SH_INT on Aug 6 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2015
Added on Aug 6 2015
#business-intelligence-applications, #data-integrator, #system-management-and-integration
7 comments
3,122 views