Hi,
I was wondering if someone could help me out with an MRP error we have been receiving since last Friday. We are getting this on both production and test. Any insight is appreciated.
12:42:17 Beginning of Delete Unfirm Jobs
13:02:17 Site: MfgSys After Delete of Table: ShopLoad
13:02:17 Site: MfgSys After Delete of Table: JobAudit
13:02:18 Site: MfgSys After Delete of Table: PcValueGrp for JobHead
13:02:18 Site: MfgSys After Delete of Table: PcValueHead for JobHead
13:02:18 Site: MfgSys After Delete of Table: PcValueSet for JobHead
13:02:18 Site: MfgSys After Delete of Table: JobMtlRestriction
13:02:18 Site: MfgSys After Delete of Table: JobMtlRefDes
13:02:18 Site: MfgSys After Delete of Table: JobMtlInsp
13:02:18 Site: MfgSys After Delete of Table: JobMtlRestrictSubst
13:02:18 Site: MfgSys After Delete of Table: PcValueGrp for JobMtl
13:02:18 Site: MfgSys After Delete of Table: PcValueHead for JobMtl
13:02:18 Site: MfgSys After Delete of Table: PcValueSet for JobMtl
13:02:18 Site: MfgSys After Backout for JobMtl
13:02:19 Site: MfgSys After Delete of Table: JobMtl
13:02:19 Site: MfgSys After Delete of Table: JobOperInsp
13:02:20 Site: MfgSys After Delete of Table: JobOper
13:02:20 Site: MfgSys After Delete of Table: JobOpDtl
13:02:20 Site: MfgSys After Delete of Table: JobOperRestriction
13:02:20 Site: MfgSys After Delete of Table: JobOperRestrictSubst
13:02:20 Site: MfgSys After Delete of Table: PartSug
13:02:20 Site: MfgSys After Delete of Table: PcValueGrp for JobAsmbl
13:02:20 Site: MfgSys After Delete of Table: PcValueHead for JobAsmbl
13:02:20 Site: MfgSys After Delete of Table: PcValueSet for JobAsmbl
13:02:21 Site: MfgSys After BackOut of JobAsmbl
13:02:21 Site: MfgSys After Delete of Table: JobAsmbl
13:02:21 Site: MfgSys After Delete of Table: JobAsmblRestriction
13:02:21 Site: MfgSys After Delete of Table: JobAsmblInsp
13:02:21 Site: MfgSys After Delete of Table: JobAsmblRestrictSubst
14:02:21 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
14:02:21 The wait operation timed out
14:02:21 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
14:02:21 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Erp.Internal.MR.MrpExp.deleteUnfirmJob(String vPlantList) in C:\_Releases\ERP\ERP10.2.400.0\Source\Server\Internal\MR\MrpExp\MrpExp.cs:line 2064 at Erp.Internal.MR.MrpExp.main_block(List1 ttMrpProcRows, List`1 ttMrpQueueRows) in C:_Releases\ERP\ERP10.2.400.0\Source\Server\Internal\MR\MrpExp\MrpExp.cs:line 2721
at Erp.Internal.MR.MrpExp.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\ERP10.2.400.0\Source\Server\Internal\MR\MrpExp\MrpExp.cs:line 926
14:02:21 The wait operation timed out
14:02:21 Unexpected Error - Cancelling MRP - MrpExp
14:02:23 Cancelling from MrpExp stopProcesses