Write Spreadsheet to Database node doubles text lengths

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).