When trying to publish schema changes using pdm_publish the error "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."

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

On migrated installations of ServiceDesk R12, on running pdm_publish "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." appears. This document explains the steps to resolve the issue.

Solution:

When the error message stated in the summary appears, all the Web Screen Painter related files get updated with the new table name.

Ex: wsptbl, wspschema.log, wsp.mods

However, the table is not created in the MDB.

To resolve the issue:

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

This time it will create the table in the database and updates the wspschema.log file with the table name again.

Environment

Release:
Component: ARGIS