407-248-1481
QuoteWerks Knowledgebase Topic (Article ID 6738)
Installation - "No value given for required parameter" when savingThis information applies to : |
Article ID 6738 Created/Updated April 3, 2023 Category Updates
|
|
| 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 Note that you may need to manually type in the value if Access gives you an error about the value of the field not being accurate. 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. |
||
|
|
©1993-2024 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)
Please Wait...