DSXchange

We are using a server job to run the routine. we are not calling the routine from sequence. We migrated the routine from prod (in compiled state) and compiled in dev after migration - we are able to test it... We could not see any more error messages apart from "Attempting to Cleanup after ABOR...

Hi, We have a "Transform function" server routine that we can compile and test. But, when we were trying to run the same from a server job<job control>, we could not execute it because of the following error message... Attempting to Cleanup after ABORT raised in stage <Jobname>.JobControl ...

Yes. I have modified the code in playground area of production since it is a run time warning that is thrown only in production environment.In dev, we have not received the warning... Anyway we are gonna sync up all the environments... I had also tried to suppress the warning. It did work but the jo...

Yes. Changing or updating project level message handleres in prduction can never be the best practice. I tried it but it did not work...I dont have the admin rights to add any warning messages to the already existing message handlers. I think i had better ask the dev team to change their code or ask...

Hi, We have a project level message handler in out production Datastage project to suppress one parallel job warning <Entire partitioning warning>. But, We have another job which has been aborted due to the below warning. "APT_CombinedOperatorController(1),6: APT_Decimal::operator=: the source ...

all the jobs that are being shown status "running" in director, have database sources.I am able to view the data in that stage.....connections are open... but while running from director they stuck up...

all the jobs that are being shown status "running" in director, have database sources.I am able to view the data in that stage.....connections are open... but while running from director they stuck up...

all the jobs that are being shown status "running" in director, have database sources.I am able to view the data in that stage.....connections are open... but while running from director they stuck up...

HI,

We just upgraded datastage 7.5.2 to 7.5.3.I have some jobs that are running for more than two days even though we are processing quite small no of records.We have adequate space in the server too.

Thanks in advance

Hi,

I am getting the follwing error while compiling a job that consists of an oracle stage,a transformer and a sequential file

oracle stage -> transformer -> seq file

##F TUXX 000001 03:57:08(000) <main_program> Internal Error: (nullFieldEntry): transform/evalexp.C: 5701

I hvae mapped Column3 in the output of the change capture stage.I think that it is not the problem of mapping or not mapping the column (Column3) in the output of change capture stage. In the change(output) dataset i got the same values for column3(as in the after dataset).I am still thrown the warn...

Hi, i am getting the below warning while using the change capture stage Change_Capture_5: When checking operator: Defaulting "Column3" in transfer from "beforeRec" to "outputRec". in the before dataset i have two columns (Column1,Column2) after dataset i have an extra c...

No

I have not set the decimal output property globally and specifically to that field but when calculating the max value of an integer datatype column it was working fine(without any warnings).Output column(max of Column2) is in double(dfloat) datatype

Hi, I am getting a warning message while finding the max value of a bigint datatype column in aggregator stage.I used double datatype for output column Warning: Aggregator_17: When checking operator: When binding input interface field "Column2" to field "Column2": Implicit conver...

Hi, I am getting a warning message while finding the max value of a bigint datatype column in aggregator stage.I used double datatype for output column Warning: Aggregator_17: When checking operator: When binding input interface field "Column2" to field "Column2": Implicit conver...