Search results

  1. T

    Question Openedge 10.1b Hf33 - Modifying Records

    Our version of OpenEdge is 10.1B and it came with our ERP system. We have a couple records that we would like to remove from the system, but apparently our version of OpenEdge is a developer only version. Is there anything we can use to modifying these records without using the ERP system...
  2. T

    Error Database Query To Locate Invalid Cr Characters

    We recently used a tool to automatically update a field, unfortunately the person used copy and paste to update a description field for several thousand items. Now the description field has a character which is a return character that is showing up as a square in our application. Now whenever...
  3. T

    Question truncate log files admserv.log and cmdplugin.log

    Where are the settings to set the log file size for advserv.log and cmdplugin.log? Currently, our log files are 6 and 5GB, and I need to free up a little disk space. I would like to delete these files without having to restart the app or db servers? Thanks.
  4. T

    Question CPU Spike 100%

    After restarting the server and app servers, our Windows 2008 Server will run for about 10-15 minutes until the _proapsv.exe processes usually two take up all 100% of the CPU. We do not have any services or processes running out of the ordinary and this database has been running solid for many...
  5. T

    Question Dump and Load

    What's the typically time required for a dump and load of a Progress database that's about 8GB? The system has 8GB of memory running quad core 3.2 procs. I'm using documentation that's provided by Epicor that runs the database on OpenEdge 10.1B
  6. T

    Windows 2010 Progress Backup

    Our Server 2008 Server is running a full backup of all files and directories on our OpenEdge 10.1B server. Will this suffice for backing up the database if it's online? I'm use to running probkup online instead, but curious if that is now just redundant? Guess trying running the database from...
  7. T

    ODBC connection failed to new server after move

    I'm having trouble establishing an ODBC connection to a Progress database. The connection worked fine before moving the database to a new server. The test connection responds with the warning message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver] (then some strange ascii characters.
  8. T

    Unable to connect progress explorer.

    Just moved our Progress 10.1B HF33 to a new server with a different name. The database started fine and port 20931 is running, but unable to connect to view the app servers and the proenv is unable to start or interact with the appservers. I'm looking for a dependency on the computername, but...
  9. T

    Question Migration to Excel and then to SQL Server

    Can somebody point me to a direction in migrating from Progress to Excel and then to MSSQL? I'm actually looking for suggestions and helpful experience. Thanks, --tj
  10. T

    BAQ query

    I have several rows of data: employeenum date payhours 1 10/29/13 8 1 10/30/13 7.5 1 10/31/13 8.25 2 10/29/13 8 2 10/30/13 7.5 2...
  11. T

    Memory leaking on Windows Server 2008 x64

    Our company is running OpenEdge 10.1B with Progress. I've found that after a while, the system's memory is all consumed by the cache and does not release properly, unless we shutdown the database and restart. I've installed Cacheset.exe and DynCache to try and elevate this problem, but it...
  12. T

    Dump-n-Load best practices

    Our 2008 Server is running with 8GB memory with plenty of disk space. Our DB is 7GB and the BI file is apx 300MB. What's the best switches to use when running the DumpTables.r file? It's suggested to run with -i -B 120000 would more be better? How long typically should this take to complete...
  13. T

    Enabling "after-image" support

    Running OpenEdge 10.1B hf 33 on Windows 2008 Server SP2 In an attempt to follow Tom's great Powerpoint presentation, it seems that we're are missing the .ai files. Where is this file located, or do you create it? Thanks, --tj
  14. T

    Safe to DELETE 2 large DBI files in oe101b_wrk directory?

    Surprisingly, I'm trying to free up some safe on the server and noticed two very large DBI files, DBI123898908 and DBI989089080 one is size 90GB and the other is size 25GB. The last write times are several months ago. So, are these files safe to delete? --tj
  15. T

    Scheduled Process set has stop our database.

    Submitted a process set to our OpenEdge 10.1B database, and now the Progress Explorer returns that it's "Starting" the Application Servers and the database returns that it's Starting, but then the DB returns an error and the Application Servers are stuck on "Starting" Ran proutil mfgsys -C...
  16. T

    Required to reboot server to restart database.

    Our database has always had problems, but simply shutting it down and restarting with the dbman -stop database dbman -start database seemed to clear things up, but now it seems the dbman -stop database is successfully, but will not start again. We get an error message complaining that a process...
  17. T

    Decompiling progress program?

    A consultant company compiles a Progress program that generated .r file that we ran to process information in our Progress database, but now the program has expired. What can we do to remove the expiration date, if this is even possible? --tj
  18. T

    Random App Server pool maxing out.

    When our app servers max out, "No More Available App Servers," it was told by support that we could locate the culprit by identifying the PID generated in very large DBI files. Will any of these files provide any evidence on what is causing our system to "crash?" procore protrace.xxxxx...
  19. T

    Promon - finding where a transaction or record is in a table

    Using the record # in promon, what kinda of query can be executed to display what table this comes from in my DB? Similar query: for each _file where _file-number = 123. display _file-name _file-number. end. Thanks, --tj
  20. T

    No more available App Servers.

    When our users receive this error message "No more available app servers" the locks logger program, which is basically promon, reports all activity on table 1167, which is our LicUser table. What could be causes our app serves to max out? Thanks, --tj
Top