EM 13c: Creating SQL Tuning Sets Fails With 'Unexpected Error Occurred' (Doc ID 2692357.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• From EM, creating SQL Tuning Sets using the below navigation:
  Login to EM conosle

  Targets --> Databases
  click on any database target
  click on performance --> SQL --> SQL Tuning Sets, click on Create
  Give some name under 'SQL Tuning Set Name' say test1, click Next

  Select option "Load SQL statements one time only",
  under Data Source drop down, select 'AWR Snapshots'
  under 'AWR Snapshots' drop down, select Customize and click on Go,
  you will get another window, please select 'Period Start Time' snapshot and
  'Period End Time' snapshot, then click select.

   
• Fails with following error:
  Error
  Unexpected error occurred. Please contact Oracle Support with these files.
  <EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/access.log
  <EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/<SERVER_NAME>-diagnostic.log
  <EM_INSTANCE_BASE>/em/<OMS_NAME>/sysman/log/emoms.trc
   
• From <EM_Instance_Home>/em/EMGC_OMS#/sysman/log/emoms.trc:
  at oracle.sysman.db.adm.BaseController.handleRequest(BaseController.java:1392)
  at oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java:149)
  at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:768)
  at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:360)
  at oracle.sysman.eml.app.Console.doGet(Console.java:374)
  at oracle.cabo.servlet.UIXServlet.doPost(Unknown Source)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
   

Cause

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