My Oracle Support Banner

AsFile Web Service Fail Without Meaningful Error Message When Query In XMLData Fails Or Returns NULL (Doc ID 2661746.1)

Last updated on APRIL 22, 2020

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.2.0.34 and later
Information in this document applies to any platform.

Symptoms

On : 10.2.0.34 version, General

ACTUAL BEHAVIOR
---------------
AsFile web service fail without meaningful error message when query in XMLData fails or returns NULL. When a query in the XMLData of an AsFile web service fails or returns a NULL value, AsFile returns a NULL pointer instead of an indication of the query that failed. This makes it very difficult to diagnose issues with complex AsFiles with many queries. The expectation is for a meaningful error message to be returned by the web service indicating the query that failed, similar to the stack trace provided by a system error in a configured transaction. When this occurs in Production, it causes severe delays in diagnosing and resolving critical issues, which results in loss of business.

EXPECTED BEHAVIOR
-----------------------
When an XMLData query fails or returns NULL, the query needs to be identified in the AsFile web service return message.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure an AsFile with a SQLMAP. Provide a query for the SQLMAP such that it returns a NULL for the name or value for one of the name-value pairs. Execute the AsFile and see that it returns a NULL pointer exception without identifying the query that failed.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.