VIP AuthHub Dataseed job fails, complains missing table prefix

Products

• Symantec Identity Security Platform - IDSP (formerly VIP Authentication Hub)

Issue/Introduction

When attempting to upgrade to 3.4.1 in our TEST region, the dataseed job fails because of a missing table IA_POLICY_PARAM. We have confirmed the table is present in the DB.

We use a different user(user_app) and schema(schema_app), and it appears the table name IA_POLICY_PARAM is not prefixed, causing this error.

SQL = insert into IA_POLICY_PARAM (ENTP_ID,LAST_UPDATED,PARAM_NAME,PARAM_VALUE,POLICY_NAME,STATUS,POLICY_PARAM_ID) values (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ), Original SQL = insert into IA_POLICY_PARAM (ENTP_ID,LAST_UPDATED,PARAM_NAME,PARAM_VALUE,POLICY_NAME,STATUS,POLICY_PARAM_ID) values (?,?,?,?,?,?,?), Error Message = ORA-00942: table or view does not exist\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:717)

Environment

VIP Authentication(Auth) Hub

Release: 3.4.1

Cause

Something in the environment outside of product has caused all the IA_ tables to use sequences

Resolution

Please make sure that all the Risk related IA ( Intelligent Authentication ) tables does not have sequences.