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...

Daniel, in our database _DB._DB-COMM is an empty string. Casper and Joey, thank you very much. It works. Though I do not like Progress, I have a sincere appreciation and respect for all of you and your thoughtful, helping nature.

Thank you, Joey. That code does not provide the results I want. Perhaps, I should specify that I would be connecting to the Progress database in multi-user mode via TCP. That code tells me the host name is "localhost" . I want the name of the remote host on which the database is running...

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...

Tom, The SQL-92 approach works fine. However, it is not especially fast. I am simply looking for a way to obtain the count programatically in < 30 seconds per table regardless of row count.

Joey, maybe I understand what you are saying and maybe I don't. I think what you are saying is that an application can be written to provide this type of information from the database, and that application would be run under the appserver on the same box as the database. If that's what you...

Tom, your reply reminds me of a serious "flaw" (in my opinion) with the Progress design: 4GL code is 4GL code; There is no distinction between 4GL code in the context of screens and local processes compared to 4GL code that does nothing but access the database. Over the past 16 years I have...

Tom, I'd like to try the approach you recommend. All this must be done from a script or code. Can I use ProUtil from a remote box?

Hello, Joey, it's nice to hear from you. I'm fine, thank-you. We dumped and reloaded our data about three months back. During the reload we moved several tables to individual storage areas. The Progress database has been working much faster since then. However, obtaining the record count of...

Hello. I found this thread when I did a search on "record" and "count". Our firm runs a Progress application. We run reports off copies of the Progress data. Our reporting tools are M$. So, we copy the Progress data to Sql Server. As an auditing issue, we need to show that the count of...

In SQL language the operator "like" is used to compare character string data. Is the column named "tr_nbr" a character datatype or is it numeric? Which column contains part of the other column: Is the value of tr_nbr a substring in workorder or is workorder a substring in tr_nbr? Here is...

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

Oops. I just saw your 'Access Denied' post. Yes, you are right. You need dba (administrator) privileges granted to your id to access the tables through ODBC and SQL-92. Using the Progress SQL Explorer, try to log in to the Progress database as user=sysprogress with password=1234. If you...

I, too, am an expert with SQL Server and Oracle. Sadly, the Progress database engine is not on the same level as those relational database systems. Do not expect Progress to work like them. "PUB" is simply the SQL schema area in which Progress places this stuff.

First, this query is everyday faire for SQL Server, Oracle , DB2, mySQL, etc., but it is going to be a grind for Progress. I believe the problem is: ...AND NOT EXISTS (SELECT * FROM ... The more typical way to do this is: ...AND NOT EXISTS (SELECT 1 as COL1 FROM ... or ...AND NOT EXISTS...

Thanks Joey. It works. I was not familiar with session:param.

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...