Cannot find custom object when publishing schema changes using pdm_publish

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

In a migrated installation of Service Desk Manager, the user runs pdm_publish and the following error is generated in the same window:

"ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1088 SQL State=42000] Cannot find the object "dbo.zXXXXX" because it does not exist or you do not have permissions."

zXXXXX is a placeholder for a customized object in this environment

Environment

All versions of Service Desk Manager with customized data 

Cause

The error message signifies all the Web Screen Painter related files are updated with the new table name, however the table is not found in the MDB.

Possibly affected files that contain references to the custom table include:

• wsptbl table in the database
• NX_ROOT\site\mods\wsp_schema.log
• NX_ROOT\site\mods\majic\wsp.mods

Resolution

To resolve the issue, follow these steps:

1. Open the wspschema.log.
2. Delete the entries for the new table zXXXX.
3. Save the file.
4. Stop the CA ServiceDesk Server service.
5. Open the command prompt.
6. Run the command pdm_publish.

The table will be created in the database and will update the wspschema.log file with the table name again.