Home » Developer & Programmer » Data Integration » Error message KUP-4050 in selecting single field from external table.
Error message KUP-4050 in selecting single field from external table. [message #231098] Sat, 14 April 2007 02:17 Go to next message
akhileshjoshi
Messages: 2
Registered: April 2007
Location: Delhi
Junior Member

hi,
I am facing an issue when I am trying to use 'select bussiness_dt from external table'in pre process Procedure, It fails the mapping and shows the error message..

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04050: error while attempting to allocate 205785 bytes of memory
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

when I am trying to execute this procedure through SQL prompt , It works fine.

I also checked read , write permission of Directory, it works fine.

Hope for your favour to resolve the issue.

Re: Error message KUP-4050 in selecting single field from external table. [message #231105 is a reply to message #231098] Sat, 14 April 2007 03:57 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
KUP-04050 error while attempting to allocate number bytes of memory

Cause: An error occurred while trying to allocate memory. 
This is likely caused by insufficient memory.

Action: Reconnect to the instance and retry the operation.


Also, check Metalink - there are a few memory leak issues with external tables.
Re: Error message KUP-4050 in selecting single field from external table. [message #231110 is a reply to message #231105] Sat, 14 April 2007 06:38 Go to previous message
akhileshjoshi
Messages: 2
Registered: April 2007
Location: Delhi
Junior Member

Hi Frank,
I have already tried this action but it not works for my case.
Is it memory leackage problem? If yes how can I resolve it. I check my PGA size and shared pool but it fullfill the hit and miss ratio codition.

Pl help me ......
Previous Topic: integrate the warehouse builder 10.1.0.4 logins with the Active directory logins
Next Topic: logon to owbclient without writing the username and password for the design
Goto Forum:
  


Current Time: Thu Mar 28 09:00:09 CDT 2024