Archivo de la categoría: PROGRESS

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 »

Para listar todas las tablas: for each _file  no-lock where _file._hidden = no,      each _field no-lock where _field._file-recid = recid( _file ):   display _file._file-number.   display _file._file-name _field._field-name. end. ————————————————————– Or, the quick ‘n dirty version: Code: find _file no-lock where _file._file-number = 7. /* change this number */ display _file._file-name.

Actualización Solución: Indexar el   2 |    Schema Area        6       de las tablas afectadas ————————————————————-     OpenEdge Release 11.2 as of Wed Feb 13 18:26:43 EST 2013 You must have your database backed up before running the conversion. (1024) Have you done this (y/n) ? y VST Table Deletion has begun. Please standby.… Leer más »

http://knowledgebase.progress.com/articles/Article/000031654 Question/Problem Description How to upgrade an OpenEdge database from version 10.2 to 11.0? Clarifying Information Error Message Defect/Enhancement Number Cause Resolution Use these steps for upgrading a database from OpenEdge 10.2 to 11. OpenEdge 10.2 exists on the same machine where OpenEdge 11 is installed: 1. Truncate the version 10.2 database using the version… Leer más »

Status: Verified SYMPTOM(s): Shell script fails to run Progress procedure as a (scheduled) batch job. ** Could not find terminal type <type> in file <file name>. (146) Unable to use your terminal. Check your PROTERMCAP file. (443) Redirection or Piping of stdin or stdout is allowed only with -b.(156) FACT(s) (Environment): Running progress in batch… Leer más »

Se requiere un reinicio para el SOAP y desbloqueo de puertos en el firewall – sucede cuando existe un cambio en las reglas del firewall T-http-7001-Processor23 2 wsa1 4GL-Provider Error in SOAP request execution: SessionPool : NoAvailableSessions[Could not connect to the AppServer: General Error: Connection refused. (7203)] (10926) error 7203 and 10926 attempting to connect… Leer más »

database analysis proutil path_to_your_database -C dbanalys > dbanalys.log Note that you can run this off or online. When run online the report will contain a warning that it is run online and the statistics are only estimations. Furthermore you can use the report to see how much space each table is using and if you… Leer más »

mover los extents prostrct repair ped

Iniciar la base con proserver (Nota: el Multi-threaded no funciona offline ) proserve db-name -S 5000 -B 128000 Para el dump con todos los CPU’s proutil db-name -C dump table-name . -thread 1