Page 1 of 1
link open processing error
Posted: Mon Dec 04, 2006 7:39 am
by scorpion
Hi
Im trying to insert records into a dynamic RDBMS stage using different links having the same metadata.
But Im getting an error "Error occurred during link open processing"
I checked the metadata for all links.They are the same.
What could be wrong?
thanks in advance
Posted: Mon Dec 04, 2006 8:00 am
by DSguru2B
Do an exact search on "Error occurred during link open processing". It reveals a few posts. See if they help.
Posted: Mon Dec 04, 2006 4:01 pm
by ray.wurlod
Read the entire error message. Does it tell you which stage, which link?
Error message
Posted: Tue Dec 05, 2006 1:05 am
by scorpion
Yes.
It is pointing to one of the links to the target table.But I checked that link and it is just like any other link into that table.
The error message is
"DSP.Open GCI $DSP.Open error -100."[/quote]
Posted: Tue Dec 05, 2006 1:21 am
by kumar_s
What if you convert the database stage into sequential stage for the newly added field. If the error disappears, you can find the difference between the other links to that. Have you tried with the IPC as suggested in some previous post?
Re: link open processing error
Posted: Tue Dec 05, 2006 5:02 am
by poornimajayan
Try running the Job with Array Size and Transaction size as 1. :D