Problema de memoria con Delphi y BDE
Problema:
El error que me daba es $2501, memoria del BDE. He configurado el archivo Init desde el BDE Administrator en el parámetro ShareMemsize de 2048 a 4096 y el problema ya no se da.
Sin duda era un problema de gestión de memoria del BDE. Mi pregunta es: ¿Se puede aumentar el valor de este parámetro aún más. Cual es el límite?.
Lo pregunto porque la aplicación necesita tener varias tablas abiertas al mismo tiempo para poder efectuar cálculos.
Respuesta:
Antiguamente sí había un problema con el incremento de este valor, pero esto era cuando la memoria RAM de las máquinas se expresaba en MB, hoy en día la capacidad de las nuevas máquinas es tan alta que no debiera tener problemas en incrementarlo en valores tales como se necesite, ahora bien procurando que sean múltiplos de 2048 para una mejor gestión.
Documentación sobre como modificar en el Bde administrator en servidores para los errores de memoria que aparentan ser del servidor y que realmente con parte de la configuración en este caso para los servidores de tareas programadas, en este documento encontramos ligas a de discusión acerca del tema, como es en la siguiente pulse tecla control y clic con mouse aquí,
BDE Discussion
The Borland Database Engine is used by the OmniRush database connectors to GoldMine and SalesLogix. This discussion applies to all applications that use BDE, including:
• CRM Products: GoldMine v4.x, 5.x and 6.x; SalesLogix v3.x, v4.x, v5.x
• Z-Firm Products: OmniRush (when used with any of the applications listed above)
Additional BDE resource: The Z-Firm Knowledge Base at www.zfirm.com.
Quick Links:
General Discussion
BDE Symptoms
Testing BDE
Increasing BDE Memory
SHAREDMEM Setting
Launching BDEADMIN manually
Reinstalling BDE
** Warning**: This document contains resolution steps that involve system modifications to the registry. It is possible to completely disable your PC when working with the Registry. Steps below should be performed ONLY after a full backup has been made, and only by a qualified PC technician.
General BDE Discussion
In many cases, the BDE memory should be increased, especially if multiple database connectors are in use concurrently, or if the CRM application will be run on the OmniRush PC.
Avoid spaces in BDE Alias names.
Symptoms & Error Messages
Unable to initialize the Borland Database Engine Error…..” (example: error: $210D, $2A06, $2501, $2104)
error on launch: “FaxRush could not detect the Borland Database Engine on this system.
GoldMine will not launch and tenders error: Goldmine cannot dynamically load functions from IDAPI32.DLL. Please re-install the Borland Database Engine (BDE) BDE Error: 8461
Testing BDE
Test One:
Launch BDE Admin. This is done by either selecting BDE Administrator in the control panel, or, if you do not have an icon for BDE Admin in control panel, see the steps at the end of this document to launch BDE manually.
If you have the “classic” BDE problem, there will be an error at this point. The error will be to the effect: 8712 : $2208 : Could not find object.
If this is the case, reinstall BDE.
Test Two:
Launch BDE Admin
Launch the BDE based CRM application (GoldMine or SalesLogix)
The symptom is either an error or that one of the two applications does not launch at all (though it may show up on the Windows Process list in Task Manager). If this is the symptom, the steps are to adjust the SHAREDMEMLOCATION and if the problem persists to also increase BDE Memory.
Increasing BDE Memory:
The BDE settings from BDE Administrator (shown below) can be modified as follows:
LOW MEMORY USAGE LIMIT increase to 128, 256, or 512
MAXBUFSIZE can be set to 4096 or 8192 (in kb, no upper limit)
MAXFILEHANDLES should be set to 196 or 256
MEMSIZE can be increased to 24, 36, or 48 as needed (use smaller values first)
SHAREDMEMSIZE can be set to 4096 or 6144 (in kb, no upper limit)
Extreme BDE
MAXBUFSIZE can be set to 32768 or any multiple of 4096.
MEMSIZE max setting: 205 (in mb, should not be more than %30 of system RAM)
SHAREDMEMSIZE in kb, can go up to 32768 or 65536
Whenever any setting is changed, BDE Admin and all other BDE applications must be closed (or the system restarted) for the change to take effect. Then, be sure to test running the CRM application and BDE Admin at the same time to check for proper operation of BDE. In many cases, SHAREDMEMLOCATION must be adjusted after making the changes noted above.
SHAREDMEMLOCATION
In many cases, the SHAREDMEMLOCATION setting needs to be either set or changed (in most cases, by default it will have no setting).
The initial values to try are:
NT/2000/XP, set to: 7000
Win9x set to: E000
Alternate values for SharedMemoryLocation if the above setting does not help:
NT: 6000, 5000
Win9x: E500, 8000
Other alternate values for Win95/98: 9000, A000, B000, C000, D000, E000, F000
If none of these work, try the x500, e.g.: 9500, A500, B500, etc.
In all cases, after making a change to this setting:
a. Exit the BDE administrator
b. Exit all BDE-based applications (including shutting down all OmniRush modules and Administrator)
c. Restart the applications.
Note that changing the SHAREDMEMLOCATION may require also changing the SHAREDMEMSIZE (typically to make SHAREDMEMSIZE smaller)
Launching BDE Admin Manually
Generally, you should have an icon in Control Panel called BDE Administrator that launches BDEADMIN. However, if you do not, or if this BDEADMIN does not run, you can manually launch BDEADMIN by locating BDEADMIN.EXE.
There are a few ways to determine where BDEADMIN.EXE can be found:
a) In GoldMine, go to Help | About | System. One of the settings displayed is the directory of the BDE DLLS. BDEADMIN.EXE will be in the same directory.
b) On a network, go to \setupbdeshare and you will find BDEADMIN.EXE here.
c) On a standalone PC, go to c:program filesborlandcommonbde and you will find BDEADMIN.EXE here.
Reinstalling BDE
1. Find the BDE registry key using REGEDIT:
HKEY_LOCAL_MACHINESOFTWAREBORLANDDATABASE ENGINE
2. Rename the DATABASE ENGINE to a new name, e.g. OLD-DATABASE ENGINE
3. Reinstall BDE using either the stand alone BDE installer from a SalesLogix CDROM or using the GoldMine Installshield installer and selecting BDE only.
Supongo que el error es que Goldmine no carga el BDE. El mensaje de error ya les dice que vuelvan a instalar el BDE. Pero fuera de eso no tengo mas sugerencias ya que desconozco cómo funciona Goldmine con el BDE. La mejor opción es que contactes con el distribuidor que te proporcionó la licencia de Goldmine para que te ayude con el problema.
Fijate que el MAX ROWS lo tenga en -1