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
link open processing error
Moderators: chulett, rschirm, roy
link open processing error
Thanx&Regards
scorpion
scorpion
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Error message
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]
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]
Thanx&Regards
scorpion
scorpion
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?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 16
- Joined: Sun Apr 17, 2005 11:27 pm
Re: link open processing error
Try running the Job with Array Size and Transaction size as 1. :D