12-01-2009 11:53 PM
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
12-02-2009 4:12 AM
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
12-02-2009 4:12 AM
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
12-02-2009 4:43 PM
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
12-02-2009 9:28 PM
After adding the below entry in the table_split file.
tablename%nr_of_whr_files;keyColumn.
Senthil
12-03-2009 4:07 PM
Hi, how do you resolve this issue ? I try lik this but withuot success.
AFVC%7;keyColumn
Regards
Eduardo Silva
12-03-2009 4:42 PM
Hi
Replace the keyColumn with AUFPL
Like
AFVC%7;AUFPL
Regards
Senthil