CA Service Management

  • 1.  Invalid column name 'formheaderdisplay'.

    Posted Apr 10, 2017 09:21 AM

    I created a new Service Catalog server;
    I imported an offer of service;
    When you try to make it available, the Catalog informs you that "The available date can not be earlier than the date of creation."
    I noticed an error in the Catalog log:

    ERROR [WR_33136396] [http-bio-8080-exec-8] [CService] CSRV0015
    Com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'formheaderdisplay'.

    The installed version is on 14.1.02 with incremental patch 1 and 2:
    R14.1.02.01_52W147 and r14.1.02.02_6D9057



  • 2.  Re: Invalid column name 'formheaderdisplay'.
    Best Answer

    Broadcom Employee
    Posted Apr 10, 2017 11:59 AM

    Hi,

     

    it would appear that the patch application didn't successfully apply the schema changes to the database. Here's a full list of the queries, in case any others failed as well:

     

    1. ALTER TABLE USM_OFFERING ADD rateplanheaderdisplay INT NOT NULL CONSTRAINT df_rateplanheaderdisplay DEFAULT 0
    2. ALTER TABLE USM_RATE_DEFINITION ADD formheaderdisplay INT NOT NULL CONSTRAINT df_formheaderdisplay DEFAULT 1
    3. alter table usm_request_item_form add is_visible int NOT NULL CONSTRAINT df_is_visible DEFAULT (1);
    4. alter table usm_request_pending_action add sequence_id int NOT NULL CONSTRAINT df_sequence_id DEFAULT (0);
    5. alter table usm_request add locale varchar(50)
    6. IF EXISTS(select * FROM sys.views where name = 'BI_tenant_h')
    exec ('Drop View BI_tenant_h')
    exec
    ('create view BI_tenant_h
    as
    WITH cte_name ( Ancestor, Descendent ,name,lvl )
    AS
    (
    select base.parent_tenant_id, base.tenant_id,base.tenant_name AS Name, 0 as lvl from usm_tenant base
    where base.parent_tenant_id <> base.tenant_id
    UNION ALL
    select cte_name.Ancestor, usm_tenant.tenant_id,usm_tenant.tenant_name AS Name, lvl+1 from
    usm_tenant inner join cte_name on cte_name.descendent=usm_tenant.parent_tenant_id
    where usm_tenant.parent_tenant_id <> usm_tenant.tenant_id
    )
    SELECT * FROM cte_name
    union
    select tenant_id as ancestor, tenant_id as descendent, tenant_name AS Name, 0 from usm_tenant ')
    7. update USM_SCHEMA_VERSION set SUB_VERSION = 1 where MAJOR_VERSION = 14 and MINOR_VERSION = 1



  • 3.  Re: Invalid column name 'formheaderdisplay'.

    Broadcom Employee
    Posted Apr 10, 2017 03:35 PM

    Hi Everton,

     

    Have you tried to re-install CA_SLCM_r14_1_01_Setup.exe patch? Did it cause any issue completing the installation? Its seems like there is a know issue around this behavior which stops on Execution of Script/Batch file.



  • 4.  Re: Invalid column name 'formheaderdisplay'.

    Posted Apr 11, 2017 01:26 PM

    I install in this sequence:

     

    DVD03063838E: Service Catalog 14.1

    RO80318 ( RO80252 )
    RO86617
    RO86785 - INCREMENTAL 1 ON 14.1.02 - with post installation
    RO90087 - INCREMENTAL 2 ON R14.1.02 - with post installation



  • 5.  Re: Invalid column name 'formheaderdisplay'.

    Broadcom Employee
    Posted Apr 12, 2017 03:31 AM

    Hi Everton,

     

    that's the correct order, but it would appear that one of the SQL update steps has failed; you'll probably see the details in the appropriate log files for the patches. Those SQL statements will repair things manually.

     

    regards

    Iain