CM-CFG-5063 errors on starting cognos services

-

Problem(Abstract)

On starting Cognos Services, the services do not start and give errors in cogserver.log. On looking at Content store observed that only seeing 5 CM* tables present. There should be more than this.

Symptom

Any of these messages may be present in the log files

CM 1127 1 Audit.cms.CM Warning CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\Program Files\cognos\c8\configuration\schemas\content\oracle\dbInitScript_oracle.sql&quo t;.
ORA-00955: name is already used by an existing object

5. 09:41:12, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

8. 09:41:12, CM-CFG-5131 A Content Manager configuration error occurred during the initialization of Content Manager Plugin Manager.
null

In the Cognos Logs:

CM-CFG-5131 A Content Manager configuration error occurred during the initialization of Content Manager Plugin Manager.
null

CM-CFG-5076 A Content Manager configuration error occurred during the initialization of Cognos Access Manager.
Call failed with error code: -24

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.

[Error] The database connection failed.
[Error] Content Manager failed to connect to the content store. The connection string is
"jdbc:oracle:thin:@localhost:1521:fpldev01.takedapharm.tpna.com".

Root Cause:

Issue found to be the result of not having the required permissions set on the Oracle Content Database.

Resolving the problem

Must ensure that Oracle database has the following permissions set:

a) connect to the database

b) create, alter, and drop tables

c) create, alter and drop triggers

d) create, alter and drop views

e) create, alter and drop procedures

f) create, alter and drop sequences

Also, add Unlimited Quotas permission to oracle content store schema if the above steps do not work.






Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more