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 and later
Information in this document applies to any platform.


On : version, General

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.

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

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.


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

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