1. Home
  2. Support
Article - CS375619

ThingWorx Error: No buffer space available maximum connections reached

Modified: 30-Aug-2022   


Applies To

  • ThingWorx Platform 9.3 SP1

Description

  • ThingWorx logs this error messages in DatabaseLog.log at ThingworxStorage/logs folder
    • 2022-08-26 05:35:46.165+0000 [L: ERROR] [O: D.c.t.t.d.QueryHandler] [I: ] [U: Administrator] [S: ] [P: ] [T: http-nio-8080-exec-5] Unable to Invoke Service Pie_Chart_City on Health_Report_Health : Execute Query failed. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 56797 has failed. Error: "No buffer space available (maximum connections reached?): connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
  • ThingWorx Errorlog.log prints this messages error:
    • 2022-08-26 08:49:44.997+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: ptc_user5] [S: ] [P: ] [T: http-nio-8080-exec-9] Error Processing Start Notification in [Health_Report_Health] : null 
      2022-08-26 08:49:46.138+0000 [L: ERROR] [O: E.c.t.r.a.ScriptServices] [I: ] [U: Administrator] [S: ] [P: ] [T: http-nio-8080-exec-10] invalid property id at line 359 column 182 source: [            StartDate: dateAddMinutes(dateAddDays(parseDate(dateFormat(new Date(), "yyyy-MM-dd"), "yyyy-MM-dd"), -7+1-dateDayOfWeek(new Date())),-330) /* DATETIME */, /* DATETIME */,] org.mozilla.javascript.EvaluatorException: invalid property id (Line#358)
          at com.thingworx.dsl.utils.DSLErrorReporter.error(DSLErrorReporter.java:70)
          at org.mozilla.javascript.Parser.addError(Parser.java:258)
          at org.mozilla.javascript.Parser.reportError(Parser.java:326)
          at org.mozilla.javascript.Parser.reportError(Parser.java:313)
          at org.mozilla.javascript.Parser.reportError(Parser.java:306)
  • These errors causing slowness in accessing ThingWorx Mashup and Composer
This is a printer-friendly version of Article 375619 and may be out of date. For the latest version click CS375619