Essbase: Validate a database against any errors with Maxl (part 2)
You have two options for attempting to validate an Essbase database: Esscmd and Maxl. This post is for using Maxl.
Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB220.127.116.11.102B025) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
MAXL> login; Enter UserName> admin Enter Password> *********** Enter Host> localhost
OK/INFO - 1051034 - Logging in user [admin]. OK/INFO - 1241001 - Logged in to Essbase.
MAXL> alter database TestApp.TestDB validate using error_file 'validate_error.log';
you will see a blinking curser for a few minutes and then you should get the results.
OK/INFO - 1005024 - Validate: no errors found during validation. OK/INFO - 1241115 - Database TestApp.TestDB altered.
If you had any errors, look at the validate_error.log file created in the applications db directory. In my environment, the directory is located at /Oracle/Middleware/user_projects/epmsystem/EssbaseServer/essbaseserver1/app/TestApp/TestDB.