Informix - Problem description
Problem IT36987 | Status: Closed |
SPL CONFLICT RESOLUTION OR POST COMMIT TRIGGERS POTENTIALLY FAILING WITH ERRORS 674 OR 201 | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When invoking a configured stored procedure for Enterprise Replication conflict resolution, this is done by constructing an "execute procedure" statement and sending that for execution. In that statement, the UDRs parameters are separated by commas and at least some of them will be quoted. Two problems can occur, typically leading to either error -674 (Routine cannot be resolved.) or -201 (syntax error). First problem is missing quoting where it would be required, specifically for DECIMAL, FLOAT or MONEY type parameters if either the server's CLIENT_LOCALE or its DBMONEY setting would impose a comma as decimal separator. As a consequnce the statement would look like having one too many parameters for every such parameter. Another problem can occur with MONEY data type parameters if again CLIENT_LOCALE or DBMONEY setting dictate a currency symbol consisting of more than precisely one character: the resulting (unquoted) MONEY value would be invalid and a syntax error would occur. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Running the server with explicit default DBMONEY setting "$.", so with a single character currency sign and a dot decimal separator, can help avoiding the problem. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.05.2021 01.11.2021 01.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |