My Oracle Support Banner

ORA-03001 Unimplemented Feature After Upgrade Demantra From 12.2.3 To 12.2.5.1 (Doc ID 2147892.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5.1 version, DM-Gen

Got worksheet error ORA-03001 Unimplemented feature after upgrade Demantra from 12.2.3 to 12.2.5.1

Customer is performing an upgrade from Demantra 12.2.3 to 12.2.5.1. (Upgrade Schema -> Platform Upgrade only). After the upgrade, when they launched Tomcat we got the following error:

ERROR appserver.thread:
java.sql.SQLException: ORA-03001: unimplemented feature

Upon turning on the sql logging they got the last query that comes up before the error comes up. Then ran the query on command lune and got the same error. Found that in the last query, the function Z_FN_get_max_date shows like this:

Z_FN_get_max_date(0)()

Which should be

Z_FN_get_max_date()

And it causes this error.

The DDL for the function z_fn_get_max_date():

create or replace
FUNCTION z_fn_get_max_date
RETURN date
IS
ret_date date;
BEGIN

ret_date := to_date(get_max_date(),'MM-DD-YYYY HH24:MI:SS');

RETURN ret_date;
END;


ERROR
-----------------------
ERROR appserver.thread:
java.sql.SQLException: ORA-03001: unimplemented feature


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Upgrade Demantra instance
2. Start the webserver



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.