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 (ESB11.
 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.

Good luck!



Add a Comment

Your email address will not be published. Required fields are marked *

(adsbygoogle = window.adsbygoogle || []).push({});