DSXchange

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...

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...

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...

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

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...

Yes, DBA did not give the correct permissions on all the needed files for dsadm id, he gave necessary permission and all permissions and ODBC issues resolved.

Thanks,
T

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...

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! ...

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...

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...

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...

I think if you know the number of distinct format then using iconv and if condition change the target format.

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

Thank for the info

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