DSXchange

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

You increased the array size with field sizes like that? Yikes. What happens if you set it to 1?

chulett wrote:You increased the array size with field sizes like that? Yikes. What happens if you set it to 1? ...

Hi Chulett,

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.

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 byte length for the record?

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 ...

Hi Chulett,


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

"Array execute failed for insert" will normally be accompanied by another error denoting the purpose.

Do you have any in the log ?

Sainath.Srinivasan wrote:"Array execute failed for insert" will normally be accompanied by another error denoting the purpose.

Do you have any in the log ? ...

Hi Sainath,

Thanks for the reply.

here are the error i am getting total error messages every time in the log.

Thanks & Regards
Prams

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.

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.

Hi Chulett,

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

No, that's the place.

chulett wrote:No, that's the place. ...

i used array size as 1 now the job is inserting only 2 records,

for array size 10000 it is inserting 20,000 records.

Is there any limit to use array size for this.

Please any knows about this please help me.

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