Archivo del Autor: carlosap

You must dump & load in order to reconfigure to type 2 storage. Type II storage areas —  for data, for indexes and  LOBs , if you have any word indexes put those in their own storage area also. NOTHING EXCEPT SCHEMA should be in the schema area. In order for an area to be… Leer más »

Printable View INFORMATION Article Number 000012531 Environment Progress 9.x OpenEdge 10.x IBM AIX UNIX Enterprise Database License OpenEdge Category: Configuration OpenEdge Category: Database OpenEdge Database Category: Monitoring/Promon OpenEdge Database Category: Performance Question/Problem Description Database hanging periodically Overall performance of the databases decreases It takes a long time to login in the application when users already… Leer más »

http://knowledgebase.progress.com/articles/Article/P99089?popup=true   Article Number 000022572 Environment All Supported Operating Systems OpenEdge 10.x, 11.x OpenEdge Server Technology Category: AdminServer Question/Problem Description How to increase or modify java heap size for the Admin Server in OpenEdge ? How to increase java memory for Admin Server in OpenEdge? How to set the JVMARGS in Release 10? How to… Leer más »

Article Number 000034388 Environment OpenEdge 10.2B06 OpenEdge 11.1 Question/Problem Description JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B SP6 The database is started and can be connected to OpenEdge Explorer shows the database as not running Clarifying Information Database Agent started without issues in 10.2B05 Only databases with a specific servergroup defined fail… Leer más »

Resolution To create a SQL DBA and hide all Progress Schema tables and views from the public do the following: PRECAUTIONS: A.  Take a backup of the database prior to making any changes. B.  Test on a copy or test database prior to making changes to the Production database. 1.  Enable the SYSPROGRESS sql DBA by registering/adding  the user SYSPROGRESS via the 4GL… Leer más »

Hi All, We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver. The isolation Level is set to READ COMMITTED IN THE Driver Properties. We are trying to retreive the data based on certain conditions from one of the web pages. However, if the record is locked in Progress… Leer más »

Nota al final añadir: – append defaultSchema=pub to the end of the URL. Like: jdbc:datadirect:openedge://localhost:5555;databaseName=testdb;defaultSchema=pub http://knowledgebase.progress.com/articles/Article/000032547   Resolution First download the installer file squirrel-sql-<version>-install.jar from http://squirrel-sql.sourceforge.net and install the SQuirreL SQL Client under Windows or Linux using the command: java -jar squirrel-sql-<version>-install.jar During the graphical installation an installation path will be asked, as well as if a base or a… Leer más »

or Progress 9.1D and later, the method for using the secondary login broker for SQL connections has changed. Databases that have both Progress ABL and SQL clients simultaneously connected should use a secondary login broker to avoid the following limitations caused by the use of a single broker: – The need to establish the maximum… Leer más »