Error, "ORA-12899: value too large for column TEXT_VALUE (actual: 34, maximum: 32)" using node in Statistica workspace

Error, "ORA-12899: value too large for column TEXT_VALUE (actual: 34, maximum: 32)" using node in Statistica workspace

book

Article ID: KB0080037

calendar_today

Updated On:

Products Versions
Spotfire Statistica 8.0 and above

Description

The workspace is trying to write more data to an Oracle column than the column can handle.  When this occurs, the error in the log looks like this:
Oracle error in log
 

Issue/Introduction

Destination database has column length that is shorter than source data. Thus the error ORA-12899 is thrown.

Environment

Oracle

Resolution

1.  Change incoming data should be the same size, or smaller, than the destination column, which would be 32 characters or less. 

Or

2.  Change the the destination database column to match the size of the incoming data.  
Powered by Wolken Software