We've installed Essbase 21.3 On Prem and are trying to run a SQL data load using an existing rule migrated from our 11.1.2.4 installation.
We are getting this error on every record because it's scrambling the data values/numerics (see attached):
\\ Invalid number [㐵㜰㌴㌲⸲〰〰〰〰0] in data column
It's not the SQL server language settings because the same SQL query returns fine in SQL.
Same behaviour in EAS Console and Essbase Web.
Tried both Oracle and Data Direct SQL Drivers but same result with both.
Connected to old SQL server where it works, same result.
So, it must be a language setting on this new Essbase install. Any ideas?