Write back DB node for large Statistica sta files to SQL Server fails
Article ID: KB0074170
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.2 and above. |
Description
When I try to use the Write Spreadsheet to Database node to write back large spreadsheets back into a MS SQL Server DB. Write back small tables with the same DB connection works fine? Working fine on other workstations. What is wrong and how is this fixed?
Screenshot of the error:
Cause:
One possible cause if the .NET Framework is not installed or is corrupt.
Issue/Introduction
Write back DB node for large sta files to SQL Server is not working
Environment
Windows operating systems only.
Resolution
SOLUTION ONE
Run the Microsoft .NET Repair Tool. See the .Net Repair Tool.
SOLUTION TWO
1. Install .NET Framework 4.6.1.
2. If the issue persists, install all .NET Framework dependencies (.NET 3.5 and .NET 2.0). All .NET Framework dependencies are located in the ISSetupprerequisites folder, a sub-folder of the Install 64 or the Installer 32 folder:
Feedback
Yes
No
Powered by
