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:53:34 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

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

vincentlim826 — Wed, 02 Dec 2009 04:12:33 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

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

Former Member — Wed, 02 Dec 2009 16:43:24 GMT

Hi Vincent,

The issue is not an issue with the privilege, the issue is that its not picking the column automatically.

Its chooses the column name as undefined, though we have our R3hint file readable

I have checked with few others, they too said they faced the same problem with EHP4, so it could be a bug, I have written to SAP.

Senthil

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

Former Member — Wed, 02 Dec 2009 21:28:33 GMT

After adding the below entry in the table_split file.

tablename%nr_of_whr_files;keyColumn.

Senthil

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

Former Member — Thu, 03 Dec 2009 16:07:36 GMT

Hi, how do you resolve this issue ? I try lik this but withuot success.

AFVC%7;keyColumn

Regards

Eduardo Silva

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

Former Member — Thu, 03 Dec 2009 16:42:11 GMT

Replace the keyColumn with AUFPL

AFVC%7;AUFPL

Regards

Senthil