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 (ESB18.104.22.168.102B025)
Copyright (c) 2000, 2012, Oracle and/or its affiliates.
All rights reserved.
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.
Please follow and like us: