I'm trying to mount a database but it says the following error: ERROR #86: the database default collations is not available
I'm trying to mount a database but it says the following error: ERROR #86: the database default collations is not available
Comments
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.
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
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
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")Looking the console log I saw it saying error with collation 20.