How to resolve "Invalid column name 'PROCNAME... USERNAME... MACHNAME...could not be preparted" when upgrading Spotfire Statistica
Article ID: KB0138566
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.4 |
| Spotfire Statistica - All Servers | 14.4 |
Description
After a successful in-place upgrade from 14.x to 14.4, the metadata database (a.k.a the Enterprise database) may require a schema change. A prompt to make this change will occur while logging into Statistica. After clicking to allow the change, the schema is successfully updated. However, login fails with four invalid column names, as below:
Resolution
The four columns need to be manaully added to the Statistica metadata database (a.k.a the Enterprise database) schema. All columns will be added to the CSAUSR table. The colums to be added are:
PROCNAME
MACHNAME
APPNAME
USERNAME
Run one of the following SQL statements to add the required four columns. The first two are for MS SQL and the last one is for Oracle:
--MS SQL statement (or Transact-SQL)
ALTER TABLE CSAUSR
ADD
PROCNAME VARCHAR(64) NULL,
USERNAME VARCHAR(64) NULL,
MACHNAME VARCHAR(64) NULL,
APPNAME VARCHAR(254) NULL;
-- Alternative valid MS SQL syntax using parentheses:
ALTER TABLE CSAUSR
ADD (
PROCNAME VARCHAR(64) NULL,
USERNAME VARCHAR(64) NULL,
MACHNAME VARCHAR(64) NULL,
APPNAME VARCHAR(254) NULL
);
/* Oracle Syntax */
ALTER TABLE CSAUSR
ADD (
PROCNAME VARCHAR2(64) NULL,
USERNAME VARCHAR2(64) NULL,
MACHNAME VARCHAR2(64) NULL,
APPNAME VARCHAR2(254) NULL
);
Disclaimer: Spotfire Support is not responsible for improper use of database queries.
Issue/Introduction
This article provides steps to resolve an error after upgrading to Statistica 14.4.
