Hi, all
One of my DS job aborted, with the error message:
"FactXXX.CLARITY_LOOKUP: ORA-24371: data would not fit in current prefetch buffer" It seems an internal OCI error has occurred, after deleted all OCI lookup llinks of this job, the job works normally.
I have a few similar job, they works just fine, except this job. Does anybody know what the problem is?
many thanks
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
prefetch buffer
The Oracle documentation suggests that when this error occurs, you should contact Oracle customer support. Have you done this yet? At least Oracle Support should be able to tell you under what situation this error occurs, which might help you in solving the problem. It is possible that the problem lies in Oracle not DataStage (but we wont know until you ask Oracle).
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [SMTP:Xiong.Li@chh.co.nz]
Sent: Wednesday, September 05, 2001 9:18 AM
To: datastage-users@oliver.com
Subject: prefetch buffer
Hi, all
One of my DS job aborted, with the error message:
"FactXXX.CLARITY_LOOKUP: ORA-24371: data would not fit in current prefetch buffer" It seems an internal OCI error has occurred, after deleted all OCI lookup llinks of this job, the job works normally.
I have a few similar job, they works just fine, except this job. Does anybody know what the problem is?
many thanks
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [SMTP:Xiong.Li@chh.co.nz]
Sent: Wednesday, September 05, 2001 9:18 AM
To: datastage-users@oliver.com
Subject: prefetch buffer
Hi, all
One of my DS job aborted, with the error message:
"FactXXX.CLARITY_LOOKUP: ORA-24371: data would not fit in current prefetch buffer" It seems an internal OCI error has occurred, after deleted all OCI lookup llinks of this job, the job works normally.
I have a few similar job, they works just fine, except this job. Does anybody know what the problem is?
many thanks
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.