Write Spreadsheet to Database node doubles text lengths
book
Article ID: KB0081805
calendar_today
Updated On:
Products
Versions
Spotfire Statistica
12.5 SP1 and higher
Description
When using the "Write Spreadsheet to Database" node to write a table to an Oracle database and then creating a data configuration on the table that is created from that node, the length of all text fields in the data configuration output spreadsheet is twice the length of the same text fields in the input spreadsheet of the "Write Spreadsheet to Database" node.
It is likely caused by an out of date Oracle driver in the workstation server or the remote server that the you are logged in to run the task.
Issue/Introduction
Write Spreadsheet to Database node doubles text lengths
Environment
Windows
Resolution
Suggest to install and use an updated Oracle driver on the workstation and the remote server (e.g. Citrix).