Clarity Service Management

Expand all | Collapse all

CA Schema Publishing Error

Jump to Best Answer
  • 1.  CA Schema Publishing Error

    Posted 01-06-2017 01:06 PM

    Hello Guys,


    I was trying to add   a new column in one of our Z_Table as  (delete_flag    SREL -> actbool.enum). The publishing was successful. when I did bop_sinfo -fa ZTable, I can see the proper reference of the newly added field. So I guess it properly published in object layer. However when I do a pdm_extract, I don't see the new field appeared in the extract output. Then I checked in our ddict.sch and see there no reference exists for the new field. Though I see the field exists in wsp_schema file and in wsp.mods file. Even when I run simple SQL on database I can see the field. So what I assume though it published in object layer it have not published in database layer somehow. Am I correct on this assumption? And most important, what could be the solution for this? I have no idea to deal with such partially published item as I always got successful publish message.

    We are using r14.1 with Advanced Availability mode with latest cumm#2 applied.

    Please advice.




  • 2.  Re: CA Schema Publishing Error
    Best Answer

    Posted 01-06-2017 04:55 PM

    manually add

    delete_flag INTEGER REF actbool ;

    to the ddict.sch file?

  • 3.  Re: CA Schema Publishing Error

    Posted 01-09-2017 06:22 AM

    Thanks for the suggestion Chi. I updated it in ddict.sch and recycled the services. Now its all set and pdm_extract command can fetch the newly added field.




  • 4.  Re: CA Schema Publishing Error

    Posted 01-17-2017 02:00 PM

    The procedure: How to do: (sorry, i don't have a english version)


    CA SDM - Como apagar um campo personalizado – Delete Field 

    Errores al intentar ejecutar PDM_PUBLISH