CA Service Management

 View Only
  • 1.  Issue on newly added column via Web Screen Painter

    Posted Jul 02, 2019 05:18 PM
    Edited by Ruben Co Jul 02, 2019 05:50 PM
    I have added a new column to the chg (Change Request) table.
    z_communicationplan STRING 4000
    Everything went fine on pdm_publish and I followed the instructions here for Advanced Availability and did not encounter any error.
    I see the column when using bop_sinfo as well on the SQL server itself.

    But when I try to use the new column as an Additional Search Arguments for Change Order I get the error below:
    Additional Search Arguments: z_communicationplan IS NULL
    Error Message: Column z_communicationplan not found in table Change_Request (subquery 1.0 WHERE) at . z_communicationplan

    I have checked the wsp and ddict files on the background, standby and application servers and I see the entry of the new column.

    One strange thing I notice is the extra <> when using bop_sinfo to display the chg table info:
    C:\Users\rco\Desktop>bop_sinfo -qd chg | find "z_communicationplan"
    z_communicationplan <> STRING(4000)

    Any idea what might be the issue is?

    I noticed on the Advanced tab that it is missing the Active UI_INFO and Site-Defined UI_INFO properties


  • 2.  RE: Issue on newly added column via Web Screen Painter

    Broadcom Employee
    Posted Jul 02, 2019 05:49 PM
    what is 
    z_communicationplan <> STRING(4000)
    ? should it be
    z_communicationplan   STRING(4000)
    ?
    OR maybe a typo. If you can post list_chg.htmpl that should help.


  • 3.  RE: Issue on newly added column via Web Screen Painter

    Posted Jul 02, 2019 05:53 PM
    Edited by Ruben Co Jul 02, 2019 05:53 PM
      |   view attached
    No it is not a typo, it is what it looks like when I run bop_sinfo on chg




  • 4.  RE: Issue on newly added column via Web Screen Painter

    Broadcom Employee
    Posted Jul 02, 2019 05:58 PM
    just to make sure we are not crazy...what is the output when you run
    bop_sinfo -qd chg|findstr "summary"
    ?


  • 5.  RE: Issue on newly added column via Web Screen Painter

    Posted Jul 02, 2019 06:05 PM
      |   view attached
    here you go


  • 6.  RE: Issue on newly added column via Web Screen Painter
    Best Answer

    Broadcom Employee
    Posted Jul 03, 2019 09:08 AM
    for some reason it seems you added attribute "z_communicationplan <>" not "z_communicationplan". you would need to correct this.