Start a conversation

List of Potential Event Log Errors

The TracerPlus Connect event log can be a helpful tool when diagnosing a problem with your sync configuration, and can be located by going to View -> Event Log -> Open Log in Connect. Below are a number of common errors, along with the potential causes for them:


  • "Invalid PROFILE Index selected in Begin Sync request. Please verify the requested PROFILE Index" 
    • No profile has been set on the sync button, or trying to sync a non-existent profile. Check your do sync buttons and see if the profile you are trying to sync exists.
  • "A column named '(Column Name)' already belongs to this DataTable." 
    • The Same field is mapped twice in your field mappings.
  • "the operation is not allowed on non-connected sockets"
    • Connection timed out / Connection was lost. Try increasing the duration before time out in Tools - > Preferences in Connect, or make sure your connection is stable. 
  • " Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.”
    • Sync buttons on form may be configured incorrectly, also could be connection timed out / connection was lost. Try increasing the duration before time out in Tools - > Preferences in Connect, or make sure your connection is stable. 
  • Unable to write data to the transport connection: An established connection was aborted by the software in your host machine. 
    • Another timeout. This may be related to the size of the data you are syncing or the destination you are syncing to. Again try increasing duration before time out.
  • "Only one usage of each socket address (protocol/network address/port) is normally permitted"
    • Connect is unable to sync because the port is already in use. You may have 2 instances of TracerPlus Connect open.
  • "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
    • Mismatch between x86 vs. 64 bit ODBC, may not be correctly created in 32 bit ODBC. 
  • "Input string was not in a correct format."
    • Typically means wrong type of data (date, number, text, etc) was being synced to a column in the database that rejected it. Not always indicative if syncing FROM a database. 
  • "Worksheet not released. Already null." 
    • Occurs with Excel when you are trying to sync, but Excel is open already in the background. Completely close Excel and attempt to sync again.
  • Cannot insert the value NULL into column '(column name), table '(table name)'; column does not allow nulls. INSERT fails.
    • Error caused by attempting to insert null data into a column in the database that must be non-null.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Tyler Kozikowski

  2. Posted

Comments