SUMMARY:
This issue has been classified as a defect by Strategy. The impact is limited to Strategy Web 9.4.1 products only with using data import republish. Currently no workarounds are available in the current document. A solution/code fix for this issue is not available in current releases but is being reviewed for a future Strategy release.
SYMPTOM:
When a user is republishing a data import cube in Strategy Web 9.4.1, the error message may appear below:
Error saving and publishing the Cube:(QueryEngine encountered error: Transform failed.
Error type: Data Import Error. Invalid Normalization Information.. Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 388, Error Code= -2147212544.)
In some cases the Strategy Intelligence server will crash after clicking ok. The error message will follow as shown in the image below.
Error saving and publishing the Cube:The connection failed. Possible causes are a) Server is not running, b) Server is loading project, c) Network problem, or d) Server reached maximum connection limit.
VIDEO:You can find a detailed video on how this issue occurs:
CAUSE:This issue occurs if the cube publish fails in the Data Services layer. If Strategy doesn't report the error in time the Intelligence server will crash. This is a known issue classified as a defect with Strategy Web 9.4.1.
ACTION:
Currently this issue is still being investigated by our Technology team and will potential be scheduled for an upcoming Strategy release.
ADDITIONAL TROUBLESHOOTING:If experiencing a Strategy Intelligence Server crash as described in the issue above Strategy Technical Support will need the following:
1. The Core-file generated by the Intelligence Server
2. The Version of Strategy including hotifx on the Intelligence Server
3. The Operating System of the Intelligence Server.
TO LEARN MORE:Strategy Advanced Reporting Guide 9.4.1
Chapter 1: Introduction to Advanced Reporting: Importing data from different data sources
Review the technotes below in the 'Related Links' section for more information on this topic.
The Strategy Internal Reference Number for the issue discussed in this technical note is 906504
