Reporter unable to connect to UVMS

Products

• CA Automic Dollar Universe

Issue/Introduction

The reporter was running all fine and all of the sudden it's show "Not Connected" and unable to connect to UVMS. The restart of the service didn't helped.

 

Environment

Component: DOLLAR UNIVERSE REPORTER

Version: 6.X

Cause

The below error is recorded in the $REPORTER_INSTALL_DIR\logs

[ERROR] 18 Feb 2024 05:00:46 [pool-1-thread-270] com.orsyp.reppub.server.command.rep.ReporterExtract$1 - com.orsyp.reppub.common.exception.ServerException: java.util.concurrent.ExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.UNI_EVT_JOBLOGS' in database 'reporter' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

The above error reflect that the server hosting SQL DB is running out of disk space.

Resolution

Increase the disk allocation on the server hosting SQL Server. The above issue can originate when there is no purge perform on the Reporter DB. As per recommendation, it is recommended to increase the disk space by same amount i.e. current size of your DB.

Additional Information

Refer the documentation on configuring periodic purge or performing ad-hoc purge(always disable redo logging) below.

• FAQ Reporter DB purge
  
  
• Reporter Database never been purged what is the best approach to reduce its size