unable to retrieve nametab info for logic table BSEG during Database Export

[Former Member]

Hi,

Our aim is to Migrate to New hardware and do the Database Export of the existing System(Unicode) and Import the same in the new Hardware

I am doing Database Export on SAP 4.7 SR1,HP-UX ,Oracle 9i(Unicode System) and during Database Export "Post Load Processing phase" got the error as mentioned in SAPCLUST.log

1. more SAPCLUST.log

/sapmnt/BIA/exe/R3load: START OF LOG: 20090216174944

/sapmnt/BIA/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#20

$ SAP

/sapmnt/BIA/exe/R3load: version R6.40/V1.4 [UNICODE]

Compiled Aug 13 2007 16:20:31

/sapmnt/BIA/exe/R3load -ctf E /nas/biaexp2/DATA/SAPCLUST.STR /nas/biaexp2/DB/DDLORA.T

PL /SAPinst_DIR/SAPCLUST.TSK ORA -l /SAPinst_DIR/SAPCLUST.log

/sapmnt/BIA/exe/R3load: job completed

/sapmnt/BIA/exe/R3load: END OF LOG: 20090216174944

/sapmnt/BIA/exe/R3load: START OF LOG: 20090216182102

/sapmnt/BIA/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#20

$ SAP

/sapmnt/BIA/exe/R3load: version R6.40/V1.4 [UNICODE]

Compiled Aug 13 2007 16:20:31

/sapmnt/BIA/exe/R3load -datacodepage 1100 -e /SAPinst_DIR/SAPCLUST.cmd -l /SAPinst_DI

R/SAPCLUST.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "BIA20071101021156

"

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "tinsp041

"

(GSI) INFO: sysname = "HP-UX"

(GSI) INFO: nodename = "tinsp041"

(GSI) INFO: release = "B.11.11"

(GSI) INFO: version = "U"

(GSI) INFO: machine = "9000/800"

(GSI) INFO: instno = "0020293063"

(EXP) TABLE: "AABLG"

(EXP) TABLE: "CDCLS"

(EXP) TABLE: "CLU4"

(EXP) TABLE: "CLUTAB"

(EXP) TABLE: "CVEP1"

(EXP) TABLE: "CVEP2"

(EXP) TABLE: "CVER1"

(EXP) TABLE: "CVER2"

(EXP) TABLE: "CVER3"

(EXP) TABLE: "CVER4"

(EXP) TABLE: "CVER5"

(EXP) TABLE: "DOKCL"

(EXP) TABLE: "DSYO1"

(EXP) TABLE: "DSYO2"

(EXP) TABLE: "DSYO3"

(EXP) TABLE: "EDI30C"

(EXP) TABLE: "EDI40"

(EXP) TABLE: "EDIDOC"

(EXP) TABLE: "EPIDXB"

(EXP) TABLE: "EPIDXC"

(EXP) TABLE: "GLS2CLUS"

(EXP) TABLE: "IMPREDOC"

(EXP) TABLE: "KOCLU"

(EXP) TABLE: "PCDCLS"

(EXP) TABLE: "REGUC"

myCluster (55.16.Exp): 1557: inconsistent field count detected.

myCluster (55.16.Exp): 1558: nametab says field count (TDESCR) is 305.

myCluster (55.16.Exp): 1561: alternate nametab says field count (TDESCR) is 304.

myCluster (55.16.Exp): 1250: unable to retrieve nametab info for logic table BSEG

.

myCluster (55.16.Exp): 8033: unable to retrieve nametab info for logic table BSEG

.

myCluster (55.16.Exp): 2624: failed to convert cluster data of cluster item.

myCluster: RFBLG *003**IN07**0001100000**2007*

myCluster (55.16.Exp): 318: error during conversion of cluster item.

myCluster (55.16.Exp): 319: affected physical table is RFBLG.

(CNV) ERROR: data conversion failed. rc = 2

(RSCP) WARN: env I18N_NAMETAB_TIMESTAMPS = IGNORE

(DB) INFO: disconnected from DB

/sapmnt/BIA/exe/R3load: job finished with 1 error(s)

/sapmnt/BIA/exe/R3load: END OF LOG: 20090216182145

/sapmnt/BIA/exe/R3load: START OF LOG: 20090217115935

/sapmnt/BIA/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#20

$ SAP

/sapmnt/BIA/exe/R3load: version R6.40/V1.4 [UNICODE]

Compiled Aug 13 2007 16:20:31

/sapmnt/BIA/exe/R3load -datacodepage 1100 -e /SAPinst_DIR/SAPCLUST.cmd -l /SAPinst_DI

R/SAPCLUST.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "BIA20071101021156

"

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "tinsp041

"

(GSI) INFO: sysname = "HP-UX"

(GSI) INFO: nodename = "tinsp041"

(GSI) INFO: release = "B.11.11"

(GSI) INFO: version = "U"

(GSI) INFO: machine = "9000/800"

(GSI) INFO: instno = "0020293063"

myCluster (55.16.Exp): 1557: inconsistent field count detected.

myCluster (55.16.Exp): 1558: nametab says field count (TDESCR) is 305.

myCluster (55.16.Exp): 1561: alternate nametab says field count (TDESCR) is 304.

myCluster (55.16.Exp): 1250: unable to retrieve nametab info for logic table BSEG

.

myCluster (55.16.Exp): 8033: unable to retrieve nametab info for logic table BSEG

.

myCluster (55.16.Exp): 2624: failed to convert cluster data of cluster item.

myCluster: RFBLG *003**IN07**0001100000**2007*

myCluster (55.16.Exp): 318: error during conversion of cluster item.

myCluster (55.16.Exp): 319: affected physical table is RFBLG.

(CNV) ERROR: data conversion failed. rc = 2

(RSCP) WARN: env I18N_NAMETAB_TIMESTAMPS = IGNORE

(DB) INFO: disconnected from DB

SAPCLUST.l/sapmnt/BIA/exe/R3load: job finished with 1 error(s)

/sapmnt/BIA/exe/R3load: END OF LOG: 20090217115937

og (97%)

The main eror is "unable to retrieve nametab info for logic table BSEG "

Your reply to this issue is highly appreciated

Thanks

Sunil

[Former Member]

Hello,

acording to this output:

/sapmnt/BIA/exe/R3load -datacodepage 1100 -e /SAPinst_DIR/SAPCLUST.cmd -l /SAPinst_DI

R/SAPCLUST.log -stop_on_error

you are doing the export with a non-unicode SAP codepage. The codepage has to be 4102/4103 (see note #552464 for details). There is a screen in the sapinst dialogues that allows the change of the codepage. 1100 is the default in some sapinst versions.

Best Regards,

Michael

[markus_doehr2]

- Did you do all the preparation steps (scans, vocabulary assignments, generation of nametab etc.) before you exported the database?

- please use the latest available tools always for Unicode conversions, your R3load is very old

Markus

[Former Member]

Hi Markus,

I am not doing unicode conversion because this System is already a unicode system.We have to replace the existing hardware with the new Hardware for that I am doing DB Export and same I will use for Import in the new hardware.

Could yu explain in details which steps you are refering to.

Thanks

Sunil

[markus_doehr2]

> I am not doing unicode conversion because this System is already a unicode system.

In this case you should do as advised and use the right codepage to export (Windows is little endian so 4103 should be used).

Also: Update your tools before you start the next attempt (R3ldctl, R3szchk, R3load) and also the database interface library (libdbsl).

Markus