Troubleshooting the Data Integration Module (DIM)

Troubleshooting the Data Integration Module (DIM)

Troubleshooting Installation Issues

User Account Privileges

If you encounter any Permission related issues when installing the Data Integration Module, you will need to check and make sure that you have Administrator rights so that the Program AND Service can be installed for use on the PC. If you do not have Administrator Rights for this PC, it is recommended that you speak with your Company IT Administrator to obtain these permissions.

.NET Framework Compatibility

As indicated in the Setup Walkthrough section, .NET Framework 2.0 or newer is required for the Data integration Module to be setup on your PC.

It has been confirmed that .NET 4.5 does work correctly with the Data Integration Module, but if you need to work in a newer version, please contact F2BSupport@field2base.com to see if there are any Compatibility issues.

Tablet PC SDK Requirement for the Project Manager

If you are using a PC that is not running a Windows Vista or Windows 7 Operating System, make sure that you have the Tablet PC SDK installed. Otherwise, you will receive errors when trying to open Forms in the Project Manager utility.



Troubleshooting Connectivity Issues

Network Issue

If you are getting any type of Web Exceptions when running the Data Integration Module Service, the first step is to always confirm that you can connect to the Field2Base Server’s download service.

You can do this by opening up your Internet Browser and going to the Web Administration Portal for your Company since it requires the same server and port to access and download Form Data.

If you cannot access the F2B Web Admin portal, it is recommended that you confirm you have a working Internet connection by browsing to another public site like www.field2base.com.

If browsing other web sites does work, proceed to the next issue in this section to see if the cause of the issue can be identified.


Firewall Issue

If you see a message like the one shown below, it means that the Data Integration Module Service cannot reach the Field2Base server because there is most likely a Firewall block in place on the computer’s network on Port 2001.

  1. 08/27 10:20:12.19 AM (tid: 2212) Error: WebException caught while calling ListRecentSentForms EXCEPTION : Unable to connect to the remote server ; (InnerException = No connection could be made because the target machine actively refused it 216.27.21.2:2001 ;  ) STACK : at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Field2Base.Transformer.Services.GetRfi.ListRecentSentForms(Int32 pLoginCompanyId, String pUsername, String pPassword, Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId) at Field2Base.Transformer.Plugins.RfiWebServiceClient.ListRecentSentForms(Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, ILogWriter pLog)
At this point, you will need to speak with your Company’s Internet Administrator and request that the Port 2001 for the Field2Base Server IP be opened.
The Field2Base Server IP Addresses are as follows:
  1. Customers: 216.27.21.2
  2. Resellers/Demo: 64.204.27.44

Local Account Issue

If you see a message like the one shown below, it means that the Data Integration Module Service cannot reach the Field2Base server because the server address, salesdemo.field2base.com for Resellers/Demo or fieldconnect.field2base.com for Customers, could not be resolved.

This usually indicates the local account the Data Integration Module Service is using does not have access to the external Internet.
  1. 09/11 12:16:15.13 PM (tid: 1892) Error : Unhandled exception calling ListRecentSentForms. Caught WebException: The remote name could not be resolved: 'fieldconnect.field2base.com' EXCEPTION : The remote name could not be resolved: 'fieldconnect.field2base.com' ; STACK : at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Field2Base.Transformer.Services.GetRfi.ListRecentSentForms(Int32 pLoginCompanyId, String pUsername, String pPassword, Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId) at Field2Base.Transformer.Plugins.RfiWebServiceClient.ListRecentSentForms(Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, ILogWriter pLog)
To confirm that this is the issue, it is recommended that you open the Data Integration Module Service in a Command window using Console Mode. This will create a new set of logs to review.

