MsSQL Tables are empty in budibase

[kasgithub8]

Checklist

• [x] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.22.13
  • App Version: 2.22.13

Describe the bug I just noticed that the MsSQL Tables across all our applications are empty even though the connections and queries work fine.

To Reproduce Steps to reproduce the behavior:

1. Create application
2. Add your MsSQL server
3. Fetch tables
4. See empty tables

Expected behavior Just a couple of weeks ago the tables were filled and should always have their data in the budibase app.

Screenshots

App Export Not app specific

Desktop (please complete the following information):

• OS: Windows
• Browser every browser
• Version 1

[linear[bot]]

BUDI-8140 MsSQL Tables are empty in budibase

[andz-bb]

hey @kasgithub8, could you send your network logs for the search network request please? You can find them in the Network tab of your browser's development tools.

It would also really help to be able to see your MS SQL table schema. Is it only this table that doesn't work for you or does it happen for all of them? Thanks

[kasgithub8]

Hi @andz-bb,

my search doesn't look like yours at all, I can't even show you preview because it's obviously empty:

And yes, this happens to all the tables.

[andz-bb]

@kasgithub8

could you send your table schema please? I haven't been able to replicate on my side

[kasgithub8]

@andz-bb I can send one even though they're all affected: CREATE TABLE [hapa] ( MAN varchar(50) NULL, AK varchar(50) NULL, PNR varchar(50) NULL, Vertrag varchar(50) NULL, Name varchar(50) NULL, Beschreibung varchar(50) NULL, Bezeichnung Dokument varchar(500) NULL, Gueltig_ab date(3) NULL, Datei varchar(50) NULL, Gueltig_bis date(3) NULL, RowId int(4) NOT NULL, CONSTRAINT [PK_hapa] PRIMARY KEY (RowId) );

[ConorWebb96]

Hey kasgithub8,

Does the user that you are connecting to the database with have the correct permissions to view the rows inside the table?

I haven't been able to reproduce this behaviour.

[kasgithub8]

Hi @ConorWebb96,

it seems to again. The mssql table is filled with its data again. I don't know what caused it or fixed it, maybe a random platform update. Thank you still!