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" the user will see the following missing privilege

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

Environment

  • SAP SuccessFactors HCM CORE
  • WFA on Hana DATA Factory

Reproducing the Issue

  1. Log into Canvas Admin (WFA Admin)
  2. Select Data Factory
  3. 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 Operations ticket.

Resolution

Please raise an incident to a component in Analytics or WFA(Workforce Analytics) and request to grant the required permissions.

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