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."

book

Article ID: 52966

calendar_today

Updated On:

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 KNOWLEDGE TOOLS 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