DSXchange

Maybe abit late, but i ran into a similar issue a while back. Unfortunately the client got fed up and we went down the reinstall route before the solution was sent to us. At that site, the Services + Engine tiers were installed first. Once completed, a following install was invoked for the Client ti...

On the offchance you are sourcing from a database i'd suggest reading up on 'window' functions for your rdbms. Perfect for reconstructing SCDs (i assume...)

1) AFAIK the hive stage is merely a wrapper for the hive jdbc connector - my recollection is that the execution is deferred to the default for your environment (doesnt switching to MR require restarting hive anyways?). If you're using the file connector to create a hive table i dont imagine it would...

The 'Login Error' seems to point more or less to your authentication parameters (be it the keytab or username or something different altogether). Have you tried perhaps putting in your FQDN for your domain? Test out the connectivity via command line on your engine? Confirm that you can connect via W...

FYI - the checksum stage spits out the MD5 of your fields.

The fields are concatenated, pipe delimited and appended with a trailing pipe.

Unfortunately not documented anywhere though.....

Are you guys sure that the link provided is "IBM DataStage" as opposed to some other program named "DataStage"?

In my experience, DataStage doesnt like passing in multiline parameters at all. Perhaps consider sanitising the parameter value that you receive when passing it into the job?

You could also try writing the query into a text file and then parameterising the stage to read the query from a file instead?

I dont believe you can change the browser engine to FF or Chrome.

Perhaps try adding your InfoServer host to the list of trusted sites? Also i think in the Advanced Settings there is an option to enable ActiveX controls (though it might be enabled by default....)

If you have IGC - write a query (not a SQL query mind you - the query in the IGC interface) which can be exported as a CSV.

You may be able to go around this by using the DSRunJob routine, though I have not personally tried id.... I think you can pass in the individual parameter values belonging to a parameter set by using [parameter_set_name].[parameter1]=[value1]|[parameter_set_name].[parameter2]=[value2]|[rest of para...

If 1 runs and 9 is queued, then it means in your jobs resources are hitting the CPU and/or memory limit designated in the operations console. From memory it defaults to 80% of each, so perhaps some job tuning is in order and nagging the infrastructure providers to beef up the DataStage engine host?

maybe an alternative is to grant said user the IGC roles to the view the job designs through IGC instead?

This sounds like an Oracle issue....

Have you checked out:
viewtopic.php?t=132761

And from that post there should be a row/column number which you can investigate to make sure its valid.

Best place to check would be in Software Product Compatibility Reports: https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=043853E0198311E7A99D5014AD6C3D46&osPlatforms=Windows&duComponentIds=D004|S002|S003|S001&mandatoryCap...

Each parameter set value defined will result in a plaintext file with the same name created in the parameter set folder (project/parameterset/<parameter set name>/<parameterset value>) on the DataStage engine file system. So my guess would be the number of parameter sets values files will be bounded...