solved: gi_webservice_config Error

cmadoery · Post by **cmadoery** » 02 Mar 2012, 09:29

Upgrade to OTRS 3.1 on Testsystem was OK.
But on productive system which runs with remote MSSQL-DB (diffrent to Test), I get following error (on Postmaster Mail Accounts):

Invalid object name 'gi_webservice_config'. (SQL-42S02), SQL: 'SELECT id, name FROM gi_webservice_config WHERE valid_id IN (1)'

whats missing here? I guess soemthing in DB update. Any help is very wellcome!
Christof

cmadoery · Post by **cmadoery** » 02 Mar 2012, 21:51

as I see this:

Screen Shot 2012-03-02 at 16.41.51.jpg

I suggest that the run of the scrips:
-mssql-datatype-upgrade-step1.sql
-mssql-datatype-upgrade-step2.sql
-mssql-datatype-upgrade-step3.sql

did not work well. I need to talk to my MSSQL-DB-Admin @%&/ç*@@ because I'm not allowed to do anything there by myself

cmadoery · Post by **cmadoery** » 08 Mar 2012, 08:44

I missed the step running otrs-schema.mssql.sql on remote MSSQL-DB.

Christof

wipeout_630 · Post by **wipeout_630** » 16 Apr 2012, 22:43

Where did you find these scripts? I've searched all over the /opt/otrs/ file structure and can't find them.

jojo · Post by **jojo** » 16 Apr 2012, 23:34

tra a second search in scripts/database

Znuny Open Source Ticketsystem