I can't tell if this is an appian problem or a DB problem and am not sure where to begin looking for the problem. When writing to a record I get this error:
I wasn't getting this error last week, which is frustrating, but I am now. As far as I can tell, I haven't changed anything that I am aware of that might cause it. The table exists in the db and the table permissions seem to be fine. Doesn't seem to be happening with other tables and I don't have access to appian's error logs. Any ideas as to what I should do next?
Discussion posts and replies are publicly visible
First thoughts on this are with casing and object permissions. I recommend you check the casing of the table defined on the record and confirm it matches the actual table name in the database? You mentioned that the table permissions seem to be fine, but check that the same is true for the object security.
I can't imagine casing is an issue as I've written with this record before and am still able to use the record to read the data. I checked to be sure, and it seems fine.
I've got direct admin permission to both the record itself and the process model I'm writing with and haven't configured any other security on the record.