Syntax Error while running step 34 (35) after unicode conversion

[Former Member]

Hello,

We are converting our test system to Unicode to find out how to do it

in our production system. We are at step 34/35 (Starting RFC job's) in

the database installation so we are almost done but we have encounted a

problem that we can't find a solution to. The error log in Sapinst give this

information:

ERROR      2008-11-09 11:19:19 [iaxxrfcimp.cpp:1103]           CAbRfcImpl::performFunctionCall FRF-00025  Unable to call function. 
Error message: ?`>?/?????????>??????/_???&<?(????????????????????????????????????????????????? .

At the same time we can read the following text in dev_w1 (and dev_w0 and so on):

A  *** ERROR => Syntax error in program SAPLBTCH                                 [abgen.c      1388]
A  *** ERROR => > Include LBTCHF39                                 line 173 [abgen.c      1390]
A  *** ERROR => > Statement "âu2018âu2018âu2018âu2018âu2018IF" is not defined. Check your spelling. spelling. [abgen.c      1393]

The error don't always look the same, here is another example:

A  *** ERROR => Syntax error in program SAPLSALC                                 [abgen.c      1388]
A  *** ERROR => > Include LSALCU54                                 line 55 [abgen.c      1390]
A  *** ERROR => > No component exists with the name "MTSYSIDâu2018MTMCNAMEâu2018MTNUMRANGEâu2018MTUIDâu2018". "MTSYSID [abgen.c      1393]
A  *** ERROR => > âu2018MTMCNAMEâu2018MTNUMRANGEâu2018MTUIDâu2018". [abgen.c 1395]

The common thing is Syntax error. If we try to log in to the system using SAP Gui we get this message: "Syntax error in program SAPMS380".

In the file dev_disp we can read a lot of these:

Tue Nov 11 14:06:32 2008
*** WARNING => DpRqServiceQueue: timeout of HIGH PRIO msg, return DP_CANT_HANDLE_REQ

But we should have enough WP since noone has loggen on to the system.

Facts:

Tue Nov 11 14:06:07 2008
kernel runs with dp version 138000(ext=102000) (@(#) DPLIB-INT-VERSION-138000-UC)
length of sys_adm_ext is 524 bytes
sysno      60
sid        S01
systemid   274 (HP (IA-64) with HP-UX)
relno      6400
patchlevel 0
patchno    258
intno      20020600
make:      single threaded, Unicode, 64 bit
pid        20538

HPUX on Intel IA64 with Oracle 10.0.2.0.2

SAP ERP Central Component 5.0

SAP_ABA 640 0021 SAPKA64021

SAP_BASIS640 0021 SAPKB64021

Please let me know that there is some small setting that I can change to regenerate the programs or something like that...

Br Linus Hellsing

[Former Member]

Hi Linus,

it seems that you have chosen the wrong Unicode codepage. Which codepage have you used in your export? There are two Unicode codepages 4102 and 4103 (big endian and little endian) which could be used depending on your platform. You have to choose the codepage right for your server running the migration R3load. If your migration is running on HP-UX, you need to run your conversion with 4102.

Do you see a huge database growth during migration. If yes, this would be another indicator for a wrong codepage. Normally your system should not grow a lot due to Unicode migration.

If yes, then you have to reexecute the migration.

Regards

Ralph

[Former Member]

Hello Ralph

Thank you for your quick answer.

During my export I use:

Oracle -> Database system -> Character set = WE8DEC

ABAP System -> Export -> Data File Code Page = 4102

I start the export like this:

SAP ERP 2004 SR1 - System Copy - Source System ->

ABAP System u2013 Oracle - Non-Unicode - ABAP Database Content Export

And the import like this:

SAP ERP 2004 SR1 - System Copy - Target System ->

ABAP System u2013 Oracle - Unicode - Central inst. inst.

SAP ERP 2004 SR1 - System Copy - Target System ->

ABAP System u2013 Oracle - Unicode - Database inst. inst.

I have heard that I should have used some other Character set during the export or that I should start

the export using the Unicode "ABAP Database Content Export" instead of the Non-Unicode "ABAP

Database Content Export". Can you confirm any of this for me 'cause it seems a bit strange to me...?

Br Linus Hellsing

[Former Member]

Hello Linus,

could you send the first five lines of one of your TOC-files and also a header of the corresponding export and import log-files? This would help to analyze your procedure.

You can do the Unicode migration during export and also during import. Normally it is easier to convert during import because this leads to less restrictions during import. If you convert during export you have to choose data code page 410x as you wrote. I'm not sure if it is important if you start as Non-Unicode or as Unicode, but in your file headers I would see if you done it write from a process perspective.

Regards

Ralph

[Former Member]

Hello Ralph

Here they are:

TOC files

SAPAPPL0.TOC:

vn: R6.40/V1.4
id: 084ac0df0000003d
cp: 4102
data_with_checksum
tab: [HEADER]
fil: SAPAPPL0.001 1024

SAPAPPL1.TOC:

vn: R6.40/V1.4
id: 084ac0df0000003d
cp: 4102
data_with_checksum
tab: [HEADER]
fil: SAPAPPL1.001 1024

EXPORT log:

SAPAPPL0.log

/sapmnt/S01/exe/R3load: START OF LOG: 20081029110702

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4
Compiled Aug 16 2008 18:01:48
/sapmnt/S01/exe/R3load -ctf E /mnt/s01_exp_uni/DATA/SAPAPPL0.STR /mnt/s01_exp_uni/DB/DDLORA.TPL /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0.TSK ORA -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0.log 


/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081029110703

/sapmnt/S01/exe/R3load: START OF LOG: 20081029110709

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4
Compiled Aug 16 2008 18:01:48
/sapmnt/S01/exe/R3load -datacodepage 4102 -e /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0.log -stop_on_error 

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC
(EXP) INFO: check NameTab widths: Ok.
(DB) INFO: Export without hintfile
(RSCP) INFO: UMGCOMCHAR read check, OK.
(RSCP) INFO: init SUMG interface; package name: "SAPAPPL0".
(RSCP) INFO: "/mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0001.xml" created.
(RSCP) INFO: environemnt variable "I18N_POOL_WIDTH" is not set. Checks are active.
(RSCP) INFO: I18N_NAMETAB_TIMESTAMPS not in env: checks are ON (Note 738858)
(RSCP) INFO: UMGSETTINGS nametab creation: ok.
(RSCP) INFO: Global fallback code page = 9491
(RSCP) INFO: Common character set is  not  7-bit-ASCII
(RSCP) INFO: Collision resolution method is 'fine'
(RSCP) INFO: R3trans code pages = Normal
(RSCP) INFO: EXPORT TO ... code pages = Normal
(RSCP) INFO: Check for invalid language keys: activated
(RSCP) INFO: I18N_NAMETAB_NORM_ALLOW = 999999999
(RSCP) INFO: I18N_NAMETAB_NORM_LOG   = 1000000002
(RSCP) INFO: I18N_NAMETAB_ALT_ALLOW  = 10000
(RSCP) INFO: I18N_NAMETAB_ALT_LOG    = 10003
(RSCP) INFO: I18N_NAMETAB_OLD_ALLOW  = 0
(RSCP) INFO: I18N_NAMETAB_OLD_LOG    = 500
(GSI) INFO: dbname   = "S0120081016081020                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(GSI) INFO: instno   = "1220008646"
(EXP) TABLE: "/BDL/LOCK"
(EXP) TABLE: "/BEV1/BO_CONT"
(EXP) TABLE: "/BEV1/BO_ENQUEUE"
(EXP) TABLE: "/BEV1/CLCONT1"
(EXP) TABLE: "/BEV1/CLDEB"

and so on

(EXP) TABLE: "ADR9S2"
(CNV) WARNING: code page conversion problem
               Number of substitutions: 4
      (row 30 of current buffer, table ADRC)
CLIENT 30 30 30                                        |000             |
ADDRNUMBER 30 30 30 30 30 31 34 38 36 39                   |0000014869      |
DATE_FROM 30 30 30 31 30 31 30 31                         |00010101        |
NATION 20                                              |                |
(CNV) WARNING: code page conversion problem
               Number of substitutions: 2
      (row 41 of current buffer, table ADRC)
CLIENT 30 30 30                                        |000             |
ADDRNUMBER 30 30 30 30 30 32 31 39 38 32                   |0000021982      |
DATE_FROM 30 30 30 31 30 31 30 31                         |00010101        |
NATION 20                                              |                |
(RSCP) INFO: 51 lines written to /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0001.xml
(EXP) TABLE: "ADRC"
(RSCP) INFO: 3 lines written to /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL0001.xml
(EXP) TABLE: "ADRCOMC"

and then its the same with table SETHEADERT and SKAT and SNAP and STXH.

I will not include the whole file as it is 14213 lines long.

SAPAPPL1.log

/sapmnt/S01/exe/R3load: START OF LOG: 20081029110701

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4
Compiled Aug 16 2008 18:01:48
/sapmnt/S01/exe/R3load -ctf E /mnt/s01_exp_uni/DATA/SAPAPPL1.STR /mnt/s01_exp_uni/DB/DDLORA.TPL /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL1.TSK ORA -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL1.log 


/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081029110702

/sapmnt/S01/exe/R3load: START OF LOG: 20081029110709

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4
Compiled Aug 16 2008 18:01:48
/sapmnt/S01/exe/R3load -datacodepage 4102 -e /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL1.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL1.log -stop_on_error 

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC
(EXP) INFO: check NameTab widths: Ok.
(DB) INFO: Export without hintfile
(RSCP) INFO: UMGCOMCHAR read check, OK.
(RSCP) INFO: init SUMG interface; package name: "SAPAPPL1".
(RSCP) INFO: "/mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/EXPORT/ABAP/COPY/NUC/DBEXP/SAPAPPL1001.xml" created.
(RSCP) INFO: environemnt variable "I18N_POOL_WIDTH" is not set. Checks are active.
(RSCP) INFO: I18N_NAMETAB_TIMESTAMPS not in env: checks are ON (Note 738858)
(RSCP) INFO: UMGSETTINGS nametab creation: ok.
(RSCP) INFO: Global fallback code page = 9491
(RSCP) INFO: Common character set is  not  7-bit-ASCII
(RSCP) INFO: Collision resolution method is 'fine'
(RSCP) INFO: R3trans code pages = Normal
(RSCP) INFO: EXPORT TO ... code pages = Normal
(RSCP) INFO: Check for invalid language keys: activated
(RSCP) INFO: I18N_NAMETAB_NORM_ALLOW = 999999999
(RSCP) INFO: I18N_NAMETAB_NORM_LOG   = 1000000002
(RSCP) INFO: I18N_NAMETAB_ALT_ALLOW  = 10000
(RSCP) INFO: I18N_NAMETAB_ALT_LOG    = 10003
(RSCP) INFO: I18N_NAMETAB_OLD_ALLOW  = 0
(RSCP) INFO: I18N_NAMETAB_OLD_LOG    = 500
(GSI) INFO: dbname   = "S0120081016081020                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(GSI) INFO: instno   = "1220008646"
(EXP) TABLE: "/BDL/ADDONKEYS"
(EXP) TABLE: "/BDL/BADHOST"

and so on until

(EXP) TABLE: "SEWADATCOL"
(EXP) TABLE: "SFHX"
(CNV) WARNING: code page conversion problem
               Number of substitutions: 1
      (row 3519 of current buffer, table SFIWP)
LANGU 4a                                              |J               |
WORDF 82 41 45 82 a8 82 ad 95 4b 97 56 82 aa 82 a0 82 |.AE.¨.­.K.V.ª. .|
WORDF c8 82 55 45 82 b7 81 42 20 20 20 20 20 20 20 20 |È.UE.·.B        |
WORDF 20 20 20 20 20 20 20 20                         |                |

and table STERM_TEXT. As before I will not include it all, the log file is 7775 lines long.

IMPORT log

SAPAPPL0.log

/sapmnt/S01/exe/R3load: START OF LOG: 20081106102704

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -ctf I /mnt/s01_exp_uni/DATA/SAPAPPL0.STR /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/DDLORA.TPL /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.TSK ORA -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.log 


/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081106102705

/sapmnt/S01/exe/R3load: START OF LOG: 20081106103529

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -dbcodepage 4102 -i /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.log -stop_on_error -k 54FB9C39DB 

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(GSI) INFO: dbname   = "S0120081106091135                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(DB) INFO: /BDL/LOCK created #20081106103642

(IMP) INFO: import of /BDL/LOCK completed (0 rows) #20081106103642

(DB) INFO: /BDL/LOCK~0 created #20081106103642

(DB) INFO: /BEV1/BO_CONT created #20081106103642

and so on until the end:

(DB) INFO: ZWF_STATUSCHANGE created #20081106173307

(IMP) INFO: import of ZWF_STATUSCHANGE completed (0 rows) #20081106173307

(DB) INFO: ZWF_STATUSCHANGE~0 created #20081106173307

(DB) INFO: disconnected from DB

/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081106173307

/sapmnt/S01/exe/R3load: START OF LOG: 20081107092517

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -dbcodepage 4102 -i /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.log -stop_on_error -k 54FB9C39DB 

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(GSI) INFO: dbname   = "S0120081106091135                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(DB) INFO: disconnected from DB

/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081107092541

/sapmnt/S01/exe/R3load: START OF LOG: 20081107111014

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -dbcodepage 4102 -i /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL0.log -stop_on_error -k 54FB9C39DB 

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(GSI) INFO: dbname   = "S0120081106091135                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(DB) INFO: disconnected from DB

/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081107111041

The log file is 81163 lines long.

SAPAPPL1.log

/sapmnt/S01/exe/R3load: START OF LOG: 20081106102702

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -ctf I /mnt/s01_exp_uni/DATA/SAPAPPL1.STR /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/DDLORA.TPL /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL1.TSK ORA -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL1.log 


/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081106102703

/sapmnt/S01/exe/R3load: START OF LOG: 20081106103529

/sapmnt/S01/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP
/sapmnt/S01/exe/R3load: version R6.40/V1.4 [UNICODE]
Compiled Aug 16 2008 18:23:56
/sapmnt/S01/exe/R3load -dbcodepage 4102 -i /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL1.cmd -l /mnt/s01_exp_uni/tmp/sapinst_instdir/ECC50/COPY/IMPORT/SYSTEM/ABAP/ORA/UC/DB/SAPAPPL1.log -stop_on_error -k 54FB9C39DB 

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(GSI) INFO: dbname   = "S0120081106091135                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "scar                                                            "
(GSI) INFO: sysname  = "HP-UX"
(GSI) INFO: nodename = "scar"
(GSI) INFO: release  = "B.11.23"
(GSI) INFO: version  = "U"
(GSI) INFO: machine  = "ia64"
(DB) INFO: /BDL/ADDONKEYS created #20081106103603

(IMP) INFO: import of /BDL/ADDONKEYS completed (0 rows) #20081106103603

(DB) INFO: /BDL/ADDONKEYS~0 created #20081106103603

(DB) INFO: /BDL/BADHOST created #20081106103603

(IMP) INFO: import of /BDL/BADHOST completed (0 rows) #20081106103603

(DB) INFO: /BDL/BADHOST~0 created #20081106103603

And so on until the end:

(DB) INFO: ZWF_INVH created #20081107211801

(IMP) INFO: import of ZWF_INVH completed (116640 rows) #20081107211817

(DB) INFO: ZWF_INVH~0 created #20081107211818

(DB) INFO: ZWF_INVI created #20081107211818

(IMP) INFO: import of ZWF_INVI completed (20557 rows) #20081107211820

(DB) INFO: ZWF_INVI~0 created #20081107211820

(DB) INFO: disconnected from DB

/sapmnt/S01/exe/R3load: job completed
/sapmnt/S01/exe/R3load: END OF LOG: 20081107211820

The log file is 52583 lines long.

There are 55 import log files and 28 export log files.

I hope some of this information is helpful for you and thank you again for your assistance!

Br Linus Hellsing

[Former Member]

Hi Linus,

from a process perspective it looks good. Your R3load executables also look pretty new. Could you check something in addition?

Please connect with "sqlplus / as sysdba" and execute the following:

sql> select * from <sapschema>.t100 where rownum < 10;

and check that all texts are readable. If your conversion was successful, you should be able to read every row. Maybe you could not read chinese, but you should see if it makes sense or not. You may select also a language of your choice to verify the conversion by executing:

sql> select * from <sapschema>.t100 where sprsl = 'E' and rownum < 10;

Regards

Ralph

[Former Member]

Hello Ralph

We decided to do everything from the beginning again. We have already deleted our (almost) unicode database so we can't execute what you suggest anymore. I hope you will be online after a week if we encounter the same problem again.

Thank you anyway for your time!

Br Linus Hellsing

[Former Member]

Hello again,

The unicode conversion is now finished again with the same results, syntax error.

We have tested your texts and they are readable. We have found a perhaps interesting thing in the export log:

<USED_CP>9491</USED_CP>
<!-- Language ' ' has no code page assigned. -->

This is repeated many times in a .xml-file while the log file SAPSSEXC.log reports

rscpMCConvertNeutral warn: 1 substitutions 
field: block

and a bit later:

EXP) TABLE: "REPOSRC".

Could it be so that the export does not succeed with the export due to some missing settings in our test system?

The problem seems to be related to the generation (compiling) of the programs.

Edit: Annoyingly wide frame

Br Linus Hellsing

[Former Member]

Hi Linus,

I'm sorry but you should open a ticket at SAP support for that. This has to be investigated by someone in development I assume. It does look to strange to me.

Regards

Ralph

[Former Member]

Ok, thank you anyway!

For future reference I will post the results in this thread. Lets hope there will be some results...

Br Linus Hellsing

[Former Member]

Hi ,

Iam also facing the same issue , were you able to find out what caused the issue .. Please let me know how you resolved this issue.

Regards

Ram

[Former Member]

Hello Ram Prakash Anandapadmanaban

It turned out to be a problem with our codepage. There was a couple of characters that had the same "Byte Sequence". I can give you an example of my problems from my codepage:

U+0007 (BELL) had byte sequence 07.

U+2440 (OCR HOOK) also had byte sequence 07.

This is ok as long as they have different strength so I moved my extra characters to segments with the strength "weak" (or just delete the character you don't want). You can do this in t-code SCP.

Best of luck!

Linus Hellsing

[Former Member]

Hi Linus Hellsing ,

Thanks for your reply , I have resolved the issue , but for me the problem was with the SAPVIEW.STR , i re imported this package again and the system started working . Any way thanks for your reply .

Regards

Ram Prakash.A