Server Action files getting corrupted when modified

[turn3636]

Using 7.2.2 on a Mac with Node.JS and MS SQL Server.

When I open an existing server action file I created several versions ago, about a year ago, and make any change to the query and click “save”, the files gets corrupted.
So here I have a simple query with a join.

When I add another column to the query, it looks ok at first,

but when I open the query back up, it changes to Select All:

And of course when I run the query it causes all types of errors. It also renames the join and repeats the table name:

This happens on every server action file I open and modify. Here is the original code file and the modified file in a diff compare, and there are a lot of differences after just adding the column:

Untitled diff - Diffchecker

This happened first on 7.2.1, then I updated to 7.2.2 thinking it was a bug that was fixed, but it is still happening. As on now, I’m dead in the water and just missed a deadline.

Anyone else seeing this issue?

[turn3636]

I also just tried creating a new server action. It works if you create it and save, but if you modify the query, it gets corrupted again by clearing out your selected columns and adding Select all.

[George]

Could you make sure that your database schema in the database manager is well updated? Just run from the context menu "Refresh Full Schema" when the tables node is selected of your database.

Let us know if it is all fixed after that.

[turn3636]

Well, that looks like it was the issue. Would not have known to do that. I refresh the schema all the time when modifying tables, but I do it from the query manager.

Thanks for the help.