DSXchange

the problem was with the dollar sign it should have been # for the parameter which was screwing up everything.

thanks to narasimha and dsguru.

but that is a database variable how can i change that

in job parameter i do not see a timestamp option

ODBC_Enterprise_5.0: ERROR: Bad timestamp external representation ' $sym_date'

I do not know i to copy from director and paste it reads as folllows
odbc_enterprise_5.0 error bad timestanp external representation

in the database it is a timestamp and i want only the date and i used left(dbvariable,10) and compared it with the date which is yyyy-mm-dd and it tells me bad timestamp external representation

actually i am running only 1 job , i am not doing many jobs .

when i get error regarding node1 node2 it is definitely the configuration file.

why dont you send me a sample of the config file.

config file only contain node1,node2 etc.
also I see the message
DBC_Enterprise_0,0: sendWriteSignal() failed on node ponny21 ds = 0 conspart = 1 Broken pipe

node_node1: Player 2 terminated unexpectedly.
main_program: Unexpected exit status 1

what I see there is exactly the same as that I see from manager client.

because that is not working properly and giving error (fatal) I want to check with somebody

can anyone give me the contents of
/usr/local/Ascential/DataStage/Configurations/default.apt file