Sql-error -4025, "application=UNICODE, LVC=ASCII " using LC10

[Former Member]

We installed the Livecache and we are trying to connect it to our SCM 50.

We recive in LC10 this error and we do not know how to solve it.

User/password are correct and the MaxDB instance is ONLINE in DBMGUI.

Any suggestion ?

Into the dev_* trace we see:

"Tue Sep 25 17:16:54 2007

create_con (con_name=LCA)

Loading DB library 'E:\usr\sap\PS1\DVEBMGS00\exe\dbsdbslib.dll' ...

Library 'E:\usr\sap\PS1\DVEBMGS00\exe\dbsdbslib.dll' loaded

Version of 'E:\usr\sap\PS1\DVEBMGS00\exe\dbsdbslib.dll' is "700.08", patchlevel (0.104)

New connection 1 created

Connect to LCA as PL1ADM with myhost-PL1

DBSDBSLIB : version 700.08, patch 0.104 (Make PL 0.111)

MAXDB shared library (dbsdbslib) patchlevels (last 10)

(0.104) Update statistic with empty schemas (note 1041547)

(0.095) MaxDB DBSL patch collection 1 2007 (note 1014270)

(0.082) MaxDB DBSL patch collection 3 2006 (note 991258)

(0.079) MaxDB DBSL patch collection 2 2006 (note 984406)

(0.068) MaxDB DBSL patch collection 1 2006 (note 962708)

(0.051) DB50 perm block defect (note 934194)

(0.046) ADBC: invalid data when fetching cursor with hold (note 925337)

(0.045) Signal 11 during creation of BIA index (note 920743)

(0.038) MaxDB DBSL patch collection 2 2005 (note 908602)

(0.034) Livecache unicode connect (use SDK 7.6.0 b11) (note 901576)

Loading SQLDBC client runtime ...

SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

SQLDBC Library Version : libSQLDBC 7.6.0 BUILD 029-123-130-265

SQLDBC client runtime is MaxDB 7.6.0.029 CL 130265

SQLDBC supports new DECIMAL interface : 0

SQLDBC supports VARIABLE INPUT data : 0

Try to connect as PL1ADM/<pwd>@mihost-PL1 on connection 1 ...

Tue Sep 25 17:16:55 2007

Attach to SAP DB : Kernel 7.6.02 Build 014-123-152-175

Database release is SAP DB 7.6.02.014

INFO : Database 'PL1' instance is running on 'myhost'

INFO : LVC DEFAULTCODE = ASCII

• ERROR => different codepage: application=UNICODE, LVC=ASCII

C *** ERROR => different codepage: application=UNICODE, LVC=ASCII

[dbslsdb.cpp 4668]

B ***LOG BY2=> sql error -4025 performing CON [dbds#1 @ 1044] [dbds 1044 ]

B ***LOG BY0=> <message text not available> [dbds#1 @ 1044] [dbds 1044 ]"

[Former Member · Accepted solution]

Roberto,

The error is at the very end of the log you sent.

Looks like the LiveCache has a default code page ASCII while your SCM 5.0 system is running Unicode.

The SAP coding at the kernel obviously sees this as an 'impossible' mismatch.

Was there an option to install LVC as unicode? Otherwise, you'll need to open a ticket with SAP with this same information.

Oh, and check OSS note - Note 882788 - LiveCache code page problem with Solution Manager. I know you are connecting to a SCM system, but the issue is the same. Looks like an updated WAS700 kernel (db componenets at least) was the fix. Please note the WARNING not to set the profile parameter in an SCM system, as this will trash you LVC data (which is very bad

-Tim

[Former Member]

Hello Roberto,

check with dbmcli : param_getvalue DEFAULT_CODE

if it returns ASCII, set it to UNICODE.

It worked for me, Hope it will work for you?

Regards,

Tushar