Audience: External | ZoneReconcile Admins
Identify common ZoneReconcile processing script errors, understand what causes them, and know what to try before contacting support. Use this guide to resolve issues faster and submit complete support tickets.
Processing script errors in ZoneReconcile, particularly during the map/reduce and summarize phases, often relate to data volume, system timeouts, or state management.
Common errors and meanings
| Error | Meaning |
|---|---|
Invalid or Unsupported Search |
Occurs when the SQL query that calculates the NetSuite bank balance fails in newer versions, especially for accounts with a large number of booked transactions. ZoneReconcile then falls back to a saved search. |
Negative Bill Payment is not allowed |
Occurs when processing a vendor credit that creates a journal linked to the vendor credit through a dummy bill payment (total amount of 0.00, not visible in the books). The created journal must already have an Approved status. Otherwise, the system returns this error. |
NO_DEPLOYMENTS_AVAILABLE |
Occurs when a map/reduce script called by another script is still running. Wait a while and retry, which usually resolves the error. |
Payment amount (x) does not correspond to the Bank Statement Transaction Line amount (x) |
Occurs when a statement is processed twice (a user submits the same statement twice) or when 1 transaction is selected on 2 lines. The system creates a payment for the first line and fails to create one for the second line. |
Please enter value(s) for: {field name} |
Occurs when NetSuite expects a value for a mandatory field. |
Record has been changed |
Occurs when 2 scripts amend the same record. Common causes include double processing of a statement and additional user event scripts running on the transactions that ZoneReconcile creates. |
SSS_TIME_LIMIT_EXCEEDED |
Occurs during statement matching, usually when the system works with a large amount of data. Review the Search optimization step under Retry steps. |
SSS_USAGE_LIMIT_EXCEEDED |
Occurs when a map/reduce script exceeds its governance limit. Map/reduce scripts should not trigger this error by design, so submit a support ticket if it occurs. |
UNEXPECTED_ERROR |
A general error. Submit an additional support ticket to NetSuite to get specific context on the nature of the error. |
Value length is over 10MB |
A system-wide error that occurs when the data passed between the map and reduce phases exceeds the 10MB limit. Processing is incomplete because some results are lost. |
Retry steps
-
Manual: For bank statements that remain in the TO PROCESS status after a processing map/reduce failure, click Edit on the record to process the statement manually.
- Alternative triggering: If an error is specific to 1 trigger method (for example, automatic import of transactions), import the same file manually to confirm whether the issue persists.
- Search optimization: For timeout issues during matching, optimize the BS TR O P C and BC TR C AC saved searches. For more information, see Configuring and Understanding Matching Preferences in ZoneReconcile.
Information to collect before escalating
When you escalate these errors to the support team, include the following details on the ticket:
-
Script details: Provide the name or ID of the script that returns the error, if available. Common scripts include
ZR Auto Import MR,ZR Auto Import BSTP MR,ZR Auto Import Bank Statements MR, andZR Process Bank Statement Transaction MR. - Frequency: State how often the error occurs.
- Trigger method: Describe the exact steps to reproduce the error.
- Environment details: Provide the account ID, the bundle version, and whether the issue occurs in Sandbox or Production.
- Data volume: Provide the number of lines in the bank statement or the number of records processing at the time of failure.
- Affected users: Identify the role in which the error occurred and whether the error is reproducible.