Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-20100: Column name undefined invalid Error - Table splitting

Former Member
0 Kudos

Hi

While tablesplitting in our upgraded ECC6.0 (EHP4) system, we are facing the below error

BEGIN table_splitter.ranges('SOFFCONT1','undefined',5,'/tmp/sapinst_instdir/ERPEhP4/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PRETABSPLIT/Split/DATA'); END;

*

ERROR at line 1:

ORA-20100: Column name undefined invalid

ORA-06512: at "SAPR3.TABLE_SPLITTER", line 775

ORA-06512: at line 1

In our R3hint file we have the below entry, but still we face the issue.

(kdecc01)#cat R3ta_hints.txt | grep SOFF

SOFFCONT1 PHIO_ID

Has anyone faced this issue before?

Senthil

1 ACCEPTED SOLUTION

vincentlim826
Employee
Employee
0 Kudos

see SAP note 1043380

Ensure the directory being reference does actually exist and ensure

privilege are provided for access. Also, a Directory Alias should be

used instead of the database parameter UTL_FILE_DIR which has been

deprecated.

Grant the READ or WRITE privileges to the username accessing the

DIRECTORY.

Ensure that the file being read does exist and actually contains

information to be read.

regards,

Vincent

1 REPLY 1

vincentlim826
Employee
Employee
0 Kudos

see SAP note 1043380

Ensure the directory being reference does actually exist and ensure

privilege are provided for access. Also, a Directory Alias should be

used instead of the database parameter UTL_FILE_DIR which has been

deprecated.

Grant the READ or WRITE privileges to the username accessing the

DIRECTORY.

Ensure that the file being read does exist and actually contains

information to be read.

regards,

Vincent