Tomcat Pega 7.31 - dual user configuration SQL error with create index
I've been looking at the system as a whole and investigating required indexes to improve performance. To that end I looked at the Database Optimize Schema option to seem what PEGA recommended. There were some indexes it recommended so I decided to go a head and create one on our test box. However even though this returned a successful message the index wasn't created and there was an error in the log.
Following changes were applied sucessfully
A index (WORKTYPEIndex) is created on table PEGA720_DATA.CRM_LINK_OPERATOR_TERRITORY for the column WORKTYPE.
ERROR - Cannot find the object "PEGA720_DATA.CRM_LINK_OPERATOR_TERRITORY" because it does not exist or you do not have
permissions. com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "PEGA720_DATA.CRM_LINK_OPERATOR_TERRITORY"
because it does not exist or you do not have permissions.
If you go to Records Explorer>SysAdmin>Database Table and filter based on the table name "CRM_LINK_OPERATOR_TERRITORY" and view the associated class, it is possible an incorrect schema (pega720_DATA) is being used. You can verify this by "Testing Connectivity" from that same page.
The table mentioned is from pega CRM application, not part of the platform. I wonder if you can try to do the same for one of the platform tables and report the outcome. If the same procedure works for a platform table, but not a strategic app table (e.g., CRM tables), I would like you create a SR for further investigation.