DSXchange

So... what does that tell you? Have you tried changing the Array Size yet?

Ah yes, forgot about that little nuance...

Seems to me DOS was the right choice. :wink: Put in some calls to DSLogInfo() and record what is coming back in the output and return code variables. You should always check the return code for a failure and handle it appropriately. And you need to remember that output from the command line is retur...

I'm not sure you can use "UNIX" for the shell on a Windows machine in spite of having the MKS Toolkit installed. See what happens if you set it to "DOS"...

You can use DSExecute() for that, make sure you set the type correctly so it knows you are executing an operating system command rather than any of the other options. It will return the result in the Command Output parameter.

Hmmm... the Folder stage was built to read XML files, regular old flat files tend to confuse it at times. I've used it to generate a list of filenames from a directory of files but I'm not sure I would ever rely on it to consume any number of flat files reliably day after day.

Having one over SERVICE_NO would be enough to stop any full table scans, which is what we're assuming the issue is here.

That looks like the old 'Grid View' that (for other stages) was available via one of the right-click options. Sometimes we've seen that due to a lack of memory on the client, if you close everything out and perhaps even reboot your PC does the problem go away? Do others have this same issue or just ...

This is the 7.x release we're discussing here, so there's no IS component. Does it even support LDAP?

That's already been mentioned but I assumed the "I do not have the rights" comment meant a scripted approach was not feasible.

Then something else is going on. As asked before, any chance you have a reject link that is set to "abort after 1 row"? Or are you using any kind of routine or transformer code that calls "DSLogFatal"? Look for something that may be coded into the job to abort itself under certai...

No, there's no other step needed. If it shows as 'Scheduled' then that means it can find the crontab entry, not sure why it is not showing for you when you check using the same userid. :? About all I can suggest at this point is to contact your official support provider and see if they know what's g...

While DataStage understands the difference between 'null' and 'empty', Oracle treats them as identical so you're not actually handling them like you think you are.

No need to dump your entire log here.

Any chance you could up your warning limit to something other than 1 temporarily as a test? Sometimes that allows the actual error to make it into the log...

Unfortunately, that doesn't really add anything we don't already know - there was one error and the job aborted. And in a Server job that is always reported by the Transformer since it is the active stage, even if the issue is elsewhere. Can you confirm something? Are you running the job with a Warn...