"Could not add column" error in stdlog, ddictbuild.exe APPCRASH, and "Can't spawn ... ddict.sch" when running pdm_publish
Article ID: 19759
CA Service Desk ManagerCA Service Management - Service Desk Manager
The symptoms described in the title of this document are known to occur when performing the following steps:
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)
Shutdown Service Desk Manager services
From a Windows command line, run: pdm_publish
The following is a list of the detailed symptoms:
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
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
Windows popup message appears. Some details are:
Problem signature: Problem Event Name: APPCRASH Application Name: ddictbuild.exe Application Version: 126.96.36.1991 Application Timestamp: 4fff16ce Fault Module Name: ddictbuild.exe Fault Module Version: 188.8.131.521 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
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
Release: 14.1 and higher Component: CA Service Desk Manager
Object attributes were being added to the "pr" or the "in" objects, but should be added to the "cr" object instead.
To use the same name for an attribute for both "pr" and "in" objects, create the attribute under the "cr" object.
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.