Monday, 2 September 2024

Cannot execute maxl statement. Essbase Error (1200448): [For Input string: "0,00"]

Cannot execute maxl statement.  Essbase Error (1200448): [For Input string: "0,00"]

Essbase 21c (EPM 11.2.18)

Error with a smartview Shared connection:



"Cannot execute maxl statement.  Essbase Error (1200448): [For Input string: "0,00"]

Do you want to connect with username/password?"

 

This cannot be use to create a private connection nor can a private connection be created manually

Cause:  Non-English install on Essbase/EPM Server

Fix:

Navigate to ..\Oracle\Middleware\user_projects\domains\essbase_domain\bin
 

Take backup and Edit file setDomainEnv.cmd


Add the parameter "-Duser.language=en" under EXTRA_JAVA_PROPERTIES:


set EXTRA_JAVA_PROPERTIES=-Duser.language=en -Djavax.management.builder.initial=weblogic.management.jmx.mbeanserver.WLSMBeanServerBuilder %EXTRA_JAVA_PROPERTIES%




Cannot execute maxl statement. Essbase Error (1200448): [For Input string: "0,00"]

Cannot execute maxl statement.  Essbase Error (1200448): [For Input string: "0,00"] Essbase 21c (EPM 11.2.18) Error with a smartvi...