Deliver - Orphan Report Records in a Deliver Database

Products

• Deliver

Issue/Introduction

The issue at hand is that the Deliver RMOGRW program is extracting reports without corresponding definitions in the Deliver database, suggesting the presence of "ghost files" in the system. To address this, a solution needs to be found.

Environment

Release : Deliver 12.2

Resolution

The problem in this case is that there were "orphan" report records in a Deliver database. To remove the orphan records, the following must be done:

. Ensure that Deliver 12.2 PTF SO10564 is on the environment in question. Use the following steps to perform the cleanup process:

. Create a new Deliver database (RMODBASE ADDDS and MAKECKPT).
. Shut down the current Deliver activity, using "/F rmostc,OFF".
. Use RMODBASE RENAME, to rename the current database to another name.
. Run RMODBASE COPY, to copy the current database to the new database.
. Use RMODBASE RENAME, to rename the new database to the current name.
. Start the Deliver activity, using "/S rmostc".