SAP Knowledge Base Article - Public

2848424 - Insufficient Privilege Error when Initial OLAP is ran - WFA on HANA

Symptom

When trying to "Build Fact Table and Cube" in "WFA on HANA Data Factory" you see the following missing privilege

com.sap.db.jdbc.exceptions.JDBCDriverException: [258]: insufficient privilege

Environment

  • SAP SuccessFactors Workforce Analytics
  • WFA on Hana DATA Factory

Reproducing the Issue

1. Log into the Data Factory (WFA Admin -> WFA on HANA Data factory)

2. Run “Build Fact Table and Cube”

Error:
Stage Processor Pre-process OLAP data failed. Exception: OlapLib.OlapException: Pre process stage failed for OLAP initial load. ---> System.Exception: There was an error when creating the OLAP database for on the server dbPool2. ---> System.Exception: Error creating a user for the OLAP database for company ---> com.sap.db.jdbc.exceptions.JDBCDriverException: [258]: insufficient privilege: Not authorized at com.sap.db.jdbc.ConnectionSapDB.execute(Boolean isStatement, RequestPacket requestPacket, Boolean ignoreErrors, Boolean isParse, Object executingObject, JdbcCommunication session, Boolean avoidReconnect) at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(RequestPacket , String , Boolean , JdbcCommunication ) at com.sap.db.jdbc.StatementSapDB.sendSQL(String sql, Int32 resultSetType, Int32 resultSetConcurrency, Boolean parseAgain, JdbcCommunication session) at com.sap.db.jdbc.CallableStatementSapDB.doParse(String , Boolean , JdbcCommunication ) at com.sap.db.jdbc.CallableStatementSapDB.constructor(String ) at com.sap.db.jdbc.CallableStatementSapDB..ctor(ConnectionSapDB , String , Int32 , Int32 , Int32 ) at com.sap.db.jdbc.CallableStatementSapDBFinalize..ctor(ConnectionSapDB connection, String sql, Int32 resultSetType, Int32 resultSetConcurrency, Int32 resultSetHoldability) at com.sap.db.jdbc.ConnectionSapDB._prepareStatement(String , Int32 , Int32 , Int32 ) at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(String sql) at com.sap.db.jdbc.trace.Connection.prepareStatement(String arg0) at Hrml.Hana.HanaPooledConnection.GetPreparedStatement(String sql, CommandType commandType)

Cause

Caused by insufficient privileges that need to be granted via an COSD Engineering ticket.

Resolution

Raise a COSD Jira, example such as COSD-39198

Keywords

WFA on HANA, Initial Load Failure, Missing Priviledge, pre process stage failed for OLAP initial load, com.sap.db.jdbc.exceptions.JDBCDriverException: [258] , KBA , LOD-SF-WFA , Workforce Analytics & Planning , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HCM Core 1908