Invoking Oracle Database / DBaaS Adapter to select from a database, fails with oracle.xml.parser.v2.XMLParseException... Invalid char in text
(Doc ID 2898702.1)
Last updated on MARCH 12, 2024
Applies to:
Oracle Integration-OIC - Version 21.2.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
Invoking an Oracle Database / DBaaS Adapter to perform a select operation from a database, fails with oracle.xml.parser.v2.XMLParseException... Invalid char in text
From the Flow Log :
[2022-09-24T00:00:25.378+00:00] [oic_server2] [NOTIFICATION] [] [oracle.ics.trace.soa.bpel] [tid: 3583] [userId: xxx] [ecid: 0000ODgg0dL95i_LxQT4iW1Z5Q78001tFC,1:556952:10] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FlowId: 0000ODgmppB99h_LxQ1FiW1Z5SB4001sob] [ICS Activity Stream Logging]: [Code:MYINTEGRATION][Version:01.00.0000][Instance:61633092][Source:Adapter][Operation:SelectFromMyTable_REQUEST][ActionName:SelectFromMyTable_REQUEST][ActionID:i6][ActionType:Invoke][Endpoint:database][Endpoint Invocation Start(UTC):2022-09-24T00:00:25.252Z][Endpoint Invocation End(UTC):2022-09-24T00:00:25.376Z][Total Execution Time(ms):124]: Request: 'Select rows from TEST.MYTABLE in Oracle Database' failed in 124 ms - SQL_WORKBENCH_SELECT: TEST.MYTABLE
[2022-09-24T00:00:25.401+00:00] [oic_server2] [NOTIFICATION] [] [oracle.osb.logging.pipeline] [tid: 33207] [userId: xxx] [ecid: 0000ODgg0dL95i_LxQT4iW1Z5Q78001tFC,0] [APP: Service Bus Framework Starter Application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FlowId: 0000ODgmppB99h_LxQ1FiW1Z5SB4001sob] [oci.instanceName: OICPRD] [oci.identityDomain: identityDomainName] [null, null, null, ERROR] [ICS Activity Stream Logging]: [Code:MYINTEGRATION][Version:01.00.0000][Instance:61633092][Operation:SelectFromMyTableSelect][ActionID:Ei6][ActionType:SelectFromMyTable][ActionType:Invoke]: Error Occurred While Invoking SelectFromMyTable Application.
[2022-09-24T00:00:25.401+00:00] [oic_server2] [NOTIFICATION] [] [oracle.osb.logging.pipeline] [tid: 33207] [userId: xxx] [ecid: 0000ODgg0dL95i_LxQT4iW1Z5Q78001tFC,0] [APP: Service Bus Framework Starter Application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [FlowId: 0000ODgmppB99h_LxQ1FiW1Z5SB4001sob] [oci.instanceName: OICPRD] [oci.identityDomain: identityDomainName] [null, null, null, ERROR] [ICS Tracing Enabled]: [Code:MYINTEGRATION][Version:01.00.0000][Instance:61633092][Location:Fault Payload Received Invoking SelectFromMyTable Application][Operation:SelectFromMyTableSelect][ActionID:Ei6][ActionName:SelectFromMyTable][ActionType:Invoke]: [[
Fault:
<soap-env:Fault xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"><faultcode xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">soap:Server</faultcode><faultstring>ICS runtime execution error</faultstring><detail><ICSfaultVar/><reason>oracle.xml.parser.v2.XMLParseException; lineNumber: 13; columnNumber: 123; Invalid char in text.:Application Error</reason><operation>SelectFromMyTableSelect</operation><request_payload/></detail></soap-env:Fault>
]]
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |