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

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:

Error:  Invalid Analysis Type

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:

SQL> Select MONID, NAME, MTYPE,  from CSMON

Output will look like below:

  MONID      NAME                   MTYPE               
----------          -------------------     -------------------- 
        41      testing_def                    STBASIC             
       713     OPERATOR NAMES    STBASIC

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.