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_communicationplanI 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