Page 1 of 1
Error Message - "DSP.Open GCI $DSP.Open error -100"
Posted: Sat Feb 10, 2007 3:41 am
by pg_smh
I am getting the following error message - "DSP.Open GCI $DSP.Open error -100" while running a server job. Data is being pulled from DB2 datasource.
Posted: Sat Feb 10, 2007 3:51 am
by kumar_s
Hi and Welcome to Dsxchange :D !!!
There should be other valid error code along with this error message.
Just with this message, we can guess various reasons like, Wrong SQL query, incompatable datatype, wrong column name specification.
You need to give more details about the job as well as the error message and as well as the query.
Try to execute the same query from command prompt and ensure the correctness.
The series of messages are as follows
Posted: Sat Feb 10, 2007 3:58 am
by pg_smh
1. Warning - Error occurred during link open processing. (while sending data to the Lookup transformer)
2. warning - DSP.Open GCI $DSP.Open error -100.
3. Fatal - DSP.Open GCI $DSP.Open error -100 (while sending data to the error transformer)
If the SQL query for pulling data from the source is run at the backend database, then rows are returned, but when this data goes to the transformer for lookups, then the following messages are encountered.
Posted: Sat Feb 10, 2007 5:01 am
by ray.wurlod
$DSP.Open is the function used to connect to DB2.
Verify that all the connection information goven in the stage is correct and that, if needed, the DB2 client software is correctly installed and configured.