DSXchange

it is taking long time or some time getting hung

i want to know can we increase or decrease the timeout in data stage jobs ,i have some jobs which are hanging or slowing down

Hi all i just want to know how can we set time out in data stage ?

Thanks in advance

FOR update UPDATE #ITR_PBLMTYPE_TABLE_NAME# SET EDW_END_DT = ORCHESTRATE.EDW_END_DT, EDW_ROW_STATUS_CD = ORCHESTRATE.EDW_ROW_STATUS_CD WHERE (PROB_TYPE_ID_SEQ = ORCHESTRATE.PROB_TYPE_ID_SEQ and VERSION_NO = ORCHESTRATE.VERSION_NO) FOR INSERT INSERT INTO #ITR_PBLMTYPE_TABLE_NAME# (PROB_TYPE_ID_SEQ, V...

Hi i am running a parallel job which has inserts and updates logic database i am using is SQL server i am geting this error main_program: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '25'. i am not using 25 anywhere in the query then y is it giving this error any help will be...

where can we find the option to enable/disable RCP i dont find in CDC stage can any one please help me out

Thanks

hi tejaswini , just want to know i am using PX 7.5.2 i dont find RCP option in CDC stage in output tab --> columns .is it not present for my version?

this seems to be database issue contact ur DBA

Hi all i am running a parallel job with CDC , ,transformer,Sort and Join Stages i am gettin warning and fatals, job is aborted. warning: Transformer_226: Error when checking operator: When binding input schema variable "APT_TRinput0Rec0": Transfer adapter is dropping non-existent field &qu...

error shows that u r running out of space .......try cleaning the scratch space.

try what salil suggested if that doesnt help u try with a look up stage .

it shows that u have a pipe in ur data which is taken as delimiter by datastage creating a new column which doesnot exist ....u need need to figure out which field has data which contain pipe .......what i wud do is create a small job seq file1----Transformer-----seqfile2 and put a seqfile3 to seqfi...

what is the log u r getting for this error ? what u mentioned above is a warning .is ur job getting aborted or just rejecting some records

where r u storing the rejected records?

check the data types ......as u have a reject link all the records rejected with this warning should be collected by this reject link try to analyze the data in ur reject file .