"Could not add column" error in stdlog, ddictbuild.exe APPCRASH, and "Can't spawn ... ddict.sch" when running pdm_publish

Products

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

Issue/Introduction

The symptoms described in the title of this document are known to occur when performing the following steps:

1. Using Web Screen Painter, create a new column for the "in" object and a new column for the "pr" object.
   (In the in-house test, the new columns were given the same name)
   
   
2. Shutdown Service Desk Manager services
   
   
3. From a Windows command line, run: pdm_publish

The following is a list of the detailed symptoms:

1. Messages that are written to the command prompt screen after invoking "pdm_publish" and before the Windows popup message in #3 appears are:
   
   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...
   Schema merge successful
   
   Building data dictionary...
   
   ERROR - could not add column zin_col_test
   
   Could not find column to add provider to
   
   
2. Messages that are written to $NX_ROOT\log\stdlog.x are:
   
   09/24 09:31:08.21 SDMPRI ddictbuild 6464 ERROR ddict_write.c 411 Could not add column zin_col_test
   09/24 09:31:08.21 SDMPRI ddictbuild 6464 ERROR ddict_write.c 470 Could not find column to add provider to
   
   
3. Windows popup message appears. Some details are:
   
   Problem signature:
   Problem Event Name: APPCRASH
   Application Name: ddictbuild.exe
   Application Version: 12.7.0.871
   Application Timestamp: 4fff16ce
   Fault Module Name: ddictbuild.exe
   Fault Module Version: 12.7.0.871
   Fault Module Timestamp: 4fff16ce
   Exception Code: c0000005
   Exception Offset: 000087ca
   OS Version: 6.1.7600.2.0.0.274.10
   Locale ID: 1033
   Additional Information 1: 0a9e
   Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
   Additional Information 3: 0a9e
   Additional Information 4: 0a9e372d3b4ad19135b953a78882e789
   
   
4. Messages that are written to the command prompt screen (after the Windows popup is closed)
   
   Could not find column to add provider to
   Can't spawn "C:\PROGRA~2\CA\SERVIC~1/bin/ddictbuild C:\PROGRA~2\CA\SERVIC~1/site
   /ddict.sch": Inappropriate I/O control operation at .\pdm_publish.pl line 413.
   ERROR: ddictbuild failed
   Could Not Find C:\Users\ADMINI~1\AppData\Local\Temp\2\cd_nx.cmd

 

Environment

Release:  14.1 and higher
Component: CA Service Desk Manager

Cause

Object attributes were being added to the "pr" or the "in" objects, but should be added to the "cr" object instead.  

Resolution

To use the same name for an attribute for both "pr" and "in" objects, create the attribute under the "cr" object.

Additional Information

Adding attributes to the "cr" object will propagate the same attributes over to "in" and "pr" objects as all three objects are tied to the Call_Req table which is where the schema definitions are stored.