Search found 147 matches
- Sat Aug 18, 2007 11:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Issue - he left-hand-side decimal has an invalid re
- Replies: 2
- Views: 2598
Decimal Issue - he left-hand-side decimal has an invalid re
Hi, one of the job is giving the following error - any idea what is causing this error and job is failing - we checked all the column data lengths and stage variable lengths and target datatype lengths are same. APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::compare: the left-hand-si...
- Tue Jul 17, 2007 5:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: "same" operator may not have a parti
- Replies: 9
- Views: 5427
Yes there was a message handler, i disable that and ran the same job with $APT_DUMP_SCORE=True , still the same it is not producing any extra dump. I found one more interesting - On developement box the same job is working fine, then i made a copy of the job with my initial, and i changed the output...
- Sun Jul 15, 2007 4:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: "same" operator may not have a parti
- Replies: 9
- Views: 5427
Clearly there is at least one difference between environments. Dump the score in each and look for those differences. Does the error message indicate which stage/operator is generating the error? ... Hi Ray, job is aborting with in 2 seconds - it is not mentioning any stage names. it is just saying...
- Sun Jul 15, 2007 11:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: "same" operator may not have a parti
- Replies: 9
- Views: 5427
main_program: "same" operator may not have a parti
Hi,
couple of my jobs are aborting with following error
The same job worked fine other environment - no changes in the jobs from Dev environment to Prod environment.
Any ideas, what could be the cause...
Thanks,
T
couple of my jobs are aborting with following error
Code: Select all
"same" operator may not have a partitioner or collector on its input
Any ideas, what could be the cause...
Thanks,
T
- Sun Jul 15, 2007 11:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error loading "orchoracle": Could not load "o
- Replies: 7
- Views: 6926
Hi Ray, basically i was having issues with Oracle stage - with permissions but meanwhile i wanted to run the same job with using ODBC stage, there also i got the issues. I raised a ticket to DBA to look into this and he gave 775 on all the Oracle files - so the issues got resolved for Oracle and ODB...
- Sat Jul 14, 2007 10:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error loading "orchoracle": Could not load "o
- Replies: 7
- Views: 6926
- Sat Jul 14, 2007 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error loading "orchoracle": Could not load "o
- Replies: 7
- Views: 6926
Ray, I checked all the permission as full in in PX/lib directory. I am also having an issue with ODBC connection it says Could not connect to datasource[DataDirect][ODBC lib] Specified driver could not be loaded then i did the DS_CONNECT to the database and i am getting bellow error SQLConnect error...
- Fri Jul 13, 2007 11:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error loading "orchoracle": Could not load "o
- Replies: 7
- Views: 6926
Error loading "orchoracle": Could not load "o
Hi, I am getting following error when i tired to view the data thru Oracle stage, any ideas? it looks like permissions but i am not able to find which permissions and which file? Error loading "orchoracle": Could not load "orchoracle": Permission denied. Any info is appreciated! ...
- Thu Jul 05, 2007 4:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StringToDecimal function - producing warnings
- Replies: 6
- Views: 3969
Hi Arndw, verified other environments, there are not message handlers for those warnings. basically in those jobs programmer converting a Varchar field to a Number value using StringToDecimal function but we changed that process to use AsInteger function as we know that the source data will have num...
- Sun Jul 01, 2007 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StringToDecimal function - producing warnings
- Replies: 6
- Views: 3969
StringToDecimal function - producing warnings
Hi, I am getting following error in one my job, the same job ran fine in other DS environment with out any error with same data - what could be the reason. Operating system AIX 5.0 in both DS environments. Conversion error calling conversion routine decimal_from_string data may have been lost Any in...
- Thu Jun 21, 2007 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy Message Handler file from One project to another
- Replies: 1
- Views: 2635
Copy Message Handler file from One project to another
Hi, We moved our datastage code from Sun Box to AIX box and Message Handler file did not get migrated so I copied /dsadm/Ascential/DataStage/MsgHandlers/project.msh file from Sun box to Aix box at the same location. But when i run the job i am getting warnings which suppose to suppress as part of pr...
- Fri May 04, 2007 10:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple date format
- Replies: 8
- Views: 4104
- Fri Mar 02, 2007 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filter Stage usage for LIKE %ABC%
- Replies: 8
- Views: 5365
Filter Stage usage for LIKE %ABC%
hello,
Can the filter stage used to filter the data where LIKE %ABC% - same as we provide in SQL?
if not, what could be the alternative to use the LIKE condition to use %ABC%.
Any info helpful and appreciated.
Thanks
Can the filter stage used to filter the data where LIKE %ABC% - same as we provide in SQL?
if not, what could be the alternative to use the LIKE condition to use %ABC%.
Any info helpful and appreciated.
Thanks
- Fri Feb 23, 2007 2:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change in dsenv file -
- Replies: 2
- Views: 2052
- Fri Feb 23, 2007 1:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change in dsenv file -
- Replies: 2
- Views: 2052
Change in dsenv file -
Need some info - if we change the dsenv file to add db2 instance - do we need to stop and start the datastage?
what are the steps need to take if any?
Thanks
what are the steps need to take if any?
Thanks