This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
AR System Server
AR System Server running on Oracle
Unable to proceed with 9.1.00 installation successfully.
Some prerequisites to follow before upgrading each module at Database level :
1. Compile invalid views :
Method 1 :
1. If you are using Oracle Database import or export tools, recompile invalid objects after import or Database Restore:
a. At database level as ARAdmin, execute following SQL
select object_name from user_objects where status != 'VALID';
b. If the output is not zero,
select 'ALTER ' || OBJECT_TYPE || ' ' || 'ARAdmin' || '.' || OBJECT_NAME || ' COMPILE;' from user_objects where status = 'INVALID'
c. Execute the output of the above command to compile the invalid objects.
d. Repeat steps a and b until you see the zero output or no change in the total count.
e. If the above SQL output is nonzero, investigate for the root cause and see if you can safely ignore invalid objects such as uncompelled packages, old views, etc., before proceeding to the next step (Take help from DBA to investigate issues with invalid objects).
If you have DBA permissions or take help from DBA to compile
EXEC DBMS_UTILITY.COMPILE_SCHEMA( schema => 'ARADMIN', compile_all => FALSE)
2. If you still see invalid views use following command to find the list of forms, export them using Dev studio and import same forms using Dev studio. AR System will drop the views and rebuild during import and would fix any discripancies.
select distinct * from (
select name,schemaid from arschema where 'T' || schemaid in (select OBJECT_NAME from user_objects where status = 'INVALID' and object_type = 'VIEW')
select name,schemaid from arschema where 'H' || schemaid in (select OBJECT_NAME from user_objects where status = 'INVALID' and object_type = 'VIEW')
select name,schemaid from arschema where 'B' || schemaid in (select OBJECT_NAME from user_objects where status = 'INVALID' and object_type = 'VIEW'))