DSXchange

In this case the truss output isn't of any help. I wonder if the job is not progressing because it is waiting for Oracle to complete? If you change the job to not write any changes to the database does it complete? Can you have your DBA monitor the DB while this job is running? I tried that job aga...

Identify the process ids and then use the "truss -p {pid}" command to see what these processes might be doing. Does this mean if you start the job from the director it does not get "stuck"? What does the job do? Hi Arnd, sorry for posting my query in this thread. But i think its...

Hi- I tried searching for an answer here for this without luck. I'm still new to DataStage so please bear with me. I have a DataStage Sequence I'm trying to get to work. The first stage in the sequence is an Execute Command stage (named Execute_Command_0). This stage executes a shell script on the ...

You may need to recompile the job sequence. You may further need to check that the logic of the job sequence is intact, for example that every path through the job sequence can enter an activity and leave that activity. Hi Ray, This job was running fine previously but now i am getting this problem....

Hi all, I am getting a warning message while running the sequences. the warning text is "Unable to find SoftwareResourceLocator start point" and this warning comes continuously unless I cleanup the resources i am unable to stop the sequence too. it doesn't aborts/stops through the abort bu...

deesh wrote:Hi Friends
Can explain how to use the "DSGetJobInfo Function " in job.

and where to use this "DSGetJobInfo Function "

I think Ray is in good mood today.

Regards,

do you have any other warning or fatal error with this one????

If you don't want duplicates in the reference link then remove the duplicates. Else if it is necessary to bring all the entries to the lookup reference link you should allow multiple records in the lookup reference link. in constraint window you can see a drop down menu with heading "Multiple r...

one more thing is I faced is 'It doesn't give the desired result when there is any field having double data type without scale and precision.'

Make sure you define the scale and precision for double/float data type

Regards,

Does change capture stage cant work with Different after and before source. I am able to get the results if i work with smillar stages such as the before and the after links were oracle stage or datasets but the change capture fails to do so if the stages are a mix in their before and the after lin...

It's not working for BUSINESS_FG = 'U' also Once again its the same problem. Go through the code IF (PLAN_CD1 = "CAT" OR PLAN_CD2 = "CAT") THEN IF ( RIDER_FORM_CD = "ES" OR RIDER_FORM_CD = "09" ) THEN VAL = "AH" END ELSE VAL = "AT" END END...

I checked Shane, when i kept the same value as BUSINESS_FG = "G" and change only the PLAN_CD1 value for e.g. PLAN_CD1 ="CA" (Other than "CAT" and "CES") then i'm getting the correct output as "DM". If the problem is with the BUSINESS_FG = "G&qu...

It depends on the roles defined by the administrator.

But I think you should have that priviledge.

Try calling the envitonment variable $APT_NO_JOBMON to your job and set it to 'True'. It resides under 'Reporting' category.

first of all try switching off the job monitor (set APT_NO_JOBMON = True)if setting the monitor time and monitor size doesn't work.

and tell us the result.

Once again the error was due to "Time Based Job Monitor"

Changing

APT_MONITOR_SIZE=100000 and
APT_MONITOR_TIME=5 resolved that issue. :D (only the error with code 139)

Thanks to all