Error Closing Job

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?

@Andrewpech Check the final operation field on JobAsmbl to be sure that is an actual operation on the job.

Hi Matt,
This is a single site, single company.

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.

@Andrewpech Unless this is your case there is a KB from a day ago on EpicCare. KB0051429 There is a datafix.

https://epiccare.epicor.com/epiccare?id=epiccare_kb_article&sys_id=ce170f87dbb0fbc098710c65ca96197a&table=kb_knowledge

1 Like

We do not have Epicare and I am looking at this issue. Can you give me insight on what this KB is about?

The issue was a bad JobOper record that referenced a non-existent JobAsmbl record

I just discovered and repaired that. Thank you for the response though.