Database error - 4025 at CON

[Former Member]

We have just come up with a parallel environment for our APO landscapes and now trying to configure a new LIVE cache

The issue is when we try to do a Live Cache Consistency check we get the error from system log

Database error -4025 at CON

please advise on how to resolve this error

[former_member229109]

Hello,

database error "-4025: Unknown or not loaded character set".

=> Do you have unicode system?

Did you connect to the liveCache as user of unicode type?

< check the LCA connection for the liveCache standard user, also you will see in the dev log the liveCache user name.

Then run "select * from users" and check the type of the user. >

Did you run the system copy using note:

Note 886103 System Landscape Copy for SAP SCM

or it's brand new installation?

What is the SCM version & SP stack of your system?

What is the version of the liveCache?

"We have just come up with a parallel environment for our APO landscapes and now trying to configure a new LIVE cache"

=> What do you mean? Could you collobarate more on what was done with your system or what is your new project?

"The issue is when we try to do a Live Cache Consistency check we get the error from system log

Database error -4025 at CON"

=> It will be helpful to check the dev log of the corresponding WP, liveCache logs, LCA logs ...

"please advise on how to resolve this error"

=> Open the SAP message to the component "BC-DB-LCA". We need to login to the system to check what was done on the system, review the logs first and discuss with you the "project" steps.

Regards, Natalia Khlopina

[Former Member]

Hello,

Thanks for ur quick response.

We are currently on SCM 7 with SP 4 and Live cache 7.7 , we did a System copy as per the note you mentioned

The Live Cache standard user is of "DEFAULT" type, But SCM is Unicode.

Please advise how to change the Live cache standard user type to UNICODE, so that the SQL read from SCM to LIVE cache MAX DB will be possible.

Thanks

Edited by: Jalandar Reddy Nalleda on May 18, 2011 7:14 AM

[former_member229109]

Hello,

1. I recommend to create the SAP message to check the issue first, if you have the application data in liveCache.

2. If the system is migrated to unicode, then may be you missed some steps of the note 632357.

3. If you run "the Homogenous liveCache copy", then steps of note 877203 may be missing.

Was your source system of UNICODE type?

What is the liveCache user of source liveCache?

Connect to the target liveCache & post output of the SQLStatent "select * from users".

Regards, Natalia Khlopina

[Former Member]

Hello,

Thanks for your help, The issue resolved by setting the default code page to UNICODE using DBM Manager, peformed as below witht the help of note 680556 and restarted LC from LC10.

param_startsession

param_put DEFAULT_CODE UNICODE

param_checkall

param_commitsession

Thanks

Jalandar

[former_member229109]

Hello,

From the information you posted itu2019s not clear what is the correct solution for you.

You run the system copy using note:

Note 886103 System Landscape Copy for SAP SCM

=>

1. If you did Heterogeneous liveCache copy, then DEFAULT_CODE liveCache parameter need to be set to Unicode, as one of recommended steps before you run the download C section steps of //OM_LC_DOWNLOAD_UPLOAD report during the Unicode conversion migration.

< you missed some steps of the note 632357. See more details in this note >

And you running u201CLive Cache Consistency checku201D. What is that?

Did you run internal database/liveCache inconsistencies checks using //om17 transaction?

< If yes, then you already past the download step. Correct? >

OR

2. If you run "the Homogenous liveCache copy", then steps of note 877203 may be missing after you followed the note:

457425 Homogenous liveCache copy using backup/restore

Was your source system of UNICODE type?

What is the liveCache user of source liveCache?

Connect to the target liveCache & post output of the SQLStatent "select * from users".

Who is the owner of the liveCache application data in the target liveCache?

==>

You need to post first additional information :

Did you run Heterogeneous liveCache copy or Homogenous liveCache copy?

Regards, Natalia Khlopina