Knowledge Base
PROGRAM: dpQWSync for e-automate - Messages or Errors

Table of Contents
dpEAQuote Activation
Notice
    dpEAQuote Activation
    Trial Version
    Trial Version: You are currently using a trial version of this product.
    Close this wizard to continue with the trial version. Click next to activate you product now.
    Resolution
  1. You can continue to use the trial version of the product
  2. Click red [X] to close
  3. Click Next to activate
Notice
    Application Notice
    This product has expired. Please run the activation wizard.
    Resolution
  1. The 30 day trial has expired. Run the activation wizard.
  2. We highly recommend activating as "Domain Administrator" or "Local Administrator" See KB.
  3.  KB
  4. Click OK to activate
Notice
    AdpEAQuote Activation
  1. Click Next to activate
Notice
    AdpEAQuote Activation
  1. Enter serial number or click Paste Serial
  2. Click Next
Notice
    AdpEAQuote Activation
  1. Enter serial number or click Paste Serial
  2. Click Next
dpEAQuote Activation Error
Notice
    Application Notice
    Unable to activate
    The following error has occurred: Value to add was out of range.
    Parameter name: value. Resolution 1
  1. QuoteWerks Node install should be made with current version
EAQuote Push Menu
Tools Push Menu
    QuoteWerks
    Push to eautomate
    After executing "Push to eautomate" in QuoteWerks Tool Menu, nothing happens.
    Resolution
    Prior versions of dpQWSync used the "Menuopts.add" file to execute the menu item.
  1. Add "Push To eautomate" to QuoteWerks/Tools/Customize Menus...
[Menu]
Push To e-automate="C:\Program Files (x86)\Hogan Data\dpQWSync - EAQuote\dpQWSyncEAQuote.exe"
Tools Push Menu
    QuoteWerks
  1. QuoteWerks/Tools/Customize Menus...
  2. Customize Menus
  3. Choose Tools Menu
  4. Click on Define Menu Items
Tools Push Menu
    QuoteWerks
  1. QuoteWerks/Tools/Customize Menus...
  2. Customize Menus
  3. Choose New
Tools Push Menu
    QuoteWerks Customize Menus
  1. Caption: Push To eautomate
  2. Action: Run External Application
  3. Command: dpQWSyncEAQuote.exe
  4. Start In: C:\Program Files (x86)\Hogan Data\dpQWSync - EAQuote (path to file "dpQWSyncEAQuote.exe")
  5. Window: Normal
  6. Owner: Administrator
  7. Check Publish to All User Menus
  8. Check Publish to My Menu
  9. Check "Access Rights" you prefer
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click Run command
    If successful the push dialog box will open
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click Run command
    If successful the push dialog box will open
    Application notice
    Because you are in configuration mode and quote has not been created you will recieve an application notice
  2. Click Ok

Tools Push Menu
    QuoteWerks Customize Menus
  1. Click Ok
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click on Close
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Choose Tools Menu
  2. Click on Publish Menu Items
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click on Add
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Choose Push To eautomate
  2. Click on Select
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click on Ok
Tools Push Menu
    QuoteWerks
    Customize Menus
  1. Click on Close
EAQuote Push Quote
Notice
    QuoteWerks
    Error executing command line
    Error executing command line of "[drive]:\Program Files (x86)\Hogan Data\dpQWSync - EAQuote\dpQWSyncEAQuote.exe"
    Error (53) File not found. Resolution
  1. When dpEAQuote is installed it makes an entry into QuoteWerks file [drive]:\QuoteWerks\menuopts.add
    [Menu]
    Push To e-automate="c:\Program Files (x86)\Hogan Data\dpQWSync - EAQuote\dpQWSyncEAQuote.exe"
  2. The path points to the dpQWSync - dpQWSyncEAQuote.exe file to execute the push.
  3. Correct the path and file name is needed.
Notice
    Application Notice
    Unable to attach
    Unable to attach to Quotewerks. Application will now close.
    Resolution 1
  1. dpQWSyncEAQuote.exe is a mix match with QuoteWerks version
    1. Version 1.1.5239.32072 = QuoteWerks 4.0
    2. Version 1.1.5529.39567 = QuoteWerks 5.0
    Resolution 2
  2. Run QuoteWerks Node install and retry dpEAQuote
Notice
    Resolution 3
  1. Run a test using QuoteWerks Medic 5.0 Utility
Notice
  1. Click menu Utilities
  2. Choose Data Manager for QuoteWerks Databases...
Notice
  1. If you get an error message simular to the one on the right
  2. It is a known issue with QuoteWerks 5.0 Build 2
  3. Run QuoteWerks Node install and retry dpEAQuote
Notice
    Application Notice
    Unable to connect to server...
    Unable to connect to server, please check connectivity and try again. Reason: Conversion failed when converting the nvarchar value "somevalue" to data type int.
    Resolution
