Troubleshooting
Problem
When trying to save a record (either a new record or after modifying an existing record), the following error message is displayed :
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
It's not possible to save the record.
Note : the error message will be different depending on the language of SQL Server.
It corresponds to the SQL error #110.
In French, the message will be :
Cause
This is a known problem in iBase 9.0.0 and 9.0.1 that happens on Windows, where the decimal separator is a Comma.
In this case, the INSERT statement that is executed by SQL Server is wrong, as it thinks that the comma (from the real number) is a Value separator.
For example, this is the INSERT query that is executed by SQL when the separator is a Comma (the last 2 fields are real numbers) :
INSERT INTO dbo.Location_ (Unique_Id, Create_Date, Create_User, Last_Upd_Date, Last_Upd_User, Coordonnée_exacte, Coordonnées_, Latitude_2, Longitude_2)
VALUES (N'LOC2', CONVERT(DATETIME, N'11/22/2020 19:53:49', 101), N'SYSADMIN', CONVERT(DATETIME, N'11/22/2020 19:59:18', 101), N'SYSADMIN', -1, N'WGE*48,896076 2,221351', 48,896076, 2,221351)
SQL server "sees" the last 2 numbers (48,896076 and 2,221351) as 4 values (48 ; 896076 ; 2 ; 221351)
Therefore, SQL server consider that the number of values doesn't match the number of fields.
Environment
iBase 9.0.X on SQL Server format.
Windows OS with the decimal separator defined as the Comma.
Resolving The Problem
One workaround is to change (in Windows) the Decimal separator from Comma to Period (".")
An APAR has been created (APAR PO09079).
A fix pack should be avaliable soon.
Related Information
Document Location
Worldwide
[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000Caw4AAC","label":"i2 iBase and i2 Analyst's WorkStation->General"}],"ARM Case Number":"TS004561423","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.0.x"}]
Was this topic helpful?
Document Information
More support for:
i2 iBase
Component:
i2 iBase and i2 Analyst's WorkStation->General
Software version:
9.0.x
Operating system(s):
Windows
Document number:
6372540
Modified date:
25 November 2020
UID
ibm16372540