Search found 20 matches
- Wed May 22, 2019 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Daatstage jobs are failing with osh -fullusage error
- Replies: 1
- Views: 2715
Daatstage jobs are failing with osh -fullusage error
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: /...
- Wed Dec 28, 2016 2:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Facing issue with ABAP extract stage
- Replies: 2
- Views: 3414
Facing issue with ABAP extract stage
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...
- Mon Jul 25, 2016 2:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Caught ORCHESTRATE exception error
- Replies: 7
- Views: 8582
Caught ORCHESTRATE exception error
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...
- Thu Feb 11, 2016 11:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for CHAR + nullable field
- Replies: 8
- Views: 5123
- Tue Feb 09, 2016 3:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for CHAR + nullable field
- Replies: 8
- Views: 5123
- Mon Feb 08, 2016 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for CHAR + nullable field
- Replies: 8
- Views: 5123
- Mon Feb 08, 2016 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for CHAR + nullable field
- Replies: 8
- Views: 5123
Null handling for CHAR + nullable field
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...
- Tue Jan 02, 2007 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencial file name capture in a job
- Replies: 18
- Views: 13743
- Fri Dec 29, 2006 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencial file name capture in a job
- Replies: 18
- Views: 13743
- Thu Dec 28, 2006 5:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencial file name capture in a job
- Replies: 18
- Views: 13743
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...
- Thu Dec 28, 2006 4:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing File name of the file being loaded
- Replies: 5
- Views: 3388
- Thu Dec 28, 2006 4:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing File name of the file being loaded
- Replies: 5
- Views: 3388
Re: Capturing File name of the file being loaded
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...
- Thu Dec 28, 2006 4:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencial file name capture in a job
- Replies: 18
- Views: 13743
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)...
- Tue Oct 24, 2006 8:53 am
- Forum: General
- Topic: size of the logs affecting job performance
- Replies: 7
- Views: 6691
Re: size of the logs affecting job performance
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...
- Fri Oct 20, 2006 1:41 pm
- Forum: General
- Topic: size of the logs affecting job performance
- Replies: 7
- Views: 6691
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...