Search results

In our Appserver Broker log the message, below, is written several times per second. What does this message mean? The ASK major version in the CONNECT request is invalid (com.progress.ubroker.util.ubMsg$InvalidMsgVersionException: MsgFormat). AppServer Keepalive protocol is disabled for this...

We have a nightly backup, shut-down, and re-start for our Progress database. Following the re-start we pull data from the Progress database to our data warehouse on SQL Server by issuing SQL SELECT statements from SQL Server to the Progress database. The job that pulls the data from Progress to...

We are just upgrading from Progress 9.1D to 10.1b. We retreive records via odbc. The 9.1D version of our database has been started with -L 128000. We are starting the 10.1b database with -L 256000. However, we are unable to use SQL to download records from the tables. We are receiving the...

We have a Progress application (4GL and database) installed on three machines for development, testing, and production. The logical database name is the same on each machine. How can a 4GL procedure obtain the name of the database host?

We use a commercially available application written in Progress 9.1D and running on a Windows platform. Something in the application is failing to release user sessions when users logout. The result is that our available Progress license count is reached and we are locked out until we restart...

We just started receiving a Fatal error regarding BFSORT.c. Can anyone shed light on this?

I have a situation in which I want to quickly (and invisibly) connect to Progress and output a long character string to a text file. I wrote a succinct little program that can find the record and output the character string to the text file. The record is found based on the value of a single...

I apoligize if these questions have been asked/answered before. Question #1: When a Progress database is configured to spread tables across multiple schema areas does Progress allocate separate memory regions for the respective schema areas or does memory remain a 'stew' of the current...

We have been using the Progress DataDirect 4.10 32-bit ODBC driver and SQL-92 successfully for two years. Most of our use is to copy complete tables from Progress to SQL Server for reporting. Sometimes Progress does not return all the records in the Progress database (for example, only 95% of...

My Progress database administrator tells me that Progress loads a table into memory when that table is requested. Any external request for data from that table (example: SQL Select of all records via ODBC) executes significantly faster when the table is already loaded in Progress memory...

For the past three weeks I have been seeking the optimal way to import the business data in our Progress database into SQL Server database for reporting. The routine(s) are to be run daily. There seems to be an absence of expert knowledge providing deep coverage in this area of integration...

The firm I work with has licensed a Progress business application that uses a Progress database. We have current Progress licensing. My management is under the impression that having a Progress end-user license does not entitle us to direct technical questions to Progress. In our case the...

I have occassional need to build routines that copy data from our Progress database to SQL Server. A simple way to quickly generate an empty table structure is to issue a SELECT ... INTO <TABLENAME> FROM ... WHERE <your criteria> AND 1 <> 1. Because the number 1 is always equal to 1 no records...

I am not finding any detailed technical documentation on performance improvements when using SQL-92 and ODBC to fetch data from a Progress 9.1D database. Is there a body of documentation or technical papers that discuss tuning the Progress database and tuning the client ODBC setup for SQL-92...

The reporting applications of which I am aware require ODBC and SQL. That creates a nasty problem when character field length is not restricted in the Progress database. What reporting tools are available specifically for Progress that provide capabilities like Crystal?

We successfully copy the data from our Progress 9.1D business application database to MS SQL Server for reporting purposes. Using DataDirect as the ODBC driver, the Progress database becomes a Linked Server of the SQL Server. Several of the Progress tables contain over 1,000,000 rows. We...

Well, my friends, I have finally come to understand why I dislike working with applications developed in Progress. Progress is not good for working in sets or matrices oriented paradigms. Sure, Progress programmers work with sets all the time, but the process is iterative throught the sets...

I am seeking technical information that describes the location of data in the physical files of the Progress database. Specifically, I wish to locate the addresses where the _Width column is located for any column of any table in the database.

Do most of you write all reports using Progress 4GL? I am just curious. It would seem that any of the reporting packages available would require ODBC. And ODBC would require the SQL Width to be properly set within the Progress database. But most Progress programmers do not care about the SQL...

I know that the SQL Width is stored in the column "_width" in the table "_Field" in the system tables. How does dbTool allow changes to the SQL Width without forcing everyone out of the Progress database?