DSXchange

Hi, I am also having similar warnings in my job. :( main_program: Sort key "MCACC" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector I am doing a join and then splitting the output into 7 output files in a transformer after the join. The join key ...

I got the reason for this error.

In the trasnformer where mapping is done, I have used a function IsValid to check if a date is valid.
If I remove this function then the job runs fine.

Regards,
Abhishek

Hi, I am getting the following error in a Px job: APT_CombinedOperatorController,1: Expected identifier; got: "2003" Does anyone know how to resolve this error? I couldnt find a solution for this in the existing posts. In the job I am doing a join between 2 sequential files. After the join...

Yes Ray,

We have a line terminator at the end of the last line.
Please find below the format of the sqlhost entry made by us:

<db_instance_name> onsoctp <server_name> <port_number>$
$

Regards,
Abhishek

Hi, We are trying to connect to informix database using Informix Enterprise stage. Inorder to enable the connection we have made an entry in the sqlhosts file. But the connection is aborting with error "Invalid sqlhosts file format". The format we entered is correct. The format is matching...

Perhaps you are having Field001 nullable Yes, but did not handle it. You can handle it by clicking the target Sequential_File_8 stage and do the following Goto Input>Columns. Double Click the serial number assosciated with the column at left. You get Edit Column MetaData Go to Nullable option Click...

Thanks a lot

Thanks chulett, The parameter LD_PRELOAD is set as follows in dsenv. LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl I guess commenting this command will resolve the issue. But what impact does it have on other processes/application. I mean whats the significance of this parameter? Actu...

Hi guys, I am also facing similar error. I am working on HP-UX 11.11. In some other thread I saw that this reason for this error was the usage of korn script. I removed the ksh command from the script calls in all the jobs. It worked fine for some jobs but didnt for others. In this particular job we...

Thanks Guys,

I too faced similar issue. The script was called using an KSH command.
I removed it and now its working fine.

Thanks a lot

Regards,
Abhishek

Hi Guys,

You are right. We have a routine with the same name in the project.
I have renamed the routine and now I am able to compile the sequencer containing the nested condition stage.

Thanks a Lot for the help.

REgards,
Abhishek

The problem is in only this job parameter. It works fine with all other job parameters. When I change the spelling of this job parameter then it works. As said earlier this job parameter comes from a job parameter file created by a VB tool. Hence in order to change this parameter name it will involv...

Hi, We have a nested condition stage in one of the jobs in DS 7.5.2. The stage should call link A if the job parameter AcctCustMapOnly is "N" else call link B. But the stage gives error "Expected: left parenthesis ("(")" in the custom condition AcctCustMapOnly = "Y...

i tried doing null handling and passed "" for null records but again it gave the same warning. The record gets inserted throught the Oracle client. Also the same data file was loaded without any warnings with Oracle Enterprise, ODBC Enterprise (both in Parallel) and ODBC stage in SErver. O...

Hi, We are loading some data in Oracle table using Oracle OCI stage in Server Jobs. The Input has has NULL values in one of the date fields. While loading the data it gives warning message as shown below per record having NULL value as date. Test_MDM1..Transformer_15: At row 1, link "Eff_Date&q...