Enterprise Error : ORA-12899: value too large for column "CSLOG"."OLDVAL" while saving a lengthy query
Article ID: KB0077530
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.3.1 and later |
Description
Below error is received when working with lengthy query jobs in Statistica Server (Enterprise Manager or WebStatistica) with Oracle metadatabase:
ORA-12899: value too large for column "CSLOG"."OLDVAL" (actual: 517, maximum: 512)
(ODBC RETCODE: -1; State: S1000, Native: 12899, Origin: [Oracle][ODBC][Ora]) [CssSPCMonitor.cpp(4921)] [?A1|SubsetNode#111] Set ss = Application().ExtractEnterpriseData(analysisConfig, False, True, sLabel$, sDT$
ORA-12899: value too large for column "CSLOG"."OLDVAL" (actual: 517, maximum: 512)
(ODBC RETCODE: -1; State: S1000, Native: 12899, Origin: [Oracle][ODBC][Ora]) [CssSPCMonitor.cpp(4921)] [?A1|SubsetNode#111] Set ss = Application().ExtractEnterpriseData(analysisConfig, False, True, sLabel$, sDT$
Issue/Introduction
Enterprise Error : ORA-12899: value too large for column "CSLOG"."OLDVAL" while saving a lengthy query
Environment
Windows
Resolution
Execute below SQL statements to update the CSLOG table on Statistica Oracle metadatabase to allow logging of lengthy queries:
alter table cslog modify oldval nvarchar2(512);
alter table cslog modify newval nvarchar2(512);
alter table cslog modify oldval nvarchar2(512);
alter table cslog modify newval nvarchar2(512);
Feedback
Yes
No
Powered by
