Direct links to fixes
APAR status
Closed as fixed if next.
Error description
User reports an XPath error when trying to use XPath to build an SQL query that contains the quote (") character. It appears that this might only happen when there are multiple parameters being built with XPath at run time. If there is only one, the quotes appear to work correctly. The error message received is similar to this: Unable to get/create XPath object from cache with XPath value of ""select "PRODUCT_LABEL" from SI_VERSION WHERE SI_COMMENTS = ?"". The system log may have further information. Search for "XPathCacheLoader.load" to find more detailed information.
Local fix
Example: STRRTC - 502733 JPM / JJB Circumvention: None
Problem summary
Users Affected: All Problem Description: User reports an XPath error when trying to use XPath to build an SQL query that contains the quote (") character. It appears that this might only happen when there are multiple parameters being built with XPath at run time. If there is only one, the quotes appear to work correctly. Platforms Affected: All
Problem conclusion
Resolution Summary: A code fix has been provided. Delivered in: 5020603
Temporary fix
Comments
APAR Information
APAR number
IT16123
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
525
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-07-14
Closed date
2016-12-15
Last modified date
2016-12-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
28 August 2023