SPN_BAS_CREATECONSTRAINT error persists after following the instructions of article 126873

book

Article ID: 131290

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Even after following the instructions of article126873, we still get Oracle error during create script: 
 

2019-04-17 18:33:20,181 ERROR impl.UIMServerDBSchemaController:run:163 [main]  - NimException caught
(503) , java.sql.SQLException: ORA-06550: line 71, column 5:
PLS-00905: object UIM.SPN_BAS_CREATECONSTRAINT is invalid
ORA-06550: line 71, column 5:
PL/SQL: Statement ignored
: ORA-06550: line 71, column 5:
PLS-00905: object UIM.SPN_BAS_CREATECONSTRAINT is invalid
ORA-06550: line 71, column 5:
PL/SQL: Statement ignored

Cause

This error used to be solved granting permission as is specified on product documentation at Link: 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/installing/pre-installation-planning/install-and-configure-your-database-software/oracle.html#concept.dita_29770a76aa73c964cc20c88d7fde7390cf3ac44b_GrantPermission

As described in the documentation, the privileges should be assigned directly to the user,  in case that privileges were assigned through a User Role, this error will also be displayed and installation will fail. 

Environment

UIM 9.0.2

Resolution

Please follow the steps below:

1 - Grant Oracle privileges directly to the Oracle user based specified at UIM Oracle Permission page

2 - Follow the instructions of Installation errors for 9.02 SPN_BAS_CREATECONSTRAINT is invalid