Article - CS321032

"Could not allocate space for object <Object> in database <Database> because the 'PRIMARY' filegroup is full" is seen on ThingWorx Platform on Microsoft SQL Server

Modified: 23-May-2025   


Applies To

  • ThingWorx Platform 9.0 to 9.6
  • Microsoft SQL Server
  • Azure SQL Database

Description

  • ThingWorx Platform on Microsoft SQL Server will not start citing a database error with following errors in /ThingworxStorage>/logs/ApplicationLog.log:
    • [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-3] [message: Could not allocate space for object '<object_name>'.<object_name>' in database 'thingworx' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.]
      [L: ERROR] [O: c.t.s.s.a.AuditSubsystem] [I: ] [U: SuperUser] [S: ] [P: ] [T: ForkJoinPool-1-worker-1] Unable to write audit entry for: [AuditEntry category=audit.AuditCategory.Lifecycle, messageKey=<Audit>]
      [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8443-exec-4] [context: com.thingworx.webservices.context.HttpExecutionContext@7753d44a][message: Thing [ptc-windchill-demo-thing] is not running]
  • Importing entities into ThingWorx fails with following error in /ThingworxStorage/logs/ErrorLog.log:
    • [L: ERROR] [O: E.c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: <User>] [S: ] [T: https-jsse-nio-8443-exec-11] [message: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]] com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object '<object_name>'.<object_name>' in database 'thingworx' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
          ...
      Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
          ...
  • Unable to create an entity or edit any configurations of Subsystems and getting the same error as above
  • Getting below error while executing service PurgeStreamEntries :
    • Unable to Invoke Service PurgeStreamEntries on XXX : com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]
  • Unable to update Thing Shape and getting below error while trying to update and save the Thing Shape:
    • Unable to update thing shape: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
  • Error message in Japanese is as below
    • データベース 'thingworx' にオブジェクト 'xxx'.'xxx' の領域を割り当てられませんでした。'PRIMARY' ファイル グループがいっぱいです。不要なファイルの削除、ファイル グループ内のオブジェクトの削除、ファイル グループへの新しいファイルの追加、またはファイル グループの既存のファイルの自動拡張の設定のいずれかを行ってディスク領域を作成してください。 
This is a printer-friendly version of Article 321032 and may be out of date. For the latest version click CS321032