ABC Code Setup Error

Daniel_White · April 4, 2024, 10:52am

I am trying to setup our training environment for our stores people so they can learn about Cycle Counting. I am trying to setup the details for ABC Code Maintenance and get this stupid error that comes up.

Its obviously one that someone setup themselves but i have looked at BPMs and BAMs and custom code and can see nothing. I have attached a trace i have done but again nothing jumps out.

Anyone have any ideas?

Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:41:22:4457763 AM 123 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:41:22:5947875 AM 58 Epicor.Mfg.BO.AbcCode Update void 04/04/2024 11:41:25:2337125 AM 62.4995 STI A 90 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadc0a5ffc 0 false 80 10.00 true false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000329292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAADKSkgAA== STI B 180 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadd0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000429292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAEKSkgAA== STI C 360 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedade0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000529292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAFKSkgAA== Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:41:52:6552071 AM 138 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:41:52:7944794 AM 62 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:42:22:8615431 AM 134 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:42:22:9972294 AM 55 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:42:53:0672868 AM 113 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:42:53:1805180 AM 53 Epicor.Mfg.BO.AbcCode Update void 04/04/2024 11:43:00:8428001 AM 86.6511 STI A 90 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadc0a5ffc 0 false 80 10.00 true false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000329292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAADKSkgAA== STI B 180 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadd0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000429292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAEKSkgAA== STI C 360 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedade0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000529292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAFKSkgAA== Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:43:23:2489591 AM 120 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:43:23:3666068 AM 48 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:43:53:4328731 AM 114 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:43:53:5446872 AM 54 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 04/04/2024 11:44:23:6131980 AM 137 '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='STINB893 1']]> Epicor.Mfg.BO.SysMonitor GetTaskHistory Epicor.Mfg.BO.SysMonitorTaskHistDataSet 04/04/2024 11:44:23:7642651 AM 48 Epicor.Mfg.BO.AbcCode Update void 04/04/2024 11:44:26:5702535 AM 51.1196 STI A 90 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadc0a5ffc 0 false 80 10.00 true false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000329292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAADKSkgAA== STI B 180 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedadd0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000429292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAEKSkgAA== STI C 360 0 0 0 0 0 false false false false false df2e5dc5-8674-c1af-e211-bedade0a5ffc 0 false 0 0 false false false 0 0 0 0 0x003d001300010000574845524520282850524f47524553535f5245434944203d20000000240008fffb0000000000000000000000000000000529292000 AD0AEwABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAJAAI//sAAAAAAAAAAAAAAAAAAAAFKSkgAA==

TDray · April 4, 2024, 11:21am

If you click detail, what does it say?

Daniel_White · April 4, 2024, 11:21am

Exception caught in: Epicor.Mfg.BO.AbcCode

Error Detail

Message: Training OOOOOPPPPPSSSSS
Type: Error
Program: bo/AbcCode/AbcCode.p
Method: Pre26_A1_execute
Table:
Row:
Field:

Stack Trace

at Epicor.Mfg.Proxy.AbcCodeImpl.Update(AbcCodeDataSet ds)
at Epicor.Mfg.UI.Adapters.AbcCodeAdapter.Update()
at Epicor.Mfg.UI.App.AbcCodeEntry.Transaction.Update()
at Epicor.Mfg.UI.FrameWork.EpiSingleViewTransaction.Epicor.Mfg.UI.FrameWork.IEpiAdapterLink.Update()
at Epicor.Mfg.UI.FrameWork.EpiViewUtils.OnUpdate(EpiTransaction trans, EpiDataView view, IEpiAdapterLink link, Boolean displayExceptions)

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.AbcCodeImpl.Update(AbcCodeDataSet ds)

TDray · April 4, 2024, 12:48pm

I was hoping the details were going to point to a specific Method Directive that was causing this but it doesn’t appear to. The error is server side and happening on the AbdCodeImpl.Update process, but not a lot of other information.

My only suggestions would be to check Event Viewer logs on the server hoping they point you somewhere.
You could also try Epicor support. They may or may not be able to point you in the direction you need to go.

Olga · April 4, 2024, 2:05pm

Search for AbcCode.p file in all server folders, maybe some interceptor left from some BPM.

Daniel_White · April 4, 2024, 2:12pm

Found it. Should i just delete the p file or make some adjustment to it?

{Bpm/Bpm.i &OBJECT_NAME=“AbcCode” &BPM_BO_SOURCE_BO=1 &CUR-COMP=“STI” &INITIALIZE}
{Bpm/MiscCallContext.i}
{Bpm/make_query.i}
{Bpm/InfoPromptAction.i}
{su/ASPExportFieldDataSet.i}{core/UserDefinedData.i “new global”}

{Bpm/BpMethod_merge.i &TT_PARAM=ttAbcCode }.

define dataset AbcCodeDataSetM for
ttAbcCodeM
.

define dataset AbcCodeDataSetB for
ttAbcCodeB
.

&global-define DECL_INPUT_PS_Update~
def input param dummy as logical no-undo.~

&global-define DECL_INPUT_FS_Update~
input dummy as logical~

