DSXchange

Hi Gurus There is a requirement of a REST call which has the Request as below - { "key1": [ "value1 ], "idSet": [ { "id": [ { "idType": "com.server1" "idValue": "451902123" } ], "id": [ { "idType": "c...

Hi Guys We are working on a migration project from V8.5 to V11.5 and Sybase to SQL Server. Currently facing the issue while comparing the data between Sybase and SQL Server tables and it is too much time consuming. Is there a way by which we can develop a job which can compare the data between Sybas...

Thanks craig for your inputs FYI - My input json file is only having 7 records and size is 22kb. Please find the job log when reset the job - From previous run DataStage Job 208 Phantom 20225 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASI...

Hi Team I have created a Server job for calling a REST POST service and capturing the response. This thread is a part of this issue but posting here if someone can help me with this server job. Design: transformer Stg ---> Hierarchical Stage ---> Seq File a) transformer stage - generating a single d...

Ernie, I have gone through the Folder stage and develop a server job for my task - Design: Folder --> Hierarchical Stage --> Flat File In Folder stage, I am passing the Source Folder name and regular expression for file but still my job is keep aborting. Warning : Abnormal termination of stage detec...

I am splitting the payload file outside the datastage box using a script and then passing the filename in hierarchical stage to read and post the data to web service.

Can you try to use ODBC connector and check whether it is also stuck ?

Use a after job subroutine to rename the files, Can you explain your stage configuration?

I am splitting payload file into multiple as this is huge to send over webservice and due to business constraints for sending the data this is only the way. That is why I am splitting the payload file into multiple and calling the web service in loop. I have used the same logic for generating the si...

Thanks Ernie and qt_ky for your suggestions. Here is what I have done in my Server job - Txf (generating a single dummy row to pass the payload file ) --> Hierarchical Stage --> Output Seq file job is keep aborting after few seconds with warning "Abnormal termination of stage transformer",...

Hi Gurus, I am calling a REST service in Hierarchical stage and using the POST method. Design: (row gen) --> Hierarchical stage --> Flat file (Response) I am passing the payload as fileName and job is running on 2 node configuration. Performance Data: Run1 - start time : 12 sec, prod time : 13 sec R...

JRodriguez, My service is invoking a parallel job which has a job controller. This job controller code is calling a sequencer which calls other job After successful completion of sequencer , it will generate a status file, which has been returned by the service on display to invoker. Service --> Par...

Thanks Julio, I'll ask my admin team to execute this script and update with the outcome.

But any idea why my sequncer is getting locked? This sequencer is not being called by the service as design is:
service --> parallel job(job controller) --> this sequencer

No, in version 11.5 this script is not available.

You can not mount, Only root user can. Ask your Linux Admin team to mount remote drive to datastage server