Knowledge Base
PROGRAM: DataPlus for Sage 100 - Messages or Errors

Table of Contents
DataPlus Installation
Notice
    Unable to insert update database. Reason given: Unable to create or establish connection to linked server. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    Reason 1
  1. Allow External Access was not configured.
  2. Resolution
  3. Open Company Maintenance in Sage 100
  4. Preferences
  5. Check Allow External Access
  6. Reason 2
  7. ODBC Basic/Database Directory: Incorrect path to PROVIDEX.DDF
  8. Resolution
  9. C:\Sage\Sage 100 Standard ERP\MAS90
  10. C:\Sage\Sage 100 Advanced\MAS90
  11. Check Allow External Access
Notice
    Unable to insert update database. Reason given: Unable to create or establish connection to linked server. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    Resolution
  1. Sage company code, user name and or password was entered in incorrect or has been changed and not updated.
Configure Data Source
  1. Open ODBC 64 bit application
  2. Click on System DSN tab
Configure Data Source
  1. Click on Source Name [S100_ABC]
  2. Click on Configure
Configure Data Source
  1. Click on Login Tab
  2. Modify Company code: sagecompanycode
  3. Modify Default UserID: sageuserid
  4. Modify Password: sagepassword
  5. Click on Debug Tab
Configure Data Source
  1. Click on Apply
  2. Click on Test Connection
  3. If successful click on OK
Configure Data Source
    SQL Instance Restart
  1. Restart SQL instance
Notice
    Unable to insert update database.
    Reason given: Unable to create or establish connection to linked server. Timeout expired. The timeout period elapsed prior to comopletion of the operation or the server is not responding.
  1. Click on OK
Notice
    Continue Installation
  1. Click on Next
Notice

    Unable to insert update database.
    Reason given: Invalid column name 'TaxAmt'.
    Reason 1
  1. Business Insights Module not Active
  2. Resolution
  3. Open Sage 100
  4. Modules / Library Master / Company Maintenance
  5. Choose Company Code
  6. Activate
  7. Business Insights
  8. Reason 2
  9. Sage 100 Database has not been converted
  10. Resolution
  11. Open Sage 100
  12. Modules / Library Master / Company Maintenance
  13. Choose Company Code
  14. Convert
  15. WARNING! Data entry files may be cleared. Back up your data before converting.
    The data will be converted to the newest version installed.
  16. Accept
  17. Close
  18. Continue DataPlus Installer
  19. Previous/Next
Notice
    Unable to insert update database.
    Reason given: Cannot open the table "IT_Category" from OLE DB provider "MSDASQL" for linked server
    NOTE: If this is your first install, you must set default view permissions and re-load DataPlus.
    Resolution
  1. Activate Business Insights Module and Accept KB Line 163
  2. Enable I/T eBusiness Manager KB Line 163
Notice
    Unable to create database objects.
    Reason given: spMenuConfigCreateNew : Must declare the scalar variable "@TableName".
    Resolution
  1. Under investigation
DataPlus Configuration
Act! Notice
    Action
  1. Server/Client: DataPlus Configuration Manager
  2. Click on Test Connection
  3. DataPlus 4.0 Error
    Unable to get configuration from server.
    The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character amoung the padding characters.
    Resolution
  4. Current user does not have permission to create DataPlus-Connection.xml file
  5. Location
    1. C:\Program Files (x86)\Hogan Data\DataPlus 4.0
    2. C:\Program Files (x86)\ACT\Act for Windows\Plugins\DataPlus 4.0
DataPlus Menus
DataPlus 4.0 Warning
    No DataPlus menus were found. The DataPlus Tab will be disabled.
    NOTE: If this is your first install, you must set default view permissions and re-load DataPlus.
    Resolution
  1. Server Installation KB Line 163
DataPlus Activation
DataPlus 4.0 Error
    The following error has occurred: Product is not activated and trial has expired. All DataPlus features will be disabled. Please run activation and re-enable DataPlus.
    Resolution
  1. DataPlus Activation
