Wednesday, March 16, 2011

DEV_MDS.MDS_INTERNAL_SHREDDED has errors



This article is about to discuss an issue I faced during starting of SOA11.1.1.4 server on top of XE database.

After installing SOA 11.1.1.4 on top of XE database and when I start admin server I started seeing below error message.
One more indication which confirms this issue is when we create a connection in Jdev we can not see any MDS  partitions to connect to the server.

Circumstance: When SOA 11.1.1.4 is installed on XE database and when we start admin server/managed server


This error is specific to XE db

Error
Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"


MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid.
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors

ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"

If you try to compile above procedure and if error is

Error(1): PLS-00753: malformed or corrupted wrapped unit, then you can simply apply below solution

Solution:
1) Use RCU to drop the SOA Suite schemas and tablespaces


2) Set the environmental variable RCU_JDBC_TRIM_BLOCKS=TRUE and then run RCU again to re-create the SOA Suite schemas and tablespaces


8 comments:

  1. I faced this problem after installing the SOA suite 11.1.1.4. I also tried dropping the schemas using RCU and setting the enviornment variable and recreating the schemas. Still I face the same error and soa-infra is showing as down in EM console. Any help?

    ReplyDelete
  2. Praveen, any idea where does the compoiste get stored in 11g? In 10g, there used to be separate tables that used to store BPEL Process meta-data and suite-case jar files.

    Did not find any such thing in 11g.

    Thanks in advance for your help.
    Ashish

    ReplyDelete
  3. Thank you!
    That worked for me: Windows 7, Oracle XE 10.2.0.1.0

    ReplyDelete
  4. This blog is great. It solved my issue. Worked on windows 7

    Thanks

    ReplyDelete
  5. Thank you so much !
    It worked for me on Windows 7 professional, Oracle XE

    ReplyDelete
  6. Thank you a lot.
    It worked for me on Windows 7 professional 64bit, Oracle XE.

    ReplyDelete
  7. Hi,
    I am getting the same error..but I have already set the RCU JDBC to TRUE followed the oracle user guide..I can understand the problem what I am facing can be fixed by connecting to the MDS from SQL, developer when trying to install SQL developer on windows 7 64 Bit and OracleXEUniv..suggest me the link from where and and which one should be downloaded also let me the the jdk downloading,looking forward for your reply.

    error log file : Started: ADF Library non-ADFJspResourceProvider post-deployment
    Finished: ADF Library non-ADFJspResourceProvider post-deployment (millis): 63
    (PConfig.java:499)
    at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:707)
    at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:764)
    at oracle.mds.config.MDSConfig.(MDSConfig.java:420)
    at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java
    :2055)
    at oracle.mds.core.MDSInstance.createMDSInstanceWithCustomizedConfig(MDS
    Instance.java:1197)
    at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:580)

    at oracle.adf.share.config.ADFMDSConfig.createMDSInstanceFromelement(ADF
    MDSConfig.java:243)
    at oracle.adf.share.config.MDSConfigFactory.createApplication(MDSConfigF
    actory.java:123)
    at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
    figFactory.java:142)
    at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
    figFactory.java:78)
    at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFCon
    figFactory.java:56)
    at oracle.adf.share.http.ServletADFContext.checkForUpdatesToADFConfig(Se
    rvletADFContext.java:645)
    at oracle.adf.share.http.ServletADFContext.initialize(ServletADFContext.
    java:443)
    at oracle.adf.share.http.ServletADFContext.initThreadContext(ServletADFC
    ontext.java:395)
    at oracle.adf.mbean.share.config.ADFConfigLifeCycleCallBack.contextIniti
    alized(ADFConfigLifeCycleCallBack.java:97)
    at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run
    (EventsManager.java:481)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
    dSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
    120)
    at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(Eve
    ntsManager.java:181)
    at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAp
    pServletContext.java:1872)
    at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletCon
    text.java:3153)
    at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.jav
    a:1508)
    at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:482)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
    teDriver.java:425)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
    river.java:52)
    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
    eDriver.java:119)
    at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedMod
    uleDriver.java:200)
    at weblogic.application.internal.flow.ModuleListenerInvoker.start(Module
    ListenerInvoker.java:247)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
    teDriver.java:425)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
    river.java:52)
    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat

    ReplyDelete
    Replies
    1. at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
      teDriver.java:425)
      at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
      river.java:52)
      at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
      eDriver.java:119)
      at weblogic.application.internal.flow.StartModulesFlow.activate(StartMod
      ulesFlow.java:27)
      at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.ja
      va:636)
      at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
      river.java:52)
      at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.
      java:205)
      at weblogic.application.internal.EarDeployment.activate(EarDeployment.ja
      va:58)
      at weblogic.application.internal.DeploymentStateChecker.activate(Deploym
      entStateChecker.java:161)
      at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(Ap
      pContainerInvoker.java:79)
      at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicD
      eployment.java:184)
      at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromSer
      verLifecycle(BasicDeployment.java:361)
      at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(De
      ploymentAdapter.java:51)
      at weblogic.management.deploy.internal.DeploymentAdapter.activate(Deploy
      mentAdapter.java:200)
      at weblogic.management.deploy.internal.AppTransition$2.transitionApp(App
      Transition.java:30)
      at weblogic.management.deploy.internal.ConfiguredDeployments.transitionA
      pps(ConfiguredDeployments.java:240)
      at weblogic.management.deploy.internal.ConfiguredDeployments.activate(Co
      nfiguredDeployments.java:169)
      at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(Conf
      iguredDeployments.java:123)
      at weblogic.management.deploy.internal.DeploymentServerService.resume(De
      ploymentServerService.java:180)
      at weblogic.management.deploy.internal.DeploymentServerService.start(Dep
      loymentServerService.java:96)
      at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      >

      Thread[[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tun
      ing)',5,Pooled Threads]: CompressionFilter: Using debug = (0)
      PostInstallConfigIntegration:oracle_ias_farm target auth registration is done.

      Delete