.p program newbie question

Yahoo Archive
1
I changed the file name as you suggested. At this point, I no longer get an error message, but I don't have a test.xml file, either. I took Karen's suggestion to look in my server log file. There are NO messages in the file at or after the time I change an order release. Just to ensure the event was getting triggered, I also have an email sent out at the same time. I get the email just fine.

Here is my revised code:

{ud/GlbAlert.i &TableName = "Orderrel"}

define variable OutputXMLFileName as character no-undo.

OutputXMLFileName = 'c:\test.xml'.

if not DumpRecordAsXMLFile(input OutputXMLFileName) then return error.



Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of DD
Sent: Friday, February 20, 2009 12:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] .p program newbie question

Check the OutputXMLFileName = '\\db1\Epicor\ ' Is there a space in the filename after the last \ ?
Is there permission to write to \\db1\Epicor? You might try writing to "C:\test.xml" to see if there is a problem with the filename.Â

--- On Fri, 2/20/09, Thomas Rose <t.rose@...> wrote:

From: Thomas Rose <t.rose@...>
Subject: [Vantage] .p program newbie question
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Friday, February 20, 2009, 1:59 PM

I'm trying my first progress program. I have it set up to run as an alert program when an order release is updated. I want to dump my order release record as an xml file. I copied the code almost verbatim from the example on p. 467 of the Epicor Tools User Guide. The notable exception is that I changed the output file name and I dropped the comments. Here is my code:

{ud/GlbAlert. i &TableName = "Orderrel"}
define variable OutputXMLFileName as character no-undo.
OutputXMLFileName = '\\db1\Epicor\ ' + string(orderrel. ordernum) + '-' + string(orderrel. orderline) + '-' + string(orderrel. orderrelnum) + '.xml' .
if not DumpRecordAsXMLFile (input OutputXMLFileName) then return error.

When I turn on the alert, I get the following error/stack trace whenever I update an order release. What am I doing wrong?

Error Detail
============
4GL STOP condition: The Server application has returned an error. (7243) (7241)