DataPlus Push Configuration
Notice
    Sage 100 Configuration Notice
    Sage connection failed. There was no end point listening at http://w764-s100erp:8000/ Sage100Bridge/proxy.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerExcepton, if present, for more details.
    Resolution
  1. Ensure that the service "Hogan Data Sage100 Bridge" is started
  2. Ensure that the service "Hogan Data Sage100 Bridge" has rights to run
Notice
    Sage 100 Configuration Notice
    Sage connection failed. The hostname could not be parsed.
    Resolution
  1. Ensure that the host server name is correct
Notice
    Action
  1. Configure Sage 100 Push
  2. Test Connection
  3. Sage 100 Configuration Notice
    Sage connection failed. Exception has been thrown by the target of an invocation.
    Resolution
  4. Ensure that the service "Hogan Data Sage100 Bridge" has rights to run
    1. Test service using local
    2. Test service using local administrator
    3. Test service using domain administrator

After testing the bridge, "Test Connection" to Sage.
Depending on your network and permissions, the test can pass with in all 3 cases or just 1.
In most cases "Local" should work.
In some cases domain administrator must be used.
Error
    Push to Sage 100 Error
    The following error has occured: Cannot open database "dpS100_MFG" requested by the login. The login failed. Login failed for user 'HOGANDATA\administrator'.
    Resolution
  1. Database dpS100_MFG has not been configured for integration with DataPlus

Note: "dpS100_MFG" is sample data. Your company id will replace "MFG".
Notice
    Sage 100 Configuration Notice
    Sage connection failed. Invalid Sage 100 Company Code
    Resolution 1
  1. Company Code is incorrect - validate code from your Sage 100 application and re-enter
  2. Resolution 2
  3. "Allow External Access" may not be enabled in Sage 100 "Company Maintenance" Preferences.
Error
    Sage 100 Configuration Error
    The follow error has occured: Value cannot be null. Parameter name: source
    Steps
  1. Configure Sage 100 Push
  2. Reason
    Server Settings/Server Name is incorrect
    Resolution
  3. Open Inbound port for SQL on server
Error
    Sage 100 Configuration Error
    The follow error has occured: Value cannot be null. Parameter name: source
    Steps
  1. Configure Sage 100 Push
  2. Save
  3. Reason
  4. User/Domain User - UAC Level 4
  5. User/Domain User - UAC Level 3 (Administrator = 2)
  6. User/Domain User - UAC Level 2 (When Admin = 2 Standard = 3)
  7. User/Domain User - UAC Level 2 (When Admin = 1 Standard = no access)
  8. Resolution
  9. Open Inbound port for SQL on server
Error
    Sage 100 Configuration Error
    The follow error has occured: Value cannot be null. Parameter name: source
    Steps
  1. Configure Sage 100 Push
  2. Reason
    Server Settings/Server Name is incorrect
    Resolution
  3. Open Inbound port for SQL on server
DataPlus Push Contacts
Error
    Push to Sage 100 Error
    The following error has occurred: Something went wrong while populating information for Salesperson No.
    Condition
    When pushing a customer from Act to Sage 100 the dropdown for "Salesperson No:" is empty.
    Resolution
  1. "Customer No" field must be populated first and formatted properly. It's important that the correct division no is used.
  2. "Contact No", if used, may not formatted properly.
  3. "Salesperson No" contact field does not exist in Act
  4. "Salesperson No" must be mapped between Act and Sage 100 (KB)

Notice
    Push to Sage 100 Notice
    Push settings are not configured for this company.
    Resolution
  1. Resoluton pPending
  2. Please contact us if you receive this notice.
Error
    Push to Sage 100 Error
    Failed pushing contact.
    Failed pushing Customer. The request channel timed out while waiting for a reply after 00:00:59.9979999. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.
    Resolution 1
  1. Restart SQL instance in "Services"
  2. Run/services.msc
  3. Resolution 2
  4. Test your linkserver connection
  5. In SSMS "New Query" and execute script EXECUTE SP_TABLES_EX 'S100_ABC' (replace ABC with your company code)
  6. If it fails then this is the reason for the connection timeout
  7. Recreate Linked Server
  8. Resolution 3
  9. Close all instances of Sage 100
  10. Delete all *.LCK files from C:\Sage\Sage 100 Standard ERP\MAS90\LOCK\_ABC (replace ABC with your company code)
  11. When you reopen Sage 100 the files will be recreated.
  12. Resolution 4
  13. Exclude Sage/Mas folder
  14. Exclude file extensions also
  15. Resolution 5
  16. Stop SQL instance in "Services"
  17. Replace the following Providex files in C:\Windows\System32
    1. pvxio.dll
    2. pvxodbc.dll
    3. pvxsec64.dll
  18. Restart SQL instance in "Services"
