407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6072)

Error - Error in GetDynTextFld or No value given for one or more required parameters; running a reconversion

This information applies to :

Article ID
6072

Created/Updated
November 14, 2017

Category
Database


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
User receive's the error when launching QuoteWerks or working within QuoteWerks:

Error in GetDynTextFld = 'field_name'
Item cannot be found in the collection corresponding to the requested name or ordinal.

...OR, as seen in some post v5.2 builds of QuoteWerks...

SQL Execute Error in SQLConnExecuteEx()
QuoteWerks trapped Error (0) No value given for one or more required parameters.


Cause:
Typically this occurs when a requested field does not exist in one or more databases. This can occur if a database is copied from one build and moved to an installation of a different build (such as the security database when creating a remote or when a product database is shared between installations). It can also occur when a database has become severely corrupted.


Solution:

Please check your version of QuoteWerks before proceeding.

First, attempt to run the reconversion. Browse to the main QuoteWerks folder (with QuoteWerks closed) and look for the siteboot.ini file (pre-v5.2 it is the site.ini). Open it up, and look for the reference to the build #. Change whatever number is listed to the number 1.

Example:

Build=8.25

should change to

Build=1


NOTE: in previous versions it was OK to edit the VERSION=. This is NOT possible post-v5.2. If your system is post v5.2 of QuoteWerks, DO NOT edit the VERSION= line of the siteboot.ini, or you could damage the system. Versions prior to v5.2 (e.g. v5.1, v4.8, etc.) it is OK to edit the VERSION= line, if not wipe it out completely. Some times in these prior versions, this is necessary, but never in post-v5.2.


Save the siteboot.ini (pre-v5.2 it is the site.ini) and close out of it. Launch QuoteWerks. There will be a series of errors, but they are all expected. These errors are occurring because QuoteWerks is trying to add fields to the database and finding that some of them are already there; once the errors clear, user should be able to login without issue.

If this does not work, you may need to restore the database from a working backup. Since the error does not usually identify the database at the root of the problem, you may need to contact technical support with the error to determine which database may need restored.

New Search