ORA-03106: fatal two-task communication protocol error
Moderators: chulett, rschirm, roy
ORA-03106: fatal two-task communication protocol error
Hi,
In one of my job's target tables has lengthy colums like varchar2(4000) and varchar2(2000) like 15 columns.
i am using UPSERT option Insert then update.
But my job is aborting after inserting 5000 record. with this error
"ORA-03106: fatal two-task communication protocol error"
Then i increased the arry size to 1500,but again the job aborting with the same error.
But this time job aborted after inserting 30,000 records.
Please if any one know the solution.please help me in this.
Thanks in advance
Thanks & Regards
Prams
In one of my job's target tables has lengthy colums like varchar2(4000) and varchar2(2000) like 15 columns.
i am using UPSERT option Insert then update.
But my job is aborting after inserting 5000 record. with this error
"ORA-03106: fatal two-task communication protocol error"
Then i increased the arry size to 1500,but again the job aborting with the same error.
But this time job aborted after inserting 30,000 records.
Please if any one know the solution.please help me in this.
Thanks in advance
Thanks & Regards
Prams
Array execute failed for insert
Hi Chulett,chulett wrote:You increased the array size with field sizes like that? Yikes. What happens if you set it to 1? ...
i ran the job with different arry sizes,but still i am getting the same like
" Array execute failed for insert"
Could you pleae help me in this regard
Thanks for your reply.
Prams.
Hi Chulett,chulett wrote:Please clarify if one of the different array sizes you tried was 1. And post all of the errors messages you receive complete and unedited rather than something like them. What is your total byt ...
If the array size not defined then the job aborting after inserting 100 records.if i increased the array size then the inserted records will more.
But all the time I am getting the same error.
like"Array execute failed for insert"
In my job there are 20,000 bytes for all the columns in the table.
Thanks & Regards
Prams
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
![Confused :?](./images/smilies/icon_confused.gif)
Regardless, involve your official support provider. Seems to me you've either hit a limitation in the product or a bug.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Chulett,chulett wrote:Where was using an "undefined" array size ever mentioned? All I've been trying to get you to try is an array size of 1. One. Uno. Ek.
Regardless, involve your official support provider. Seems to me you've either hit a limitation in the product or a bug.
Thanks for the reply,
I mentioned in oracle stage --->propertice----->Target
in it write method as "upsert"
upsert order as insert then update(for updating sql 1=0)
there is option like "insert array size"
here i mentioned the array size.
If i am wrong please(correct) help me,if any other place i need to use this option.
Thanks & Regards
Prams
I got a SIMILAR error message "Array execute failed for insert" when accessing an Oracle CLOB via the Oracle Enterprise Stage.
IBM support stated that ORACLE CLOB is not supported in the Oracle Enterprise Stage. Thye suggested I use the ODBC Stage or the Dynamic RDBMS Stage instead.
viewtopic.php?p=352322
IBM support stated that ORACLE CLOB is not supported in the Oracle Enterprise Stage. Thye suggested I use the ODBC Stage or the Dynamic RDBMS Stage instead.
viewtopic.php?p=352322