IBM Support

When trying to login to Business Space from a browser you are not getting a login prompt and the page is blank

Troubleshooting


Problem

The Business Space applications have been successfully deployed with IBM Case Manager (ICM) Administration Client (CMAC). You try to test and validate if the Business Space is configured properly before proceeding with the rest of the ICM configuration tasks by hitting the Business Space [ http://servername:port.mum/enabler], instead of getting a prompt to login to Business application, you are getting a blank page

Symptom


The Business Space data source is trying to connect to the default database schema named MASHUPS instead of the real Schema defined for the Business Space database in CMAC.

For DB2 database, you will see the errors below in WAS ICM SystemOut.log file:


    --- The error occurred in com/ibm/mm/server/persistence/rdbms/resources/maps/FileStore.xml.
    --- The error occurred while applying a parameter map.
    --- Check the readPathByID-InlineParameterMap.
    --- Check the statement (query failed).
    --- Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=MASHUPS.FILESTORE_PATH, DRIVER=3.61.65
    com.ibatis.common.jdbc.exception.NestedSQLException:
    --- The error occurred in com/ibm/mm/server/persistence/rdbms/resources/maps/FileStore.xml.
    --- The error occurred while applying a parameter map.
    --- Check the readPathByID-InlineParameterMap.
    --- Check the statement (query failed).
    --- Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=MASHUPS.FILESTORE_PATH, DRIVER=3.61.65
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
    ...
    ...

For Oracle database, you will see a similar error reported in WAS ICM SystemOut.log as follows :
    com.ibm.mm.server.persistence.rdbms.dao.ibatis.BaseDao getRoot BMWSD0429E: An SQLException was encountered while communicating with the database. Error code: 942, SQL State: 42000, Message:
    --- The error occurred in com/ibm/mm/server/persistence/rdbms/resources/maps/FileStore.xml.
    --- The error occurred while applying a parameter map.
    --- Check the readPathByID-InlineParameterMap.
    --- Check the statement (query failed).
    --- Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
    ...
    ...

[{"Product":{"code":"SSCTJ4","label":"IBM Case Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Case Manager Client","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"5.1.0.1;5.1.1.0;5.1.0.0","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21598047

Page Feedback