Error: SQLEngine got an Exception from DFC: [DFCENGINE] Engine Logic: Fact does not exist at a level that can support the requested analysis. Fact: "Visitor Count". Level: "Visitor ID, Visitor Center Name and ID".
Error in Process method of Component: SQLEngineServer, Project VUE Reporting, Job 43595, Error Code= -2147212800.
If you have worked with MicroStrategy, you have definitely come across this error at least once!
First things first - did you recently change any attributes? If you did, did you update the schema? If no, then that is most likely your problem. Update the schema from MSTR Desktop > Schema > Update Schema or Ctrl+U.
If that does not fix your problem, I may not be able to give you an exact answer but can guide you through troubleshooting the problem. Below, I will use my error mentioned above related to Visitors to guide you through troubleshooting. The steps mentioned below may be a little long for those of you who are already familiar with MSTR and object development.
1. Make a backup of your report
2. Remove all other metrics from the report template except for the metric in question - in my case Visitor Count
3. Run the report. Problem fixed? No, go to step 4. Don't forget to add these metrics back to the report template once the problem is fixed. If Yes, one of those metrics was the problem maker.
4. Remove the attributes mentioned in the error from report template - in my case [Visitor ID] and [Visitor Center Name and ID]. Does this fix the problem (keeping in mind you did remove the two attributes that are needed on your report)? Yes? Well, those attributes were your problem.
5. Check the relationships between those attributes - that is where the source of your troubles is.
6. Don't forget to add the other metrics back on the report, if you removed them.
Hope this helps! If you have more specific questions feel free to ask in the comments.
Error in Process method of Component: SQLEngineServer, Project VUE Reporting, Job 43595, Error Code= -2147212800.
If you have worked with MicroStrategy, you have definitely come across this error at least once!
First things first - did you recently change any attributes? If you did, did you update the schema? If no, then that is most likely your problem. Update the schema from MSTR Desktop > Schema > Update Schema or Ctrl+U.
If that does not fix your problem, I may not be able to give you an exact answer but can guide you through troubleshooting the problem. Below, I will use my error mentioned above related to Visitors to guide you through troubleshooting. The steps mentioned below may be a little long for those of you who are already familiar with MSTR and object development.
1. Make a backup of your report
2. Remove all other metrics from the report template except for the metric in question - in my case Visitor Count
3. Run the report. Problem fixed? No, go to step 4. Don't forget to add these metrics back to the report template once the problem is fixed. If Yes, one of those metrics was the problem maker.
4. Remove the attributes mentioned in the error from report template - in my case [Visitor ID] and [Visitor Center Name and ID]. Does this fix the problem (keeping in mind you did remove the two attributes that are needed on your report)? Yes? Well, those attributes were your problem.
5. Check the relationships between those attributes - that is where the source of your troubles is.
6. Don't forget to add the other metrics back on the report, if you removed them.
Hope this helps! If you have more specific questions feel free to ask in the comments.
Comments
Microstrategy Online Training
Microstrategy Online Course