Error Codes

U_SALTBOX_MESSAGES is not an EntitySet

This error response occurs when Service Layer is unable to communicate with the Saltbox Query Extension installed in Hana Studio. When this error occurs, restart Service Layer.

This error is typically seen in workflow triggers, and may be visible when using the Test Connection option with Test Hana Extension enabled.

When troubleshooting:

• Test Hana Extension in Saltbox. Go to Project Settings and open the connection’s configuration.

  At the bottom of the configuration, enable “Test Hana Extension” and provide the following settings:

  • Query Category = “B1WebAPI_saltbox”

  • Query Name = “GetWorkFlowMessages”

  • Add two parameters to simulate fetching a list of newly added sales orders. This will not run any workflows but will respond (or fail to respond) as if that were the action.

    • Parameter 1 Name = b1TransactionType

    • Parameter 1 Value = Added

    • Parameter 2 Name = B1ObjectType

    • Parameter 2 Value = 17

  • Press the “Test” button and verify a valid result. If the same error above is encountered, or if a message similar to below is encountered, restart Service Layer.

• If the above results are fine, Access Saltbox Query Extension on the server and run the query manually.

  In a web browser with access to Saltbox Query Extension, load the query - for example: http://10.0.0.0:8000/Saltbox_Query_Extension/MY_COMPANY/B1WebAPI_saltbox/GetWorkFlowMessages?b1TransactionType=Added&B1ObjectType=17

  If the results are as outlined below, restart Service Layer.

  {
    "OriginalQueryString":"Select \"Code\", \"U_B1ObjectKey\" From \"@SALTBOX_MESSAGES\"\r where \"U_B1TransactionType\" = \r CASE [%b1TransactionType]\r WHEN 'Updated' THEN 'U'\r WHEN 'Added' THEN 'A'\r else \"U_B1TransactionType\"\r end \r and \"U_B1ObjectType\" = [%B1ObjectType] and \"U_MessageState\" = 'New'",
    "ErrorMessage":"Error with the 2nd query (update statement). InternalError: dberror($.hdb.Connection.executeUpdate): 585 - SQL error, server error code: 585. The statement is not supported by the function"
  }