Error <COLLATEMISMATCH> Studio
Hello, I am writing to you because I am receiving a strange error on our Integration server after restoring a Production copy.
On other occasions we had restored the Production copy on this server without problems (in fact it was done weekly)
After restoring the copy when entering the Studio this error appears:
.png)
I've checked the documentation about this error:
.png)
But I don't know what I must check.
Do you know what it could be?
Thank you!
Comments
Looks like an error with the mapping of globals among namespaces:
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…
Hi @Daniel Aguilar
for every DB you have a default collation that is tied to DB:
you can see it in SMP System > Configuration > Local Databases > Database Properties.png)
this is the standard.
If the collation of your source server is Spanish, German, Fench, , ....
the DB may have used this national collation as default.
On your target serve you need to have this collation to be installed.
in SMP System > Configuration > Locale Definitions you see what is installed on your Caché instance.png)
You may need to add the missing collation table to your Caché instance:
.png)
Hello, I think you are both right.
Checking the namespaces we found that some of them had Cache Standard Collation and others Spanish1.
.png)
It seems there was some problem restoring the copy. We manualy copied the namespaces with Spanish1 collation again and they now appear correctly as Cache Standard.
Thanks @Luis Angel Pérez Ramos and @Robert Cemper !!