Exception raised in GCI subroutine

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
metabill
Premium Member
Premium Member
Posts: 26
Joined: Wed Aug 27, 2003 9:55 am

Exception raised in GCI subroutine

Post by metabill »

My server job ends with an ODBC insert into a SQL Server table. Every job run hangs/aborts at this point, and eventually reports:

From previous run
DataStage Job 22 Phantom 3388
Program "DSD.BCIPut": Line 204, Exception raised in GCI subroutine:
Access violation.
Program "DSD.BCIPut": Line 204, Exception raised in GCI subroutine:
Unknown exception code.
Unhandled exception raised at address 0x7C9501CC : Unknown exception code
Aborting DataStage...

Other jobs insert successfully to tables in the same database. I can manually run the generated SQL successfully. If I write to a sequential file instead of the table, it succeeds. I've tried restarting the DataStage services.

Please let me know if you have any insight/tips; thanks.

-Bill
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Try resetting the job and looking at or posting the "from previous run..." entry in the log file.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Hmmm... believe we're already got one of those posted. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply