Article - CS405625
AddDataTableEntry service fails to add entry with more that 254 fields in ThingWorx using SQL Server persistence provider
Modified: 29-Sep-2025
Applies To
- ThingWorx Platform 9.3
- Microsoft SQL Server as Persistence Provider
Description
- Following error is seen when executing a service that calls AddDataTableEntry on a dataTable with a large number of fields when using SQLServer as Persistence Provider
-
[1,018] Data store unknown error: [Error occurred while accessing the data provider.]
-
- Enabling stack trace in Logging Subsystem shows the following exception in ErrorLog.log
- [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: Administrator] [S: ] [P: ] [T: https-openssl-nio-443-exec-5] Unable to Invoke Service AddOrUpdateDataTableEntries on XXXX: java.lang.RuntimeException: com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.] com.microsoft.sqlserver.jdbc.SQLServerException: The concat function requires 2 to 254 arguments. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431) at com.thingworx.persistence.common.SQLStatementUtilities.executeQuery(SQLStatementUtilities.java:107) at com.thingworx.persistence.mssql.dao.BaseMssqlDao.executeQuery(BaseMssqlDao.java:134) ... 17 common frames omitted
This is a printer-friendly version of Article 405625 and may be out of date. For the latest version click CS405625