Views not returning schema data

[raymantle]

OS info

• Operating System : Windows 10.0.22000
• Wappler Version : 4.2.2
• ASP.Net
• IIS

Problem description

When I expand views, nothing is returned.

Steps to reproduce

1. Expand a view

[2021-11-13 21:16:38.004] actionFilePath=file:///C:/###################################connection_######.json
[2021-11-13 21:16:42.263] START loadDatabaseConnection for connection_######
[2021-11-13 21:16:42.263] options: loadTable=undefined
[2021-11-13 21:16:42.263] options: noLock=true
[2021-11-13 21:16:42.264] load connection_###### from CACHE …
[2021-11-13 21:16:42.264] view not loaded yet - load: dbo.vw_customers
[2021-11-13 21:16:42.265] get knex dbType=mssql
[2021-11-13 21:16:43.506] START loadDatabaseConnection for connection_######
[2021-11-13 21:16:43.506] options: loadTable=undefined
[2021-11-13 21:16:43.506] options: noLock=true
[2021-11-13 21:16:43.506] load connection_###### from CACHE …
[2021-11-13 21:16:43.506] view not loaded yet - load: dbo.vw_card_orders
[2021-11-13 21:16:43.506] get knex dbType=mssql

DB connection is OK

Tables expand correctly

[raymantle]

Also, not expanding within query builder.

[mimuk]

Yes I have this issue as well.

[turn3636]

I have the same issue. Sometimes if you refresh the schema for the database, or test the database connection it will work, but not all the time.

I listed the same issue a couple of weeks ago.

Cannot access views in ASP.NET after 4.2.2

I’m not sure what version this happened, as I have not worked on this project in a couple of weeks. I updated to 4.2.2 last week. Using a Mac, connecting to a MSSQL via IIS. The app was built last year and I have been working on it ever since. I just made some changes to the app a couple of weeks ago. I open it up this morning to make a couple of changes before I show it to the customer and I noticed some things were not working. I discovered that it is not seeing my table views. When I o…

[raymantle]

Glad I’m not the only one.

This is preventing me from continuing with my project updates because the views are not showing in the query builder.

[George]

Is it just the views? How are you connecting toMS SQL Server from Wappler?

See:

Error connecting to MS SQL Server

As we switched to newer MS SQL driver in Wappler called Tedious, seems named SQL Server addresses are no longer supported. You can convert them to normal addresses as suggested at:

[raymantle]

Hi George,

It’s just the Views. I am connecting to MS SQL Server via IP address.

Tables are OK.

Its Views that are not expanding. Here you can see I have a table expanded, but the Views below fail to expand.

[turn3636]

And if you have a field from a view in your query and when you open your query, it will tell you that it can’t find that field in your database.

[sid]

Bump. Any update on this bug? @patrick @George
Unable to work on SAs due to this. Really in need of a fix.

[raymantle]

Even if I don’t set up a direct connection, when in query builder, the view does not expand, so not limited to the database manager.

[George]

This will be fixed in the next update. We have greatly improved MS SQL Server schema retrieval now.

[Teodor]

This has been fixed in Wappler 4.3.1