topic Re: ORA-20100: Column name undefined invalid Error - Table splitting in Application Development and Automation Discussions

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

Former Member — Tue, 01 Dec 2009 23:52:37 GMT

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

vincentlim826 — Wed, 02 Dec 2009 04:14:12 GMT

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