Technical Blog Post
Abstract
TCR authorization error CM-SYS-5003
Body
TCR authorization error CM-SYS-5003
This will firstly show up as a DPR-ERR-2109 when trying to launch Tivoli Common Reporting (TCR) or as CM-REQ-4159 when a report is tried to be run.
This is a generic error and the cogserver.log needs to be reviewed to see what the further details of the error are.
The cogserver.log shows:
CM-SYS-5003 Content Manager is unable to connect to the content store.
Verify that the database connection properties in the configuration
tool are correct and that when you test the connection, the test is
successful.
Connection authorization failure occurred. Reason: User ID revoked.
ERRORCODE=-4214, SQLSTATE=28000
There are two options to resolving this issue:
A. Ensure that no users are shown as being locked in the administrators list.
B. The password has been changed on the content store database in which case:
Use the Cognos Configuration tool to update the Cognos Content Store database password.
This tool is located in the following directory:
On Windows operating systems: JazzSM_INST_DIR\reporting\cognos\bin64\tcr_cogconfig.bat
On AIX® or Linux operating systems: JazzSM_INST_DIR/reporting/cognos/bin64/tcr_cogconfig.sh
After you start the tool, on the <"Content Store"> Database > Resource Properties window, click the pencil icon to change the password and then click Save.
After you run this tool, you must restart Jazz™ for Service Management.
Subscribe and follow us for all the latest information directly on your social feeds:
Check out all our other posts and updates: | |
Academy Blogs: | https://goo.gl/U7cYYY |
Academy Videos: | https://goo.gl/TLfMoF |
Academy Google+: | https://goo.gl/HnTs0w |
Academy Twitter : | https://goo.gl/HnTs0w |
UID
ibm11083327