Error
    Push to Sage 100 Error
    Failed pushing contact.
    Failed pushing Customer. You are not authorized to access this program.
    Resolution
  1. Ensure that all the Sage 100 modules have been converted in "Company Maintenance".
Error
    Push to Sage 100 Error
    Failed pushing contact.
    Failed pushing Customer. Exception has been thrown by the target of an invocation.
    Resolution
  1. Ensure that all the Sage 100 modules have been converted in "Company Maintenance".
Error
    Push to Sage 100 Error
    Failed pushing contact.
    Failed pushing Customer. Cannot proceed as the requested customer does not exist in system. Error #12: File does not exist (oralready exists) File: MPOABC.SOA
    Resolution
  1. Customer No, Contact No, eCustomerID, eContactID fields in Act are populated.
  2. When pushing to Sage 100 these fields indicate Customer exists
  3. If customer does not exist in Sage 100 an error will occur
  4. If you want to push the contact to "create" it in Sage, remove the data in eCustomerID and/or eContactID field in Act
Error
    Push to Sage 100 Error
    Failed pushing contact.
    Failed pushing Customer. Cannot proceed as the requested customer does not exist in system. Module A/L is not on file.
    Resolution
  1. Module A/L is not active in Sage 100
DataPlus Push Transactions
Error
    Push to Sage 100 Error
    The following error has occurred: Failed pushing Sales Order, Error #41: Invalid integer encountered (range error or non-integer) Error #41: Invalid integer encountered (range error or non-interger)
    Resolution
  1. Customer No, Contact No, eCustomerID, eContactID fields in Act are populated.
  2. When pushing to Sage 100 these fields indicate Customer exists
  3. If customer does not exist in Sage 100 an error will occur
  4. If you want to push the contact to "create" it in Sage, remove the data in eCustomerID and/or eContactID field in Act
Error
    Push to Sage 100 Error
    The following error has occurred: Failed pushing Sales Order. There was no endpoint listening at http://w74-s100erp:8000/ Sage100Bridge/ proxy.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException...
    Resolution
  1. Hogan Data S100 ERP Bridge may not started
  2. Start or restart the service and try again
Error
    Push to Sage 100 Error
    The following error has occurred: Failed pushing Sales Order. Error saving information for sagefield "ItemCodeDesc"
    Resolution
  1. Item Type is not allowed to push to Sage transaction
Error
    Push to Sage 100 Error
    The following error has occurred: Failed pushing Sales Order. Exception has been thrown by the target of an invocation.
    Reason
  1. Transaction permission fails due to proper permissions using the "Hogan Data S100 ERP Bridge"
  2. Resolution
  3. Change service permission to local or domain administrator account
Sage ODBC
ProvideX ODBC
    Options
    Time out message
    Resolution 1
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\v2019\MAS90\Home\
  3. Check Dirty Read:
  4. Check Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. UnCheck Enforce DOUBLE:
  8. UnCheck NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:4
ProvideX ODBC
    Options
    Time out message
    Resolution 2
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\v2019\MAS90\Home\
  3. UnCheck Dirty Read:
  4. UnCheck Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. Check Enforce DOUBLE:
  8. Check NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:40
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
Hogan Data eStore
Act! CRM Solutions
CRM
CRM & Marketing Automation
Marketing Automation
Compare
Pricing
Try Growth Suite Starter
Try Growth Suite
Mobile Solutions
Helpful Links
ACTeStore.com
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
Contact Us
Privacy Policy
Return Policy
Resources
DataPlus Subscription
DataPlus Maintenance
QuoteWerks Maintenance
DataPlus cloud
Client Portal
Partner Portal
Partner Lead Submission
Secure CC Authorization
Secure CC Pre-Authorization

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