Dollar Universe Reporter server is failing to extract:Invalid object name 'UNI_EVT_EXTRACTIONS'

Products

• CA Automic Dollar Universe

Issue/Introduction

The Dollar Universe Reporter server extraction is failing after an upgrade Dollar Universe Reporter server

 

Error messages:

 Database communication error: Invalid column name 'DELETED'.

or 

REPORTER: Extraction Monitor on <Reporternode>:
Could not open a connection to the database.Check your database settings.Invalid object name 'UNI_EVT_EXTRACTIONS'.

Environment

Component: Dollar Universe Reporter Server

Release : 6.10.x

Cause

The SQL script to update the Reporter server table has not been executed.

Resolution

Please execute the SQL script delivered in <Reporter server installation>/dbscripts .