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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by teosarca
, 7 months ago
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)
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(SqlDefaultValueExpression.java:123)
at de.metas.ui.web.window.descriptor.sql.SqlDefaultValueExpression.evaluate(SqlDefaultValueExpression.java:48)
at de.metas.ui.web.window.model.Document.provideFieldInitialValueForNewDocument(Document.java:488)
at de.metas.ui.web.window.model.Document.access$900(Document.java:78)
at de.metas.ui.web.window.model.Document$Builder.lambda$build$0(Document.java:1368)
at de.metas.ui.web.window.model.Document.initializeField(Document.java:405)
at de.metas.ui.web.window.model.Document.initializeFields(Document.java:347)
at de.metas.ui.web.window.model.Document.access$800(Document.java:78)
at de.metas.ui.web.window.model.Document$Builder.build(Document.java:1373)
at de.metas.ui.web.window.model.sql.SqlDocumentRepository.createNewDocument(SqlDocumentRepository.java:181)
at de.metas.ui.web.window.model.IncludedDocumentsCollection.createNewDocument(IncludedDocumentsCollection.java:166)
at de.metas.ui.web.window.model.Document.createIncludedDocument(Document.java:1076)
at de.metas.ui.web.window.model.DocumentCollection.getOrCreateDocumentForWriting(DocumentCollection.java:186)
at de.metas.ui.web.window.controller.WindowRestController.commit0(WindowRestController.java:238)
at de.metas.ui.web.window.controller.WindowRestController.lambda$commit$1(WindowRestController.java:231)
at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$3.call(TrxCallableWrappers.java:151)
at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$4.call(TrxCallableWrappers.java:180)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call0(AbstractTrxManager.java:694)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:606)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:507)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:444)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:429)
at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:413)
at de.metas.ui.web.window.controller.Execution.callInNewExecution(Execution.java:89)
at de.metas.ui.web.window.controller.WindowRestController.commit(WindowRestController.java:231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.