KB87351
Published: May 24, 2018
Revision: 2.0

OptoDataLink: "Database INSERT transaction failed/Number of values and fields not the same" when Single Sample option isn't selected


Applies To:

OptoDataLink

Versions Affected:

R9.6a through R9.6c; and Beta version B9.6d, all builds through 0013

Resolved In Version:

R10.0a


Symptoms:

If the Single Sample check box isn't selected when the source is an Opto 22 Device table (Edit > Add New Data Link > Data comes from an Opto 22 Device Table) , OptoDataLinkRuntime will display an "Error in [link name]: Database INSERT transaction failed. Reason: Number of query values and destination fields are not the same" message when the link tries to run.

Workaround:

  1. Open your OptoDataLink's project file in a text editor. The project file has a file extenson of .xml (for example, WeatherData.xml). 
     
  2. In the file, each link that comes from an Opto 22 Device Table will have these two lines:
    <sendIndex>False</sendIndex>
    <sendTimestamp>False</sendTimestamp>

    You can use the text editor's Find feature to find the lines. 
     
  3. Replace all instances of those lines with these:
    <sendIndex>True</sendIndex>
    <sendTimestamp>True</sendTimestamp>
     
  4. Save the file, restart the project in OptoDataLink, and then run the links.

Resolution:

Opto 22 has resolved this issue. 

Questions?

Contact: Opto 22 Product Support.
Phone: 800-835-6786 or 951-695-3080
Email: support@opto22.com


DISCLAIMER

This Opto 22 Knowledge Base ('OptoKB') article is intended to provide general technical information on a particular subject or subjects and is not an exhaustive treatment of such subjects. Accordingly, the information in this OptoKB article is not intended to constitute application, design, software, or other professional engineering advice or services. Opto 22 may modify the OptoKB articles at any time. Before making any decision or taking any action which might affect your equipment, you should consult a qualified professional.

OPTO 22 DOES NOT WARRANT THE COMPLETENESS, TIMELINESS, OR ACCURACY OF THE DATA CONTAINED IN THIS OPTOKB ARTICLE AND MAY MAKE CHANGES THERETO AT ANY TIME AT ITS SOLE DISCRETION WITHOUT NOTICE. FURTHER, ALL INFORMATION CONVEYED HEREBY IS PROVIDED TO USERS 'AS IS.' IN NO EVENT SHALL OPTO 22 BE LIABLE FOR ANY DAMAGES OF ANY KIND INCLUDING DIRECT, INDIRECT INCIDENTAL, CONSEQUENTIAL, LOSS PROFIT, OR DAMAGE, EVEN IF OPTO 22 HAS BEEN ADVISED ON THE POSSIBILITY OF SUCH DAMAGES.

OPTO 22 DISCLAIMS ALL WARRANTIES WHETHER EXPRESSED OR IMPLIED WITH RESPECT TO THE INFORMATION (INCLUDING HARDWARE, SOFTWARE, AND/OR FIRMWARE) PROVIDED HEREBY, INCLUDING THE IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTIBILITY, AND NON-INFRINGEMENT. Note that certain jurisdictions do not sanction the exclusion of implied warranties: thus, this disclaimer may not apply to you.

Copyright © 2019 Opto 22. All rights reserved.