Stack Trace
===========
at Progress.Open4GL. DynamicAPI. Session.runProce dure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL. DynamicAPI. Session.runState lessProcedure( 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.Proxy. SalesOrderImpl. Update(SalesOrde rDataSet ds)
at Epicor.Mfg.UI. Adapters. SalesOrderAdapte r.Update( )
at Epicor.Mfg.UI. App.SalesOrderEn try.Transaction. Update()

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror. com

[Non-text portions of this message have been removed]
2
I'm trying my first progress program. I have it set up to run as an alert program when an order release is updated. I want to dump my order release record as an xml file. I copied the code almost verbatim from the example on p. 467 of the Epicor Tools User Guide. The notable exception is that I changed the output file name and I dropped the comments. Here is my code:

{ud/GlbAlert.i &TableName = "Orderrel"}
define variable OutputXMLFileName as character no-undo.
OutputXMLFileName = '\\db1\Epicor\' + string(orderrel.ordernum) + '-' + string(orderrel.orderline) + '-' + string(orderrel.orderrelnum) + '.xml' .
if not DumpRecordAsXMLFile(input OutputXMLFileName) then return error.

When I turn on the alert, I get the following error/stack trace whenever I update an order release. What am I doing wrong?

Error Detail
============
4GL STOP condition: The Server application has returned an error. (7243) (7241)


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.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()


Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror.com
3
Check your server log file for more info on the error

--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> I'm trying my first progress program. I have it set up to run as
an alert program when an order release is updated. I want to dump my
order release record as an xml file. I copied the code almost
verbatim from the example on p. 467 of the Epicor Tools User Guide.
The notable exception is that I changed the output file name and I
dropped the comments. Here is my code:
>
> {ud/GlbAlert.i &TableName = "Orderrel"}
> define variable OutputXMLFileName as character no-undo.
> OutputXMLFileName = '\\db1\Epicor\' + string(orderrel.ordernum) + '-
' + string(orderrel.orderline) + '-' + string(orderrel.orderrelnum)
+ '.xml' .
> if not DumpRecordAsXMLFile(input OutputXMLFileName) then return
error.
>
> When I turn on the alert, I get the following error/stack trace
whenever I update an order release. What am I doing wrong?
>
> Error Detail
> ============
> 4GL STOP condition: The Server application has returned an error.
(7243) (7241)
>
>
> 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.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
>
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
> www.electricmirror.com
>
4
Check the OutputXMLFileName = '\\db1\Epicor\ ' Is there a space in the filename after the last \ ?
Is there permission to write to \\db1\Epicor? You might try writing to "C:\test.xml" to see if there is a problem with the filename.Â

--- On Fri, 2/20/09, Thomas Rose <t.rose@...> wrote:

From: Thomas Rose <t.rose@...>
Subject: [Vantage] .p program newbie question
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Friday, February 20, 2009, 1:59 PM






I'm trying my first progress program. I have it set up to run as an alert program when an order release is updated. I want to dump my order release record as an xml file. I copied the code almost verbatim from the example on p. 467 of the Epicor Tools User Guide. The notable exception is that I changed the output file name and I dropped the comments. Here is my code:

{ud/GlbAlert. i &TableName = "Orderrel"}
define variable OutputXMLFileName as character no-undo.
OutputXMLFileName = '\\db1\Epicor\ ' + string(orderrel. ordernum) + '-' + string(orderrel. orderline) + '-' + string(orderrel. orderrelnum) + '.xml' .
if not DumpRecordAsXMLFile (input OutputXMLFileName) then return error.

When I turn on the alert, I get the following error/stack trace whenever I update an order release. What am I doing wrong?

Error Detail
============
4GL STOP condition: The Server application has returned an error. (7243) (7241)

Stack Trace
===========
at Progress.Open4GL. DynamicAPI. Session.runProce dure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL. DynamicAPI. Session.runState lessProcedure( 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.Proxy. SalesOrderImpl. Update(SalesOrde rDataSet ds)
at Epicor.Mfg.UI. Adapters. SalesOrderAdapte r.Update( )
at Epicor.Mfg.UI. App.SalesOrderEn try.Transaction. Update()

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror. com



















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



If you have a message similar to this in your server log file (one we
received with the same errors you had (7243) (7241))



'db/trg/DemandSchedule/write.p' Line:492) 40001: [Microsoft][SQL Native
Client][SQL Server]Transaction (Process ID 117) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.



We used this resolution:



1. Go the Vantage/Vista server.

2. Go to Start->Programs->Open Edge 10.0B->Progress Explorer Tool.

3. Expand the Database folder to MfgSys80, to Configurations, to

DefaultConfiguration.

4. Right-click on DefaultConfiguration and choose Properties.

5. Increase the # Lock Table Entries.

6. Increase that number to 409600 or higher. A multiple of 8192 is

recommended by Progress.

7. Click OK to save the changes.



These changes will not take effect until the DB is stopped and restarted

in the Progress Explorer Tool as follows: (not given this information,
but there is a certain order to stop/start)



Karen S









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Friday, February 20, 2009 2:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: .p program newbie question



Check your server log file for more info on the error

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Thomas Rose <t.rose@...> wrote:
>
> I'm trying my first progress program. I have it set up to run as
an alert program when an order release is updated. I want to dump my
order release record as an xml file. I copied the code almost
verbatim from the example on p. 467 of the Epicor Tools User Guide.
The notable exception is that I changed the output file name and I
dropped the comments. Here is my code:
>
> {ud/GlbAlert.i &TableName = "Orderrel"}
> define variable OutputXMLFileName as character no-undo.
> OutputXMLFileName = '\\db1\Epicor\' + string(orderrel.ordernum) + '-
' + string(orderrel.orderline) + '-' + string(orderrel.orderrelnum)
+ '.xml' .
> if not DumpRecordAsXMLFile(input OutputXMLFileName) then return
error.
>
> When I turn on the alert, I get the following error/stack trace
whenever I update an order release. What am I doing wrong?
>
> Error Detail
> ============
> 4GL STOP condition: The Server application has returned an error.
(7243) (7241)
>
>
> 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.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
>
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com
>





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