Questions? We have answers.

MBER1332 - Encountered single record with more lines than the specified upper limit of 100

Article author
Kate H
  • Updated

Summary

Learn what to do if you encounter single record with more lines than the specified upper limit of 100.


Symptom

An error occurs while trying to import a general ledger.


Resolution

There is an unbalanced quotation character ( " or ' ) on the line specified.

  1. Open your general ledger file and go to the line specified in the error message. In the example below, the line would be row 238.
  2. Search for a double or single quotation mark ( " or ' ). An odd (as opposed to even) number of either of these quotation marks will cause this error; either add a balancing " or ', or remove all " and ' characters.
    • Note that properly formatted CSV files have " characters to escape values that have , (comma) in them, in which case you should not just delete all " characters from the file.
  3. If there are more than a few rows with unbalanced (odd number) quotation marks, notify your client of this issue and ask them for a better formatted file (e.g., in proper CSV format or tab delimited text file).
Encountered single record with more lines than the specified upper limit of
100 (row 238). Context: RT Lower hinge w/148"
wheelbase (14),1334905,2019-12-10,2020-01-01,318.75,2019-12-10 08:52:48.65000

Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Related Articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.