Question

Easiest way to determine which collection or table has an invalid number of rows?

Forms Version 11 Self-Hosted

Updated May 10, 2024

asked on May 6, 2024

We have a Forms process where a user is receiving the following error when trying to submit a form:

Errors encountered during forms submission:
Field Name: Amount, Position: 78, Error: Invalid number of rows in collection/table. [LFF9313-InvalidNumberOfElementsInCollection] [LFF9312-ErrorOccuredDuringFormsValidation]
[LFF9320-FormsValidationAggregateException]

There are several tables on this form and almost all have a field named Amount. What is the easiest way to determine which table it is referring to?

0 0

Replies

replied on May 6, 2024

It actually means Field 78 as in #q78. What I do is go into the CSS/Java tab where it shows you all of the numbering in the right pane and look for it there. If you have fields with hidden fields/sections, sometimes you have to complete parts of the form to have fields show. If this doesn’t work, export the form and check the xml.

0 0

replied on May 6, 2024

The position and the field id are not the same. The field that has an id of 78 is not in a table and it's not a field named Amount.

0 0

replied on May 7, 2024 • Show version history

I have discovered the field that is being referenced in the error message by going to the dbo.cf_fields table in the database and searching by position and label.

The field in question is in a table and is the last field in the table row, but I don't see what is causing the error. The error is about an "Invalid number of rows in collection/table." There is only 1 row and it is populated by Workflow. The table is setup as follows:

We are using these same settings on other tables with no issues. Has anyone come across this before?

0 0

replied on May 8, 2024

Hi Blake,

One possible way is to check number of sets in a collection in cf_bp_data table from database.

To check the number of sets:

You can use specific submission ID to check how many rows was submitted during that submission:

SELECT * FROM [cf_bp_data]
WHERE submission_id = {submissionID}

You can also query by attribute_id to check all past histories of that collection/table

SELECT * FROM [cf_bp_data]
WHERE attribute_id = {attributeID }

check the value column, the first number represents how many rows/sets that table/collection have./

Hope that helps.

0 0

replied on May 10, 2024

I ran into the same error message as well on a form. I did check the number of rows in the cf_bp_data table and it matched what was shown on the form and in the collected variables. My table is also an append and the data pulls from a lookup rule. The fields are read only so data cannot be changed. I have 3 other tables that work the exact same way and they are not kicking back errors.

1 0

You are not allowed to follow up in this post.

Question

Question

Easiest way to determine which collection or table has an invalid number of rows?

Replies

Sign in to reply to this post.