Category Archives: Berry van den Heuvel
Unlock a user
If logging in to OBIEE is failing, it is possible that the account is locked; there is no message displayed that tells us that the account is locked.
This is how a user can be unlocked.
- log in to the console
- click bifoundation_domain
- click Security
- click Unlock User
- enter the username
- click Save
The message User successfully unlocked appears.
The “successful” message will always appear; also if the user wasn’t locked or when a user doesn’t exists!
But, when the user exists and was locked, it will be possible to log in again.
Het bericht Unlock a user verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
The Logical Column is not assigned to a Level
Problem: model check warning / Error No. 39071
Screenshot:
Screenshot text:
[39071] The Logical Column [COLUMN] is not assigned to a Level. Aggregate Persistence may create large aggregates.
Solution:
- go to the logical column
- double click on the logical table name
- go to the tab Levels
- select Logical Dimension
- select Logical Level
- close the pop-up
- do a model check
The warning / error message is not displayed anymore.
Het bericht The Logical Column is not assigned to a Level verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Blacklisted connectionpool
Problem: Error No. 43143 in Enterprise Manager
Screenshot:
Screenshot text:
[43143] Blacklisted connection pool: [PHYS_SCHEMA].[PHYS_CP]
Cause:
With the properties of connection pool [PHYS_SCHEMA].[PHYS_CP] it is not possible to connect to a database.
Trying to view data from a table in this physical schema results in the message The connection has failed
Solution:
- go to the physical schema [PHYS_SCHEMA]
- double click on the connectionpool
- on the tab General, enter a valid Name
- enter the right Call interface
- enter Data source name
- enter User name
- enter Password
- click OK
- close the pop-up
- check in the rpd
- try to view data from a table in [PHYS_SCHEMA]
If the data is viewed, then the error message will not be displayed in Enterprise Manager anymore.
Het bericht Blacklisted connectionpool verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Invalid character at OCI call
Problem: Error when trying to save physical select statement
Screenshot:
Screenshot text:
[NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 911, message: ORA-00911: invalid character at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed.
Possible solution:
- remove comments (including /* and */)
- remove semicolons / ;
- save physical statement
Het bericht Invalid character at OCI call verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Completely remove an OBIEE user
A user can be deleted in the console. When a user is deleted this way, there will be leftovers. For example, the user folder continues to exist. To completely remove a user, you must use the command below.
- connect to the Unix server
- make sure the Catalog Manager is closed
- run the command
runcat.sh -cmd forgetAccounts -offline /[ENV]/FMW/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/ -username [USER] -cleanup
([ENV] and [USER] have to be replaced)
The user is completely removed now, including the user folders.
Screenshot output:
Screenshot output text:
BIFNDN_LABEL =BIFNDN_11.1.1.7.0BIBP_LINUX.X64_140209.2017 # Command : -cmd forgetAccounts -offline /[ENV]/FMW/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/ -username tester -cleanup N1 ------------------------ cmjniconnection.cpp 2790 saw.catalogmanager Oracle BI CatalogManager 11.1.1.7.140225 (Build 140209.2017 64-bit) is connecting offline. N1 ------------------------ userpopulation.cpp 303 saw.catalog.local.loadCatalog Using only catalog user population N1 ------------------------ cmjniconnection.cpp 483 saw.catalogmanager Loading catalog /[ENV]/FMW/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/. Successfully cleaned account tester. Command 'forgetAccounts' completed successfully. Cleaned 1 accounts.
Het bericht Completely remove an OBIEE user verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
