Search results

Hi, One of our development DB was restarted with -F option. Now every time we see a warning. How to get rid of this warning without rebuilding all the indexes. Thanks

Hi, Pentaho Report Designer 3.9.0-GA 15557, Openedge 10.1C The following query throws error (shown after query) : select ptho_agtsals.agentid, ptho_agtsals.agentname, ptho_agtsals.grosssales, ptho_agtsals.repyear, ptho_agtsals..repmonth where...

Hi DBAs, Openedge 10.1c, AIX 5.x, In one of our production database the maximum servers allocated are 100. At any given point in time our concurrent user count does not exceed 120 which includes batch processes. Ours is a GUI application and users does not login in remotely, unless for batch...

Hi All, Progress 10.1c, Prgress 4GL in-built application and RH linux. I have an editable browser with records from a table displayed to the user. The requirment is that the user selects few records, lets assume 4, right clicks to run a procedure that changes some fields. These changes should...

Hi All, Progress 10.1c, Redhat 5, windows xp client. I am trying to connect to admin server on linux from windows xp cleint. I can ping/telnet the linux server and ther is no firewall / iptables on the server. When I try connecting admin server on linux from windows it shows error "invalid...

Hi, Any one supporting an OLTP application on 4GL appserver or webspeed, please let me know : 1. Type of remote procedure ie synchronous or asynchronous 2. Appserver session mode settings such as session managed or session free and which type ie state-free, state-reset, and when to use which...

Hi all, In Promon, R&D Activity, BI Log, apart from all metrics there is an "busy buffer waits" and "empty buffer waits". Can any one be kind enough to explain the difference between these two, since at the outset they appear to be the same. Thanks in advance.

Hi, One of the field in a table contains arrays. How to view / export data of this field using SQL or Java client ( SQL explorer for example). TIA

Hi all, I have a problem displaying "n" number of decimals in my SQL client application. Example, original value in database (9.1e) is 123.123456789 but the value in SQL client application is 123.1234567. Any ideal how to display the full length? Thanks in advance.

Experts, What is the recommended number of hard disks to implement RAID 10 for database of around 150 GB, nearly 200 concurrent users on a redhat box, an inhouse developed webspeed application(OLTP) and a BI tool. Thanks

Hi experts, Progress 9.1e, Redhat, SQL explorer. Urgent help needed to run below SQL & PL/SQL queries in SQL explorer. 1. Description : To Know total row count from statistics available (with out running count(*) from that table) SQL Statement : SELECT num_rows FROM all_tables WHERE...

Hi, I am connecting a Progress 9.1e database through Sql explorer. I created a table using SQl but unable to create an index. What is the exact syntax to create index on a table using SQL-92. Thanks in advance.

Hi All, We manage to do ODBC connection and when I try to connect from MSAccess to a sports2000 DB table (customer), it throws error "Reserved error (-7748); there is no messsage for this error". Where as if I connect to any SYS* table it connects. How can I view records from "customer"...

Hi Experts, Is it possible to create primary key for a field during database design in Progress using data dictionary. Or, is it possible to create it by using dataservers or ODBC/JDBC. Using VSTs can I query which table(s) contain primary key or foreign key or unique constrainst created...

Hi experts, How to find out what are DB buffer & BI buffer sizes. Are they tunable? If so how & when. TIA

Hi all, I am setting up first time OE management. When I create default resource plan for CPU, I dont see any data. It say "not checked" and on the right side it displays " no data" for all users, system and total. Anyone who has done setup can please guide me how to monitor CPU for local...

Hi DBAs, Progress 9.1E, Windows 2003. We wish to install virtualisation application in our windows intel server. Can any one please recommend any hypervisor (preferred is VMWare) to install in windows 2003 server. Is anyone using VMware with Progress 9.1e on windows? If so what are the...

Hi experts, I want to copy full ai files and rename to a different folder in a dos batch script. It could be like : proenv>rfutil sports2000 -C aimage full the output will be c:\test\sports2000.a3 How to copy this file & rename it with date & time attatched as extensions or with any...

Hi All, Has any one tried to find out which user and / or which problem is causing bottleneck in OE 10.1c? Which option in Promon or Protop we can find out which line of source code is causing the performance problem. Thanks in advance

Hi, If temp tables are used to pass as parameters in an n-tier application, then how is concurrency maintained. I mean, if user A modifies records of a table and those records are passed as temp tables and at the same time another user B modifies same record at the same time then which one is...