[egenix-users] ProgrammingError

[Erich Birrer-Uster]

Hallo

Ab und zu (aber leider immer wieder) tritt bei einer Anwendung folgender Fehler auf:

  	Site Error
An error was encountered while publishing this resource. 
mx.ODBC.Error.ProgrammingError
Sorry, a site error occurred.
Traceback (innermost last): 
•	Module ZPublisher.Publish, line 163, in publish_module_standard
•	Module Products.PlacelessTranslationService.PatchStringIO, line 51, in new_publish
•	Module ZPublisher.Publish, line 108, in publish
•	Module Zope.App.startup, line 226, in abort
•	Module ZODB.Transaction, line 134, in abort
•	Module Shared.DC.ZRDB.TM, line 63, in abort
•	Module Products.mxODBCZopeDA.ZopeDA, line 1064, in _abort
•	Module Products.mxODBCZopeDA.ZopeDA, line 939, in errorhandler
ProgrammingError: ('HY000', 9114, '[Pervasive][ODBC Client Interface][Client LNA]Your connection to the server is no longer working.
To continue, disconnect from the data source and re-connect again. Contact your system administrator if you still need assistance.',
1094) 
________________________________________
Troubleshooting Suggestions
•	The URL may be incorrect.
•	The parameters passed to this resource may be incorrect.
•	A resource that this resource relies on may be encountering an error.
For more detailed information about the error, please refer to error log. 
If the error persists please contact the site maintainer. Thank you for your patience. 


Meine Installation sieht wie folgt aus:

Zope Version (unreleased version, python 2.3.3, win32)
Python Version 2.3.3 (#51, Dec 18 2003, 20:22:39) [MSC v.1200 32 bit (Intel)]
System Platform win32
SOFTWARE_HOME C:\Programme\Plone 2\Zope\lib\python
ZOPE_HOME C:\Programme\Plone 2\Zope
INSTANCE_HOME C:\Programme\Plone 2\Data
CLIENT_HOME C:\Programme\Plone 2\Data\var
Network Services ZServer.HTTPServer.zhttp_server (Port: 8080) ZServer.HTTPServer.zhttp_server (Port: 80)

Connection Id  	 w-e3000  	 
Connection Title 	e3000-DB 	 
Database Connection Source 	DSN=webudc01 	 
ODBC Manager/Driver 	Platform Default 	 
Connection Information 	Connected database: Pervasive.SQL, 7.94
ODBC driver: W3ODBCCI.DLL, 7.82.197 	 
Database Timezone 	Local Time Zone 	 
Connection Options 	
    * Database Warnings are reported as Python exceptions.
    * Connection uses transactions.
    * Time columns are returned as DateTime values.
    * Date/time columns are returned as Zope DateTime values.
    * Short integers are fetched as short integers.
    * NULL values are returned as None.
    * Scale 0 floats are converted to integers.
    * The first available result set is fetched in queries.
Connection Pool 	Pool size: 20
Physical connections: 1 open
Connection State 	connected (since 2005/08/29 20:07:46.640 GMT+2)
mxODBC Zope DA 1.0.8

Wo beginne ich am Besten mit der Fehlersuche?

Besten Dank für eure Tipps

Erich