cancel
Showing results for 
Search instead for 
Did you mean: 

Could not read working days information from TFACS table - insufficient privilege

PMathieu
Explorer
155

Another problem that appeared during the update and was not resolved is the Workdays_between function, this function was the subject of several notes 3396583 and 3300174 which allowed the function to work correctly

 
Since the January update on SAP Datasphere, Analytics models fall into error when fact views that use the function with the following error:
 
The query executed with errors.
Caught exception : exception 70002048: column store error: exception 334060: Could not read working days information from TFACS table "SPACE001"."TFACS_ABC" - insufficient privilege: Detailed info for this error can be found with guid '9A184BAE96589C49AA8F7EFFBCCEF981' at Authorization/insuffPriv/impl/InsufficientPrivilegeThrow.cpp:365
 
It should be noted that this happens if the Fact view is shared and therefore the analytical model is in a different space than the useful TFACS remote table.
 
The view and the tables are shared but without solving the problem

 If the model is created in the same space as the TFACS view/table, the model works correctly.

By Patrice Mathieu

Accepted Solutions (0)

Answers (2)

Answers (2)

PMathieu
Explorer
0 Kudos

The problem is solved after the latest patch release of the database

currently our system shows 4.00.000.00.1734558877 (2024.40.8)
and a patch release is available 

We run and implement the release 2024.40.13

 

Patrice

klorn_pallier
Explorer
0 Kudos

I had this issue and sharing with the Fact and analytical model space solved the it for me.

DominicF
Discoverer
0 Kudos

-

DominicF
Discoverer
0 Kudos

-

DominicF
Discoverer
0 Kudos
I had the same issue and sharing the view with the other spaces did not work for me. However creating a new TFACS-view (that uses the TFACS-table shared to this view) in the space where the calculation is done solved the probleme for me. You can find additional information here:https://userapps.support.sap.com/sap/support/knowledge/en/3396583