Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

no data returned from sql server 2016 tables #3839

Closed
GiovanniBaldo opened this issue Dec 20, 2021 · 4 comments
Closed

no data returned from sql server 2016 tables #3839

GiovanniBaldo opened this issue Dec 20, 2021 · 4 comments
Assignees

Comments

@GiovanniBaldo
Copy link

Ive installed budibase on premise with docker (budibase is version 1.0.25)
I'm connecting to a db in sql server. it connects correcly and has loaded all the tables definition.
Some tables are correctly opening and returns data. see for example:
image
Some tables are correctly opening but do not display any rows
image

@shogunpurple
Copy link
Member

Hi @GiovanniBaldo - do the tables that are not returning data have a PRIMARY KEY set?

@GiovanniBaldo
Copy link
Author

GiovanniBaldo commented Dec 21, 2021

hi @shogunpurple, this is structure of one of the not working tables:

CREATE TABLE [dbo].[tbClienti](
[IDCliente] [varchar] (3) NOT NULL,
[Cliente] [varchar] (40) NOT NULL,
[Project] [int] NULL,
[Trasferito] [bit] NULL,
[DataModifica] [datetime] NULL,
[IDProfilo] [int] NULL,
[RapportoChiuso] [bit] NOT NULL,
[AddebTrasf] [bit] NOT NULL,
[NonFatturare] [bit] NOT NULL,
CONSTRAINT [aaaaatbClienti_PK] PRIMARY KEY NONCLUSTERED
(
[IDCliente] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

and this is the structure of one of working tables:
CREATE TABLE [dbo].[tbValute](
[IDValuta] [int] IDENTITY(1,1) NOT NULL,
[SiglaValuta] [varchar] (5) NOT NULL,
[DescValuta] [varchar] (30) NOT NULL,
[NDecVis] [int] NOT NULL,
[IsEuro] [bit] NOT NULL,
CONSTRAINT [PK_tbValute] PRIMARY KEY NONCLUSTERED
(
[IDValuta] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

At a first look I tought it can be a problem with the name of the constraint for the primary key (its a bit strange on the tbClienti table). But some working tables have the same strange name for the constraint so probably thats not the problem!

@KevMyst

This comment has been minimized.

@mike12345567
Copy link
Collaborator

This should be resolved in the latest release of Budibase.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants