DSXchange

Hello all, On day one of my new job I have been asked to come up with a solution for the following issue. Here for the daily incrementals to the datamart tables, datastage PX jobs that isert/update the tables call an after job routine that captures the statistics in an xml file with <Project name><J...

Hi, I am extracting XMl file from a sequential stage using file pattern option with the following wildcard option *.xml Well, I need to specify the formats in sequential stage as what type of format, the xml file has i.e fixed width or delimiter or record field formats etc Please suggest me, What fo...

Hi ! My Job Structure is as follows: <b> Seq Stage ---> XML input ---> TX Stage----> Lookup File set </b> The problem is in the Seq stage, the parameters are as follows: File Pattern : acential/datastage/folder/xml/data/*.xml Read Method: File Pattern Other Parameters are default XML Input stage,th...

Your biggest problem is the fact that the Sequential stage cannot deliver the entire contents of the XML file in one record/field like the Folder stage can in Server. You need to see if it can pass in the fully qualified path to the XML file and then switch the XML Input stage to use the 'URL' opti...

Hi ! My Job Structure is as follows: <b> Seq Stage ---> XML input ---> TX Stage----> Lookup File set </b> The problem is in the Seq stage, the parameters are as follows: File Pattern : acential/datastage/folder/xml/data/*.xml Read Method: File Pattern Other Parameters are default XML Input stage,the...

Hi ! What is the substitute for Folder Stage in parallel, as I want to extract the XML file from a particular folder. Please advise me the process to do that in parallel. Thanks, Nitin Hi, I got my answers for the above question from the following post http://www.dsxchange.com/viewtopic.php?t=10215...

Hi !
What is the substitute for Folder Stage in parallel, as I want to extract the XML file from a particular folder.

Please advise me the process to do that in parallel.

Thanks,
Nitin

...ds_ipcflush() - Error in mutex_unlock() - Not owner... This message is unfortunately not particularly help. When one side of the pipe terminates and the other side can no longer communicate you get this error by the surviving process. So this is just reporting that your job has terminated and is...

Do you have any other stages like IPC or Link Partioner in your job design. Once had a similar problem and removed the IPC and it performed OK. Another option I found in the forum is to check inter process under Enable row buffer option and increase the time out-say 60sec. HTH see I am working in p...

Do you have enough space on the disk where you are writing your target file. See I am doing a conversion from server to parallel , the job runs perfectly fine with same parameters in server. Therefore, space wise target is fine. I am creating this job in parallel just to speed up the process. let m...

Hi, I think it is better you check with your DBA once. And can explain what exactly you are doing after the funnel stage(loading the data into any table or etc..). Hi Meena, Thanks for the reply ! Well after the funnel stage' Funnel stage -->TX--->Seq stage (target ) at the TX , performing lookups ...

Hi !

I am using a funnel stage that combines data from two source. Now , the problem is that from one of the source (Transformer Stage) , I am getting the following error:

ds_ipcflush() - Error in mutex_unlock() - Not owner

Please advice me the reson for the particular error.

Thanks
Nitin

hi ray !

this is fixed width

Hi,
I got a new type of error , don't have any idea what it means. Please explain me how to resolve this isuue

Error details

main_program: Fatal Error: Pos arg exceeds numFields()-1: 3

DataStage Job 2270 Phantom 17275

The job aborts. Explain me please....

thanks,

Nitin

I did check the metadata for Balanced_Qty, there is no dissimilarity. Both are numeric (10) ...I don't know why its giving the validation failed error ?