DSXchange

zealcrash wrote:there is no backup...

Why ever not?!!

If there's no backup, there's no way to restore.

Looks like you need to re-install. Do back up your projects first, however, as these may be recoverable.

You might also check that everything about tnsnames.ora is correct - the pathname of the file and the entry for D2IDEV1.

babbu9 wrote:The problem is we already use odbc stage and we cannot change all of our code to use oracle stage now.

Not true. If it's the only solution that works, then it's the correct thing to do.

Search this site for a parallel version of the Ereplace() function. It's not available out of the box in version 8.x, but it's been created for the DSXchange community. From memory it's called pxEreplace().

Generate four outputs constrained by system variable @PARTITIONNUM.

Don't use port number with -server option. Indeed, if you're using default port numbers, don't bother with them at all. But it's the domain that's listening on port number 9080, not the engine server.

Technically it IS available for free download.

But you won't be able to install it until you've purchased a license.

+1

"step" is the terminology of the parallel engine for what we call a job. What is your exact job design? The error message suggests a parallel job that has no stages. This is not a particularly useful design. You might also like to include APT_DUMP_SCORE into your job as a parameter, set to...

Welcome aboard. I'm surprised to hear of any target that can only handle a limited number of rows. The filter expression you use in a Filter stage is actually quite limited (check the Parallel Job Developer's Guide for details). In the meantime replace your Filter stage with a Transformer stage, whi...

Why not use a WaitForFile activity in your sequence, with a really short timeout (perhaps 1 second)? The OK trigger fires if the file exists, the Failure trigger fires if the wait times out.

Other than by exporting the project, editing the export file, and re-importing, no. Before you do that, it would be useful to perform a Where Used analysis on the Parameter Set in question, so that you have a better chance of not missing any. If you'd like a really crazy way to effect this requireme...

IBM certifications tend to be product-specific, but there are some that you may be interested in. Check out http://www.ibm.com/certify

Were there any other error messages reported? This is a really generic report, indicating that stage xxx returned a non-success exit status. And nothing more. Perhaps you could enable some of the reporting environment variable job parameters to try to get a better handle on what's happening when the...

You have it correct. Unconditional triggers throughout, and no automatic handling of failures. The sequence will finish, possibly with a status of "Finished". You can force it to generate warnings in the compilation options, if that's what you want to see.