Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Enterprise Server not archiving to SQL Server database.

Issue

Enterprise Server not archiving to SQL Server database. 

Getting the following Error in ErrorLogService:  “Failed to archive (1): tridium.datax.net.DxRemoteException: java.sql.SQLException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (""): The supplied value is not a valid instance of data type real. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater: than precision. 

The SOW displays:

at tridium.datax.net.DxExchange.doResponse (bytecode 107)
at tridium.datax.net.DxExchange.run (bytecode 118)
at java.lang.Thread.run (line 5)

Environment

R2, WorkPlace Pro 2.301.529, Enterprise Server

Cause

NA

Resolution

The coreRuntime-2.301.529a.v1 jar file corrects possible issues related to the archiving of data to a Microsoft SQL 2005 database.  This jar is only required by Enterprise Servers with the IA-SQL-DBS driver feature.

Installation:

  1. Stop the running station and Niagara service
  2. Locate the existing coreRuntime-2.301.529.v1.jar file (e.g. ...\nre\modules) directory.  Rename the existing file to coreRuntime-2.301.529.v1.jar.old
  3. Copy in the coreRuntime-2.301.529a.v1.jar file.

Restart the Niagara service and Enterprise Server station.

Tags (1)
Labels (1)
Version history
Revision #:
2 of 2
Last update:
a week ago
Updated by:
 
Contributors