DSXchange

srinath0253 wrote:However, individual emails are not possible.

Why not?

Resist stupid requirements!

All 81xxx errors pertain to the RPC mechanism, and can be decoded via the ERRD.H file in the INCLUDE sub-directory of DSEngine. Are you running multiple versions? If not, why are you using non-default port number (31539) and non-default user name (ad4dsrpcd)? And are you running the services and eng...

One of my current customers is still on 8.5. They use CSV exclusively, because Excel is the analytic tool of choice in that organization!

The modify operator is FAST. I've had a moment to track down the appropriate Modify stage function, which is lookup_int16_from_string(). For example, where column State_Code contains the value to be tested and output column test_value is of type Int16: test_value=lookup_int16_from_string[default_val...

Looks like you are using the same seed every run. Check out the RANDOMIZE statement. See based on, for example The default seed should be based on the system date and time; perhaps this is not working in your case.

Can you see the jobs in Director connected to engine2?

If yes you probably need to synchronize the project on engine2. Use the syncproject command.

Are you using HTTPS when trying to open Launchpad? Are you sure that port number 9447 is the one on which it is listening?

Does the Surrogate Key Generator stage work properly?
Why do you want to know its content?
Have you set a user-defined block size and, if so, to what value have you set it?

The result of the routine (the Ans variable) contains the list of dependent jobs. Do with this what you will. Perhaps modify the routine to write to a file as Ans is appended to. Note, however, that this routine returns design time information - that is, jobs that MAY be called from the sequence dep...

The usual way is via the results file, where the rule has been configured to output records that do not match. In your future (higher versions) are automatic capturing of exceptions, storage of these into an exceptions database, and governance (including business process management) over the handlin...

It appears that your source is Netezza. Have the DBAs search for any connection problem (e.g. timeout) that may have occurred.

I once worked at a site where the maximum time they would allow for a query was 8 minutes. This was unhelpful when trying to do profiling!

I'd think about using a lookup table in a Modify stage, that has a default encoding you can check.

Would it work if you enabled Inter Process Row Buffering in the server job? Just a thought. I still believe that blocking operations are incompatible with ISD.

Change the Preserve Partitioning setting in the upstream stage to Clear