SAP Knowledge Base Article - Public

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


When trying to "Build Fact Table and Cube" in "WFA on HANA Data Factory" the user will see the following missing privilege [258]: insufficient privilege


  • 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”

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 ---> [258]: insufficient privilege: Not authorized at isStatement, RequestPacket requestPacket, Boolean ignoreErrors, Boolean isParse, Object executingObject, JdbcCommunication session, Boolean avoidReconnect) at , String , Boolean , JdbcCommunication ) at sql, Int32 resultSetType, Int32 resultSetConcurrency, Boolean parseAgain, JdbcCommunication session) at , Boolean , JdbcCommunication ) at ) at , String , Int32 , Int32 , Int32 ) at connection, String sql, Int32 resultSetType, Int32 resultSetConcurrency, Int32 resultSetHoldability) at , Int32 , Int32 , Int32 ) at sql) at arg0) at Hrml.Hana.HanaPooledConnection.GetPreparedStatement(String sql, CommandType commandType)


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


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


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


SAP SuccessFactors HCM Core 1908