[otrs] MSSQL, CS_OPT_TEXTSIZE failed and the solution mentioned in the CHANGELOG

29 Mar 2012

      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