You can run the Data Integration Module Service in Console Mode by doing the following:

  1. Open the Data Integration Module Administrator
  2. Go to the Service Manager
  3. Click Stop
  4. Confirm the Service Status is stopped
  5. Go to the Start Menu
  6. Select Run
  7. Type in “cmd”
  8. Press Enter
  9. Type in the following:  ”C:\Program Files\F2B Data Integration Module\F2BDataIntegrationService.exe” –cl
  10. Press Enter
  11. You will now see a Command window with the message: “Running F2BDataIntegationService in Console Mode. Press enter to stop”
  12. Let the Service run for about a minute
  13. Press Enter to Stop the Service

If you are running the service in the Command window and still seeing the same issues, it is recommended that you contact F2BSupport@field2base.com and have your Log files ready for review.

If the service is now running correctly with no Exceptions, you will need to update the F2B Data Integration Module Service with an account with Internet Access in the Windows Service Control Manager.

To update the service in this fashion, please do the following:
  1. Go to the Start Menu
  2. Open the Control Panel
  3. Switch to Classic View of the Control Panel (if not already in that view)
  4. Open Administrative Tools
  5. Open Services
  6. Select the F2B Data Integration Service
  7. Right Click on the Service
  8. Select Properties
  9. Go to the Log On tab
  10. Click on This Account
  11. Enter your Account and Password
  12. Click OK

You are now setup to run the F2B Data Integration Module Service through an account with Internet Access.


Invalid Login Issue

The most common issue that can occur is that one of the values entered for your Server Login Info is incorrect.

If you see a message like the one shown below, it means that the Data Integration Module Service had an issue when using the Project’s Login Credentials when attempting to connect to the Field2Base Server.

This usually indicates the Company ID, Username, or Password were not entered correctly and need to be changed.
  1. 09/11 12:42:52.96 PM (tid: 5808) Error: Unhandled exception calling ListRecentSentForms. Caught SoapException: Invalid login EXCEPTION : Invalid login ; STACK : at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Field2Base.Transformer.Services.GetRfi.ListRecentSentForms(Int32 pLoginCompanyId, String pUsername, String pPassword, Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId) at Field2Base.Transformer.Plugins.RfiWebServiceClient.ListRecentSentForms(Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, ILogWriter pLog)
If you are seeing this error, then you will need to re-enter your Server Login Info. This can be done by doing the following:
  1. Open the Data Integration Module Project Manager
  2. Go to the File Menu
  3. Select Open
  4. Open the Project processing in the Data Integration Module Service
  5. Go to the File Menu
  6. Select the Edit Login Info option
  7. Re-Enter all of your Login Credentials
  8. Click OK
  9. Save the Project
  10. Close the Project Manager
  11. Open the Data Integration Module Administrator
  12. Go to the Service Manager
  13. Click the Restart button
  14. Confirm the Service gets Restarted
You should now check the Logs again and confirm you do not see the Invalid Login Exception. If you still see this issue, please contact F2BSupport@field2base.com to get your Login Credentials re-sent to you.

You Do Not Have Rights to Use the Service Issue

If you see a message like the one shown below, it means that the Data Integration Module Service cannot connect to the Field2Base Server because your account does not have the downloading capability of the Data Integration Module Service.
  1. 10/09 02:36:57.12 PM -4   Error:Unhandled exception calling ListRecentSentForms. Caught SoapException: You do not have rights to use this service System.Web.Services.Protocols.Soap Exception: You do not have rights to use this service at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters at Field2Base.Transformer.Services.GetRfi.ListRecentSentForms(Int32 pLoginCompanyId, String pUsername, String pPassword, Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, String pMinRFITimestampUTC) at Field2Base.Transformer.Plugins.RfiWebServiceClient.ListRecentSentForms(Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, DateTime pMinRfiTimestampUtc, ILogWriter pLog)
If you encounter this issue, please contact F2BSupport@field2base.com.

Generic Server Error Issue

