Hello, This might be a simple fix however, I've been unable to resolve the error "An error occurred in executing an Activity Class." while attempting to load an excel file into a database.
I've mapped the datastore to a constant and mapped the CDT to a constant.
I've successfully loaded a document to a documents folder however, I've been unable to load the document into a CDT or a Database (Yes the CDT matches the columns in my Document). Everytime I use the 'Write to data store entity' or 'Import Excel to Database' It throws the same error as shown below. unfortunately, I'm new to Appian and this error is not very descriptive.
Any help is appreciated. Thanks!
Discussion posts and replies are publicly visible
You will need to access the application server logs where you will hopefully find a more verbose output of the error
Thanks Tim! the logs show the following Error:
Appian.[Data Store Entity:"839d3950-9614-4af1-b9a3-6ea89074845b@13966"]' doesn't exist=???Table 'Appian.[Data Store Entity:"839d3950-9614-4af1-b9a3-6ea89074845b@13966"]' doesn't exist???]I've gone back to the model and tried variations of the datastore with and without quotes and assigning it to a constant "jdbc/Appian". No luck so far.
In general I'd suggest not trying to reference the entity using a string in the Write to Data Store Entity node. The best way to do this is to create a constant object and point it to your data store entity. Then, reference the constant as an expression inside of your write to data store entity node.
This will ensure that it always points to a valid data store entity.
Thanks everyone for the feedback! It ended up being an issue with the table name. apparently my CDT had underscores so when the actual database table was created it re-named it without underscores.