|
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) |
