No Response data being returned after upgrading to v7.7.3 (MSSQL)

Hello,

NodeJS, Docker, MSSQL

I upgraded a project today from v7.7.1 to v7.7.3 and noticed that none of the APIs are returning JSON data under Response tab. Instead all the APIs returning the full ejs code.

As a result, all the elements that have a dynamic binding to these APIs have stopped displaying any information from the database.

I also noticed that one of the core files that has been updated in v7.7.3 is lib/auth/database.js. Is there a bug in this code with an MSSQL database?

There's no error in the dev console.

Any help to troubleshoot will be greatly appreciated.

EDIT: I have a couple of other projects that are retruning the data correctly after upgrading to v7.7.3 and also use MSSQL databases.

What about looking for something on dmx.app.data and navigate to the sc?
There's a lasterror there, maybe a "no valid json?" appears?

Hi Francisco,

Thank you for providing some tips to troubleshoot. It turned out to be an issue with how routes are being parsed when a wildcard route is added to routes.json.

@Cheese provided me with a detailed explanation of this issue and attached the updated code provided by Patrick. It looks like the new routes code has been included in the v7.7.6 release that came out last night (see this post for reference: API Actions Settings Route Path Issue).

1 Like

We just released an inline extension update that fixes this problem.

1 Like