Hi,
Im using DB2 connector as look up to transformer and using SQL inside the connector for look up. when i run the job, the get the error "DSP.OpenGCI $DSP.open error -100" and a warning "schema reconciliation failed : the column names defined on the link donot match with that of the external resource". i checked all the columns and all look fine. as i have seen in one of the posts, i deleted and recreated the stage and link but still same error.
Please help.
DSP.OpenGCI $DSP.open error -100
Moderators: chulett, rschirm, roy
Re: DSP.OpenGCI $DSP.open error -100
DSP Open Errors commonly occurs due to below listed one's
1. Metadata Mismatch such no of columns mismatch
2. Wrong Credentials
But as per your post, It is Type 1 of above listed
Thanks
1. Metadata Mismatch such no of columns mismatch
2. Wrong Credentials
But as per your post, It is Type 1 of above listed
Thanks
Thanks
Ravi
Ravi