IBM Advanced Studies

 View Only
Expand all | Collapse all

Maximo Cognos MXCSP Error Connection

  • 1.  Maximo Cognos MXCSP Error Connection

    Posted Wed May 24, 2023 09:54 AM

    There are 3 server:
    1. Maximo
    2. DB2
    3. Cognos

    I install Cognos using MXCSP, so user can login to the cognos with maximo userid, but there is error:

    1. in cognosserver.log:

    2023-05-24T10:24:07.815+0700 ERROR com.ibm.ba.glass.utils.Logger [Default Executor-thread-115681] 2vdsyGd44w2lCGvyjhy2hsvdMhyhh4MvGvGMC9yl 2vdsyGd44w2lCGvyjhy2hsvdMhyhh4MvGvGMC9yl NA 172.16.3.1 54902 _unknown_ NA /v1/perspectives/login bi-service 1816 Exception:
    java.lang.Exception: parseFileContribution: Did not find message file: common.locales.rs_authoring
    Caused by: java.util.MissingResourceException: Can't find bundle for base name common.locales.rs_authoring, locale in
    Caused by: java.io.IOException: java.lang.ClassNotFoundException: common.locales.rs_authoring_in
    Caused by: java.lang.ClassNotFoundException: common.locales.rs_authoring_in

    2. in JDBCSample.log:

    24 Mei 2023 10:32:24:050 [INFO] checking for trusted credential
    24 Mei 2023 10:32:24:050 [INFO] user not found using getTrustedCredential
    24 Mei 2023 10:32:24:050 [INFO] Token found while launching from Maximo.
    24 Mei 2023 10:32:24:050 [INFO] Attempting to validate token using Maximo authentication URL: http://172.16.3.40/maxrest, user: MAXADMIN, token: 10001992-Cb5E5SaWKokIqwGclbU0J4v
    24 Mei 2023 10:32:24:050 [INFO] Validator postIt Method
    24 Mei 2023 10:32:24:050 [INFO] UNAUTHORIZED USER: MAXADMIN
    24 Mei 2023 10:32:24:050 [INFO] error: java.io.IOException: Server returned HTTP response code: 401 for URL: http://172.16.3.40/maxrest/token?mxtoken=10001992-Cb5E5SaWKokIqwGclbU0J4v&userid=MAXADMIN
    24 Mei 2023 10:32:24:050 [INFO] Token validation failed
    24 Mei 2023 10:32:24:050 [INFO] Token validation failed
    24 Mei 2023 10:32:24:050 [INFO] Error: com.cognos.CAM_AAA.authentication.UserRecoverableException
    24 Mei 2023 10:32:28:273 [INFO] checking for trusted credential
    24 Mei 2023 10:32:28:273 [INFO] user not found using getTrustedCredential
    24 Mei 2023 10:32:28:273 [INFO] check for published token
    24 Mei 2023 10:32:28:273 [INFO] mxtoken from publish is null
    24 Mei 2023 10:32:37:417 [INFO] checking for trusted credential
    24 Mei 2023 10:32:37:417 [INFO] user not found using getTrustedCredential
    24 Mei 2023 10:32:37:417 [INFO] check for published token
    24 Mei 2023 10:32:37:417 [INFO] mxtoken from publish is null
    24 Mei 2023 10:32:37:417 [INFO] MXUserValidator validate Method
    24 Mei 2023 10:32:37:417 [INFO] connectionString: jdbc:db2://172.16.3.41:50005/maxdb71
    24 Mei 2023 10:32:37:433 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:433 [INFO] set current schema maximo
    24 Mei 2023 10:32:37:452 [INFO] getMXRestURL: value - http://172.16.3.40/maximo
    24 Mei 2023 10:32:37:454 [INFO] mxresturl: http://172.16.3.40/maximo
    24 Mei 2023 10:32:37:455 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:486 [INFO] User Authorized
    24 Mei 2023 10:32:37:486 [INFO] getMXUserID: value - MAXADMIN
    24 Mei 2023 10:32:37:486 [INFO] User validation successful
    24 Mei 2023 10:32:37:486 [INFO] Creating Visa...
    24 Mei 2023 10:32:37:486 [INFO] MXVisa INIT Method
    24 Mei 2023 10:32:37:486 [INFO] connectionString: jdbc:db2://172.16.3.41:50005/maxdb71
    24 Mei 2023 10:32:37:502 [INFO] MXVisa init got connection
    24 Mei 2023 10:32:37:502 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:502 [INFO] set current schema maximo
    24 Mei 2023 10:32:37:502 [INFO] MXVisa before create account
    24 Mei 2023 10:32:37:517 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:517 [INFO] MXUtil createAccount: before getAccountProperties
    24 Mei 2023 10:32:37:517 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:517 [INFO] MXUtil createAccount: after getAccountProperties
    24 Mei 2023 10:32:37:517 [INFO] MXVisa after create account
    24 Mei 2023 10:32:37:517 [INFO] MXVisa after super.init
    24 Mei 2023 10:32:37:517 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:517 [INFO] MXUtil updateMembership username: MAXADMIN
    24 Mei 2023 10:32:37:517 [INFO] MXVisa after updateMembership
    24 Mei 2023 10:32:37:517 [INFO] MXVisa init complete.
    24 Mei 2023 10:32:37:517 [INFO] Logging initialized.
    24 Mei 2023 10:32:37:517 [INFO] userid from form field: null
    24 Mei 2023 10:32:37:517 [INFO] Visa Created!






    ------------------------------
    Iko Sona
    ------------------------------


  • 2.  RE: Maximo Cognos MXCSP Error Connection

    IBM Champion
    Posted Tue June 27, 2023 11:12 AM

    Hey, even if my answer is late it might be beneficial for anyone encountering the same issue.

    Based on the provided error logs, it appears that you are encountering issues with the Cognos integration within your environment. Here are some suggestions to troubleshoot and address the problems:

    1. In the cognosserver.log:

      • The error message indicates that the message file common.locales.rs_authoring is not found. Check if the required language resource files are properly configured and accessible within the Cognos installation directory. Verify that the file exists and is accessible by the Cognos server.
    2. In the JDBCSample.log:

      • The error "Server returned HTTP response code: 401" suggests an authorization issue when validating the token using Maximo authentication. Ensure that the authentication URL, user credentials, and token are correct. Double-check the configurations related to token validation and authentication within your Cognos and Maximo integration setup.
      • Verify that the required dependencies and drivers for the DB2 database are correctly installed and configured. Check the connection string and ensure it is pointing to the correct database instance.

    I hope this gives you an idea on what to do and how to solve the issue.



    ------------------------------
    Youssef Sbai Idrissi
    Software Engineer
    ------------------------------