Hi all,
We had a big problem over our weekend and we got most of it fixed but now Epicor Task Agent refuses to function properly. This is what it says in the appserver logs:
[20/11/17@03:24:47.235-0500] P-011332 T-011336 1 AS – SYSTEM ERROR: Index RunInfo in SysAgentSched for recid 79515037 could not be deleted. (1422)
[20/11/17@03:24:47.235-0500] P-011332 T-011336 1 AS – ** ABL Debug-Alert Stack Trace **
[20/11/17@03:24:47.235-0500] P-011332 T-011336 1 AS – --> updateSched agent/TaskAgent.p (E:\Epicor905\Server\agent\TaskAgent.r) at line 2471
[20/11/17@03:24:47.235-0500] P-011332 T-011336 1 AS – agent/TaskAgent.p (E:\Epicor905\Server\agent\TaskAgent.r) at line 1959
[20/11/17@03:24:47.236-0500] P-011332 T-011336 3 AS AS – TRACE: Non-PERSISTENT Procedure END STOP. (8397)
When I exit out of my database client it says:
Exception caught in: Epicor.Mfg.BO.GenXData
Error Detail
Message: This is a duplicate entry of an existing record.
Type: Error
Program: bo/GenXData/GenXData.p
Method: StoreData
Table: XXXDef
Row:
Field:
Stack Trace
at Epicor.Mfg.Proxy.GenXDataImpl.StoreData(GenXDataDataSet ds)
at Epicor.Mfg.UI.FrameWork.GenXObject.handleChunkAndSave(Boolean doCompression, String company, String productID, String typeCode, String cgcCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Epicor.Mfg.UI.FrameWork.GenXObject.ChunkNSaveStringByID(String company, String productID, String typeCode, String cgcCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Epicor.Mfg.UI.FrameWork.GenXObject.ChunkNSaveStringByID(String company, String productID, String typeCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Epicor.Mfg.UI.FrameWork.FormFunctions.ChunkNSaveStringByID(Object sender, String company, String productID, String typeCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
Inner Exception
ERROR condition: The Server application has returned an error. (7243) (7211)
Inner Stack Trace
at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Core.CallContext.CallContextPersistentProc.runProcedure(String procedureName, ParameterSet parameters, MetaSchema metaSchema)
at Epicor.Mfg.Core.CallContext.ProxyHelper.CallMethod(String methodName, ParameterSet parameters, MetaSchema metaSchema, BLConnectionPool connPool, Session connection, PersistentProc persistProc, CallContextDataSet callContextDataSet)
at Epicor.Mfg.Proxy.GenXDataImpl.StoreData(GenXDataDataSet ds)
So our database comes up and runs but we cannot process anything. I have been working all night on this problem and really need some Epicor expertise to solve it. Please call me as soon as you are able to. Would sure appreciate it.
Thanks,
Jill Schoedel
Metalworks
231-845-3148