Clarity Service Management

Expand all | Collapse all

change the length of a customized column

  • 1.  change the length of a customized column

    Posted 11-20-2014 06:36 AM

    Hello Team,

     

    Could me guide me how to change the length of a zcolumn in CA SDM. I have followed the steps given in below link but nothing has worked. Please help me.

     

    Our SDM version is R12.7,C2

     

    Implementation Guide r12.5 - CA

     

    Thanks

    Madhavi.



  • 2.  Re: change the length of a customized column

    Posted 11-20-2014 10:52 AM

    Hi Madhavi,

     

    The length of a zcolumn can only be changed if it is a STRING column. Is that the case in your environment?

     

    Best regards,

    Peter



  • 3.  Re: change the length of a customized column

    Posted 11-20-2014 10:55 AM

    Hi Peter,

     

    Yes, it is a string column.



  • 4.  Re: change the length of a customized column

    Posted 11-20-2014 11:01 AM

    Hi Madhavi,

     

    In that case the procedure as listed in the implementation guide should work. Where there any errors displayed on the output of pdm_wspupd or pdm_publish or in stdlog? And did you modified both wsp_schema.sch and wsp.mods files?

     

    Best regards,

    Peter



  • 5.  Re: change the length of a customized column

    Posted 11-25-2014 03:17 AM
      |   view attached

    Hi Peter,

     

    My Requirement is to change the column length in TWA table. I have followed the same steps again. Now I can increase the column size. Here the issue is, after changes I cannot see any customized column in ddict.sch file and when I click on Search-->Configuration items, the page is not displaying properly. Attached is the screenshot for your reference. Could you please help me.

     

    Thanks

    Madhavi.



  • 6.  Re: change the length of a customized column

    Posted 11-25-2014 05:02 AM

    Hello,

     

    Issue is resolved after publishing the schema from web screen painter. But my question is , why I have to again publish the schema??? Any idea on this.

     

    Thanks

    Madhavi.