Universe Stage Problem.

Gokul · Post by **Gokul** » Thu Jun 09, 2005 8:02 am

Hi,

I tested for a Job containing Universe Stage on my Local Machine.(i.e Server installed on My Local Machine).
But when i tried the same job on our Production Server, it gave error.

sample1..UniVerse_13.IDENT1.DSLink8: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE "T2RngGT" SET RNG_TYP_NME = ?, RNG_CDE = ?, RNG_CDE_DESC = ?, RNG_LWR_LMT_NBR = ?, RNG_UPR_LMT_NBR = ?, PRCS_DTE = ? WHERE (RNG_TYP_NBR = 1)
SQLSTATE=S1000, DBMS.CODE=930164
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Parameter marker 2 does not match expected data type.
SQLSTATE=S1000, DBMS.CODE=930121
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: CursorDefineParam failure.

For using Universe Stage do we need to alter some setttings.

Gokul

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 09, 2005 8:21 am

Is it a user-defined SQL. Check the data type of second column in the link.

ArndW · Post by **ArndW** » Thu Jun 09, 2005 8:22 am

It looks like the table (UniVerse file) is declared differently in each environment. Use the Manager to read in the column descriptions in both environment and compare them.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2005 3:10 pm

Specifically, check that the data type if RNG_CODE is the same in DataStage as it is in UniVerse. This is the column name associated with the second parameter marker.

Always read everything in the error message.