During OBIA 220.127.116.11 installation, while generating Datawarehouse tables, I encountered below error:-
“Creating Datawarehouse tables Failure’
But when i checked in the log file ‘generate_ctl.log’, it have the below message:
S1000: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01917: user or role ‘SSE_ROLE’ does not exist
The reason for above issue is missing SSE_ROLE.
Even if you do the install with DBA role, it will fail is SSE_ROLE is not present. Please create it and try again.
CREATE ROLE SSE_ROLE; GRANT DBA TO SSE_ROLE; GRANT SSE_ROLE TO BAW (basically your db user);
Some more info:-
For an Oracle database, when you create the SSE_ROLE role, you need to grant the following privileges:
For an Oracle database, if the DAC repository and the Informatica repository are stored in a different database to the data warehouse database, the SSE_ROLE must have the following additional privileges:
If you are using a Teradata database, you do not need to create the SSE role. If you are using a DB2 390 database, you can use an alternative SSE role name to SSEROLE if required. To specify a different role name, modify the ‘set GRANTEE=”SSEROLE”‘ line in the OracleBI\dwrep\createwtables.bat file.