Skip to main content
Kofax

ORA-01031: insufficient privileges error when installing KAMV

Article # 3034248 - Page views: 65

Article # 3034248 - Page views: 65

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:

Section "Create schema for Kofax Analytics for MarkView":

clipboard_e9c4d60aebc1c95313056d44a0dcfb8de.png

Section "Create schemas for Kofax Analytics for MarkView Insight project":

clipboard_e4585903780542f6e5ab12eea3372f84f.png

 

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:

clipboard_e943ab4c1dc6d86f3a938ea1ab4937dec.png

 

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.

clipboard_edb58017d7f58ab0351348874390f32d7.png

Level of Complexity

Moderate

 

Applies to  

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

  • Was this article helpful?