DSXchange

FAQ section by the same Author (Vincent).
Refer this http://dsxchange.com/viewtopic.php?t=94 ... 559264f947

Chulett,



Thank you, your suggestion with 'InterimStatus' worked out.Now i am able to get my expected result.

aquilis...

Hi all, I am trying get 'InterimStatus' of the job, and trying to fire after job routine to post the mail notification from that job itself. But my job is running continuously.so what would be the cause. could you guyz suggest me what went wrong in my below routine.: vToAddr = Field(Field(ArraySumma...

Thank you, According to Andw, My routine is working perfectly then, since its firing/executing. Chulett, I think you might be right,it's checked 0r Unchecked my routine is firing. but i am getting warning as : 'After-job routine returned error: No error' and as part of information i am getting follo...

Hi all, I am using an after job subroutine,which will trigger only when the job fails to execute sucessfully,for this i have unchecked the option 'Only run after jobsubroutine on sucessful completion of job',so it should work around the way. but even then its firing a mail after sucessful completion...

[quote="sudharma"]Hi Guru, i got this fixed . the MAXUPROC (Maximun Process per user ) was 128 in the QA Environment. Dev and Prod had 500. so we had to set this to 500 on QA and the issue is resolved now. Hi all, can anybody share that Kernel command with us for resetting MAXUPROC (Maximu...

Hi, We have faced simialr problems in our project due to some corrupt files. One thing you can always try out is to export the job and re-import it. When you re-import the job a fresh set of config and status files get created. Note: When you import that the design and executable are linked to each...

Hi all,
sorry for delayed response.
I just cleared my disk space,as my disk was full.
This thing cleared my issue.

Thanks Chulett & all for your total support.

Not sure how a post from 2000 in the Oliver archives can be the 'recent' post I was hoping you would find. :wink: http://www.dsxchange.com/viewtopic.php?t=112908 Chulett, Thanks for your quick response, Actually i came across with this post before,but didn't get things like how he has resolved prob...

Hello Chulet,

I came across with post :
viewtopic.php?t=81201

I have tried pretty much,whatever i came across in most of the posts in DSX.The only thing i need to confirm is , "is it Disk full Issue?".

Thanks,

Have you not added a reject link from your Oracle Enterprise stage to wherever you want to collect them? :? ... Chulet, I have added the reject link and am able to collect unique constraint violated data into the reject link.But i am facing the following issues: 1. Not able to collect the Not Null ...

in oracle OCI stage you have input tab in which you will find "Treat warning as fata error" and with this in tranformer you use rejected link. you will get all error codes for oracle. thanks for the response: But i am moving with oracle enterprise stage.What I want know is ,will it be pos...

Hi all, I need to capture the rejections at Database level, so i have a design like: Oracle enterprise(source DB)----->Transformer------------------>Oracle enterprise stage(target DB)---------> Reject DB table Datatypes for all the columns At source DB level are VARCHAR But target DB has got all DAT...

DB Used: Oracle Status Sql: SQL100 Error message when tested: Arg1 = XYZ Arg2 = DFLD Arg3 = abc Arg4 = select count(*) from DFLD.DFREJECT; Test completed. DSLogInfo called from : ExecSql Message to be logged is... > Connection OK DSLogInfo called from : ExecSql Message to be logged is... > request S...

Craig,

Thank you
It worked out fine.