If you see a message like the one shown below, it means that the server has received too many requests from Data Integration Module services for that Company ID. This occurs when multiple machines are running the Data Integration Module (i.e. a live PC and a test PC) at the same time. Normally, this will only delay the download of Forms by a few minutes and can often be ignored unless downloads are not occurring at all.

  1. 02/25 08:50:51.84 PM -5   Error:Unhandled exception calling ListRecentSentForms. Caught SoapException: Server error System.Web.Services.Protocols.SoapException: Server error at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Field2Base.Transformer.Services.GetRfi.ListRecentSentForms(Int32 pLoginCompanyId, String pUsername, String pPassword, Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, String pMinRFITimestampUTC) at Field2Base.Transformer.Plugins.RfiWebServiceClient.ListRecentSentForms(Int32 pSearchCompanyId, String pFormTemplateId, Int32 pMinRFIPkId, DateTime pMinRfiTimestampUtc, ILogWriter pLog)
The easiest way to resolve this is to only have one machine running Data Integration Module on a regular basis.

Forms Not Downloading in a Timely Manner Issue

This issue usually should only occur if the Data Integration Module services are not running automatically or service has been disrupted. Essentially, if the Data Integration Service is not running for a long length of time and Forms are being sent by the Company’s Tablets and Mobile Devices, there could be a long delay in processing Form Data due to the amount of downloading required.

The reason for this issue is twofold:

  1. The default configuration for the Data Integration Service is to download every pending Job (set of Form Data) to the PC before processing will start.
  2. The Field2Base Server has a limit on how many Job downloads can occur per each Data Integration Module installation.

These factors combine to form the possibility of the Job downloads taking hours to download all of the data before processing will begin.

If this is an issue that occurs with you, Field2Base does have a change available for the Data Integration Service configuration that will limit the number of Jobs to download before processing can start.

If you have interest in adding this configuration to your Data Integration Module, please contact F2BSupport@field2base.com.


Troubleshooting Processing Issues

CSV Output Issue

Check the file system to see if the Output File or Folder has been moved, deleted, or is inaccessible.


SQL Connection Issue

Check to see if the Database can still be connected to in the Project Manager by making a new SQL Data Transform as a test.


SQL Input String Format Issue

If you see the message below, it means that the format of the Data in the Form does not match the format that is expected for that column in the Database.
  1. 03/08 11:33:49.81 AM -4   Info : Could not convert value to Int32 for REGION_NAME. Caught System.FormatException: Input string was not in a correct format. 
The easiest way to fix this is to go into Forms Designer and update the Form’s Region to make sure it matches the expected format in the Database. For more complex situations, scripting within the Form can be used to help handle format issues. Remember to re-publish the Form to the server after making a change.

The other option is to change the Database’s format for this column, but in most scenarios this would not be the preferred solution since the format used in the Database was chosen for a reason (i.e. for Reporting or Analytical purposes).


Custom

Check the file system to see if the Custom Code file has been moved or deleted.


Exec

Check the file system to see if the Executable File has been moved or deleted.

 
    • Related Articles

    • Data Integration Module (DIM) User Guide

      Overview The Field2Base Data Integration Module allows you to automatically download data from your Sent Forms to your backend systems. The DIM provides transformation of your Form Data into a variety of formats including CSV and SQL. The DIM Sample ...
    • Troubleshooting the Enterprise Dispatch Module (EDM)

      Overview The Enterprise Dispatch Module has three main areas where issues may arise: Installation, Connectivity, and Processing. Each of these sections will provide brief descriptions of common issues and provide solutions and Log samples when ...
    • Data Integration Overview

      Our paperless mobile platform drives your digital transformation. A part of how we accomplish this is through our robust integration solutions designed specifically around your business and existing systems. Field2Base offers complete data ...
    • Integration Service Configuration Guide

      How To Configure Integration Services To Allow Read/Write Access on a Network Path All of our Integration Products, including the DIM, DUU, and EDM have respective Windows Services responsible for communicating with our server. Occassionally, ...
    • DIM 6.5 Install Guide

      Integration Suite Editions There are two available editions of the Field2Base Integration Suite, the Server Edition and the Designer Edition. Each edition has a 32 Bit and a 64 Bit version. We recommend using the 64 Bit for increased memory ...