CA Service Management

Hello,

SDM 14.1

Recently upgraded from 12.6 to 14.1, web screen painter login failed with the below log messages .

is this know error?  suggestions to fix this please.

  domsrvr:wsp          7532 SEVERE_ERROR bpobject.c            5064 Attempt to cast type UNDEFINED_VAL BPData to string
  domsrvr:wsp          7532 ERROR        sec_mgr.c             3678 Error retrieving value of attribute zcigroup referenced in data partition constraint for user cnt:F3A7DAFE5DC94045BED70A9D98CCAD17 (cnt:F3A7DAFE5DC94045BED70A9D98CCAD17):
  sqlagt:upinde        6972 ERROR        sqlclass.c            1010 SQL Execute  failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=207 SQL State=42S22] Invalid column name 'role_id'.
  sqlagt:upinde        6972 ERROR        sqlclass.c            1011 Clause (INSERT INTO usp_bopsid ( bopsid_val, cnt_persid, cnt_userid, host_name, last_mod_dt, procname, role_id, session_id, id ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )) Input (<bopsid_val:int>223986537|<cnt_persid:string>cnt:F3A7DAFE5DC94045BED70A9D98CCAD17|<cnt_userid:string>w0TNKH+2Zjfyb1wjxkt0HAxqF7c0/EI7OMweeZUQaaUa/jNHqrZ+r0CeN+uvzsFRKCVAUrNmvGQArFy6zIWn8Q==|<host_name:string>t_mod_dt:time>10/04/2015 07:44:12|<procname:string>wsp:e_id:int>10002|<session_id:int>467630314|<id:int>400101)
  sqlagt:upinde        6972 ERROR        sqlsrvr.c              651 Execution failed. MISC_DB_ERROR
  boplgin              6700 SEVERE_ERROR bpobject.c            5064 Attempt to cast type OBJECT BPData to string
  boplgin              6700 ERROR        bplhndlr.c            2171 BOPSID_Handler error. Method:checkin_done Error:NO AHD04199:An unexpected error occurred. Contact your administrator. [Microsoft OLE DB Provider for SQL Server] [ SQL Code=207 SQL State=42S22] Invalid column name 'role_id'.

Thanks,

Venkat

Hi Venkat,

Pls provide the complete error message which helps us to understand if there is any issue with the usp_bopsid data.

Thanks,

Naveen

Hi Naveen,

Here is the full logs using pdm_logstat .

Thanks,

Venkat

Hi Venkat,

I see that there's verbose logging enabled  (mostly on everything)  which is something we normally never recommend.   

pdm_logstat -a   <hit enter>

That normally should turn it off   but you can verify if there's some other item on which it is ON by doing: pdm_logstat -Lv

Coming to the real issue -  SQL Server seems to be complaining that role_id column in usp_bopsid table doesn't exist. Can you verify that in SQL Mgmt Studio?  

Was the migration/upgrade successful?  Normally this is what 14.1 installer would have done

1) detect that you have 12.6 software

2) upgrades 12.6 software to 14.1

3) Installs new 14.1 common tables (called CDB)

4) upgrades 12.6 database to 14.1 (normally called MDB upgrade)

5) runs pdm_migration (ie., migrates 12.6 data to 14.x format)

6) pdm_configure  to complete the whole process

7) and integrate with common components and/or end points

I have a feeling that one of the above steps did not go through successfully, which resulted in this behavior.

_R

Hi Venkat,

In addition to what Raghu had mentioned, you need to create role_id column in usp_bopsid table if it doesn't exist. You may refer below tech document which is for R12.9, however, I believe it should be applicable for 14.1:

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec612215.aspx

Thanks,

Naveen

Thank you, Upgrade is successful the only issue i faced is unable to login to web screen painter.

after updating role_id web screen painter is accessible.

 

Venkat