DSXchange

Hi again everyone, I have a delivered job that I cannot figure out. I have done many searches on this issue but have found most of the results relevant for formatting issues. Anyway, we're on a db2 database first of all. Basically, on one of the lookups a datetime field is being used to populate the...

Hey, Thanks for the help guys. Can't say we really found the error, but it was something to do with the target table's metadata. When we reimported the table structure, the job ran fine.

Have you tried Resetting (not recompiling) the job via the Director? Sometimes that will get you a 'From previous run...' log message and it can have additional (as in helpful) information. Hi, yes I tried to reset the job in director but it didn't give me anymore information. Also, the job appears...

Yes this website. :P Jokes apart, what exact message were you referring too. I doubt any error message that the DSEngine can produce, has not been discussed here. Usually there are surrounding warn ... Ha...yeah you're right...This would be the first place i'd come if I had some kind of warning or ...

Hi everyone, I was wondering if there are any ways to view more detailed information about an aborted job than using director and looking at the log file. For some of our delivered mappings that fail, all we get is a job aborted message and nothing else to really indicate what the problem might be. ...

Hi Ray, Thanks for the suggestion. I did a search on the forum and this very well may be our problem. Our settings for spintries and sleep are 0 and 5000 respectively. Would this mean spintries is turned off and shouldn't impact us or should we try to increase this number from 0? Thanks for the help.

Hi, We have delivered jobs with Error Tables that abort the job due to Mutex Timeouts. A few of the jobs in their simplest form look like this: src --> ipc ---> trans ---> ipc ---> tgt ---> hash The error table comes off the transformer without an ipc and there are some hash lookups attached to the ...

DataStage sequences can be written to do this. Since there are so many ways of branching or waiting on "triggers" it is hard to answer your question directly. Often the presence or absence of a file is used as a switch, or even as a trigger to start processing. External scripts can be cal...

Hi,

Does anyone know if Ascential has the capability to receive workflow triggers from a source system to tell it whether to run a job or not? Thanks in advance for your help and time.

There are many ways to unlock a job Do a search on "unlock job" A quick solution In DS director Goto Job -> Cleanup resources. Look into all the processes Find "your job" (one that complains of being locked) Click on the "Release" button The issue is that the job does ...

There are many ways to unlock a job Do a search on "unlock job" A quick solution In DS director Goto Job -> Cleanup resources. Look into all the processes Find "your job" (one that complains of being locked) Click on the "Release" button The issue is that the job does ...

Hi everyone, While running an dsx import, manager crashed and when I attempted to run the import again, I had a problem with one of the jobs. The error basically said "Job already exists and that the job was locked in DS_JOBS". However, when I look in the project, the job is nowhere to be ...

I was able to finally release the locks and voila..the project was deleted easily. Thanks for all the help.

No it means you previously brought down DS and restarted incorrectly so you now have more than one shared memory segment which is not good and away from this deleteing Project issue.... So bring DS doen or stop it and then have your Unix Admin (root) do the following: ipcs | grep ade ipcrm -m {shar...

I took your advice and this is the results: Cache Segments : 0 active User Segments : 0 active I decided to try and restart the DataStage Server to see if that would help and I got an error: Unable to remove the following shared memory segment(s) during shutdown: m 1020264485 0xadec7511 --rw-rw-rw- ...