DSXchange

Create a quickie job to write your generated sequential file into a dataset. Does that work?

Could it be non-fixed length and missing the final delimiter? I recall PX has an option for that.

Hello hemant, the log file is actually a DataStage hashed file and cannot be processed from the OS level. You can use the OS command "dsjob" and one of the following options: -logsum -logdetail -lognewest to get log information printed out to standard output, which you can then use as the body of ma...

Can you create another job with a DataSet output as a test to see if it is limited to your one job and one data contents? Does the job abort at or before row one or does it happen downstream? If you use a different APT_CONFIG file (with a different amount of nodes), does it work?

Doesn't the file automatically receive the remote file user's login umask? That might be changed to limit access.

dxp,

why don't you post the answer so that others are helped?

It looks like the first DateFromDaysSince() function has an invalid first argument, '1' is not a date.

I don't think that type of an area (i.e. a section/forum) is a good idea - known limitations can be found with a search and there is already a forum for enhancement or change wishes (where your two issues should go). I don't know where one would draw a line between limitations and wishes - stating t...

I agree with the stored procedure issue (which I hadn't known about); the .XLS stuff of UNIX is just something that has always been an issue to a few (I've had the same problem at sites before). The DataDirect drivers for UNIX XLS are not part of the deal with packaged drivers, that would have cost ...

Bangorlad, I disagree with your assertion that Ascential should write a driver - accessing XLS files on a UNIX host is not part of the expected or mainstream processing for this product, and as such the engineering effort required to write a special solution and maintain it is not worth it to Ascent...

Sreeprabha, you really need to read the installation guide AND follow the instructions in it. Your APT configuration file needs to be modified (you are using the default unchanged file according to the error message) and you need to set your environment variables per the installation guide so that t...

These doubts can all be answered by using SEARCH in this forum. Missing columns can be handled in the sequential stage definitions. You can specify attributes for each column and what you should do if it is missing on input. Of course this only works for columns missing from the end of the row, for ...

Hello Ray, the restores either evinced the same corruption or were incomplete (i.e. only a DATA.30 or a OVER.30 since they were using incremental backups) so the file needed to be FIXed, whereupon the same problems cropped up. The VERIFY.SQL SCHEMA {pathname} showed inconsistancies that were not cor...

Is this error reproduceable at the same row? Is it reproduceable with the same data when run manually? If it is sporadic, does the error occur when particular conditions exist on the server - i.e. when it is very heavily loaded or lightly loaded, when there are more than normal users?

The only solution you need is to do some better design, this is not a problem with single- or multi-instace jobs but at a lower level. At a very abstract level you might say that it takes 5000 seconds do to a job. If you split this up into 500 jobs that each need only 10 seconds you will get a box f...

Ray - thanks for the suggestion, we tried that earlier and got an invalid schema error. The issue with that corrupted file is that now all projects are 'protected' and cannot be unprotected! The restores done won't work either, the UV_SCHEMA file is still inaccessible to both root and dsadm. I looks...