ORA-03113: end-of-file on communication channel
Moderators: chulett, rschirm, roy
If you paste your insert and update statement into SQLplus from Oracle stage and replace the orchestrate.something with some values, do you get disconnected?
Maybe your DBA could help and examine your session from Datastage (he could see the exact SQL statement that Oracle can see) and see what happens.
Maybe your DBA could help and examine your session from Datastage (he could see the exact SQL statement that Oracle can see) and see what happens.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
DeepakCorning wrote:1. Generated the SQL statements (Insert) and ran them in SQL Plus. The SQL runs fine. With no discconection issue.
2. Replaced the DRS stage with an Oracle OCI stage , the job works fine.
Now the question is why DRS stage is not working fine with this one?
I never used DRS, and in your SQL, if you are only connecting to oracle, then why do you need to use DRS, it will be slower than Oracle OCI stage.
anyway so if you eliminated all the other possible sources of error ( and I think you did), this could be a bug with the DRS stage, I would advise you to contact IBM for this issue.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Yeppeeeeee...
I do not know the reason why this can be an issue ! But the last column in the DRS stage was delared as Varchar (2000). I changed it to Char 255 (Tested it with Var char 255 as well) and now the job just works fine.
I changed it back to Varchar 2000 , and the job aborts again with the same reason.
Any idea WHY?
I do not know the reason why this can be an issue ! But the last column in the DRS stage was delared as Varchar (2000). I changed it to Char 255 (Tested it with Var char 255 as well) and now the job just works fine.
I changed it back to Varchar 2000 , and the job aborts again with the same reason.
Any idea WHY?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 5
- Joined: Thu Jul 27, 2006 2:37 pm
Re: ORA-03113: end-of-file on communication channel
I am not sure if below comments will help you or not. But on my pervious job I encounter similar issue after experimenting I found answer.
Which data stage version you using. If you are using 6.0 then you will face this kind of problem with oracla9i stage. If you using oracla9i stage then you can't able to connect to oracle to resolve this issue you have to use oracle8i stage or OCI stage.
Your situation might be different then mine if you not using version 6.0 and oracla9i stage then I am not sure why you getting this error.
Which data stage version you using. If you are using 6.0 then you will face this kind of problem with oracla9i stage. If you using oracla9i stage then you can't able to connect to oracle to resolve this issue you have to use oracle8i stage or OCI stage.
Your situation might be different then mine if you not using version 6.0 and oracla9i stage then I am not sure why you getting this error.
GD
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are also limits on row size and column count for ODBC that are set in the uvodbc.config file. Defaults are 8KB and 400 respectively; they are set using MAXFETCHBUFF and MAXFETCHCOLS.
Are you using ODBC as the connection type in your Dynamic RDBMS stage?
Are you using ODBC as the connection type in your Dynamic RDBMS stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am