3458293 - Story reports error - Caught exception: exception 42111: SQL Error-Internal error occurred while run a query from EC or MDF schema

While create a simple story, with JobInfo, Foundation objects schema and also some EC related schemas, preview query once, will get error(example) in network logs:

"Type": 2,
            "Number": 42014,
            "Text": "Internal error occurred while processing.",
            "DetailedError": "Caught exception : exception 42111: SQL Error : ect_sac_1000_employmentInfo_5365543694118114: line 22 col 98 (at pos 1421)\n"

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    • Story Reports

1. Login into SF instance
2. Go to report center and create a new story report with schema "Employment"->"JobInformation"->"UserID"(or schema from Position, Foundation objects )
3. Preview Query will see error 

Internal error occurred while processing.
For assistance, please contact your administrator or the SAP Product Support team, if needed.
Correlation ID: 

Issue cause by reoccurring job that cleanup obsolete/stale functions. When this job runs, the permission function entity gets cleared from DB, but in cache remains as it haven't reach expiry period.

Permanent resolution is still under investigation with Engineering team.

Temporary workaround:

Need to manually delete the dynamically created permission table functions and cache entries to bring the state back to normal. 
Please create case with Support to perform this activity.

Caught exception: exception 42111, Story, Report, Error, Instance, Refresh, Automatic, Delete, Cache, 70000328: invalid name of function or procedure , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , Problem