Search results

Hello-Over the past few months we've been experiencing some performance issues, so we've been reviewing all Progress, network, OS etc....settings trying to determine where the problem might be. We're on Progress 10.2B07, AIX 64 bit. We noticed that the -B (blocksindatabasebuffers) param was set...

Hello-We are Progress 10.2B007 (will be upgrading this fall when the newest version of our ERP software is released). My understanding has been that we should be able to add new fields to existing tables while the database is online. We have done so many times in the past by loading a .df that...

Hi All-I am opening Internet Explorer from a Progress program (10.2B0709) using the following method: CREATE "InternetExplorer.Application" oExplorer. oExplorer:Visible = True. oExplorer:Navigate("www.testsite.com"). Is there a way I can get the IE Window to be on top of other windows when it...

Hello-We are on version 10.2B0709. We have type 2 storage areas. Database size is 350 GB. Database resides on an IBM AIX system. We have been told by two different Progress consultants that since we are on type 2 storage areas, we should not need to do dump and loads...that doing an index...

Hello-We have a warm spare disaster recovery site. We sync our after image files to it and roll them forward via scripts. If we make schema changes to the source (production) db, what is the process for applying those changes to the target (DR) database? In the past we've always ran a backup of...

Hello-A new programmer here asked me a question and I want to make sure there isn't a way to do this that I am missing. I know how to create dymanic queries...is it possible to create dynamic assign statements? Example (a very simple one...our real life scenario is more complex) A window has...

I posted this recently in the SQL forum and did not see any responses. Thought I'd cross post to development in case some of you on that forum have any thoughts. Thanks. Hello All-Our ERP system is SX.enterprise, version 6.0.060, running Progress version 10.2B04. We are in the process of...

Hello All-Our ERP system is SX.enterprise, version 6.0.060, running Progress version 10.2B04. We are in the process of designing a data warehouse and are investigating options for syncing the data in the Progress SX.enterprise database with the data warehouse SQL database. We came up with a high...

Hello-We just upgraded from OpenEdge 10.0B to 10.2B. Our database and appservers run on an AIX machine. We are finding that our memory usage has beyond doubled....we are swapping right now and will be running out of paging space within hours. Help! I compared our ubroker and conmgr properties...

Hello-We are in the process of upgrading from OpenEdge 10.0B to 10.2B. We are seeing a lot more memory usage in both the windows and unix (Aix) environments. Is this normal? Adding more memory to our unix environment is a possibility, but is more problematic in the windows environment. Are there...

I posted this in the dev forum too. We recently upgraded our test environment from OpenEdge 10.0C to 10.2B003. We have a blob field in our database. Our sister company has an application that connects to the OpenEdge db via ODBC and reads the blob field. My understanding is that they take the...

We have a table in our open edge database that contains a blob field (binary large object). A sister company of ours has an SQL application that reads this field. After upgrading to OpenEdge 10.2B (from 10.0C), they are having problems reading the data in the field. The code on their side takes...

Does Progress have a mod or most frequently used function? For example, say I have a table or temp table with a field in it called order_qty. Is there a function I could use to show me the most popular value in order_qty? Like if the quantity of 100 has been ordered 12 times and the qty of 500...

Hello All-We are looking to set up a separate reporting database. Ideally we would use Replication, but at this time it is not in our budget to do so. We are currently on Progress v 10.0B05. The reporting database could be either another Progress db or SQL. Are there any tools less expensive...

Hello-I am sure this information is on the Progress website somewhere, but I am having a hard time finding it. We are currently on 10.0b05. Is 05 the highest service pack/patch level available for 10.0b (Win version)? Thanks.

Hi All-We use Infor's SX.enterprise ERP system. Several years ago we designed a few web pages using Webspeed that both read and write to our Progress db. We have several enhancement requests that will require a fairly major rewrite of the web pages. Since we have to basically rewrite the apps...

Hi All-We are in the process of setting up a hot site at a remote location to be used in the event of a disaster at our local data center. Our database (ERP=Infor's SX.enterprise) is about 180 GB and is on an AIX machine (AIX version 5.3.0.0, OpenEdge version 10.0B05). We have after imaging...

Hello All-We have been experiencing rapid growth of the before image files. About a year ago we implemented an application that connects to the Progress db via odbc. Since that time, it seems like we've had a lot more before image growth than we did in the past and over the past couple of weeks...