Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 17, 2009 at 02:39 PM

    - 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

    Add comment
    10|10000 characters needed characters exceeded

    • > 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

  • avatar image
    Former Member
    Feb 18, 2009 at 10:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded