How to resolve the error "Invalid analysis type" when trying to run an analysis from Statistica Server after upgrading from Statistica 8.x to 13.x and above
book
Article ID: KB0070243
calendar_today
Updated On:
Products
Versions
Spotfire Statistica
8.x through 13.x
Description
After upgrading from an older version of Statistica, for example, Statistica 8.0, to 13.x, while the upgrade completes, when using Statistica Server (also known as WebStatistica), the following error occurs when accessing the "Analyses and Reports" option in the menu:
There may be other causes.
Environment
OS: Windows
Resolution
Query the Statistica Enterprise database, also known as the meta database repository, to check the monitor types in the database. The query will look like the following:
If the query contains output with MTYPE equal to STBASIC, SCL, STB then this is most likely the cause of the error. These monitor (analysis) types are not compatible with 13.x and above.
DISCLAIMER: Cloud Software Group is not responsible for improper modification of the meta database. Always backup the database before making any direct modifications. Proceed with caution.
The solution is to set the VFLG='"D" which will mask the monitors as deleted so they will not load in WebStatistica.
An example SQL statement to set these to D is below:
SQL> Update CSMON Set VFLG = 'D' where MONID in(41, 713);
Issue/Introduction
When upgrading from a much older version, Statistica 8, to Statistica 13.x and above, Statistica Server (also known as WebStatistica) throws "Invalid analysis type." This article discusses how to resolve this issue.