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:
- Stop the running station and Niagara service
- 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
- Copy in the coreRuntime-2.301.529a.v1.jar file.
Restart the Niagara service and Enterprise Server station.