org.openmdx.base.exception.ServiceException: DefaultDomain.MEDIA_ACCESS_FAILURE BasicException[0] Class = org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction Method = find Line = 5393 ExceptionClass = org.openmdx.base.exception.ServiceException ExceptionDomain = DefaultDomain ExceptionCode = MEDIA_ACCESS_FAILURE Timestamp = 2012-04-18T08:47:41.328Z Paramaters: 0: path = org::opencrx::kernel::account1/provider/CRX/segment/Standard/account/9DZBQ0VYWCYJLF9I90SSGMRG7/accountMembership 1: statement = SELECT v.*, v.distance AS p$$distance, v.quality AS p$$quality, v.dtype AS p$$dtype, v.disabled AS p$$disabled FROM OOCKE1_TOBJ_ACCTMEMBERSHIP1 v WHERE (1=1) AND (v.p$$parent = ?) AND ((/*!DBOBJECT 1 */ (1=1) ) and ( v.member IN ( select distinct(member) from oocke1_tobj_acctmembership1 m, oocke1_account a where ((m.disabled is null) or (m.disabled = false)) and ((m.account_to = a.object_id) and ((a.disabled is null) or (a.disabled = false))) ) ) ) AND (((v.dtype IN (?)))) AND (((v.distance IN (?)))) AND (((v.quality <= ?))) AND (((v.disabled IN (?)) OR (v.disabled IS NULL))) AND (v.member IN (SELECT object_id FROM OOCKE1_TOBJ_ACCTMEMBERSHIP_ v WHERE ((((v.owner IN (?, ?, ?, ?, ?, ?, ?, ?))))))) 2: parameters = [account/CRX/Standard/9DZBQ0VYWCYJLF9I90SSGMRG7, org:opencrx:kernel:account1:AccountMembership, -1, 9, false, Standard:breiner.Group, Standard:Unspecified, Standard:Unassigned, Standard:breiner.User, Standard:Users, Standard:breiner, Standard:Administrators, Standard:Public] 3: sqlErrorCode = 1064 4: sqlState = 42000 StackTrace:

