Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add MS SQL Server error - OEM 13.2c

rootsmanDec 26 2018

Hi guys,

I already installed agent version 12.1.0.5.0 on Windows 2003 32 bit host. But when i tried to add MS Sql server database i face error although test connection passed fine.

Error is : Add Microsoft SQL Server MSSQLSERVER on https://host.domain.com:3872/emd/main/ failed: oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Target Already exists: MSSQLSERVER:microsoft_sqlserver_database:host.domain.com:https://host.domain.com:3872/emd/main/:3:0. See log for details.

Log has this

GenericAddTargetBacking.class logp.251 - Exception:

oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: Target Already exists: MSSQLSERVER:microsoft_sqlserver_database:host.domain.com:https://host.domain.com:3872/emd/main/:3:0

at oracle.sysman.emdrep.target.EntityUtil.handleAddNYMException(EntityUtil.java:2565)

at oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2416)

at oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2302)

at oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3626)

at oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3596)

at oracle.sysman.emSDK.core.target.EntityManager.createEntities(EntityManager.java:320)

at oracle.sysman.core.discovery.home.GenericAddTargetBacking.addTarget(GenericAddTargetBacking.java:540)

at oracle.sysman.core.discovery.home.GenericAddTargetBacking.longRunningTask(GenericAddTargetBacking.java:499)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

at oracle.sysman.emSDK.view.util.AdfUtil.invokeEL(AdfUtil.java:641)

at oracle.sysman.sdkImpl.core.uifwk.ui.progress.ProgressBackingBean.pollListener(ProgressBackingBean.java:221)

at sun.reflect.GeneratedMethodAccessor9892.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodExpression(UIXComponentBase.java:2016)

at org.apache.myfaces.trinidad.component.UIXPoll.broadcast(UIXPoll.java:98)

at javax.faces.component.UIViewRoot.broadcastEvents(Unknown Source)

at javax.faces.component.UIViewRoot.processApplication(Unknown Source)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

at javax.faces.webapp.FacesServlet.service(Unknown Source)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.view.page.editor.webapp.WebCenterComposerFilter.doFilter(WebCenterComposerFilter.java:117)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.share.http.ServletADFFilter.doFilter(ServletADFFilter.java:77)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:800)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.sysman.emInternalSDK.core.model.utils.EntityManagerFilter.doFilter(EntityManagerFilter.java:46)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:561)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilterImpl.doFilter(AdfFacesCachingFilterImpl.java:136)

at oracle.adf.view.rich.webapp.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:66)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.sysman.core.app.exception.EMRuntimeExceptionFilter.doFilter(EMRuntimeExceptionFilter.java:150)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1575)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Please help me with this.

Regards!

Comments
Post Details
Added on Dec 26 2018
0 comments
123 views