Category Archives: Berry van den Heuvel
Presentation table contains alias which is already used
Problem: consistency check Error No. 38044
Screenshot:
Screenshot text:
[38044] Presentation table [TABLE] contains alias [ALIAS] which is already used.
Solution:
- go to the presentation table that contains the alias [ALIAS]
- double click on the presentation table name
- go to the tab Aliases
- select the alias
- remove the alias
- click OK to close the pop-up
- check in the rpd
The error message is not displayed anymore.
Het bericht Presentation table contains alias which is already used verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Logical table has no defined key
Problem: consistency check warning / Error No. 39001
Screenshot:
Screenshot text:
[39001] Logical table [TABLE] has no defined key.
Solution:
- go to the logical table [TABLE]
- double click on the logical table name
- go to the tab Keys
- insert a Key Name (for example PK (Primairy Key))
- select all column(s) that belong to the primairy key
- close the pop-up
- check in the rpd
The warning / error message is not displayed anymore.
Het bericht Logical table has no defined key verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Skipped one AccessControlToken with null Account or unsupport Account
Problem: error displayed on the server after clicking on the users-directory in the Catalog Manager
Screenshot text:
[oracle@bi02 Oracle_BI_XIT]$ runcat.sh BIFNDN_LABEL =BIFNDN_11.1.1.7.0BIBP_LINUX.X64_140209.2017 # Command : Skipped one AccessControlToken with null Account or unsupport Account type. Account - null
Solution:
- (optional) open Catalog Manager
- go to users-directory
- look which users are deleted and are not in the console anymore
- for all these users repeat these steps
- select directory with name of the user
- follow Delete a directory or file in the Catalog Manager to delete this directory
- next user
- close Catalog Manager
- open Catalog Manager
If the users-directory is clicked, no error messages are not displayed anymore.
Het bericht Skipped one AccessControlToken with null Account or unsupport Account verscheen eerst op OBIEE 24/7.
Delete a directory or file in the Catalog Manager
Sometimes it is difficult to delete a directory or file in the Catalog manager. Mostly there is a problem with permissions. To delete a directory or file, follow these steps:
- open Catalog Manager
- open the rpd online
- go to the file or directory
- click right mouse button
- click Properties
- select the admin-user as Owner
- check Apply Recursively
- click OK
In most cases, the ownership is not applied recursively! So, go through the subdirectories and files to check if the owner is the admin-user everywhere. If not, then apply the last 5 steps above on the other subdirectories.
If the owner is the admin-user in all subdirectories and files, then go further with the next steps.
- select the directory again
- click right mouse button
- click Permissions
- move the admin user or Administator role to the left
- set Permission to Full Control
- check Apply Recursively
- select Replace Option Replace All
- click OK
- click OK
- select the directory again
- click right mouse button
- click Delete
- confirm the deletion by clicking Yes
The directory is gone!
Het bericht Delete a directory or file in the Catalog Manager verscheen eerst op OBIEE 24/7.
Target path not found (in shortcut)
Problem: Oracle BI Presentation Server (ERROR:16)
Screenshot Enterprise Manager:
Screenshot text log-file:
[2015-03-17T13:44:44.000+01:00] [OBIPS] [ERROR:16] [] [saw.catalog.local.getItemInfo] [host: [HOST]] [nwaddr: [IP]] [tid: 1157466432] [ecid: 17a1d6f2bb2956da:-77aafc18:14b30885af1:-8000-0000000000874f73,0:1] [TARGET: /Farm_bifoundation_domain/instance1/coreapplication_obips1] [TARGET_TYPE: oracle_bi_presentation_services] Target path not found ([PATH]/_selections/4jlh8qa37lhbie33/_defaults/DashboardUser) in shortcut ([PATH]/_selections/4jlh8qa37lhbie33/[NAME]).[[ File:localwebcatalog.cpp Line:2194 Location: saw.catalog.local.getItemInfo saw.subsystem.portal.pagesImpl saw.subsystem.portal saw.httpserver.processrequest saw.rpc.server.responder saw.rpc.server saw.rpc.server.handleConnection saw.rpc.server.dispatch saw.threadpool.socketrpcserver saw.threads Path:[PATH]/_selections/4jlh8qa37lhbie33/_defaults/DashboardUser SessionID: gg77htkuu1l8moajlqlog94oo9hp83h73omnjka AuthProps: AuthSchema=UidPwd|PWD=******|UID=[UID]|User=[USER] ecid: 17a1d6f2bb2956da:-77aafc18:14b30885af1:-8000-0000000000874f73,0:1 ThreadID: 1157466432 HttpCommand: Dashboard RemoteIP: [IP]
Solution:
- open Catalog Manager
- open the rpd online
- derive the path that is not found in the screenshot text (in our case it is _selections)
- decide if this directory may be deleted
- if it may be deleted, then select the directory _selections
- click right mouse button
- click Delete
If the directory is succesfully deleted, the message will not be displayed in the Enterprise Manager and log-files again.
Note: when there is a problem with deleting, see the post Delete a directory or file in the Catalog Manager
Het bericht Target path not found (in shortcut) verscheen eerst op OBIEE 24/7.
