EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB14318: Error ‘ORA-28000: the account is locked’ occurs while executing reports or accessing attribute elements in MicroStrategy Developer 9.4.1 and 10.x

Stefan Zepeda

Salesforce Solutions Architect • Strategy

Error ‘ORA-28000: the account is locked’ occurs while executing reports or accessing attribute elements in MicroStrategy Developer 9.4.1 and 10.x

SYMPTOM
The following error occurs in two-tier mode when users try to execute a report or try browsing attribute elements in Strategy Developer 9.4.1 and 10.x (the same error is reported in DSSError log file):
 

ka02R000000kcHWQAY_0EM440000002FRs.jpeg


QueryEngine encountered error: Call SQLDriverConnect got SQL_ERROR
ORA-2800: the account is locked

Driver's SQLSetConnectAttr failed.

 

CAUSE
This error can occur because of one of the following:

  1. An incorrect login name has been used in the database instance or connection mapping to connect to the warehouse.
  2. The user has entered the wrong password consequently for a maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the database administrator has locked the account.

ACTION
Verify that the database login name used is correct. For more information on the error, review following documents:
 

  • http://ora-28000.ora-code.com/
  • http://www.adp-gmbh.ch/ora/sql/create_user.html
Comment

0 comments

Details

Knowledge Article

Published:

May 15, 2017

Last Updated:

May 15, 2017