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

[Former Member]

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

[Former Member]

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

[vincentlim826]

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

[Former Member]

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

[Former Member]

After adding the below entry in the table_split file.

tablename%nr_of_whr_files;keyColumn.

Senthil

[Former Member]

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

AFVC%7;keyColumn

Regards

Eduardo Silva

[Former Member]

Hi

Replace the keyColumn with AUFPL

Like

AFVC%7;AUFPL

Regards

Senthil