link open processing error

scorpion · Post by **scorpion** » Mon Dec 04, 2006 7:39 am

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

DSguru2B · Post by **DSguru2B** » Mon Dec 04, 2006 8:00 am

Do an exact search on "Error occurred during link open processing". It reveals a few posts. See if they help.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 04, 2006 4:01 pm

Read the entire error message. Does it tell you which stage, which link?

scorpion · Post by **scorpion** » Tue Dec 05, 2006 1:05 am

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]

kumar_s · Post by **kumar_s** » Tue Dec 05, 2006 1:21 am

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?

poornimajayan · Post by **poornimajayan** » Tue Dec 05, 2006 5:02 am

Try running the Job with Array Size and Transaction size as 1. :D

DSXchange

link open processing error

link open processing error

Error message

Re: link open processing error