BI EhP 1 Migration from NUC error in Table splitting preparation

[Former Member]

Hello,

We are doing the NUC-UC migration of BI 7 EhP 1. We have provided the following as the split input text file to the installer.

/BI0/AFIAR_O0300%5

/BI0/AFIGL_O0200%40

/BIC/AC0SD_O0100%10

/BIC/ACO_FCST100%5

/BIC/ACO_SDBIL00%30

/BIC/ACO_SDORD00%20

/BIC/ACO_VOLUM00%10

/BIC/ACOD_COST00%5

BALDAT%10

DDLOG%10

RSDDSTAT%5

RSZWOBJ%5

SOFFCONT1%5

During the table splitting preparation, we are getting the attached error.

BEGIN table_splitter.ranges('/BI0/AFIAR_O0300','undefined',5,'/IMPORT/tmpdir/sap

inst_instdir/NW701/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PRETABSPLIT/Split/DATA'); END

;

*

ERROR at line 1:

ORA-20100: Column name undefined invalid

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

ORA-06512: at line 1

-

---

Can anyone please throw some light on the same?

Thanks

Nischal

[markus_doehr2]

> /BI0/AFIAR_O0300%5

> BEGIN table_splitter.ranges('/BI0/AFIAR_O0300','undefined',5,'/IMPORT/tmpdir/sap

> inst_instdir/NW701/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PRETABSPLIT/Split/DATA'); END

Did you specify the key field to split in R3ta.txt for that table?

Markus

[Former Member]

Thanks for your reply Markus!

I have provided the contents of my R3ta.txt file.

We have not faced this issue with similar inputs using the similar syntax.

If I have to include the keyfield, is there any particular format to specify?

Please let me know if you seek further information.

Thanks

Nischal

[markus_doehr2]

> I have provided the contents of my R3ta.txt file.

Also for the table specified? Not all tables are listed in R3ta.txt.

> We have not faced this issue with similar inputs using the similar syntax.

Maybe those tables are in the R3ta.txt.

> If I have to include the keyfield, is there any particular format to specify?

Check the current R3ta.txt for the syntax.

Markus

[Former Member]

Thanks for all our replies Markus!

However I do feel the disconnect regarding the R3ta.txt file you are referring to.

To run through our actions.

1. We analyzed the top tables of out db from db02 transaction in our BI system.

2. We created the split.txt file (as input for SAPINST, also mentioned in this message before), which I was referring to R3ta.txt, you said.

3. And I provided split.txt as the input to SAPINST, which now is stuck.

I do see one R3ta_hints.txt file in my installer directory with the following contents.

Please let me know if you require anything else.

Thanks

ACCTCR AWREF

ACCTIT AWREF

AFVV AUFPL

APQD TRANS

AUFM MBLNR

AUSP OBJEK

BALDAT LOG_HANDLE

BKPF BELNR

BSAD BELNR

BSAS BELNR

BSIP XBLNR

BSIS BELNR

CDCLS CHANGENR

CDHDR CHANGENR

CE1BROC BELNR

CE1DE02 BELNR

CE1MXOC BELNR

CE1USOC BELNR

CE4BROC_ACCT PAOBJNR

CKIS KALNR

CKMI1 AWREF

CMFP NR

COEP BELNR

COSB OBJNR

COSP OBJNR

COSS OBJNR

DBTABLOG LOGID

DRAO DOKNR

E071K AS4POS

EDI40 DOCNUM

GLPCA GL_SIRID

GLSP VARKEY

JCDS OBJNR

JEST OBJNR

KEKO KALNR

KEPH KALNR

KOCLU KNUMV

LIPS VBELN

LTAP TANUM

MCKALKW AUFNR

MLCR BELNR

MLCRF BELNR

MLCRP BELNR

MLIT BELNR

MSEG MBLNR

NAST OBJKY

PCL2 SRTFD

PCL4 SRTFD

PLMZ ZUONR

PLPO PLNNR

PPOIX PERNR

PTEX2000 AWKEY

QALS PRUEFLOGS

RESB RSNUM

RFBLG BELNR

S033 MBLNR

SOFFCONT1 PHIO_ID

STPO STLNR

STXH TDNAME

STXL TDNAME

SWWWIHEAD WI_ID

TST03 DNAME

USH12 AUTH

VAKPA VBLEN

VBAP VBELN

VBFA VBELN

VBFS SAMMG

VBPA VBELN

VBRP VBELN

YCDHDR CHANGENR

YCDPOS CHANGENR

YECCS_RPT_ARCH BUNIT

YRECON_DETAIL DOCNR

ZZ01TPA GL_SIRID

ZZGLA GL_SIRID

ZZJVA GL_SIRID

[markus_doehr2]

In split.txt you define the tables to split and in how many parts they are to be split.

R3ta.txt is used to find out, how the tables are to be split (which key field is used to generate the parts).

So all tables listed in split.txt must also be listed with the field in R3ta.txt, otherwise R3ta does not know how to split the tables - which is the error you see.

Markus

[Former Member]

In which path do we place the R3ta_hints.txt file?

By default it is there in the /sapmnt/<SID>/exe folder?

Its not picking up the data.

In earlier release it automatically calculated if the data was not there in the R3ta_hints.txt?

Can you kindly elaborate?

[markus_doehr2]

> In which path do we place the R3ta_hints.txt file?

usually the file is copied from the kernel directory.

> By default it is there in the /sapmnt/<SID>/exe folder?

yes

> Its not picking up the data.

sorry?

> In earlier release it automatically calculated if the data was not there in the R3ta_hints.txt?

How should R3ta know how to calculate?

Markus

[Former Member]

We used note 1043380 to do manual splitting from Oracle since we could'nt find R3ta.txt in the.../exe directory. We are still co ordinating with SAP to check why is that so.