OTRS 3.0 beta7 Statistics cannot be opened

[AlexeyM]

Hello,
Any help will be appreciated on my issue because I'm new with the system.
I have installed OTRS 3.0 beta7 on MS Windows 2003 Server, IIS 6.0, MS SQL Server 2005 Express
Everything works fine (if to compare with beta5) but when I try to access STATISTICS/Overview (that worked fine in beta5) I get en error:

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.

otrs.log contains the record:
[Error][Kernel::System::AuthSession::DB::_SyncToStorage][353] [Microsoft][SQL Native Client]Connection is busy with results for another command (SQL-HY000), SQL: 'UPDATE sessions SET session_value = ? WHERE session_id = ?'

otrs.log.error contains the record:
Out of memory!
[Wed Nov 10 15:34:22 2010] index.pl: DBD::ODBC::db do failed: [Microsoft][SQL Native Client]Connection is busy with results for another command (SQL-HY000) at C:/Program Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 422 during global destruction.
ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Wed Nov 10 15:34:22 2010

Message: [Microsoft][SQL Native Client]Connection is busy with results for another command (SQL-HY000), SQL: 'UPDATE sessions SET session_value = ? WHERE session_id = ?'

Traceback (4372):
Module: Kernel::System::AuthSession::DB::_SyncToStorage (v1.47) Line: 353
Module: Kernel::System::AuthSession::DB::DESTROY (v1.47) Line: 365

[Mike_B]

Hi Alexey,

that kinda sucks. It seems like your database really does not accept more than one simultaneous connection?
Please review your database settings with your DBA.

In the mean time, it could be a workaround to save your sessions on the file system instead of in the database. This saves lots of inserts and updates. Just go to Admin > SysConfig > Framework > Core::Session and select "FS" as the session module.

--
Mike.

[Cluss]

Hi Alexey,

did you solve this problem? I have exactly the same errors also on win with MS SQL Server.
But in FAQ section. It also only happens when i want so save an entry, then also the explorer can´t be called.
It works again when i delete the entry directly in the database. Category are also no problem to save/change
The switch to store the session in fs didn´t work for me either.

Thanks

regards
Alex

[Mike_B]

Please check this link to the bugzilla: http://bugs.otrs.org/show_bug.cgi?id=5023#c8

Setting a different value for LongReadLen supposes to work around the issue.

--
Mike

[Cluss]

Hi Mike,

many thanks.
That worked for me too.
I set the value to 40 and it works now, above this value the error occurs.

Regards

Alex