MSSQL, CS_OPT_TEXTSIZE failed and the solution mentioned in the CHANGELOG
Hello, I am using MSSQL as customer backend and I am getting the infamous CS_OPT_TEXTSIZE error. The CHANGELOG suggests to set the "Attribute => {}" option of the database backend, in order to prevent LongReadLen being set. This is what I did: Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Sybase:server=XXX; database=XXX', User => 'xxx', Password => 'xxx', Table => 'XXX', Attribute => {}, ... } Despite the "Attribute" var being set it seems to be ignored, as I am still getting a lot of "Setting of CS_OPT_TEXTSIZE failed. at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 319." errors. PRODUCT = OTRS VERSION = 3.1.2 BUILDDATE = Fri Mar 2 08:35:30 CET 2012 BUILDHOST = otrsbuild.otrs.com Compile-time settings (established with the "configure" script) Version: freetds v0.82 freetds.conf directory: /etc/freetds MS db-lib source compatibility: no Sybase binary compatibility: yes Thread safety: yes iconv library: yes TDS version: 4.2 iODBC: no unixodbc: yes The MSSQL server is 2008 R2, TDS protocol version is set to 8.0. Any ideas? Regards, Johannes Scholz
Hi Johannes, did you manage to find a workaoround to this issue? I am having exactly the same problem on OTRS 3.2.6. I guess the DBI lib being used is still the same (# $Id: DBI.pm,v 1.3 2011-11-28 12:28:37 mb Exp $) Thanks Oreste Attanasio ________________________________________ From: otrs-bounces@otrs.org [otrs-bounces@otrs.org] on behalf of Johannes Scholz [js@vinci-info.com] Sent: Thursday, March 29, 2012 11:32 To: otrs@otrs.org Subject: [otrs] MSSQL, CS_OPT_TEXTSIZE failed and the solution mentioned in the CHANGELOG Hello, I am using MSSQL as customer backend and I am getting the infamous CS_OPT_TEXTSIZE error. The CHANGELOG suggests to set the "Attribute => {}" option of the database backend, in order to prevent LongReadLen being set. This is what I did: Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Sybase:server=XXX; database=XXX', User => 'xxx', Password => 'xxx', Table => 'XXX', Attribute => {}, ... } Despite the "Attribute" var being set it seems to be ignored, as I am still getting a lot of "Setting of CS_OPT_TEXTSIZE failed. at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 319." errors. PRODUCT = OTRS VERSION = 3.1.2 BUILDDATE = Fri Mar 2 08:35:30 CET 2012 BUILDHOST = otrsbuild.otrs.com Compile-time settings (established with the "configure" script) Version: freetds v0.82 freetds.conf directory: /etc/freetds MS db-lib source compatibility: no Sybase binary compatibility: yes Thread safety: yes iconv library: yes TDS version: 4.2 iODBC: no unixodbc: yes The MSSQL server is 2008 R2, TDS protocol version is set to 8.0. Any ideas? Regards, Johannes Scholz --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
participants (2)
-
Attanasio, Oreste -
Johannes Scholz