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

book

Article ID: 19759

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER 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

Description:

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

Solution:

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

Environment

Release:
Component: ARGIS