[unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set.
Hi there, After several workarounds, we have installed otrs-2.4.5-01 on OpenSuSE 10.3 connected to a MSSQL database. In order to achieve it, we installed the following RPM packages: unixODBC-devel-2.2.12-55 unixODBC-2.2.12-55 perl-DBI-1.58-17 perl-DBD-ODBC-1.14-13 An also installed freetds-0.82 from source with the following options: ./configure --with-tdsver=7.0 --with-mssql And configured the files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and /usr/local/etc/freetds.conf We are creating users, customers, queues, etc and they're being stored in the MSSQL database no problem but when we try to install a new package using /otrs/index.pl?Action=AdminPackageManager, the following error shows up: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri Nov 6 13:45:50 2009 Message: [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted (SQL-HY000) [unixODBC][FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 7: The parameter name is invalid. (SQL-42000)(DBD: st_execute/SQLExecute err=-1), SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)' Traceback (1612): Module: Kernel::System::Web::UploadCache::DB::FormIDAddFile (v1.20) Line: 96 Module: Kernel::System::Web::UploadCache::FormIDAddFile (v1.19) Line: 153 Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 962 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48 Thanks in advance for your help solving this issue, Regards, Leonardo Certuche
I was wondering do you experience any performance hit with FreeTDS? We have it set up as well with sql server 2005 and freetds .83 and what a difference in speed from mysql to mssql, when I use mysql I go from 5 secs to 26 secs using mssql in the support assessment SQL Benchmark. Could you let me know what your SQL Benchmarks are using freetds. Thanks, Rob From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Leonardo Certuche Sent: Friday, November 06, 2009 11:49 AM To: User questions and discussions about OTRS. Subject: [otrs] [unixODBC][FreeTDS][SQL Server]Error converting charactersinto server's character set. Hi there, After several workarounds, we have installed otrs-2.4.5-01 on OpenSuSE 10.3 connected to a MSSQL database. In order to achieve it, we installed the following RPM packages: unixODBC-devel-2.2.12-55 unixODBC-2.2.12-55 perl-DBI-1.58-17 perl-DBD-ODBC-1.14-13 An also installed freetds-0.82 from source with the following options: ./configure --with-tdsver=7.0 --with-mssql And configured the files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and /usr/local/etc/freetds.conf We are creating users, customers, queues, etc and they're being stored in the MSSQL database no problem but when we try to install a new package using /otrs/index.pl?Action=AdminPackageManager, the following error shows up: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri Nov 6 13:45:50 2009 Message: [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted (SQL-HY000) [unixODBC][FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 7: The parameter name is invalid. (SQL-42000)(DBD: st_execute/SQLExecute err=-1), SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)' Traceback (1612): Module: Kernel::System::Web::UploadCache::DB::FormIDAddFile (v1.20) Line: 96 Module: Kernel::System::Web::UploadCache::FormIDAddFile (v1.19) Line: 153 Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 962 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48 Thanks in advance for your help solving this issue, Regards, Leonardo Certuche
Thanks for your interest on the topic Robby,
Unfortunately I haven't been able to install the Benchmark package due to
the error that I reported in the current thread. If you (or someone else)
could give me some clues on how to solve it, I'll be more that glad to
answer your question regarding speed.
Anyone with experience setting character sets to communicate OTRS on Linux
to its database on microsoft SQL server?
Thanks,
Leonardo Certuche
On Fri, Nov 6, 2009 at 4:17 PM, Robby Garon
I was wondering do you experience any performance hit with FreeTDS? We have it set up as well with sql server 2005 and freetds .83 and what a difference in speed from mysql to mssql, when I use mysql I go from 5 secs to 26 secs using mssql in the support assessment SQL Benchmark. Could you let me know what your SQL Benchmarks are using freetds.
Thanks,
Rob
*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Leonardo Certuche *Sent:* Friday, November 06, 2009 11:49 AM *To:* User questions and discussions about OTRS. *Subject:* [otrs] [unixODBC][FreeTDS][SQL Server]Error converting charactersinto server's character set.
Hi there,
After several workarounds, we have installed otrs-2.4.5-01 on OpenSuSE 10.3 connected to a MSSQL database. In order to achieve it, we installed the following RPM packages: unixODBC-devel-2.2.12-55 unixODBC-2.2.12-55 perl-DBI-1.58-17 perl-DBD-ODBC-1.14-13
An also installed freetds-0.82 from source with the following options: ./configure --with-tdsver=7.0 --with-mssql
And configured the files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and /usr/local/etc/freetds.conf
We are creating users, customers, queues, etc and they're being stored in the MSSQL database no problem but when we try to install a new package using /otrs/index.pl?Action=AdminPackageManager, the following error shows up:
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri Nov 6 13:45:50 2009
Message: [unixODBC][FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted (SQL-HY000) [unixODBC][FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 7: The parameter name is invalid. (SQL-42000)(DBD: st_execute/SQLExecute err=-1), SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)'
Traceback (1612): Module: Kernel::System::Web::UploadCache::DB::FormIDAddFile (v1.20) Line: 96 Module: Kernel::System::Web::UploadCache::FormIDAddFile (v1.19) Line: 153 Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 962 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48
Thanks in advance for your help solving this issue,
Regards,
Leonardo Certuche
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (2)
-
Leonardo Certuche -
Robby Garon