DSXchange

nansekar wrote:Our requirement is to migrate a application from DS 7.1 to DS 7.1

Which one of those two numbers is incorrect?

As suspected.

Perhaps "the DS job" that needs to be triggered should be deployed as a web service?

... and does it rely on any underlying O/S functionality like cron or is it a "self contained" service?

Mike wrote:The DataStage scheduler via the Director client utilizes cron / at behind the scenes.

I'm not sure that is still true in the 9.x release, can someone confirm / deny?

I would (again) but you're basically ignoring everything I'm suggesting, so what's the point?

Another thing - you have a list of event ids. You can't simply use that in the for loop as the from and to values... it's a list after all. Count how many entries are in the list and then loop from 1 to Count and use the loop counter to pull the Nth event id from the list and then get the log entry ...

So... you want to round to the nearest second?

What characterset is each instance using?

The job itself won't care and will happily process an empty file. However, because no rows are flowing through the job you can't use a condition inside the job to abort it. What Andy posted is cleanest and makes what is going on much more obvious / visible to the casual observer. You could do someth...

There's nothing more for me to post. Right now I'm suggesting that as a debugging aid you add calls to DSLogInfo() to your routine to see the data you are working with. Write the LogList value to the log after you fetch it. Write vEventDetail to the log after you fetch it. Etc. They'll help you figu...

See if this helps.

Breadcrumbs. Where are the DSLogInfo calls?

Your for loop is broken. You can't step from X to X where X is a list of event numbers.

So... not a Server job then. Off you go to the PX forum.

Your sort stage worked just fine, it's just the expectation of getting sorted output from the hashed file that was incorrect. Due to the destructive nature of hashed file key handling (duplicates are not allowed and last one in survives) the order records are written to the hashed file can be critic...