DSXchange

There should be other error messages in the log that detail the cause; this message doesn't help much. Does the data contain more than 31685 records? Notice that one less output than input rows came in - if you have no constraints in the transform stage then something in the data caused the abort. O...

The important part of the message is ##W TBLD 000000 12:55:38(003) <main_program> Error when checking composite operator: Output from subprocess: 1540-5216 (S) No licenses available. Please install the licenses that accompany the licensed product. If you have obtained a Try and Buy version, please c...

This could be the username/password combination for the repository database.

Your first step is to set APT_DISABLE_COMBINATION to true so that you can find out which stage is causing the error. You also need to look into your log file and find the real error message, the one you posted doesn't specify exactly what the error was.

I agree with Ray, any further steps you take just run the risk of immediately corrupting the UV_SCHEMA to such an extent that you will need to re-install the engine. I think that at this stage you should just bite the bullet, choose a time when nobody is using the system, and reinstall the engine, a...

Under "options" in the sequential file stage you can specify "First line is Column Names" which effectively skips the first line.

I really don't know if NAP ends up executing anything other than an OS sleep call (well, "nanosleep" or the like) at UNIX. So I wouldn't rely on NAP not showing the same sporadic issues.

While I like brevity, I think you might be overdoing it here. I'm not sure where that error message was generated - was it from the ADMIN tool? If so, did you get when entering the tool or when trying to add a project?

Malli, we are trying to help you, but without additional information it is going to be impossible and trying to get this data from you is proving itself rather difficult. You state "some invalid chracters <sic>" but in reality characters can only be invalid codepoints when given a context;...

execute the command from TCL, not from a shell; i.e. "cd $DSHOME", ". ./dsenv", "uvsh", then "RESIZE UV_SCHEMA * * *"

Can you create a project as "dsadm" from the DataStage admin client? If not, then it is almost certainly access rights issues, either in the repository or on the datastage server.

I prefer my error message, "##W IIS-DSEE-TBLD-00000 13:46:07(005) <main_program> Error when checking composite operator: Output from subprocess: /usr/vacpp/bin/xlC_r: 1501-228 input file /home/dsrun/PXFunctionTest/BadParams.o not found ". Want to trade? :roll: Seriously, though. There have...

Enter into TCL and then, as shown above, type in "RESIZE UV_SCHEMA * * *"

Dump your schema from the dataset, "orchadmin describe -c -s YourDataset" - is the column information correct there?

I'd test everything if possible within your project time constraints - particularly if you are in production.

<edit>
I would be surprised if you found any differences if the jobs all compile but it is better to be able to prove that you did due diligence.