Notice
    Application Notice
    Could not retrieve current quote information
    Unable to acquire contact information from e-automate:. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    Resolution
  1. Ensure you are using the correct SQL instance name
  2. Ensure SQL Server service is running
  3. Ensure SQL Server Browser service is running
  4. Ensure TCP/IP and Named Pipes protocols are enabled
  5. Ensure the "Allow remote connections to this server" is checked in SQL Server Properties
  6. Configure the Windows Firewall for the SQL Server port and SQL Browser service
EAQuote Product Push
Notice
    Application notice
    Cannot push to e-automate. The following item did not originate from e-automate.
    Item description
    Action
  1. Create quote from QuoteWerks to e-automate with item not in e-automate
  2. Reason
  3. Creating new items in e-automate are not allowed
  4. Resolution
  5. Launch: EAQuote Configuration
  6. dpQWSync - EAQuote - Push Configuration
  7. Inventory Options
  8. Check Enable Adding Inventory Items to e-automate
Notice
    Application notice
    Cannot push to e-automate. The following item did not originate from e-automate.
    Item description. Cannot be added: Mapping was not found for Allen Parts
    IAction
  1. Create quote from QuoteWerks to e-automate with item not in e-automate
  2. Reason
  3. Vendor "Allen Parts" has not been mapped
  4. Resolution
  5. Launch: QWSync Configuration
  6. Configure Mapping
  7. Map new items "KB"
  8. dpQWSync - Server Installation
Notice
    Application notice
    The following error has occurred: Cannot insert the value NULL into column 'CategoryID', table 'CoEA87.dbo.ICItems'; column does not allow nulls.
    INSERT fails
    The statement has been terminated
    Action
  1. Create quote from QuoteWerks to e-automate with item not in e-automate
  2. Reasons
  3. Category does not exist in e-automate
  4. Category in mapping is incorrect
  5. Resolution 1
  6. Validate Category in e-automate
  7. Add Category in e-automate
  8. Resolution 2
  9. Launch: QWSync Configuration
  10. Configure Mapping
  11. Validate category "KB"

Notice
    Application notice
    Could not retrieve current quote information.
    Unable to cast COM object of type 'QuoteWerks.DocFunctionsClass' to interface type 'QuoteWerks._DocFufnctions'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8560F69D-0789-449B-81A-B3A96BA1C8FE}' failded due to the following error: Not such interface supported (Exception from HRESULT; 0x800004002 (E_NOINTERFACE)).
    Action
  1. Launching e-automate push from QuoteWerks
  2. Resolution
  3. Install current QuoteWerks node on current machine.
Error
    DataPlus 4.0 Error
    The following error has occurred:
    Procedure or function 'spEA_Web_CreateQuote' expects parameter '@PurchasingNotes' which was not supplied.
    Resolution
  1. There is probably a mismatch with used installers. Install QW Sync and EA database in newest installer
dpEAQuote Sync Results
Results
    dpEAQuote Sync Results
    Contacts not available
    Resolution 1
  1. Insure that Sync EA Contacts is Checked in QW\EA Sync Configuration
  2. Resolution 2
  3. dpQWSync is not capatible with current version of QuoteWerks being used
  4. Your yearly subscription of dpQWSync has expired
    Items not available
    Resolution 1
  1. dpQWSync is not capatible with current version of QuoteWerks being used
  2. Your yearly subscription of dpQWSync has expired
After sync the following data should be displayed in log file.
File: QWS_*.log
Notice: Synchronization Started
Notice: Processing Categories
Notice: Processing Vendors
Notice: Processing Contacts (if selected}
Notice: Synchronization Completed
Related FAQs
   
Software Solutions
DataPlus Integration
DataPlus ERP Integration
DataPlus Custom Integration
DataPlus Addons
DataPlus Plugins & Tools
Hosting Solutions
Mobile Solutions
QuoteWerks Quoting Solutions
QuoteWerks Integration
QuoteWerks Subscription & Licensing
Act! CRM Solutions
CRM
CRM & Marketing Automation
Marketing Automation
Pricing
Mobile Solutions
Helpful Links
Act! Hosting Solutions
Act! Mobile Messenger
Act! ERP Integration
Act! Custom Integration
Act! Addons
Act! Plugins & Tools
Act! Training
Act! Resources
Act! Support
Act! Community
Act! Downloads & Updates
Learning - Support
Software Support
Support (GoToAssist)
Support Plans
Training
Act! Training
KB Hogan Data / DataPlus
KB Act! Questions
KB QuoteWerks Questions
Contact Us
About Us
How Can We Help You
Privacy Policy
Return Policy
Resources
DataPlus Subscription
DataPlus Maintenance
QuoteWerks Maintenance
Partner Lead Submission
Secure CC Authorization
Secure CC Pre-Authorization

Translate this page:
©1995 - 2019 HOGAN DATA | All rights reserved