Page Comparison

...

All DBC SQL operations are performed within a database transaction. The When the following SQL errors cause to generate occur, flags the submission with an error and generates Doc Action Failure emails to the tenant or /flow admin users and tag the submission (s) :

• An update statement updates ) rows and autocreate is false
• A query with autocreate=true is missing a create statement
• A query when autodelete is true and is missing the delete statement
• A query with the Delete statement and the delete Key is not defined
• A delete statement where the specified delete key cannot be found in the retrieved resultset
• If any one of the SQL operations (except Update) fails - For
  •  For example: When calling a querySet with 1 or more autocreate or autodelete=true, internally the DBC is likely to execute multiple SQL statements:
    • It will try to delete all rows that were deleted from the form
    resultset
    • resultSet that were originally in the
    resultset
    • resultSet retrieved from the database.
    • It will try to update rows from the form
    resultset
    • resultSet - and if autocreate is true and the update fails, it will execute an insert for each update failure. 
• Browsing the URL to generate the schema for querysets

Updates do not trigger errors due to several valid use cases for update failures ex: autocreate=true

tenant

Image Removed

 Image Added

Log entries for the error are captured in the database-connector.YYYY-MM-DD.log

2017-10-26 13:46:05.828 ERROR mycompany 93f95ebc-6a85-4426-a015-eb34a1c96042 17048 --- [http-nio-8082-exec-8] c.f.connectors.database.QueryResource    : Create operation not defined for query BIRT/createOrder
2017-10-26 13:46:05.829  INFO mycompany 93f95ebc-6a85-4426-a015-eb34a1c96042 17048 --- [http-nio-8082-exec-8] org.restlet.Component (2011499821)       : 2017-10-26    13:46:05    127.0.0.1    -    127.0.0.1    8082    POST    /database/BIRT/createOrder    -    404    328    535    6    http://localhost:8082    Jakarta Commons-HttpClient/3.1    -

Live Forms tomcat running on non-default port

...