Odd error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Odd error

Post by JDionne »

I have been getting this error with one of my jobs

JOCPOPDEVEXPORTSTEP1Test..Scrbbususcnc01: Internal error: Failed to IRowsetFastLoad interface.

first i thought it was the spliter that I had in the job so i took that step out. the only thing left was the bulk load to the SQL server. I am in the middle of an acidental shrink db on my server, dont ask :)
is there a chance taht this error is resulting from not getting access to that table?
Jim
Sure I need help....But who dosent?
Top
Vipin
Participant
Posts: 15
Joined: Thu Oct 16, 2003 4:05 am
Location: India

Post by Vipin »

Hi,
According to my limited knowledge of SQL Server , bulk load drops the constraints if any ,on the object you are trying to insert data. Then it inserts data and recreate the constraints.
Although, shrink database command does not lock the object,but probably it wont be allowing you to alter the table definition, coz of bulk load's nature.
You can use ODBC stage instead.

Regards,
Manoj.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”