Andrewpech
(Andy Pech)
September 1, 2021, 4:16pm
1
Hi All,
We’re getting a strange error that I’ve not seen before.
Any ideas where to dig?
Record not available.
Exception caught in: Epicor.ServiceModel
Error Detail
Correlation ID: 09c871ee-fadf-4554-8222-5bd4f3550f67
Description: Record not available.
Program: Erp.Services.BO.JobClosing.dll
Method: JobOperAfterGetRows
Line Number: 1832
Column Number: 17
Table: JobAsmbl
Client Stack Trace
at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Erp.Proxy.BO.JobClosingImpl.OnChangeJobNum(String pcJobNum, JobClosingDataSet ds, String& pcMessage)
at Erp.Adapters.JobClosingAdapter.OnChangeJobNum(String pcJobNum, String& strMessage)
Real long shot on this but are in the right site?
gpayne
(Greg Payne)
September 1, 2021, 5:38pm
3
@Andrewpech Check the final operation field on JobAsmbl to be sure that is an actual operation on the job.
Andrewpech
(Andy Pech)
September 2, 2021, 2:07am
4
Hi Matt,
This is a single site, single company.
Andrewpech
(Andy Pech)
September 2, 2021, 2:08am
5
Though the final op date is set. There is no operation marked as the “final op”
I did check a few other jobs that were cutover from the legacy vantage environment and they don’t have final ops either.
gpayne
(Greg Payne)
September 2, 2021, 2:21am
6
1 Like
MattSpotts
(Matt Spotts)
January 31, 2022, 8:54pm
7
We do not have Epicare and I am looking at this issue. Can you give me insight on what this KB is about?
gpayne
(Greg Payne)
January 31, 2022, 9:09pm
8
The issue was a bad JobOper record that referenced a non-existent JobAsmbl record
MattSpotts
(Matt Spotts)
January 31, 2022, 10:31pm
9
I just discovered and repaired that. Thank you for the response though.