Thanks for your answer Marco,
Unfortunately when I try to install the Support-1.0.93.opm package using the
AdminPackageManager against a working MSSQL DB, the following error occurs:
Message: (DBD: st_destroy/SQLFreeStmt(SQL_DROP) err=-1), SQL: 'INSERT INTO
web_upload_cache (form_id, filename, content_type, content_size, content,
create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)'
Does anyone know how to overcome this problem?
Thanks,
Leonardo Certuche
On Tue, Nov 10, 2009 at 10:37 AM, Marco Vannini
Hi leonardo,
If you have the availability to point to both the db you can try to execute alternative a run to SQL Benchmark: inside [ Support Assessmenthttp://otrs.h3g.it/otrs/index.pl?Action=AdminSupport ] (available via package manager)
I don't know if it could give a relevant benchmark in general ...
hth
MV
On Tue, Nov 10, 2009 at 2:10 AM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
I'd like to demonstrate to the organization I'm installing OTRS for, that it's not convenient to store the data on MSSQL. A good starting point to convince them would be to be able to use the Benchmark package and compare but unfortunately I haven't been able to do so. If I try with /otrs/ index.pl?Action=AdminPackageManager I get the following error:
(DBD: st_destroy/SQLFreeStmt(SQL_DROP) err=-1), SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES (?, ?, ?, ?, ?, ?, ?)'
If I try with the command /opt/otrs/bin/opm.pl -a install -p Benchmark-1.2.5.opm I get the following error:
not well-formed (invalid token) at line 1, column 18, byte 18 at /usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi/XML/Parser.pm line 187
I just want to give them strong reasons to forget about MSSQL for OTRS, so if you guys have facts or experiences you could share here, I much appreciated it.
Thanks million,
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/
--------------------------------------------------------------------- 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/