Hi guys
Some software I have had running at a client's site has been doing the job, but they get about 10 of these stack trace errors a day. Looking through it I cannot see anything that helps me find the error. An internet search of the pertinent details hasn't returned anything useful either.
The application is a pallet label printing application that sits on a production floor PC. It connects via AppServer to download the data for the pallet from the server. The AppServer does not have a startup database connection. The station connects to the AppServer and loads a persistent procedure called YES-AS-PalletStationLibrary. This procedure has internal procedures to connect to the database and download data (DownloadPalletStationData).
The YES-AS-PalletStationLibrary persistent procedure also loads persistent procedures called DBLibrary.r (standard functions and procedures to get and set database records... like GetTempTableData) and Library.r (other standard functions and procedures like setting or getting registry values).
GetTempTableData is used throughout the application on both the client and AppServer which makes it hard to understand why it would crash. It uses dynamic code to create and populate dynamic temp tables using passed parameters (which DB table, the where clause, etc).
Does anyone have any advice for me? Happy to answer any questions as I am sure this is not enough information.
This is what the client provided...
ø‹D =================================================
PROGRESS stack trace as of Mon Jul 04 05:00:55 2011
=====================================================
Startup parameters:
-pf C:\sastek\oe10\startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-logginglevel 1,-logfile C:\sastek\oe10tmp\ib2.server.log,-ubpid 3728,-Ms 1,-logname ib2,-logentrytypes ASPlumbing,DB.Connects,-logthreshold 0,-numlogfiles 3,-ASID 4,-ubpropfile C:\sastek\oe10\properties\ubroker.properties,-ipver IPv4
Exception code: E0000003
Fault address: 77E4BEF7 01:0000AEF7 C:\WINDOWS\system32\kernel32.dll
Registers:
EAX:0012F4F8
EBX:00000002
ECX:00000001
EDX:00000000
ESI:00000000
EDI:00000002
CS:EIP:12001B:77E4BEF7
SS:ESP:120023:0012F4F4 EBP:0012F548
DS:0023 ES:0023 FS:003B GS:0000
Flags:00000246
Call Stack:
Address Frame
77E4BEF7 00000000 RaiseException+3C
0081E094 00000000 dbut_bufmov+44
** ABL Stack Trace **
--> GetTempTableData Foundation\Procedures\DBLibrary.p (C:\sastek\utilities\YES Software\Run Code\Foundation\Procedures\DBLibrary.r) at line 0
DownloadPalletStationData PlugIns\Inventory\YES-AS-PalletStationLibrary.r (C:\sastek\utilities\YES Software\Run Code\PlugIns\Inventory\YES-AS-PalletStationLibrary.r) at line 13869
** Persistent procedures/Classes **
Handle File Name
001001 C:\sastek\utilities\YES Software\Run Code\Foundation\Procedures\DBLibrary.r
001000 C:\sastek\utilities\YES Software\Run Code\Foundation\Procedures\Library.r
001002 C:\sastek\utilities\YES Software\Run Code\PlugIns\Inventory\YES-AS-PalletStationLibrary.r
//=====================================================
PROGRESS stack trace as of Mon Jul 04 05:00:55 2011
//=====================================================
Exception code: E0000003
Fault address: 77E4BEF7 01:0000AEF7 C:\WINDOWS\system32\kernel32.dll
Registers:
EAX:0012F4F8
EBX:00000002
ECX:00000001
EDX:00000000
ESI:00000000
EDI:00000002
CS:EIP:12001B:77E4BEF7
SS:ESP:120023:00000009 EBP:0012F548
DS:0023 ES:0023 FS:003B GS:0000
Flags:00000246
Call Stack:
Address Frame
77E4BEF7 0012F548 RaiseException+3C
0081E094 00000001 dbut_bufmov+44
Regards
Craig
I didn't see a version - that may be important to know.
In the meantime, do any of these apply to you ?
ID: P170320
Title: "Error 12001 updating record with a word index"
D: P122700
Title: "Client session crashes using add-columns-from and add-like-column"
Julian
On 5 July 2011 07:19, Beez Brothers Administrator
Hi Julian
Yes, that helps. While I have no word indices in my database, but the internal procedure (GetTempTableData) that failed uses the "add-like" functions to dynamically create temp tables to pass data from the AppServer back to the client PC. I will double check the error-handling in the code.
Can I ask how you extracted the error IDs and where the error information came from? I have never worked with stack traces before so would love to find out more about them.
Regards
Craig
OE10.1B