Error with bulk load

samyamkrishna · Post by **samyamkrishna** » Fri Aug 24, 2012 7:24 am

Hi,

I am using a oracle connector stage.

When it runs in insert mode the job runs fine.

But when i change the load to bulk mode the job aborts with the following error.

"Oracle_Connector_676,0: [IIS-CONN-ORA-001003] The OCI function OCIDirPathPrepare returned status -1. Error code: 600, Error message: ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]. (CC_OraLoad::prepareDirectPathLoad, file CC_OraLoad.cpp, line 1,246)"

Any halp will be greatly appreciated.

REgards,
Samyam

chulett · Post by **chulett** » Fri Aug 24, 2012 7:28 am

ORA-00600 errors are a catch-all "something really bad happened but I can't tell you what" kind of error. You should probably take it to your DBA and see what they can find in the alert log. Are you able to buk load the table outside of DataStage? If nothing turns up on the Oracle side, I would suggest taking the issue to your official support provider.

ArndW · Post by **ArndW** » Fri Aug 24, 2012 8:15 am

My first guess would be that the userid you are using doesn't have sufficient rights in the database to drop/build indices as the bulk loader is wont to do.

chulett · Post by **chulett** » Fri Aug 24, 2012 9:12 am

That will probably be an eventual issue but something that simple really shouldn't throw a 600. [shrug]

ArndW · Post by **ArndW** » Fri Aug 24, 2012 9:32 am

Hmmmm... does sound awfully "harsh" as an error message for insufficient access rights.

samyamkrishna · Post by **samyamkrishna** » Fri Aug 24, 2012 10:54 am

Allrite will go back the BBA's and check what this is.

samyamkrishna · Post by **samyamkrishna** » Mon Aug 27, 2012 6:39 am

DBA's have no solution for this.

Used an Oracle Enterprise stage to avoid this error.

chulett · Post by **chulett** » Mon Aug 27, 2012 7:09 am

chulett wrote:If nothing turns up on the Oracle side, I would suggest taking the issue to your official support provider.