FAQ ID # 83
Last Update : 2019/03/01
Print this FAQ

Question / Issue
dpQWSync for e-automate - Messages

Answer / Solution
PROGRAM: dpQWSync EAQuote for e-automate - Messages
Table of Contents


    dpQWSync dpEAQuote Activation
      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
      Application Notice
      This product has expired. Please run the activation wizard.

      Resolution

    1. The 30 day trial has expired. Run the activation wizard.

      We highly recommend activating as "Domain Administrator" or "Local Administrator" See KB.

    2. KB - Line 26
    3. Click OK to activate
      AdpEAQuote Activation
    1. Click Next to activate
      AdpEAQuote Activation
    1. Enter serial number or click Paste Serial
    2. Click Next
      AdpEAQuote Activation
    1. Enter serial number or click Paste Serial
    2. Click Next


    dpEAQuote Activation Error
      Application Notice
      Unable to activate
      The following error has occurred: Value to add was out of range.
      Parameter name: value.

      Resolution 1:

    1. Currently under investigation


    dpQWSync Server Database Installer
      Notice
      Unable to attach
      Unable to insert settings into database. Reason given:
      Invalid column name 'ReusebleCoreID'.
      Invalid column name 'ReturnableItemID'.

      Resolution 1:

    1. e-automate has been upgraded to version 8.7 and the columns are no longer valid. Upgrade your version of dpQWSync.


    EAQuote Push - Create e-automate Quote
      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.
      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
      - Version 1.1.5239.32072 = QuoteWerks 4.0
      - Version 1.1.5529.39567 = QuoteWerks 5.0

      Resolution 2:

    2. Run QuoteWerks Node install and retry dpEAQuote

      Resolution 3:

    1. Run a test using QuoteWerks Medic 5.0 Utility
    1. Click menu Utilities
    2. Choose Data Manager for QuoteWerks Databases...
    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
      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

      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


    dpEAQuote e-automomate Push
      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

      Reason

    2. Creating new items in e-automate are not allowed

      Resolution

    3. Launch: EAQuote Configuration
    4. dpQWSync - EAQuote - Push Configuration
    5. Inventory Options
    6. Check Enable Adding Inventory Items to e-automate
      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

      Action

    1. Create quote from QuoteWerks to e-automate with item not in e-automate

      Reason

    2. Vendor "Allen Parts" has not been mapped

      Resolution

    3. Launch: QWSync Configuration
    4. Configure Mapping
    5. Map new items "KB"
    6. dpQWSync - Server Installation
      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

      Reasons

    2. Category does not exist in e-automate
    3. Category in mapping is incorrect

      Resolution 1

    4. Validate Category in e-automate
    5. Add Category in e-automate

      Resolution 2

    6. Launch: QWSync Configuration
    7. Configure Mapping
    8. Validate category "KB"

      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

      Resolution

    2. Install current QuoteWerks node on current machine.

    Related FAQs
    dpQWSync - Server Installation
    dpQWSync EAQuote - Client Installation
    QuoteWerks ReHost Database.

    Direct Link to This FAQ
    http://kb.hogandata.com/?f=83

    Back to Top