DSXchange

Hi Ray/Craig, We are using the same Database for both DS7.1 and DS7.5.2 which is in UTF-8. Also I have checked the Datastage Server Maps and the Parallel maps in both the setup. They are exactly same. Also both the setup are on the same box and the same locale is used by both. Local -a command outpu...

Hi Craig, I checked with our solution support team (unix Guru in our project) but they are also not aware of this issue. In addition we are also having some other weird problems as given below. 1> Our process archives the output file in a archive directory and appends the file name with the current ...

Hi,

Can anyone help me with my above given query?
Waiting desperately for your response

Regards,
Abhishek

While running the process on D7.5.2 we get the following warnings. Warning! One or more of your selected locales are not available. Please invoke the commands "locale" and "locale -a" to verify your selections and the available locales. Continuing processing using the "C&quo...

Hi, We are migrating an application from DS7.1 to DS7.5.2. While testing we have come up some issues as described below: The source data has some special characters like "" (Arrow). In DS 7.1 this character comes correctly in the output, but in DS 7.5.2 it gets converted into some junk cha...

Yes, Hash partitioning on both the input links will solve this issue.

Hi,

Its working fine now. There was a spelling mistake in the protocol used.

Regards,
Abhishek

There isn't any Sort/Merge Collectore with this column "MCACC" as the key. Thankfully this issue is fixed now. I have changed the Join key name from "MCACC" to "MCACC_KEY" (in both the left and right links) and I am not getting this warning anymore. Thanks a lot for hel...

Hi ArndW, The runtime column propagation has been disabled in the job which is running fine. Also the output files of this job doesn't have this field MCACC. In the first job (which runs fine) the output files are overwritten. While in the other 2 jobs (with warnings) I am appending the output to th...

Hi, I am getthing the following warning in one of my jobs: main_program: Sort key "MCACC" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector main_program: There are no sort keys in the dataset schema. No sortmerge collector will be inserted. In thi...

Sure Ray,

I will create a new topic.

Regards,
Abhishek

Thanks jseclen, I thought it was due to space issue on scratch disk. In one of the job I have used a sort stage with no limit on memory usage (i.e. I havent set "Restrict Memory Usage" property). But this job has also aborted before. These job aborts randomly. It will abort now but on the ...

Hi, These days we are facing space issues on our development server. Our parallel jobs are frequently aborting with the following message. Join.Right_ecdi_account_Sort,3: Failure during execution of operator logic. Join.Left_aibm17_Sort,1: Fatal Error: mmap failed: Not enough space When we try to co...

Thanks ArndW,

It works!!

Regards,
Abhishek

Hi, I am having a pipe delimited file as imput which is created from a fixed width file. Blank value in numeric fields in the pipe delimited file is represented as "0", "00", "000", "00.00", "000.000" etc depending upon the width of the column. I wis...