407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6738)

Installation - "No value given for required parameter" when saving

This information applies to :

Article ID
6738

Created/Updated
March 15, 2022

Category
Updates


Are you using the most current release of QuoteWerks?
Version 23.0 Build 1
Issue:

When user attempts to save a quote, they receive:

SQL Execute Error
QuoteWerks trapped error No value given for one or more required parameters(-2147217904)

followed by a lengthy SQL statement.

Cause:

An installation or upgrade did not properly complete.

Solution:

Version 4.0:

With QuoteWerks closed, browse to the main QuoteWerks folder look for the file site.ini. Launch it and look for the line referencing the Build number (example: Build=44.06). It should be near the beginning.

Delete the listed number and replace it with 1 (example: Build=1). Save the site.ini file and close out. Relaunch QuoteWerks and click Ok on every error that pops up before your login screen displays (they're expected). Go ahead and login, then test the save again. It should work now.

Version 4.5 and above:

With QuoteWerks closed, browse to the main QuoteWerks folder look for the file site.ini. Launch it and look for the line referencing the Build number (example: Build=44.06). It should be near the beginning.

Delete the listed number and replace it with 1 (example: Build=1). Then, look for a line referencing Version=4.5 and delete it. It will be before the section header [Contact Managers]. Once both of those steps are completed, save the site.ini file and close out. Relaunch QuoteWerks and click Ok on every error that pops up before your login screen displays (they're expected). Go ahead and login, then test the save again. It should work now.

Versions post 5.6 build 4:

In some cases the conversion never changed the SoldToCMAccountNo to be the SoldToCMContactRecID, also check ShipToCMAccountNo as it should be ShipToCMContactRecID and also BillToCMAccountNo to be BillToCMContactRecID

You will have to open the database and manually change this a reconversion will not fix this.

MS Access: Docs.mdb - DocumentHeaders table
MS SQL: QuoteWerks database DocumentHeaders table

Simply rename the fields and save the changes and it will be fine.

In some cases fields were not even created we had to manually create the fields in the table:

MS Access: Docs.mdb - DocumentHeaders table

Fields - All Data Types Short Text:
BillToCMCompanyRecID
ShipToCMCompanyRecID
BillToCMSecondaryContactRecID
ShipToCMSecondaryContactRecID

MS SQL: QuoteWerks database - DocumentHeaders table

Same Fields but Data Types are nvarchar(50) allow nulls checked.

New Search