GL Interface troubleshooting guide
We put together a list of common errors, possible causes, and solutions in a table. You can use the information in the table to troubleshoot before contacting Support.
Where to find error messages?
When a summary run fails, its status will be changed to Error. In the default view, error messages are not displayed. You need to enable the Errors column to display error messages.
In the Summary Runs tab, click the view icon and then select Errors in the list of column names.
The Errors column is now displayed. You can check the error message for each failed summary run.
Common Errors, possible causes, and solutions
Rerun this particular journal run and download the exported file immediately after the rerun completes.
| Error message or symptom | Possible causes | Solutions |
|---|---|---|
|
Error authenticating to Zuora Connect or Zuora -> Error in file upload -> Error Transferring CSV to the SFTP endpoint -> The server did not respond during connection attempts. |
SFTP issue |
Check whether the SFTP server is available. |
|
Error authenticating to Zuora Connect or Zuora -> Error in file upload -> Access Denied |
SFTP issue |
Ensure your credentials to the SFTP server are still valid. |
|
Error authenticating to Zuora Connect or Zuora -> Error creating the inputs to the Journal Run creation API -> undefined method `[]' for nil:NilClass |
Configuration issue |
|
|
Error authenticating to Zuora Connect or Zuora -> Error creating Journal Run -> Revenue Event Item can only be selected when Target Date(s) is an Accounting Period. |
Behavior as designed |
Revenue Event Item can only be selected when Target Date(s) is an Accounting Period. |
|
Error authenticating to Zuora Connect or Zuora -> undefined method `each' for nil:NilClass |
Configuration issue |
|
|
Error authenticating to Zuora Connect or Zuora -> Error in file upload -> Error Transferring CSV to the SFTP endpoint -> Net::SFTP::StatusException open .FILENAME.zip (2, "no such file") |
SFTP issue |
Ensure the SFTP file directory is valid. |
|
Error authenticating to Zuora Connect or Zuora -> Error creating Journal Run Data Source Export -> Export Creation Unsuccessful : Syntax error in ZOQL at position 1:478. Text was: |
ZOQL issue |
|
|
Error authenticating to Zuora Connect or Zuora -> Error Marking Journal Entry as TransferredToAccounting -> Transferred to Accounting can no longer be changed after a Journal Entry has been cancelled. |
Behavior as designed |
|
|
Error authenticating to Zuora Connect or Zuora -> Error in file upload -> Error Transferring CSV to the SFTP endpoint -> Net::SSH::ConnectionTimeout |
SFTP issue. The connection to the SFTP server times out. |
Ensure that you can connect to the SFTP server. |
|
Error authenticating to Zuora Connect or Zuora -> Error querying out preexisting Journal Run -> Cannot find entity by key: 'JR-00000041'. |
Configuration issue |
Ensure the journal run ID is valid. |
|
Error authenticating to Zuora Connect or Zuora -> Error Mapping journal entry items to the endpoint's format -> Liquid syntax error: Unexpected character \ in "JournalEntryItem.Type == \'Debit\'" |
Liquid error |
Ensure the Liquid expressions used in the file mappings are valid. |
|
When clicking the Download link to get the files, the user got the error message: "AccessDeniedRequest has expired". |
Behavior as designed |
Rerun the journal run by ID and download the exported file immediately after the rerun completes. |