Home › Forums › Help needed › SqlException when starting Tabbles (with Cloud database)

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
    • Avatar photoGorgsenegger
      Participant
      May 24, 2022 at 7:56 pm
      Post count: 2
      #16187

      I’m using tabbles V 5.9.5 an suddendly keep getting errors when starting the application:

      SQL Server is not responding. Retrying…

      The logfile contains the following entries:

      20:43:25:54 Tabbles is starting. 5.9.5 24.05.2022
      20:43:25:77 showLoginDialogAndCheckDbVersion2 5.9.5 24.05.2022
      20:43:25:77 showWndLoginAndReturnUid 5.9.5 24.05.2022
      20:43:53:71 success retrieving sql server address for tabbles cloud 5.9.5 24.05.2022
      20:43:53:71 tryLoginCommonLanAndCloud 5.9.5 24.05.2022
      20:43:53:71 SPROC getUserIdOfNameAndPwd: enter — dbGetUserIdOfNameAndPwd 5.9.5 24.05.2022
      20:43:54:2 —SPROC getUserIdOfNameAndPwd: exit duration 0,2987628 seconds 5.9.5 24.05.2022
      20:43:54:4 SPROC dbFunctionsWithTransactions+getUserDataOfUserIdRetryForever2@3141-1: enter 5.9.5 24.05.2022
      20:43:54:17 —SPROC dbFunctionsWithTransactions+getUserDataOfUserIdRetryForever2@3141-1: exit duration 0,1230774 seconds 5.9.5 24.05.2022
      20:43:54:18 SPROC activation+activationPassed@250-2: enter 5.9.5 24.05.2022
      20:43:54:22 —SPROC activation+activationPassed@250-2: exit duration 0,0464659 seconds 5.9.5 24.05.2022
      20:43:56:34 SPROC Tabbles_logic+continueAfterValidLoginAndDbVersion@4456-8: enter 5.9.5 24.05.2022
      20:43:56:38 —SPROC Tabbles_logic+continueAfterValidLoginAndDbVersion@4456-8: exit duration 0,0475273 seconds 5.9.5 24.05.2022
      20:43:56:39 SPROC getDataToComputeSuggested: enter — chiamato da continueAfterValidLoginAndDbVersion 5.9.5 24.05.2022
      20:43:56:58 Sql Error: 20:43:56: getDataToComputeSuggested – exception: System.Data.SqlClient.SqlException number 1105 , state 2 – Could not allocate space for object ‘dbo.aux_allTabbles’.’PK_aux_allTabbles’ in database ‘tabbles5’ 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. 5.9.5 24.05.2022
      20:43:58:58 SPROC getDataToComputeSuggested: enter — chiamato da continueAfterValidLoginAndDbVersion 5.9.5 24.05.2022
      20:43:58:75 Sql Error: 20:43:58: getDataToComputeSuggested – exception: System.Data.SqlClient.SqlException number 1105 , state 2 – Could not allocate space for object ‘dbo.aux_allTabbles’.’PK_aux_allTabbles’ in database ‘tabbles5’ 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. 5.9.5 24.05.2022
      20:44:00:75 SPROC getDataToComputeSuggested: enter — chiamato da continueAfterValidLoginAndDbVersion 5.9.5 24.05.2022
      20:44:00:92 Sql Error: 20:44:00: getDataToComputeSuggested – exception: System.Data.SqlClient.SqlException number 1105 , state 2 – Could not allocate space for object ‘dbo.aux_allTabbles’.’PK_aux_allTabbles’ in database ‘tabbles5’ 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. 5.9.5 24.05.2022
      20:44:02:93 SPROC getDataToComputeSuggested: enter — chiamato da continueAfterValidLoginAndDbVersion 5.9.5 24.05.2022
      20:44:03:11 Sql Error: 20:44:03: getDataToComputeSuggested – exception: System.Data.SqlClient.SqlException number 1105 , state 2 – Could not allocate space for object ‘dbo.aux_allTabbles’.’PK_aux_allTabbles’ in database ‘tabbles5’ 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. 5.9.5 24.05.2022
      20:44:05:11 SPROC getDataToComputeSuggested: enter — chiamato da continueAfterValidLoginAndDbVersion 5.9.5 24.05.2022

      So it seems there is a problem with the SQL server in the “cloud”.

    • Avatar photorcertz
      Participant
      May 28, 2022 at 7:24 am
      Post count: 3
      #16194

      I had this issue about 2 weeks ago.  I wound up setting up my own SQL server at 2 in the morning because I coudlnt sleep on this.  I would advise getting off their servers as they go down either expected maintence or not… it is not communicated transparently.  I used the tutorals on the website and was able to get my way through it.  Once I was able to get into my cloud session I exported the database then imported it to my own sql server.  If you are computer saavy you should be fine.  I have not been terribly impressed with the support here as my questions go unanswered.

    • Avatar photoGorgsenegger
      Participant
      May 29, 2022 at 7:27 am
      Post count: 2
      #16196

      Thanks for your reply – I’m inclined to think that there isn’t much support and ongoing development. Running my own SQL server is not an option for me as I don’t have a server apart from my NAS and I don’t want to have it permanently running on my normal computer.

      I may have to start looking (again) for a different solution :-/

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.