We are experiencing an issue in which the software is not recognizing entities i

We are experiencing an issue in which the software is not recognizing entities in the database that are new or updated. All entities that existed previous to this week, work fine, are recognized and can perform without issue.

Alert:
There is a problem with task “Write to Data Store” in the process Dev: BRA - Admin Employee. An error occurred while trying to retrieve the data store entity [id=1e715e99-ac04-4355-ab82-cb79f8de101a@772]. Verify that the data store and entity have not been deleted, and have the correct security settings. Details: The entity [id=1e715e99-ac04-4355-ab82-cb79f8de101a] does not exist in the latest published version of the data store “Branch” [id=772]. (APNX-1-4169-001)

Caused by: com.appiancorp.suiteapi.common.exceptions.AppianException: Failed to look up entity (rule: [getOpsGrpDivListAJAX]) (APNX-1-4164-021)

We've confirmed that the Data Store exists, that the Entity exists, that the query rule exists and is c...

OriginalPostID-70099

OriginalPostID-70099

  Discussion posts and replies are publicly visible

Parents
  • Alex- as sys admin, it should not matter about credentials to the data store in Appian. We'v confirmed with our DBA and through a test using our Appian Service Account that nothing has changed as far as rights for this account. Meaning, I logged in via another IDE outside of Appian and ran an insert statement to the same table that the model was trying to write to via Appian, and my manual insert was successful.

    Christine - now that's an interesting question. Yesterday, when all of this was happening....I added an entity, clicked very and publish and instead of getting pink (to add the table to the database), it was green. I logged into our database outside of Appian, and the table did not exist. Yesterday, Appian would not create a new table via the verify and publish. We did a reboot, and after that when I added a new entity to a datastore, Appian showed pink and added the new table.
    I am still trying to run impact analysis on the impacted CDTS and continuously receive a server timeout. We just did a reboot so I am hoping to get this answered for you shortly.
Reply
  • Alex- as sys admin, it should not matter about credentials to the data store in Appian. We'v confirmed with our DBA and through a test using our Appian Service Account that nothing has changed as far as rights for this account. Meaning, I logged in via another IDE outside of Appian and ran an insert statement to the same table that the model was trying to write to via Appian, and my manual insert was successful.

    Christine - now that's an interesting question. Yesterday, when all of this was happening....I added an entity, clicked very and publish and instead of getting pink (to add the table to the database), it was green. I logged into our database outside of Appian, and the table did not exist. Yesterday, Appian would not create a new table via the verify and publish. We did a reboot, and after that when I added a new entity to a datastore, Appian showed pink and added the new table.
    I am still trying to run impact analysis on the impacted CDTS and continuously receive a server timeout. We just did a reboot so I am hoping to get this answered for you shortly.
Children
No Data