MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid.

I installed a new soa suite and started my managed server.

Though managed server status is up and running the soa-infra is down and i can see following logs in the soa logs

[2014-04-22T14:18:50.436+05:30] [soa_server1] [NOTIFICATION] [] [oracle.mds] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 0000KM8b^xxEoIJLymH7iW1JLYlz000002,0] [APP: composer] "Metadata Services: Metadata archive (MAR) not found."
[2014-04-22T14:18:55.243+05:30] [soa_server1] [WARNING] [SDP-26024] [oracle.sdp.messaging.driver.base] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 0000KM8b^xxEoIJLymH7iW1JLYlz000002,1:22904] [APP: usermessagingdriver-email] Registration of driver Email-Driver did not complete; will retry periodically until messaging server responds.
[2014-04-22T14:18:56.482+05:30] [soa_server1] [ERROR] [] [oracle.mds] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 0000KM8b^xxEoIJLymH7iW1JLYlz000002,0] [APP: soa-infra] [[
oracle.mds.lcm.exception.MDSLCMException: MDS-01330: unable to load MDS configuration document
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"
ORA-06512: at line 1


at oracle.mds.internal.lcm.deploy.DeployManager.deploy(DeployManager.java:747)
at oracle.mds.internal.lcm.deploy.DeployManager.startDeployment(DeployManager.java:211)
at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:215)
at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:77)
at weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:282)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.application.internal.flow.BaseLifecycleFlow$LifecycleListenerAction.invoke(BaseLifecycleFlow.java:199)
at weblogic.application.internal.flow.BaseLifecycleFlow.preStart(BaseLifecycleFlow.java:62)
at weblogic.application.internal.flow.HeadLifecycleFlow.prepare(HeadLifecycleFlow.java:283)
at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:648)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:191)
at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:59)
at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:144)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:39)
at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:191)
at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:21)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:165)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.mds.config.MDSConfigurationException: MDS-01330: unable to load MDS configuration document
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"
ORA-06512: at line 1


at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1014)
at oracle.mds.config.PConfig.(PConfig.java:767)
at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:1151)
at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:1218)
at oracle.mds.config.MDSConfig.(MDSConfig.java:781)
at oracle.mds.config.MDSConfig.(MDSConfig.java:728)
at oracle.mds.internal.lcm.deploy.DeployManager.deploy(DeployManager.java:529)
... 27 more
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"
ORA-06512: at line 1


at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1008)
... 33 more


The reason for this error is that i am using an XE database.

If you are using an XE database it is very important to execute a command before running rcu

In order to resolve the issue

drop the RCU

Open a command prompt and navigate till the rcu.bat folder there set the following

RCU_JDBC_TRIM_BLOCKS=TRUE

then run the bat file as shown below