New Table Creation is Failing using Web Screen Painter

Products

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

Issue/Introduction

Customer is trying to create a new table in the database

The table is created within Web Screen Painter

When running pdm_publish from the command prompt, we see the following output:

Pdm_publish - Implement DBMS schema changes from Web Screen Painter
Verifying files output from Web Screen Painter...
Verifying CA Service Desk Manager server is not running...

Merging schema files...
../bop.mac (19) : syntax error, unexpected YACC_PROVIDER, expecting YACC_STRING or YACC_QSTRING or '}' on seeing provider in wsp_schema.sch  (275)
Output suppressed due to error
AHD04759:schmerge failed
pdm_publish execution failed

Environment

Service Desk Manager 17.3 and higher

Cause

One of the columns in the table being created was named provider

Provider is already defined in ddict.sch

Resolution

After updating the provider column name to something not already defined like "provider_test", pdm_publish should complete

Additional Information

The default ddict.sch mentions "provider" here:

PROVIDER {
   CURR_PROV -> "<SERVER_NAME>" _prov "db_provider" ;
}