Local Install of Appian 16.1 (connected to Oracle XP) I have created a reco

ChristineH

Certified Lead Developer

over 8 years ago

Local Install of Appian 16.1 (connected to Oracle XP)
I have created a record (in grid layout) and have configured a facet based on lookup data. Anytime I click on a facet option or search in the search box, I get the attached error on the screen and the below in the app server log. Any ideas?
FYI - If I remove the filter, I get a diff pink error (error while retrieving APNX-1-4205-003), but same error in log.

2016-03-08 16:46:11,498 [http-/0.0.0.0:8080-5] ERROR org.hibernate.transaction.JDBCTransaction - JDBC commit failed
java.sql.SQLException: Commit can not be set while enrolled in a transaction
          at org.apache.commons.dbcp2.managed.ManagedConnection.commit(ManagedConnection.java:232)
          at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:166)
          at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)
          at com.appiancorp.type.external.teneoimpl.TeneoDataStore....

Discussion posts and replies are publicly visible

0 ChristineH
Certified Lead Developer
over 8 years ago

...commitTransaction(TeneoDataStore.java:259)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eliot Gerson
Appian Employee
over 8 years ago

Is the data source configured through the admin console? What hotfix are you on?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristineH
Certified Lead Developer
over 8 years ago

Yes - through admin console. Hotfix A.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Former Member over 8 years ago

In addition to Eliot's question, the second APNX error code in the pink box (APNX-1-4205-021) refers to a User Filter (prevously known as 'facets') not evaluating. You mentioned you tested removing those User Filters but you get a new APNX code relating to retrieval of data for the record type.

If you edit the record type from Grid to News style, then save it and retry, do you get the same or different behavior?

If that provided different behavior, then swap the record type back to Grid style, and save it. Do you get the new behavior or the old one?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristineH
Certified Lead Developer
over 8 years ago

I will have to create an interface to load as feed, as it doesn't convert (in fact, it messed up what I had).....
Something to note, facets and searches on records for apps built for 7.11 and imported into this install aren't working either.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eliot Gerson
Appian Employee
over 8 years ago

I will follow up with you separately.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristineH
Certified Lead Developer
over 8 years ago

here is the app server log
appserverlog.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Thenmozhi Mohanakrishnan
Certified Senior Developer
over 8 years ago

Am facing a similar issue. When trying to execute a query rule from SAIL form, I get this error - Error evaluating function 'queryruleexec' : JDBC commit failed

Is there is any solution for this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eliot Gerson
Appian Employee
over 8 years ago

Are you also on 16.1 Hotfix A? Are you also seeing the message "Commit can not be set while enrolled in a transaction"?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ramakg
A Score Level 1
over 8 years ago

Hi, we have moved application from 7.3 to 16.1 and when I try to execute query rule getting the same error message like below.

Error evaluating function 'queryruleexec' : JDBC commit failed

Any suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel