IT36987: SPL CONFLICT RESOLUTION OR POST COMMIT TRIGGERS POTENTIALLY FAILING WITH ERRORS 674 OR 201

APAR status

• Closed as program error.

Error 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 <routine-name> 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.
  

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.
  

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.                        *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC7.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels