Progress 9.1D dump to CSV Vantage 6.10

bobshaw

New Member
if we'll meet up, buy me a beer and we'll call it even :)


i've made a few more changes, had another look at the proc today and
fixed a glitch in the array export routine

i've used the -T param to specify the target drive and dir (note: the
params are case-sensitive)

and -param to specify the file query where clause, the default is now
"where not _hidden or _file-name = '_user'"

for example -
bpro -p dump.p -db x:\mydb -T z:\dump -param "where _file-name = 'item'"


heres a short recap

to compile -
bpro -p compile.p -rx

dump while database is offline
bpro -p dump.p -db x:\mydb -T z:\dump

dump while database is online
mbpro -p dump.p -db x:\mydb -T z:\dump -Bp 50


xml, pdf, office or open office docs with office xml schemas or odf etc.
are also doable.

its been fun, hope to talk to you again
Hi all I apologize for resurrecting an old thread but I'm pulling out my few remaining hairs. I am using the code quoted above on a Progress 9.1D db and for some reason it stops before dumping all of the tables. More specifically the last table it dumps begins with a "P" so any table alphabetically after that doesn't get dumped. Total files dumped is 578 at 950MB. I originally thought it was a disk space / format issue so I tried dumping to a different drive and ended up with the same amount of files. Any thoughts or suggestions? I appreciate any or all help.

Edit: Proenv does not display any error messages to assist with troubleshooting.
 
Last edited:

cj_brandt

Active Member
memory is a bit foggy after 10 years, but I'd try creating a batch file to dump a couple tables. If it works try a few more tables, if it doesn't work look at the message produced.
 

Cringer

ProgressTalk.com Moderator
Staff member
Is the last table dumped complete? Anything in the database logfiles?
 

bobshaw

New Member
Wow thank you both for your quick replies. I was in the process of figuring out how to do the batch file when the second post came through. Opened up the last table (labeled prcheck) and it contained the following error-
** "db/trg/prcheck/find.p" was not found. (293)
Contents of the log file around the time I was attempting this:
Thu May 28 16:16:58 2020
16:16:58 BROKER 0: Multi-user session begin. (333)
16:16:58 BROKER 0: Begin Physical Redo Phase at 288 . (5326)
16:17:05 BROKER 0: Physical Redo Phase Completed at blk 871 off 5589 upd 389. (7161)
16:17:05 BROKER 0: Started for 6100 using TCP, pid 884. (5644)
16:17:05 BROKER 0: Connecting to Admin Server on port 7835. (8836)
16:17:10 BROKER 0: Registered with Admin Server. (8846)
16:17:10 BROKER 0: PROGRESS Version 9.1D on WINNT. (4234)
16:17:10 BROKER 0: Server started by SYSTEM on CON:. (4281)
16:17:10 BROKER 0: Started using pid: 884. (6574)
16:17:10 BROKER 0: Physical Database Name (-db): C:\EPICOR\Mfgsys61\Db\mfgsys. (4235)
16:17:10 BROKER 0: Database Type (-dt): PROGRESS. (4236)
16:17:10 BROKER 0: Force Access (-F): Not Enabled. (4237)
16:17:10 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
16:17:10 BROKER 0: Number of Database Buffers (-B): 168. (4239)
16:17:10 BROKER 0: Maximum private buffers per user (-Bpmax): 42. (9422)
16:17:10 BROKER 0: Excess Shared Memory Size (-Mxs): 16390. (4240)
16:17:10 BROKER 0: The shared memory segment is not locked in memory. (10014)
16:17:10 BROKER 0: Current Size of Lock Table (-L): 409600. (4241)
16:17:10 BROKER 0: Hash Table Entries (-hash): 43. (4242)
16:17:10 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
16:17:10 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
16:17:10 BROKER 0: Crash Recovery (-i): Enabled. (4244)
16:17:10 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
16:17:10 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
16:17:10 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
16:17:10 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
16:17:10 BROKER 0: Before-Image Cluster Size: 131072. (4250)
16:17:10 BROKER 0: Before-Image Block Size: 8192. (4251)
16:17:10 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
16:17:10 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
16:17:10 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
16:17:10 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
16:17:10 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
16:17:10 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
16:17:10 BROKER 0: Maximum Number of Clients Per Server (-Ma): 5. (4257)
16:17:10 BROKER 0: Maximum Number of Servers (-Mn): 5. (4258)
16:17:10 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
16:17:10 BROKER 0: Maximum Number of Users (-n): 21. (4260)
16:17:10 BROKER 0: Host Name (-H): atlantic7. (4261)
16:17:10 BROKER 0: Service Name (-S): 6100. (4262)
16:17:10 BROKER 0: Network Type (-N): TCP. (4263)
16:17:10 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
16:17:10 BROKER 0: Parameter File: Not Enabled. (4282)
16:17:10 BROKER 0: Maximum Servers Per Broker (-Mpb): 4. (5647)
16:17:10 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
16:17:10 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
16:17:10 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
16:17:10 BROKER 0: SQL Server Stack Size (-SQLStack): 1000. (10026)
16:17:10 BROKER 0: SQL Server Statement Cache Size (-SQLStmtCache): 100. (10027)
16:17:10 BROKER 0: SQL Server Max Open Cursors (-SQLCursors): 50. (10028)
16:17:10 BROKER 0: Large database file access has been enabled. (9426)
16:17:10 BROKER 0: Created shared memory with segment_id: 11534336 (9336)
16:17:13 BIW 5: Started. (2518)
16:17:15 WDOG 6: Started. (2518)
16:17:17 APW 7: Started. (2518)
16:23:17 Usr 8: Login by administrator1 on CON:. (452)
16:23:18 Usr 8: Logout by administrator1 on CON:. (453)
16:24:03 Usr 8: Login by administrator1 on CON:. (452)
16:24:03 Usr 8: Logout by administrator1 on CON:. (453)
16:27:19 Usr 8: Login by administrator1 on CON:. (452)
16:27:19 Usr 8: Logout by administrator1 on CON:. (453)
16:31:17 Usr 8: Login by administrator1 on CON:. (452)
16:31:17 Usr 8: Logout by administrator1 on CON:. (453)
16:34:30 Usr 8: Login by administrator1 on CON:. (452)
17:59:25 Usr 8: Logout by administrator1 on CON:. (453)

And if any of this looks like I don't know what I am doing its because I don't! haha
 

cj_brandt

Active Member
Originally this post was about dumping data from a Progress database medman which was used in an application called intergy. You are using a different application, but still are trying to dump data from a Progress database - C:\EPICOR\Mfgsys61\Db\mfgsys. (4235). I think you want to start a new thread and state what you are trying to do.

Include the types of licenses you have available on the server - you can just list the name of the license - not the control codes. There is an icon in the progress folder to display the licenses.
 

bobshaw

New Member
Hi all! I'm currently attempting to dump a Progress 9.1D db into csv files. We are currently using an antique Epicor product called Vantage 6.1 and are preparing to switch to a more modern ERP software. I was attempting to use the code in this post:

edit: I can't post links but it is the post titled "Trying to dump database to csv file" on this site

but ran into one issue. Output format looks great but for some reason it stops creating CSVs after a certain point. The files are created in alphabetical order and it currently stops in the "P" range-same table every time. Total files dumped is 578 at 950MB. I originally thought it was a disk space / format issue so I tried dumping to a different drive and ended up with the same amount of files. The last table dumped (which is labeled prcheck ) contains this message:

** "db/trg/prcheck/find.p" was not found. (293)

So on a random shot I deleted that table (this is a test rig) and the output stopped on the next table which is labeled "prchkded" with the following error message:

** "db/trg/prchkded/find.p" was not found. (293)

So I'm guessing I'm hitting some limit somewhere but I'm not sure where to go next.
Licenses are as follows:
Progress 9.1D
Enterprise DB
Client Networking
Query/Results
Report Builder
SQL Server Enterp
Running on Windows Server 2003

Any and all help is appreciated

Log file only contains:
13:08:08 Usr 9: Login by administrator1 on CON:. (452)
14:03:42 Usr 9: Logout by administrator1 on CON:. (453)
 
Last edited:

Stefan

Well-Known Member
** "db/trg/prcheck/find.p" was not found. (293)

So on a random shot I deleted that table (this is a test rig) and the output stopped on the next table which is labeled "prchkded" with the following error message:

** "db/trg/prchkded/find.p" was not found. (293)

So I'm guessing I'm hitting some limit somewhere but I'm not sure where to go next.
The errors are due to the find trigger firing but the procedure for the find trigger not being available.

If you are in luck you can disable the find triggers by modifying the code you are using to include (see: OpenEdge 11.7 Documentation)

Code:
...
procedure exportBuffer:

    define input param phBuffer as handle no-undo.

    phBuffer:disable-dump-triggers().
...

If you cannot override the find trigger (this is determined by the schema) then you may be able to put dummy procedures in place, but that may be blocked by a crc check on the procedure. Your only option is then to modify the schema.
 

bobshaw

New Member
The errors are due to the find trigger firing but the procedure for the find trigger not being available.

If you are in luck you can disable the find triggers by modifying the code you are using to include (see: ...)

Code:
...
procedure exportBuffer:

    define input param phBuffer as handle no-undo.

    phBuffer:disable-dump-triggers().
...

If you cannot override the find trigger (this is determined by the schema) then you may be able to put dummy procedures in place, but that may be blocked by a crc check on the procedure. Your only option is then to modify the schema.

That worked great when I used a different code . Thank you so much for the help!!!
 
Last edited:
Top