opencrx | argonym | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    SQL Error in AccountRelationships.jsp

    opencrx | 5 years ago | argonym
    org.openmdx.base.exception.ServiceException: DefaultDomain.MEDIA_ACCESS_FAILURE BasicException[0] Class = org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction Method = find Line = 5393 ExceptionClass = org.openmdx.base.exception.ServiceException ExceptionDomain = DefaultDomain ExceptionCode = MEDIA_ACCESS_FAILURE Timestamp = 2012-04-18T08:47:41.328Z Paramaters: 0: path = org::opencrx::kernel::account1/provider/CRX/segment/Standard/account/9DZBQ0VYWCYJLF9I90SSGMRG7/accountMembership 1: statement = SELECT v.*, v.distance AS p$$distance, v.quality AS p$$quality, v.dtype AS p$$dtype, v.disabled AS p$$disabled FROM OOCKE1_TOBJ_ACCTMEMBERSHIP1 v WHERE (1=1) AND (v.p$$parent = ?) AND ((/*!DBOBJECT 1 */ (1=1) ) and ( v.member IN ( select distinct(member) from oocke1_tobj_acctmembership1 m, oocke1_account a where ((m.disabled is null) or (m.disabled = false)) and ((m.account_to = a.object_id) and ((a.disabled is null) or (a.disabled = false))) ) ) ) AND (((v.dtype IN (?)))) AND (((v.distance IN (?)))) AND (((v.quality <= ?))) AND (((v.disabled IN (?)) OR (v.disabled IS NULL))) AND (v.member IN (SELECT object_id FROM OOCKE1_TOBJ_ACCTMEMBERSHIP_ v WHERE ((((v.owner IN (?, ?, ?, ?, ?, ?, ?, ?))))))) 2: parameters = [account/CRX/Standard/9DZBQ0VYWCYJLF9I90SSGMRG7, org:opencrx:kernel:account1:AccountMembership, -1, 9, false, Standard:breiner.Group, Standard:Unspecified, Standard:Unassigned, Standard:breiner.User, Standard:Users, Standard:breiner, Standard:Administrators, Standard:Public] 3: sqlErrorCode = 1064 4: sqlState = 42000 StackTrace:
  2. 0

    HSSQLDB to Oracle Migration - HS Supports Bools and Oracle doesn't

    opencrx | 5 years ago | mgalesic
    org.openmdx.base.exception.ServiceException: DefaultDomain.MEDIA_ACCESS_FAILURE BasicException[0] Class = org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction Method = find Line = 5311 ExceptionClass = org.openmdx.base.exception.ServiceException ExceptionDomain = DefaultDomain ExceptionCode = MEDIA_ACCESS_FAILURE Timestamp = 2012-09-14T12:11:22.355Z Parameters: 0: path = org::opencrx::kernel::account1/provider/CRX/segment/Standard/account/LT1SJ440VHB6PJRLEQ42XMK1X/accountMembership 1: statement = SELECT v.*, v.distance AS p$$distance, v.account_from AS p$$account_from, v.dtype AS p$$dtype, v.disabled AS p$$disabled FROM OOCKE1_TOBJ_ACCTMEMBERSHIP1 v WHERE (1=1) AND (v.p$$parent = ?) AND ((/*!DBOBJECT 1 */ (1=1) ) and ( v.member IN ( select distinct(member) from oocke1_tobj_acctmembership1 m, oocke1_account a where ((m.disabled is null) or (m.disabled = false)) and ((m.account_to = a.object_id) and ((a.disabled is null) or (a.disabled = false))) ) ) ) AND (((v.dtype IN (?)))) AND (((v.distance >= ?))) AND (((v.distance <= ?))) AND (((v.account_from IN (?)))) AND (((v.disabled IN (?)) OR (v.disabled IS NULL))) AND (v.member IN (SELECT object_id FROM OOCKE1_TOBJ_ACCTMEMBERSHIP_ v WHERE ((((v.owner IN (?, ?, ?, ?, ?, ?, ?, ?))))))) 2: parameters = [account/CRX/Standard/LT1SJ440VHB6PJRLEQ42XMK1X, org:opencrx:kernel:account1:AccountMembership, -1, 1, org::opencrx::kernel::account1/provider/CRX/segment/Standard/account/LT1SJ440VHB6PJRLEQ42XMK1X, false, Standard:Unspecified, Standard:Unassigned, Standard:admin-Standard.Group, Standard:Users, Standard:Administrators, Standard:admin-Standard, Standard:Public, Standard:admin-Standard.User] 3: sqlErrorCode = 904 4: sqlState = 42000 StackTrace:

    Root Cause Analysis

    1. org.openmdx.base.exception.ServiceException

      DefaultDomain.MEDIA_ACCESS_FAILURE BasicException[0] Class = org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction Method = find Line = 5393 ExceptionClass = org.openmdx.base.exception.ServiceException ExceptionDomain = DefaultDomain ExceptionCode = MEDIA_ACCESS_FAILURE Timestamp = 2012-04-18T08:47:41.328Z Paramaters: 0: path = org::opencrx::kernel::account1/provider/CRX/segment/Standard/account/9DZBQ0VYWCYJLF9I90SSGMRG7/accountMembership 1: statement = SELECT v.*, v.distance AS p$$distance, v.quality AS p$$quality, v.dtype AS p$$dtype, v.disabled AS p$$disabled FROM OOCKE1_TOBJ_ACCTMEMBERSHIP1 v WHERE (1=1) AND (v.p$$parent = ?) AND ((/*!DBOBJECT 1 */ (1=1) ) and ( v.member IN ( select distinct(member) from oocke1_tobj_acctmembership1 m, oocke1_account a where ((m.disabled is null) or (m.disabled = false)) and ((m.account_to = a.object_id) and ((a.disabled is null) or (a.disabled = false))) ) ) ) AND (((v.dtype IN (?)))) AND (((v.distance IN (?)))) AND (((v.quality <= ?))) AND (((v.disabled IN (?)) OR (v.disabled IS NULL))) AND (v.member IN (SELECT object_id FROM OOCKE1_TOBJ_ACCTMEMBERSHIP_ v WHERE ((((v.owner IN (?, ?, ?, ?, ?, ?, ?, ?))))))) 2: parameters = [account/CRX/Standard/9DZBQ0VYWCYJLF9I90SSGMRG7, org:opencrx:kernel:account1:AccountMembership, -1, 9, false, Standard:breiner.Group, Standard:Unspecified, Standard:Unassigned, Standard:breiner.User, Standard:Users, Standard:breiner, Standard:Administrators, Standard:Public] 3: sqlErrorCode = 1064 4: sqlState = 42000 StackTrace:

      at org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction.find()
    2. org.openmdx.application
      AbstractDatabase_1$LayerInteraction.find
      1. org.openmdx.application.dataprovider.layer.persistence.jdbc.AbstractDatabase_1$LayerInteraction.find(AbstractDatabase_1.java:5393)
      1 frame
    3. org.opencrx.kernel
      Audit_1$LayerInteraction.find
      1. org.opencrx.kernel.layer.persistence.Indexed_1$LayerInteraction.find(Indexed_1.java:662)
      2. org.opencrx.kernel.layer.persistence.Audit_1$LayerInteraction.find(Audit_1.java:440)
      2 frames
    4. org.openmdx.application
      Standard_1$LayerInteraction.find
      1. org.openmdx.application.dataprovider.spi.Layer_1$LayerInteraction.find(Layer_1.java:412)
      2. org.openmdx.application.dataprovider.layer.model.Standard_1$LayerInteraction.find(Standard_1.java:324)
      2 frames
    5. org.opencrx.kernel
      AccessControl_1$LayerInteraction.find
      1. org.opencrx.kernel.layer.model.AccessControl_1$LayerInteraction.find(AccessControl_1.java:1348)
      1 frame
    6. org.openmdx.application
      Layer_1$LayerInteraction.find
      1. org.openmdx.application.dataprovider.spi.Layer_1$LayerInteraction.find(Layer_1.java:412)
      1 frame
    7. org.opencrx.kernel
      OpenCrxKernel_1$StandardLayerInteraction.find
      1. org.opencrx.kernel.layer.application.OpenCrxKernel_1$StandardLayerInteraction.find(OpenCrxKernel_1.java:226)
      1 frame
    8. org.openmdx.application
      Layer_1$LayerInteraction.find
      1. org.openmdx.application.dataprovider.spi.Layer_1$LayerInteraction.find(Layer_1.java:412)
      2. org.openmdx.application.dataprovider.layer.type.Strict_1$LayerInteraction.find(Strict_1.java:233)
      3. org.openmdx.application.dataprovider.spi.Layer_1$LayerInteraction.find(Layer_1.java:412)
      3 frames
    9. org.openmdx.base
      MarshallingSequentialList$MarshallingIterator.hasNext
      1. org.openmdx.base.rest.spi.AbstractRestInteraction.execute(AbstractRestInteraction.java:458)
      2. org.openmdx.base.accessor.rest.spi.Switch_2$SwitchingInteraction.pass(Switch_2.java:254)
      3. org.openmdx.base.rest.spi.AbstractRestInteraction.find(AbstractRestInteraction.java:165)
      4. org.openmdx.base.rest.spi.AbstractRestInteraction.execute(AbstractRestInteraction.java:458)
      5. org.openmdx.base.rest.spi.AbstractRestInteraction.execute(AbstractRestInteraction.java:648)
      6. org.openmdx.base.rest.spi.ConnectionAdapter$InteractionAdapter.execute(ConnectionAdapter.java:464)
      7. org.openmdx.base.accessor.rest.AbstractContainer_1$BatchingList$BatchingIterator.load(AbstractContainer_1.java:2174)
      8. org.openmdx.base.accessor.rest.AbstractContainer_1$BatchingList$BatchingIterator.hasNext(AbstractContainer_1.java:2229)
      9. org.openmdx.base.accessor.rest.AbstractContainer_1$ChainingList$ChainingIterator.hasNext(AbstractContainer_1.java:3214)
      10. org.openmdx.base.accessor.rest.AbstractContainer_1$OrderedValues$ValueIterator.hasNext(AbstractContainer_1.java:1137)
      11. org.openmdx.base.collection.MarshallingSequentialList$MarshallingIterator.hasNext(MarshallingSequentialList.java:685)
      12. org.openmdx.base.collection.MarshallingSequentialList$MarshallingIterator.hasNext(MarshallingSequentialList.java:685)
      13. org.openmdx.base.collection.MarshallingSequentialList$MarshallingIterator.hasNext(MarshallingSequentialList.java:685)
      14. org.openmdx.base.collection.MarshallingSequentialList$MarshallingIterator.hasNext(MarshallingSequentialList.java:685)
      14 frames
    10. org.apache.jsp
      AccountRelationships_jsp._jspService
      1. org.apache.jsp.wizards.en_005fUS.AccountRelationships_jsp._jspService(AccountRelationships_jsp.java:653)
      1 frame
    11. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      1 frame
    12. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      1 frame
    13. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
      3 frames
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      1 frame
    15. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
      4 frames
    16. OpenEJB :: TomEE :: Catalina
      OpenEJBValve.invoke
      1. org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:44)
      1 frame
    17. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
      2. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
      3. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
      4. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
      5. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      6. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
      6 frames
    18. Grizzly HTTP
      AprEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:269)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
      3. org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1773)
      3 frames
    19. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      3. java.lang.Thread.run(Thread.java:662)
      3 frames