Defects

Error 404 when edit anything on the Environment in the Repository



ID:    D27830
Published:    30 April 2021
 

Defect Id

DEF344721

Originally Reported Against

SBM 11.7.1

Also Affects

SBM 11.7.1

Status

Submitted

Description

After upgrading SBM on Oracle, everything is working perfectly fine. The only problem is that they cannot edit anything in the Repository on the Environment screen, including the Deploy Enable flag and endpoints.

The server.log gives errors like this:
 2021-11-16 00:25:19,297 ERROR [ajp-nio-6009-exec-9] [org.apache.axis2.rpc.receivers.RPCMessageReceiver:216] [::] -- could not extract ResultSet
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
 Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist 

 

Resolution

This will happen after an upgrade if the OE User Schema and the CL User Schema are not the same. 

Workaround: Manually create the missing sequence by logging into Oracle as the OE user and running this script:
 CREATE SEQUENCE HIBERNATE_SEQUENCE  START WITH 11 INCREMENT BY 1 NOCACHE   NOCYCLE;  

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs