org.adempiere.ad.expression.exceptions.ExpressionEvaluationException: Got no result for SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS Default Value FROM C_Order WHERE C_Order_ID=@C_Order_ID@ (SQL: SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS DefaultValue FROM C_Order WHERE C_Order_ ID=1001827)

GitHub | teosarca | 3 months ago
  1. 0

    Error while fetching C_OrderLine.C_BPartner_ID default value

    GitHub | 3 months ago | teosarca
    org.adempiere.ad.expression.exceptions.ExpressionEvaluationException: Got no result for SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS Default Value FROM C_Order WHERE C_Order_ID=@C_Order_ID@ (SQL: SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS DefaultValue FROM C_Order WHERE C_Order_ ID=1001827)

    Root Cause Analysis

    1. org.adempiere.ad.expression.exceptions.ExpressionEvaluationException

      Got no result for SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS Default Value FROM C_Order WHERE C_Order_ID=@C_Order_ID@ (SQL: SELECT (CASE WHEN IsSOTrx='Y' AND IsDropShip='Y' THEN DropShip_BPartner_ID ELSE C_BPartner_ID END) AS DefaultValue FROM C_Order WHERE C_Order_ ID=1001827)

      at de.metas.ui.web.window.descriptor.sql.SqlDefaultValueExpression.evaluate()
    2. de.metas.ui
      WindowRestController.lambda$commit$1
      1. de.metas.ui.web.window.descriptor.sql.SqlDefaultValueExpression.evaluate(SqlDefaultValueExpression.java:123)
      2. de.metas.ui.web.window.descriptor.sql.SqlDefaultValueExpression.evaluate(SqlDefaultValueExpression.java:48)
      3. de.metas.ui.web.window.model.Document.provideFieldInitialValueForNewDocument(Document.java:488)
      4. de.metas.ui.web.window.model.Document.access$900(Document.java:78)
      5. de.metas.ui.web.window.model.Document$Builder.lambda$build$0(Document.java:1368)
      6. de.metas.ui.web.window.model.Document.initializeField(Document.java:405)
      7. de.metas.ui.web.window.model.Document.initializeFields(Document.java:347)
      8. de.metas.ui.web.window.model.Document.access$800(Document.java:78)
      9. de.metas.ui.web.window.model.Document$Builder.build(Document.java:1373)
      10. de.metas.ui.web.window.model.sql.SqlDocumentRepository.createNewDocument(SqlDocumentRepository.java:181)
      11. de.metas.ui.web.window.model.IncludedDocumentsCollection.createNewDocument(IncludedDocumentsCollection.java:166)
      12. de.metas.ui.web.window.model.Document.createIncludedDocument(Document.java:1076)
      13. de.metas.ui.web.window.model.DocumentCollection.getOrCreateDocumentForWriting(DocumentCollection.java:186)
      14. de.metas.ui.web.window.controller.WindowRestController.commit0(WindowRestController.java:238)
      15. de.metas.ui.web.window.controller.WindowRestController.lambda$commit$1(WindowRestController.java:231)
      15 frames
    3. org.adempiere.ad
      AbstractTrxManager.call
      1. org.adempiere.ad.trx.api.impl.TrxCallableWrappers$3.call(TrxCallableWrappers.java:151)
      2. org.adempiere.ad.trx.api.impl.TrxCallableWrappers$4.call(TrxCallableWrappers.java:180)
      3. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call0(AbstractTrxManager.java:694)
      4. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:606)
      5. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:507)
      6. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:444)
      7. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:429)
      8. org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:413)
      8 frames
    4. de.metas.ui
      WindowRestController.commit
      1. de.metas.ui.web.window.controller.Execution.callInNewExecution(Execution.java:89)
      2. de.metas.ui.web.window.controller.WindowRestController.commit(WindowRestController.java:231)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    6. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
      2 frames