Error when trying to delete an order

This is definitely bpm related, even if they are not active the compiled
code is still lurking out there, and when the schema changes between
releases this is the error you get if you don't recompile the bpms. To
recompile find one on the sales order then make it active, save it the
make it inactive again. (or find an active on, make it inactive, save,
then make active again).



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Roberts
Sent: Friday, February 18, 2011 10:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Error when trying to delete an order





I am seeing an unusual error when trying to delete any sales order in
9.05.602a. Error message & details below. This occurs for all sales
orders, including immediately after creating a brand new one with header
only -- no details, no shipments against it, etc. We have no BPMs
active and we get the same error with our screen customization disabled.
A support has been placed to Epicor, but has not produced a solution.
I'm hoping somebody here will have seen the error and could point me in
the right direction.

Error popup after clicking delete: "Unexpected error - see appserver
logs."

And the results choosing Detail on that error message is attached.

The log has these 2 lines:

[11/02/18@09:31:20.695-0500] P-001596 T-005744 1 AS -- (Procedure:
'Update bo/SalesOrder/SalesOrder.p' Line:0) The caller's temp-table
parameter ttOrderHed does not match to the target temp-table ttOrderHed.
(5363)

[11/02/18@09:31:20.695-0500] P-001596 T-005744 1 AS -- (Procedure:
'Update bo/SalesOrder/SalesOrder.p' Line:0) Parameters for procedure
Update bo/SalesOrder/SalesOrder.p (table ttOrderHed and table
ttOrderHed) do not match. (12311)

Any suggestions?

Thanks,

Brian Roberts

Business Systems Analyst

Ground Effects Ltd

-----Original Message-----

Exception caught in: Epicor.Mfg.AD.SalesOrder

Error Detail

============

Message: Unexpected error - see appserver logs.

Type: Error

Program:

Method:

Table:

Row:

Field:

Stack Trace

===========

at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Delete(DataRow dr)

at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Delete()

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(Strin

g 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.SalesOrderImpl.Update(SalesOrderDataSet ds)

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I am seeing an unusual error when trying to delete any sales order in
9.05.602a. Error message & details below. This occurs for all sales
orders, including immediately after creating a brand new one with header
only -- no details, no shipments against it, etc. We have no BPMs
active and we get the same error with our screen customization disabled.
A support has been placed to Epicor, but has not produced a solution.
I'm hoping somebody here will have seen the error and could point me in
the right direction.



Error popup after clicking delete: "Unexpected error - see appserver
logs."

And the results choosing Detail on that error message is attached.



The log has these 2 lines:

[11/02/18@09:31:20.695-0500] P-001596 T-005744 1 AS -- (Procedure:
'Update bo/SalesOrder/SalesOrder.p' Line:0) The caller's temp-table
parameter ttOrderHed does not match to the target temp-table ttOrderHed.
(5363)

[11/02/18@09:31:20.695-0500] P-001596 T-005744 1 AS -- (Procedure:
'Update bo/SalesOrder/SalesOrder.p' Line:0) Parameters for procedure
Update bo/SalesOrder/SalesOrder.p (table ttOrderHed and table
ttOrderHed) do not match. (12311)



Any suggestions?





Thanks,



Brian Roberts

Business Systems Analyst

Ground Effects Ltd





-----Original Message-----



Exception caught in: Epicor.Mfg.AD.SalesOrder



Error Detail

============

Message: Unexpected error - see appserver logs.

Type: Error

Program:

Method:

Table:

Row:

Field:







Stack Trace

===========

at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Delete(DataRow dr)

at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Delete()



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(Strin

g 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.SalesOrderImpl.Update(SalesOrderDataSet ds)











[Non-text portions of this message have been removed]