Kbase P130900: _sqlsrv2 server process is crashing whenever running a simple SQL Update query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/04/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
Windows
SYMPTOM(s):
_sqlsrv2 server process is crashing whenever running a simple SQL Update query.
ODBC driver returns error code -20219
SQL-92 database trigger for updating the specific rows is activated.
Database is started via Adminservice
Specific jar files used by the trigger are included within the users environment variable PROGRESSCP.
registry entry HKEY_LOCAL_MACHINE\SOFTWARE\PSC\PROGRESS\9.1D\JAVA, PROGRESSCP does not contain the specific .jar files used by the specific database trigger
CAUSE:
If the database is started via the Adminservice which in turn is started with a different user account then the current user then environment variables are read from the registry. If the registry entries for the Progress Classpath PROGRESSCP environment variable does not contain pointers to the Java archive (.jar) file which contains certain classes used by the SQL-92 database trigger then running the specific trigger will fail.
FIX:
Make sure the Progress Classpath PROGRESSCP environment variable within the Windows registry contains your customer class archives as well.