Users get disconnected when running reports. The logs show "Invalid column name 'DOCUMENT_SIZE'".

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

After upgrading to R12 SP2, the users get disconnected when running reports.  

Environment

CA Workload Automation DE R12 SP2MS SQL 2008 with Windows Authentication enabledMS SQL 2012 with Windows Authentication enabledMS SQL 2016 with Windows Authentication enabled

Cause

When upgrading the CA Workload Automation DE R12 server to R12 SP2, the correct user id may not have been used.  The Windows user running the patch must have full access to the database used.  The user id must be able to create and alter tables.   If it cannot, then the DB will not update and the inplaceupgrade.log will show the following error:

 

Note: The inplaceupgrade is located in <de_install>/upgrades/logs

 

201708..:21:27.67... INFO com.ca.wa.de.migrateruntimedata.DBConnector - Database is using Windows integrated authentication 
201708.. 08:21:28... INFO com.ca.wa.de.migrateruntimedata.DBConnector - Database connection successfully created. 
201708.. 08:21:28... INFO com.ca.wa.de.migratestaticdata.UpdateStaticData - dbType is: Microsoft SQL Server 
201708.. 08:21:29... ERROR com.ca.wa.de.migratestaticdata.DatabaseUtils - Failed sql query: SELECT VERSION from ESP_VERSION 
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ESP_VERSION'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)

Resolution

If the DB was not updated, then it will be necessary to re-run some of the scripts.  Please follow the following steps:

• Stop the DE server. If High Availability, stop both Primary and Standby.
• Back up the SQL database 
• Login to DE server as windows user that has full access to the SQL DB
• Run the following bat two files located in upgrades directory:

<de_install>\upgrades\bin\convertstaticdata.bat

<de_install>\upgrades\bin\convertruntimedata.bat

• Start the DE server.   If High Availability, start both Primary and Standby.
• Login to DE via Desktop Client and run a report.