Search results

Our database is around 20GB and it's set up as UTF-8. The dump takes about 3 hours, loading takes about 4~5 hours. The filesystem is a on a NAS box that gives me a throughput of up to 60MB per second. The machine itself is a VMWare ESX environment with Linux ES, the hardware underneath is some...

I use this in my client startscript (Linux box): LIMIT=2 COUNT=`who | grep $LOGNAME | wc -l | awk '{print $1}'` # If the user has more then $LIMIT sessions open, kick him/her out immediately if [ "$COUNT" -gt "$LIMIT" ] then echo "`date +%y%m%d-%H%M` Login refused for $LOGNAME, limit...

Hi guys, AI isn't troubling us. I have variable extents and rotate them once an hour. Every Saturday night the db is taken down for an offline backup and the AI's are emptied (on working days the system must be up 24 hours since we are a global company). I can't speak freely since we are under...

After this weekend, I found a few 'hanging' transactions again, see below: 14:57:47 ProTop xx -- Progress Database Monitor 11/10/08 Summary mfgprod [/mfg/data/db2/mfgprod] Rate Hit Ratio: 3713:1 324:1 Commits: 10...

Hi Folks, Is it possible to find the table/record from transaction id only? We use MFG/Pro together with QXtend on OpenEdge 10.1B03 on a Linux box. Occasionally QXtend leaves an open transaction behind, causing our BI file to grow until the database is taken down for backup on Saturday night...

Casper, Tom, Thanks guys! It was a record in area #9 (static data) containing pricelists. One record was missing there (when compared to test). I managed to reload it. These are crafty little programs, I'll add them to my toolbox ;) Willem (who can now happily continue his vacation)

Occasionally we have an error in the database (10.1B) "index for recid # could not be deleted". It is then impossible to remove/update a record in the database using standard software or the progress editor. When this happens, we dump the record, remove it using "proutil -C idxfix" and then...

Hi Chris, I just received a private message from "Jeanette" which I would classify as spam. Unfortunately there is no "Report Post" button for private messages, so forgive me for posting here ;-) Rgds, Willem

Rough guess: About twice as fast... Both database and BI reside on the same filesystem. After the weekly backup, this is is approx. 50% full, with the BI truncated. In the past, after a whole week's work, database + BI would grow to 65~70% full (20% increase). Now, with 10.1B03 it grows to...

We upgraded from Progress 9.1E05 to 10.0B01 and recently moved to 10.1B03. With 10.1B03 it seems that our BI file is growing much faster then with previous versions of Progress. Can anyone confirm that?

Hi Sharkdim, I'm actually weary about using triggers, since a lot of our customised software (as developed by QAD) relies on triggers. Setting triggers in our own programs would then overrule those created by QAD, making the software flakey. I prefer wrappers. My 2 cents. Regards, -Willem.

Can the editor be restricted to querying only? I'm looking for a way that MFG/Pro should work normally, but when a user gets into the editor, that he cannot do updates to the database. Someone here is in a position where he can demand access to the editor -business reasons-, but I want to...

I would actually write a wrapper program for Sales Order maintenance, so that at the exit a routine would check the sales order lines for qty = 0. something like this: {mfdeclre.i} {gprun.i ""sosomt.p""} /* catch sales order number here */ /* find sales order lines with qty = 0 */ /* if...

AFAIK there is no batch delete in Sales Orders. Press Ctrl-F in a sales order to find out: ┌──────────────────────────── Program Information ─────────────────────────────┐ │ Table.Field: so_mstr.so_ord_date │ │ Description: Sales Order Master...

Found it... The first condition is that the order currency differs from base currency. The second is that the order is still unconfirmed.

Does anyone know under what conditions the exchange rate frame pops up when in Sales Order Maintenance? One thing is that the order currency is different from base currency, but more conditions seem to apply. Any hint is welcome.

As far as I know, there is no batch delete for sales orders. When nothing has been shipped, the sales order can be deleted at header level. When something has been shipped, the only way is via Invoice print and Invoice post.

Hi Nimra, There are several topics here that cover cimming. There you should find enough examples to get you going. Regards, Willem.

You can retrieve the fields quite easily. It is important to realise that a cim is considered a batch process and programs may behave differently then. This can be simulated from the editor like this: {mfdeclre.i} assign batchrun = true. {gprun.i ""apvomt.p""} This will start voucher...

Note that you may have to use variable length cim files. E.g. we use cim's to update duedates in existing sales orders, but depending on whether the line is confirmed or unconfirmed, there is an extra field to skip. The same goes for transaction comments. I solved this by creating a program...