DSXchange

Hi, We are receiving the error "ORA-03135 Oracle Connection Lost" daily in our production environment. This happens in jobs that uses ORACLE OCI stage. The connection loss occurs when there is a INSERT sql sent from OCI stage. Datastage has been installed in Windows server and an Oracle c...

sachin1 wrote:stage variable will help............

stage variable = stage variable + input column value

Yeah, this should work. Don't forget to initialize the stage variable to whatever value you want (ex. '0').

CT_VAL_GEN_KEY CT_ELE_UNQ_KEY CT_ELEMENT_VALUE 1649 216 13 1649 182 45 1649 217 67 1649 218 87 1649 219 123 1649 220 86 1649 1 EXISTING 1650 216 15 1650 182 56 1650 217 77 1650 218 84 1650 219 145 1650 220 89 1650 1 EXISTING Each CT_VAL_GEN_KEY will have 7 CT_ELE_UNQ_KEY and wil have 7 values for e...

You still need to try and reset the aborted job and see if anything shows up from the previous run. . Thanks for the reply Craig. The strange thing about this warning message is when I reset the job, it resets properly and it does NOT give out any error messages from previous run. Then when I go ba...

Gurus, I am afraid this issue started re-appearing again! Just to give a recap, initially the code was working fine. Then all of a sudden "Abnormal Termination of stage" warning started to pop-up. Then to resolve this I re-coded the job as it is and that started to work like a charm, until...

Also, try adjusting the array size and transaction size. They play a big part while insert/update actions. Too high of a transaction size would definitely be an issue as it slows performance in the DB itself!

Thanks Ray and Craig for your replies. As you both pointed out, I was not able to use the FTP command within the FTP stage. So, I just wrote an FTP script and executed the "quote site lrecl=<num>" command. I am running this script from DOS command line as a before job routine using ExecDOS...

You have to find out what FTP option (it could be a "before" command) you need to use (on your system) to override this, so that your GTG has the desired line length. Ray, Thanks for your reply. Can you please explain further what you meant by the above sentence? As far as I know, we need...

As part of a project, I am trying to FTP two extract files , that I am generating, to Mainframe . Both the files are fixed width (100 characters wide, including filler) and I have two separate jobs for them as they are generated in seperate streams. Both the jobs have the same design: Sequential fil...

In Administrator client command window SELECT NAME,JOBNO FROM DS_JOBS WHERE NAME = 'InsCpsClaimAdj'; That will give you the job number. On the server look in a directory called RT_BPnnn, where nnn is that job number. A file whose name ends in TRANSnn is the source code generated by the Transformer ...

In Administrator client command window SELECT NAME,JOBNO FROM DS_JOBS WHERE NAME = 'InsCpsClaimAdj'; That will give you the job number. On the server look in a directory called RT_BPnnn, where nnn is that job number. A file whose name ends in TRANSnn is the source code generated by the Transformer ...

Just copy the relevant portion of the log message(s) to your clipboard then include it/them here as text, no need for a screenshot. The reason I wanted to include a screenshot was to show that there is nothing else to the error message than what I posted here. Anyways, I followed your suggestion an...

I've found that NOTFOUND is always unreliable when used with anything other than hashed files as a reference input. :wink: Thanks for the replies Ray and Craig. There is nothing else in the error message than what I posted. As a matter of fact, this " Abnormal termination of <jobname>.XFM &quo...

Gurus, In one of our schedules, one particular job is aborting with " Abnormal Termination of stage <jobname>.XFM ". This is the transformer stage that is aborting and it is spitting out NO other errors . I have tried searching the forum in vain. If I am resetting the job, it is not giving...

I have a question with this routine Ray.

> Is there a reason why "UnAssigned()" is present twice?