Error while adding assembly

Kinetic 202X
1

Hello Team,

In one job we are facing issues while adding sub assembles.
Please advise.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Application Error

Exception caught in: Epicor.ServiceModel

Error Detail

Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Program: Epicor.ServiceModel.dll
Method: CallWithCommunicationFailureRetry

Client Stack Trace

at Ice.Cloud.ProxyBase1.CallWithCommunicationFailureRetry(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, RestRpcValueSerializer serializer) at Ice.Cloud.ProxyBase1.CallWithMultistepBpmHandling(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
at Ice.Cloud.ProxyBase`1.Call(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
at Erp.Proxy.BO.JobEntryImpl.Update(JobEntryDataSet ds)
at Erp.Adapters.JobEntryAdapter.OnUpdate()
at Ice.Lib.Framework.EpiBaseAdapter.Update()
at Erp.UI.App.JobEntry.Transaction.Update()

Thanks
Rishi Raj

2

This happens when you are bringing in a subquery as data in your row. If your subquery brings in more than one data row it will give you this error. I would check your subquery and make sure it’s returning one data row per record you are attaching to.

1 Like
3

Hello Dough,

I have not done any change in query or written any directive method.
I am using as per standard Epicor.

Is there anyway I can look and identify the issue.

Thanks

Br,
Rishi raj

4

If the query did not change then the data did. Look at the sub query and if possible run it on its own. Something is returning two rows where it did not before. If it is sub assemblies, then maybe you have two approved. You might need to do a group by in the subquery to guarantee only one row.

5

Hello Greg,

Thanks for the suggestion, it did took sometime but got this resolved with qery.

Thanks
Rishi Raj