APAR status
Closed as program error.
Error description
bson_update(<bson>, "{$set:<update_json_string>}") working in most simplistic cases only: - <update_json_string> can only contain a single key - that key needs to exist already in <bson> - its existing value, if complex, must have exactly same structure as new one For instance you would have this bson: {a : 1, b : 2} You can say {$set : {a : 10}} or {$set : {b : 20}} but {$set : {a : 10, b : 20}} would run into 9659: The server does not support the specified UPDATE operation on JSON documents. Same for {$set : {c : 30}} where key 'c' had not existed before. You also could say {$set : {b : { b1 : 11, b2 : 12}}}, so replace key b's value by a more complex one, but then only e.g. {$set : {b : { b1 : 21, b2 : 22}}} would work on this, and not e.g. {$set : {b : { b1 : 21, b2 : 22, b3 : 33}}} or {$set : {b : 22}} These quite confusingly now would run into -201 SQL syntax error - during execution of the command.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All NoSQL users using bson_update($set) * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC6
Temporary fix
Comments
APAR Information
APAR number
IT07901
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-03-24
Closed date
2015-12-30
Last modified date
2024-11-10
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 November 2024