Reporter extraction job is failing

Products

• CA Automic Dollar Universe

Issue/Introduction

After the upgrade, the Reporter extraction job fails. The job is scheduled to run at 6 am - it will start and run for almost an hour and then abort. The following are errors from the universe.log file:

| 2023-07-13 07:00:21 |ERROR|A|IO |pid=44615.140198575867648| owls_task_populate_variab | Unable to extract Uproc SYSXH170.001
| 2023-07-13 07:00:22 |ERROR|X|IO |pid=44503.140535931045632| owls_io_user_sys_user     | system user [abcp/username1] associated with submission account [username1] not found
| 2023-07-13 07:00:22 |ERROR|X|IO |pid=44503.140535899576064| owls_io_user_sys_user     | system user [username2] associated with submission account [username2] not found

Environment

Release : 6.x, 7,x

Cause

The error messages from the log file is indicating that the user access is causing the problem for the job to abort. 

Resolution

To install the Reporter Server:

• On Windows, the user must be an administrator.
  
  
• On Linux, it is preferable to use root. 
  If the installation is executed without root rights: Reporter can only be started or stopped by this user, and the Reporter startup is not registered in the machine startup files.

Before the upgrade/install process is started, please make sure that:

• Univiewer Console and Univiewer Management Server must be installed and running.
• Dollar Universe Application Servers and UniJob must be accessible both to Univiewer and the Reporter Server.
• A Java Runtime Environment must be installed.
• A database must be installed and accessible (Oracle or SQL Server).
• An appropriate JDBC driver must be installed.
• A database user with DBA rights must exist.