DSXchange

Hello,
I made the experience, that it always comes to deadlocks with "upsert", when using mutiple nodes and having duplicates records (with respect to the defined keys).
So i think, that it can happend both nodes try to update the same record.
Manfred

sorry, i didn't read the second page of posts
Manfred

Hello,
i use to check dates with "IsValid" in a Transformer
If IsValid('date',StringToDate(L1.LOANAF_DAT_CRE,"%yyyy%mm%dd")) then ... else ...
Manfred

Hello,
i just want to understand the sence/meaning of this parameters:
DSWaitResetTimeout
DSWaitResetStartup
DSWaitStartup

Can anybody give me any information ?

Manfred

together with IBM we solved the problem
there was an old/wrong ODBC-driver-version

Chulett, thanks for your feedback. I see, that we currently have set only this DSWaitStartup=60 and not the other 2 parameter mentioned. As these parameters are set under "user defined" variables, i would expect, i can set and change them. Can anybody tell me the usage / meaning / purpose ...

Hello,
one additional hint:
i seems, that this timeout often come when waiting for Oracle feedback

Is there any special parameter setting for this waiting time?

Hello, i have the problem, that many of our datastage jobs get a timeout -14 DSJE_TIMEOUT when the maschine is very busy. All other jobs on the same maschine like pure Unix/SQL-Loader don't fail, they just run longer. Therefore my question is, whether i can set any datastage parameters so that the j...

Hello,
sounds, that you have one job with 2 orcacle steps updating the same table?
I would do both updates in separate jobs, one after the other.
Best regards
Manfred

ppid=3031124:pi 3ce008:1 ENTER SQLSetEnvAttr SQLHENV 0x30194d88 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 3 SQLINTEGER 0 ppid=3031124:pi 3ce008:1 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x30194d88 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 3 SQLINTEGER 0 ppid=30311...

Hello Eric, yes i also tried without this \UIP_ALM, but it didn't work. Without this entry the job runs 1 second. With this entry it runs 10 seconds. So it seems to do something more ... Also i need this entry when setting up an ODBC connection to Microsoft Access DB. Therefore i guess, \UIP_ALM is ...

Hello, i try to setup a ODBC Connection to a MSSQL-Database Well, i have searched in this Forum several hours ... tested all hints given ... now i have no further idea ????? Everythink looks fine ! odbc.ini (part) --------- [UIP_ALM] Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so...

I searched in hundrets of posts here ...
In on post i found the same problem ... there it was told, that upsert instead of append works.
I tested it ... and found the same.
So i would know a workaround.
But what is the reason ???
Manfred

Hello Ray, i changed the field to LongVarChar ... but still get the same error. Meanwhile i found, that char has this limit of 255, or? The Loader-Log looks like: SQL*Loader: Release 10.2.0.4.0 - Production on Wed Jun 22 12:01:07 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Control Fi...

Hello, some further information: 255 / 256 really seems to be the threshold. Fields with 255 length are possible; 256 not. Even if i read from an existing oracle e.g. a field with varchar 1000, the job fails when writing this into an other oracle table. Even, if i try to load 256 in a field with len...