Save and Publish fails with an error "publish_schema failed in backend: Timeout waiting for reply after 60 seconds. "

book

Article ID: 6043

calendar_today

Updated On:

Products

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

After manually adding custom columns, for example, loading the wspcol table to a server, when selected "save and publish" in Schema Designer, an error "publish_schema failed in backend: Timeout waiting for reply after 60 seconds" comes up as shown below and the schema changes cannot be saved. 

<Please see attached file for image>

Save_and_Publish.jpg

If we click on the "save and publish" again, the following error appears and the changes will not be saved.

<Please see attached file for image>

error02.jpg

Cause

The error will appear if a column in the wspcol table referencing to non-existing table name, such as one that does not exist in the out of box schema or the wsptbl table.

e.g.

Non-existing table is specified as a SRel table of a custom SREL column.

A custom column added to non-existing table.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component:

Resolution

Remove a problematic column from the wspcol table, load it to the Service Desk Manager server, and then select "save and publish" in Schema Designer again after making a dummy change.

Additional Information

TEC578669: Using the Swing-Box method for Upgrading/Migrating to a new version of CA Service Desk Manager

CA Service Management - 14.1 > Upgrade CA SDM Using the SWING Box Method

Attachments

1558707897668000006043_sktwi1f5rjvs16quz.jpeg get_app
1558707895493000006043_sktwi1f5rjvs16quy.jpeg get_app