SAP Knowledge Base Article - Preview

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

Symptom

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"


Read more...

Environment

  • SAP SuccessFactors HCM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      •  People Analytics (Analytics Cloud for SF) 
        • Query Designer - Filter, Calculated Column, Params

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors People Analytics 2311

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.