DSXchange

kumar_s wrote:Are the environmental varialbe SID and USER been defiend in the new environment?

Yes The SID ,USER and PWD are defined well.We are able to import metadata using these credentials,but it gives trouble while View-Data as well as Insert/Update.

I've exporeted a job from my development environment to production.The job which used to run fine in DEV is throwing some error in the production. The job design is as follows Ora_TAB1------>TRANSFORMER------>FlatFile The necessary priveleges are given to the datastage user in Oracle. The error says...

I'm extracting data from sap R/3 using the plugin ABAP pack.But I'm facing an issue while running the jobs,i.e:either the job hangs for too long or gets aborted very soon saying 'APT_CombinedOperatorController,0: Logging delayed metadata.' APT_CombinedOperatorController,0: Requesting delayed metadat...

APT_CombinedOperatorController,0: Operator terminated abnormally: received signal SIGSEGV main_program: Unexpected termination by Unix signal 9(SIGKILL) When i executed the job with a lesser configuration it works fine for the remaining 4 times. I want to know whether this error is caused by Bad jo...

There's no single step resolution for these issues.what u can probably try next is to make copies of ur existing job so that it has less no. of derivations,say 300 cols * 4 jobs (=1220 cols),so that all the columns are there.If all of these compiles individually,we can suspect other issues,and if it...

Still i am facing same problem and i check in my transformer all the expressions are correct (no red mark) I tried and generated the same error on my system,as per my conclusion its bcos: " Trying to setnull() a column i.e not nullable."Pls confirm that everycolumns are nullable:'yes' And...

I dont think datastage by itself changes the type of data,apart from considering a decimal without precision as integer on the fly. pls check whether any of the derivations have syntax prob(red mark),like any braces not closed or so. Minor mistakes like that can happen as the no. of fields are more...

Hi, I have a doubt I am processing 10,000 records using seq--->sort--->seq. I got the log as Sort_1,0: Sort revision : 2.6.2 Total CPU (sec) : 0.188 user (sec) : 0.141 system (sec) : 0.047 Records processed: 10000 Bytes processed : 1360K Disk space used : 0 Next time I processed 1 million records i...

I dont think datastage by itself changes the type of data,apart from considering a decimal without precision as integer on the fly.
pls check whether any of the derivations have syntax prob(red mark),like any braces not closed or so.
Minor mistakes like that can happen as the no. of fields are more..

We'll go on iteratively:
In the metadata of all output columns(for decimal),ensure:
datatype:decimal
nullable:yes
precision&scale>0

Its not clear whether u have tested the whole derivations in chunks of 300 or only some of it to conclude that - The derivetions used are same through out every column. which functions might have thrown the error. Can u pls paste the full output from the transformer compiler error log.. That may hel...

Thanks Kenneth for the reply. In the Oracle Enterprise Stage, i use UPSERT option with User-Defined Update and Insert. The updates which iam doing are fictitious updates which will never work as they have Where Clause 1=2. Instead of using fictitious updates ,you can set the property to user_define...

##I TFCP 000008 12:08:30(012) <transform> Error when checking composite operator: cxx -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -O -IC:/Ascential/DataStage/PXEngine/include C:/Ascential/DataStage/Projects/P1/RT_BP1.O/V0S1_First_Transformer_1.C -o C:/Ascential/DataStage/Projects/P1/RT_BP1.O/V0S1_Firs...

Is it regarding a parallel job or a server one?

Is it feasible to use a Merge stage instead of join so that you'll have reject links corresponding to each update dataset you use?