&global-define USE_INPUT_S_Update~
input false~

&global-define DECL_INPUT-OUTPUT_P_Update~
def input-output param dataset for AbcCodeDataSet.~

&global-define USE_INPUT-OUTPUT_Update~
input-output dataset AbcCodeDataSet~

&global-define USE_INPUT-OUTPUT_M_Update~
input-output dataset AbcCodeDataSetM~

procedure Pre26_A1_execute:
{&DECL_INPUT-OUTPUT_P_Update}

define variable body as character no-undo.
{&TRY_PRIVATE}    

define variable body_cnt as integer no-undo.
assign body = body + 'Training OOOOOPPPPPSSSSS'.


{lib/PublishEx.i &ExMsg = body 
    &ExType   = {&MESSAGE_ERR}

}
{&THROW_PRIVATE}.
{&CATCH_PRIVATE}

end procedure.

/**********************************************************************************

Update
**********************************************************************************/

procedure Unposition_Update private:
find first ttAbcCodeS where false no-error.
end procedure.

procedure Prepare_Update private:
empty temp-table ttAbcCodeR.
empty temp-table ttAbcCodeB.
empty temp-table ttAbcCodeM.
end procedure.

function Pre26_p returns logical private ({&DECL_INPUT_FS_Update}).
return true.
end function.

{Bpm/BpMethod_select.i &METHOD=Update &DIR=Pre26 &TT_PARAM=ttAbcCode &CAN_FIND_PARENT = “true”}

procedure Update:
define input-output parameter dataset for AbcCodeDataSet.
{&TRY_PUBLIC}

run Bpm/CheckCallContext.p.
run ExtractInfoMessages.
run Prepare_Update.
	
	define variable counterProc   as handle    no-undo.
	define variable counterResult as logical   no-undo.
	define variable oldErrText    as character no-undo.
	define variable newErrText    as character no-undo.
	define variable baseRunCustom as logical   no-undo initial false.
	define variable trackState    as character no-undo.
	define variable isHandlerInvoked as logical no-undo initial false.
	
	CALL_CONTEXT_BLOCK__:
	do on error undo: /* Customized method start: */
					/* Directive #Pre26: */
					do:
						
					end.
					
		run Server/bo/BpInstanceCounter/BpInstanceCounter.p persistent set counterProc.
		
		BPM-INNER-BLOCK___:
		do on error undo, leave:
					/* Directive #Pre26: */
					do:
						run Unposition_Update.
						
						run Pre26_ttAbcCode_select ({&USE_INPUT_S_Update}).
						
						/*Add source code that should be executed before the designed actions here*/
						
						
						/* 1. RaiseExceptionActionType >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> */
						define variable xPre26_A1 as logical no-undo initial false.
						xPre26_A1 = IsTracked ("AbcCode.Update_BO_Pre26_A1").
						if not xPre26_A1 then do:
							run TrackIt ("AbcCode.Update_BO_Pre26_A1").
							run LocateBPMDataRow.
							run LocateClientRow.
							run ttAbcCode_Backup.
							
							run Pre26_A1_execute ({&USE_INPUT-OUTPUT_M_Update}).
							
							run ttAbcCode_Restore.
							run ttAbcCode_copyFromMatch.
							assign xPre26_A1 = true.
						end.
						/* <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< RaiseExceptionActionType <<< */
						
						
						/*Add source code that should be executed after the designed actions here*/
					end.
					
					if GetExceptions() <> "" then leave BPM-INNER-BLOCK___.
					
					if not IsTracked("AbcCode.Update_BO_BaseProcCall") then do:
					    run TrackIt ("AbcCode.Update_BO_BaseProcCall").
						if not baseRunCustom then do:
							
							run super (input-output dataset AbcCodeDataSet).
						end.
						
					end.
					if GetExceptions() <> "" then leave BPM-INNER-BLOCK___.
					
		end. /* BPM-INNER-BLOCK___ */
		
		delete procedure counterProc.
		
		if GetExceptions() <> "" then do: /* Rollback */
			undo, leave.
		end. /* Rollback */
		
		else do: /* Commit */
		end. /* Commit */
	finally:
		if not isHandlerInvoked then
		run UnTrackAll("AbcCode.Update_BO_").
	end finally.
	end. /* Customized method end. CALL_CONTEXT_BLOCK__ end.*/
	
	if GetExceptions() <> "" then do:
		{&THROW_PUBLIC}.
	end.
	
{&CATCH_PUBLIC}
GetInfoMessages("AbcCode.Update", DCD-USERID, CUR-COMP, CUR-PLANT).

end procedure.

Olga · April 4, 2024, 2:20pm

afair, it is file generated by BPM. It should have been removed if you don’t have BPM on ABCCOde BO or table.
If it is not, probably should be deleted… Better move it to some backup folder outside of server just in case

Daniel_White · April 4, 2024, 2:26pm

We have no BPMs on the ABCCode table so i will move it to a folder off of the sever

Daniel_White · April 4, 2024, 2:56pm

Removed the file and all works fine. Thanks Olga