I'm trying to mount a database but it says the following error: ERROR #86: the database default collations is not available

Question

Question

Nildo Torres · Jun 16, 2023

Product version: Caché 2018.1

$ZV: 2018.1.5

Discussion (5)2

Log in or sign up to continue

Robert Cemper · Jun 17, 2023

in Caché it is %installdir%/mgr/cconsole.log
and you can see it from MgmtPortal
and it would be helpful if you uncover the primary language you use

0 0

Lorenzo Scalese · Jun 18, 2023

Hello @Nildo Torres ,

If the collation to install is identified, you can use the following classmethod :

Set $Namespace = "%SYS"
; Change fraw by the locale you need.
Set sc = ##class(Config.NLS.Locales).Install("fraw")

0 0

score 0 · Answer 1 · 2023-06-16T08:08:05-04:00

Looks like the database was created with a different collation, and contains a few globals with this collation.

I don't remember, but I think in the messages.log it should show which collation is expected. And then, you can change it in Management Portal, and with NLS. When you activate NLS which contains the expected collation, it will be able to mount this database.

score 0 · Answer 2 · 2023-06-17T15:38:11-04:00

Hi Dmitry!! Hope you are doing well!!

Could you please describe your procedure in more detail please. I did not find messages.log file and could please explain in more detail how I could do that in Management Portal, since this the .dat file is in offline state. You mentioned about activate NLS could please give me more detail about that.

Thank you very much in Advanced.

Nildo Torres

score 0 · Answer 3 · 2023-06-25T09:13:01-04:00

Nildo Torres · Jun 25, 2023

Looking the console log I saw it saying error with collation 20.

0 0