DSXchange

All the datastage jobs in a project are failing with below error. Please suggest me what could be the reason to get these kind of error message. main_program: Orchestrate Parallel Command Shell usage: /opt/ibm/informationserver/Server/PXEngine/bin/osh <options> "<step specification>" or: /...

Hi All, I am facing a weird issue with ABAP extract stage. when i am generating ABAP program using build sql query option to extract data from SAP table, i am getting syntax error as below. Line = 7 Offset = 0 Error Message = Statement "REPORT" is not defined. Check your spelling. . Please...

Hi, Has anyone had experience with the following error. Job aborted with following error and it ran fine once after restart. main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadPointer: From: Loading memory archive: Expected class "APT_SchemaFieldListRep&quo...

We corrected SAP program to receive SPACE instead of blank.

Thank you everyone, appreciate your help

Hi,

This is NULLABLE in target table(Teradata).

I haven't set any NULL filed property in schema file

Hi Craig,

Here is the warning.

sf_InterimFile,0: Field "PARAS" delimiter not seen, at offset: 5

If i change schema file to varchar(1) it is working fine.

Hi, I am reading pipe delimited file and loading data to Teradata by parsing data through schema file. (Generic job) The job is failing with warnings, The input looks like below. (No NULL, No Space) AAA || BBB|C|C BBB || CCC|D|E At target the datatype is CHAR(1) NULLABLE. When I parse data through s...

according to IBM this is fixed in patch 96576 for DS EE 7.5.1A; we are yet to try it in our environment.

The "file name column" property must refer to a column (type VarChar probably) that is defined on the output link. Is this the case with your design? The same is true for the file row number property, if you use that. yes, and, as i mentioned, it gets populated - just with the wrong data.

The Sequential File stage can generate two additional columns, one containing the file name of the file currently being read, the other containing the line number within that file of the record currently being read. But, as noted, it may be wise to set APT_IMPORT_PATTERN_USES_FILESET to False. Or a...

DSguru2B wrote:You are replying to a post that was last answered in Jun 06.

i know. this is asynchronous communication, plus this is a common problem.

there is "almost" working more elegant solution here: http://dsxchange.com/viewtopic.php?p=210536 however, it does not quite work :( You need to develop job with parameter to store file name ( assuming you know file anme before you read that). Use transformer stage to map the parmater name...

this is precisely my experience as well - APT_IMPORT_PATTERN_USES_FILESET causes each node from apt config to pick up a file name and use that for all the files it processes. so in my case i have two nodes and 200 files, as a result (if i have APT_IMPORT_PATTERN_USES_FILESET set to true for the job)...

thanks for your input guys. ibm acknowledged the problem and provided the patch. in some cases log files get corrupted, then performance drops through the floor. this seems to be inherent to the deficiencies with universe db file hashing that stores the logs. if this bites you, ask support for a pat...

kenneth, thank you. so you are saying that having a project-level purging setting and even clearing the logs in the director is not enough - i should do an extra step to clear them? others: we have purging setup - we used to keep 3 days, but that was slowing things down. now if we purge the logs rig...