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!

LKM MSSQL to Oracle (BCP/SQLLDR) Error at step Call SQLLDR via Jython

Muhammad AqeelMay 22 2013 — edited May 22 2013

Hi,

I am trying to load data from SQL server 2005 to Oracle 11g. I am using ODI 11.1.1.7 on windows 7 professional and stuck with very bad error which does not give any clue. Your help will be highly appreciated.

Error:

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 22, in <module>
SQLLDR failure(s): 1 / sqlldr control=D:/TempODI/X2300011.ctl log=D:/TempODI/X2300011.log userid=posdata/posdata@DWHDB > D:/TempODI/X2300011.out

Generated command if executed directly from the command line is successfully executed and data is loaded.

SQL loader is called as I can see the control file, BCP file in the temp directory but data is not loaded into staging area table. I am stuck for 3 days with it and even Oracle support is finding it difficult to find exact reason of error. Any one who experienced such case may give us a clue and it will me much appreciated.

best regards,
Muhammad

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on May 22 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

540 views