We are using Skuid for Salesforce as well as for content management of our MSSQL server. We have a number of tables which we’ve been updating successfully for over a year or so. Over the last 5 days, however, we’ve been having an issue where we can query our database and return rows to our skuid models, but when we make changes and then save, we get an error:
Error: An internal server error occurred
After this happens, we aren’t able to even query our database to return rows to our model.
We’ve set up an SQL trace to see what happens, and it appears that there’s our initial sql update command, but this is then followed up with an sql select command for data that has nothing to do with our database structure, or any of the sql-managing pages we’ve created in skuid.
As an example, this would be like I’m trying to update a record relating to the colour of a car, and the follow-up sql “select” is asking for records relating to the customer purchasing scores for baskets from Albania.
Because our database doesn’t return any data to the second request, we think the transaction for the initial update doesn’t get committed or rolled-back, and the whole sql session hangs.
Nothing had changed with our database structure or permissions. I had initially suspected that the account used for the sql connection might’ve had an expired password, which I reset and configured in the skuid datasource settings. After doing this, tested the database connection and this was all fine, but we still get the same issue with weird select queries.
Has anyone else experienced this?