DSXchange

mctny wrote: Is it possible that your SQL or this particular job ending your connection with oracle, ?

How is that possible ? (Sorry I have very less knowlegde of this)

Thats what is bugging me

Let me try.. Also someone to,ld me that the generated SQL may be too long .. but thats also not the case..

Row limit set to 1 - Same Error.
I introduced a seq file in between the trans and target stage - Same error
Removed all other stages and just kept the seq file and Target stage - Same error
Using generated SQL , Update Action is Update or Insert.

Target stage is a DRS stage.

If you have the Generated SQL On then the generated SQL will be converting this Date Column to a char type (TO_CHAR) (verify this) , and if not then you will have to manually do this as I am not sure Datastage will handle the Date time stamp as it is.

Is the output link to an IPC stage?

Also whats is definition of the column in the stage?

Yes , it is showing me the same error everytime i run it. As a matter of fact I wa snot able to run this job successfully even once.

Do you have some other job that works well with this database? Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)? Can you connect to the database from the Datastage machine using SQLplus? ORA-03113: end-of-file on communicatio...

ivannavi wrote:Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?

Yes to all...

While running a job I am getting this error for each row which it is trying to insert in an oracle Database -- ORA-03113: end-of-file on communication channel I searched the forum but they have resultions like "timeout" or check connectivity. I have checked both of them and they are fine. ...

Nope the datastage Manager one will not..it will show only the ones which u selected.

Even better -

Log on to the Datastage Manager .

Navigate to the category.

Select all the jobs underneath it.

DO Usage Analysis (its under tools).

When the window opens up , say View HTML.

:D

Ray , I have suggested , but these things are not in my control.. I could have decided and designed it looong back :D

Why ? - Requirement - customer wants two different projects (each containing a particular set of jobs to be in there) and then wants to schedule them together. So I was just curious whether its possible without a BAT file or not.
Thanks For the reply.

I Searched the forum for this particular Internal Error and got lot of hits , but none of the topics gives the actual reason for this error. Can any one help me in determining this error? or guiding me to the topic which clearly states the cause and solution.

Thanks alot
Deepak.

Can a Sequence activity call a job in a different project in the same server , i know I can do it with BAT file or CMD line etc. but just want to know whether its directly possible or not.