ORA-01031: insufficient privileges error when installing KAMV

Issue

Installation of KAMV 1.1.2 msi fails with the below error:

Start executing SetupBackEnd.Resources.sql.synonyms.create_synonyms.sql.
End executing SetupBackEnd.Resources.sql.synonyms.create_synonyms.sql.
Start executing SetupBackEnd.Resources.sql.dba.grant_privileges.sql.
There was an issue while executing sql scripts.
ORA-01031: insufficient privileges
ORA-06512: at line 2

 

Cause

The Apps grants are missing from the dba_tab_privs for the Kofax Analytics for MarkView schema (typically kamv_source) and the kamv_data schema even after running the grants scripts per the below steps:

Solution

1. Have the DBA drop the Kofax Analytics for MarkView schema (typically kamv_source) and the kamv_data schema with the Cascade option.

2. Have the DBA recreate the Kofax Analytics for MarkView schema (typically kamv_source) and the kamv_data schema. To recreate the schemas, the DBA should use the grant scripts from the attached zip file: grant_privileges.zip.

This zip file contains four (4) scripts. Two (2) for the "kamv_source" schema, and two (2) for the "kamv_data" schema.  

NOTE: During the creation of the Kofax Analytics for MarkView schema (typically kamv_source), note for Step 6 below, do not use the scripts listed - use the attached scripts from 'grant_privileges.zip' script instead.

1. Login in as SYSDBA and run the kamv_grant_privileges.sql script from the attached zip file grant_privileges.zip.
2. Login in as APPS schema and run the kamv_grant_privileges_apps.sql from the attached zip file grant_privileges.zip.
3. Login in as SYDBA and continue from Step 7 in the guide below:

 

NOTE: During the creation of the kamv_data schema, note for Step 4 below, do not use the scripts listed - use the attached scripts from 'grant_privileges.zip' script instead.

 

1. Login in as SYSDBA and run the kamv_data_grant_privs.sql script from the attached zip file grant_privileges.zip.
2. Login in as APPS schema and run the kamv_data_grant_privs_apps.sql from the attached zip file grant_privileges.zip.
3. Login in as SYDBA and continue from Step 5 in the guide.

Level of Complexity

Moderate

 

Applies to  

Product	Version	Build	Environment	Hardware
Kofax Analytics For MarkView	1.1.x

 

​