The data store "HPI DataStore" [id=105030] was saved but cannot be published: An error occurred while trying to modify the data source schema: Error accessing tables metadata (APNX-1-4178-000)

Question

Hi EveryOne, 
 when I'm Publish the Data Store Entity I am getting the following error: can you please help with this.

Thanks...

Mathieu Drouin · Accepted Answer

Yes. So definitely an issue with permissions on the at the DB level.

Abhishek Karumuru · Answer

Hi G. Harsha Vardhan Reddy The error mentions an issue with accessing table metadata. Confirm that the user account used by Appian to connect to the database has the necessary permissions to retrieve metadata information. Ensure that the user account is not locked or expired.

Jesse Knight · Answer

We encountered this error last Fall in our dev environment, but were able to work around it until today. We thought it had something to do with our MySQL 5.8 upgrade (internal RDS) and the change to utf8mb4 defaults. Yet it was something different from that, and the timing was coincidental. The stdout log didn't show an error when I clicked 'verify'. However, I accidentally discovered that clicking "Download DDL Script", generates the actual permissions error in our stdout log file. In our case, it was related to a sandbox / experimental view that was created with improper SQL SECURITY definitions on an unrelated data store. After we fixed that error with that view in the database, our data stores verify ok.

The data store "HPI DataStore" [id=105030] was saved but cannot be published: An error occurred while trying to modify the data source schema: Error accessing tables metadata (APNX-1-4178-000)

Top Replies