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:
This time it will create the table in the database and updates the wspschema.log file with the table name again.