DB export (MSSQL Server 2005) error and Data file code page

[hanse_atik2]

Hi,

by exporting the DB I get the following error message in many logsfiles:

env I18N_NAMETAB_TIMESTAMPS not set

I found in SDN that this is an issue of the code page and I think so. As I can see in SAPinst the code page is set to: 1100.

There is a possibiliy on SApinst to change it.

My question is: Which code page should be used in this case?

The export and the import should be done on MSSQL Server 2005

Thanks in advance

Best regards

HanseAtik

[former_member184473]

Hello Hanse,

Which is your kernel version? Which is the SDN you found?

Check if note [978244|http://service.sap.com/sap/support/notes/978244] is related to your case.

Regards,

Eduardo Rezende

[hanse_atik2]

Hi,

the SAP Kernel version is: SAP R/3 Kernel 640_REL

regards

HanseAtik

[former_member184473]

Hello Hanse,

Are you using at least R3load version 71?

On note 978244:

If such an R3load is not available, set two environment variables:
I18N_NAMETAB_OLD_ALLOW=5000
I18N_NAMETAB_OLD_LOG=5000

Regards,

Eduardo Rezende

[hanse_atik2]

Hi,

this is what I have.

D:\usr\sap\DEV\SYS\exe\run>r3load -v

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

This is r3load version R6.40/V1.4 [UNICODE]

Compiled Oct 30 2006 00:15:11

I changed code page from the standard 1100 to 5000 and the export worked and the export file increased from 2 GB to 4 GB but then ended with the same error message:

.

(NT) Error: DOKCLU : normal NameTab from 20050112230750 younger than alternate NameTab from 20000323224119!

Syslog: k CQF : DOKCLU &20000323224119&2005011rscpgdio 47

myCluster (55.11.Exp): 873: received return code 64 from rscpCheckNTTimeStamps.

myCluster (55.11.Exp): 874: suspicious create timestamp of alternate nametab encountered.

myCluster (55.11.Exp): 878: create timestamps of nametab: 20050112230750; alternate nametab: 20000323224119.

myCluster (55.11.Exp): 297: error when retrieving physical nametab for table DOKCLU.

(CNV) ERROR: code page conversion failed

rc = 2

.--

---

============--

---

.

RSCP - Error

Error from: Codepage handling (RSCP) 3

code: 64 RSCPECALL Illegal mixture of procedure calls.

Altername NameTab too old

module: rscpgdio no: 47 line: 2876 T100: TS007

TSL01: CQF p3: DOKCLU &20000323224119&2005011

`----

---

'

(rscpMC) Warn: env I18N_NAMETAB_TIMESTAMPS not set

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20110328104310

-

---

Best regards

HanseAtik

[nils_buerckel]

Hi,

can you please describe your scenario ?

Is your source system based on Unicode ?

If not, which code page is used (content of table TCPDB) ?

If Non-Unicode, do you plan to do a Unicode conversion ?

Please also have a look at SAP note 738858. However this one is important only, if you want to do a Unicode conversion.

Best regards,

Nils Buerckel

SAP AG

[hanse_atik2]

Hi.

My scenario:

I am exporting a DB from the source system which is: 32bit, Mysap 2005, MSSQL Server 2005, Unicode:

The code pape which is now used by SAPinst is: 1100

As I mentioned I had the same error message before but after I changed the code page from 1100 to 5000 and the export worked and exported about 2 GB and stoped.

I ust dowloaded the newest R3load.exe from SAPNet :

000001 View content info Add to download basket R3load_137-20000971.SAR R3LOAD

* Support Package SAP KERNEL 7.00 32-BIT UNICODE Windows Server on IA32 32bit DB2 UDB)*

And when I check the version of R3load it gives the following error:

D:\t>r3load -v

Could not open the ICU common library.

The following files must be in the path described by

the environment variable "PATH":

icuuc30.dll, icudt30.dll, icuin30.dll [nlsui0.c 1610] pid = 4504

So it is not poosible to use the new version of R3load, if I have the correct one.

Current status:

I I ust deleted the exported files and logsfile under SAPinst_Instdir AND start the export. Now I get the following error message:

MOS-01012 Problem: D:\usr\sap\DEV\SYS\exe\run\R3lldctl.exe -l

./R3dctlExport.log -p Z:\db_export/DATA/ returned with '2' which is not defined as a success code.

Thanks and best regards

HanseAtik

Edited by: Hanse Atik on Mar 29, 2011 11:22 AM

Edited by: Hanse Atik on Mar 29, 2011 1:56 PM

[nils_buerckel]

Hi,

in this case your system uses code page 4103 (UTF-16 LE). And this code page should be used for the export (hence no conversion is triggered).

Not sure what happens, if you select 5000 (which is as far as I know not a valid code page number).

Maybe the system then defaults to 4103 (and your current problem is caused by some other issue) ...

However I would retry with code page number 4103.

Best regards,

Nils

[hanse_atik2]

Hi Nils,

Thanks for fhe reply.

I tried with code page 4301 as you mentioned but I got the same error.

Best regards

HanseAtik

Edited by: Hanse Atik on Mar 29, 2011 4:15 PM

[nils_buerckel]

Hi,

I assume you used code page 4103 (and not 4301 as written above) ....

Regarding the mentioned error (MOS-01012), did you check the log R3dctlExport.log for errors ?

Best regards,

Nils

[markus_doehr2]

> 000001 View content info Add to download basket R3load_137-20000971.SAR R3LOAD

> * Support Package SAP KERNEL 7.00 32-BIT UNICODE Windows Server on IA32 32bit DB2 UDB)*

>

> And when I check the version of R3load it gives the following error:

> D:\t>r3load -v

> Could not open the ICU common library.

> The following files must be in the path described by

> the environment variable "PATH":

> icuuc30.dll, icudt30.dll, icuin30.dll [nlsui0.c 1610] pid = 4504

>

> So it is not poosible to use the new version of R3load, if I have the correct one.

You are using a Unicode kernel and the kernel doesn't find the proper ICU libraries.

Make sure the system can be started with the kernel and that those libraries are in the system PATH.

Markus