Search results

I just upgraded 15 databases from V9 to OE. I added to these databases an SQL user with dba rights. One database does not work. I get the Auth failed error. I used the same input file for all databases. I cannot understand why one did not work and the others did. I tried to re-create the...

Thank you both so much for your time and suggestions. I do agree that the delete is overhead, but the end user is not going to be me and I was trying to eliminate the need for maintenance on this database. I have basically created this as a side database so that the exposue to my ERP is...

I have a report database that I place data into for view by managers. The database is a subset of the order information that drives the business (sales orders, purchase orders, work orders, etc.). The processes of loading the report database is a nightly update. However, when I have to...

Sweet! I had used 2>&1 before, but I got confused as to where to place it in the command. I tried looking through my manuals and such, but could not find anything. Tom to the rescue!

I need to direct my dbtool report output to a file on Linux. The tool does not ask me for this when I select 1, for report. I tried to redirect the command output (below) by supplying my input parameters to the file. This resulted in the menu and paramter selections making it to the output...

Tom wins the golden ring! The code that was calling this particular code had a connection to another db, not the db that was showing up in the error (still curious). The connection string was using the service port for the Progress 9.1D database. I changed the compile path to point to that...

I have a very curious issue. I have one set of base code for our QAD environment (eB2.1). I am upgrading to OpenEdge 10.1C from Progress V9.1D. I have a single Roundtable repositiory with RTB 10.1C and 9.1D on top of it. All code changes are done in 9.1D, but are compiled from both. We...

Thanks! I will give this a try

I am having issues with my SQL 89 to 92 code conversion on array elements. I have code that looks for the presence of unpopulated data fields in an array. Here is a snippet: where so_end_eff[2] IS NULL Error message: Syntax error in SQL statement at or about "IS NULL" (10713) I am...

Tom, This code does run, but the warning messages pop up when the user launches them. It is messy and I would like to not have them see this message. Can I suppress it somehow?

We have a procedure that run persistently for generating a PDF. Our current version of Progress is 9.1D. We are in the process of upgrading to 10.1C. This code generates warning messages when it starts (below). The code that it is complaining about is also contained in this post. WARNING...

Awesome! That absolutely did the trick!!!!:D:D:D:D:D

I have a process that lists users of my databases (QAD & EAM). I am running this process inside of my EAP application, QAD. The QAD side works well as the QAD database is the DICTDB. However, I need to switch the DICTDB to EAM, when listing those users. I have everything working except for...

Hello! We have a 32-bit OS. We are going to upgrade our 9.1D to OE on this OS. In 2011, we plan on replacing our servers and upgrading to 64-bit. I am curious. Is there are point where Progress OpenEdge will not be supported on a 32-bit OS? When would that be?

I found out what was wrong and now have it working. I am curious though... Has anybody, using QAD, done this for the abs_id field? I need to know if this is a one-time deal or am gonna have to keep running this for a while? I just don't know alot about this field and whether the total...

Also... The library, librocket_r.so, does exist in the lib, so it must not be loaded(able) somehow

I am interested in running dbtool. I have tried, but I am getting an error. The version of Progress that I am running is 9.1D SP 09 on Red Hat Linux. The app exists and I tried to run from the command line: dbtool /pkg3/db/my_db01 got the following error: /pkg3/appl/dlc/91d/bin/dbtool...

One other thing... I did try to create a key file to input the disconnect, however, I ran into an issue. If there are more than 1 screen filled with users (option 8), then I can input a q, followed by a 1 and then the usr number. If there are less than 1 screen filled with users , I have...

I would like to disconnect a progress user from the linux prompt. Any ideas on how to do this without simply kill the linux process. i.e using the same commands that promon uses only without starting promon to do it. Thanks!!

Thanks to all of you for your speedy answers! I felt that something was there that caused the two .rs to be different, but I could not put my finger on it. There is a slight change in the paths here by a few characters and, since there are only a few bits difference, this must be the reason...