Product(s):	APM Implementation and Performance Management
	Version(s):	7
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A

Problem Description

User had recently upgraded APM. Upon launch of the Thick Client, APM errored with a message stating that "oq.outboundevents table was missing".

Solution

APM database tables often expand as new versions of APM are available, it is rare that old tables are removed but when they are the old tables and their references are cleaned up. These references are sometimes contained in the stored procedures in the database. In this particular case, the database user did not have adequate permissions when upgrading and the stored procedures in the database had not updated automatically. By manually reloading the proc_apponly_ivara.sql stored procedure into the oracle database using the proc_apponly_ivara.sql from the new version of APM being upgraded to, the problem was resolved.