DSXchange

Hi All, I am not able to open any of my jobs. Today our project was locked. After getting unlocked by administrator, when I am trying to open any job, it is giving me message "Cannot Open file DS_JOBOBJECTS". Can anybody help me in this? Appreciate your prompt Response. MERRY CHRISTMAS to ...

Hi, I am facing severe problems with connection. The server is at remote location. Previously we had Version 6 and now we have migrated to Version 7. But now since last few days connection is breaking many a times. On observing it closely, I found that whenever I click Cleanup Resources, connection ...

Hi, I got some info on the problem I'm facing. I have two jobs that are creating Data Sets as the output. After that one job merges these two data sets to create the final sequential file output. When I run the jobs with One Node configuration, everything works fine. But when I run the jobs with 4 n...

My job consists of 2 join stages to join 3 Datasets. When i run this job it aborts immediately with the following error message. "main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel APT_JoinSubOperator in JnsTgtCol_1. The number o...

Hi BP,
There are soooooooo many RT_BP files i.e. RT_BP1, RT_BP2.....RT_BP400 etc.........

Pls let me know how can i identify the file for particular job.
Appreciate if you can tell me the significance of thie RT_BP files also.

Thank & Regards
Pinkesh

Hi BP,
There are soooooooo many RT_BP files i.e. RT_BP1, RT_BP2.....RT_BP400 etc.........

Pls let me know how can i identify the file for particular job.
Appreciate if you can tell me the significance of thie RT_BP files also.

Thank & Regards
Pinkesh

Hi BP,

Thanks for your time.

Pls let me know where can i see this generated OSH script?

Thanks and Regards
Pinkesh

Hi,
I have a date field coming in the format MMDDYYYY. I have to check for it's validity i.e. whether it is a valid date or not and I have to check for the format of the date i.e. incoming date is in MMDDYYYY format or not.

What is the best way to do this validation?

Thanks & Regards
Pinkesh

Hi, I am getting the following error when i am running the same job with an input file containing 300K records. "CopyOfGTLJB0500.#0.TrmMfdDaysSinceLastVisitQty.LkFromBOMitmMfdW-Input.LkFromBOMitmMfdW: ds_ipcgetnext - timeout waiting for mutex." And I am getting the following error even whe...

Hi,
Is this happening because of space? The Same job when rane with much lesser data is working fine.
Pls let me know what can be the solution for this?
How can we optimize the space requirement?

Thanks & Regards
Pinkesh

Hi, My Datastage jobs which were running fine with certain input files have started aborting when i changed the input files. The input file is a Fileset. Iam getting the below error when i run the DataStage job with a certain input FileSet. "APT_ParallelSortMergeOperator: Error when checking op...

Hi,
Is there any command line utility or utility provided by Data Stage which can convert Data Sets to Sequential files?

Also wanted to know, which occupies more space Data Sets or Sequential files?

Appreciate if anybody can help me in this.

Thanks & Regards
Pinkesh

Hi Ken,

Thanks a lot.

Pls let me know the reason for connection break. Actually, all my developers are losing connection because of this and hence are not able to work at their best.

Regards
Pinkesh

Hi, I'm facing a strage problem. As soon as I go to Job ->Cleanup Resources in Director, my connection in designer breaks. I've tried this many a times today. My job is in Aborted state. When I try to compile it, it says Unable to write to RT_CONFIGxxx file and fails to compile. When I do Clear Stat...

Hi Teej,

Thanks a Lot.

It's working now.

Regards
Pinkesh