MSSQL Installation fehler

[Norbert]

Hallo,

bei der Installation von Limbas auf einer MSSQL Daten bank werden beim erstellen der Limbas Tabellen folgende Fehler ausgegeben.

drop existing trigges ... done
drop existing constraints ... done
drop existing views ... done

table LDMS_FAVORITES created.
inserting rows ...

0 inserts.
table LDMS_FILES_1 created.
inserting rows ...

0 inserts.
table LDMS_META created.
inserting rows ...

0 inserts.
table LDMS_RULES created.
inserting rows ...

3 inserts.
table LDMS_STRUCTURE created.
inserting rows ...

4 inserts.
table LMB_ACTION created.
inserting rows ...

206 inserts.
table LMB_ACTION_DEPEND created.
inserting rows ...

2 inserts.
table LMB_ATTRIBUTE_D created.
inserting rows ...

0 inserts.
table LMB_ATTRIBUTE_P created.
inserting rows ...

0 inserts.
table LMB_ATTRIBUTE_W created.
inserting rows ...

0 inserts.
table LMB_CHART_LIST created.
inserting rows ...

2 inserts.
CREATE TABLE LMB_CHARTS (ID NUMERIC(10) NOT NULL,CHART_ID SMALLINT ,FIELD_ID SMALLINT ,AXIS SMALLINT ,FUNCTION SMALLINT ,COLOR VARCHAR(8) ,PRIMARY KEY(ID))
creating table LMB_CHARTS failed!
table LMB_COLORSCHEMES created.
inserting rows ...

2 inserts.
table LMB_CONF_FIELDS created.
inserting rows ...

69 inserts.
table LMB_CONF_GROUPS created.
inserting rows ...

1 inserts.
table LMB_CONF_TABLES created.
inserting rows ...

2 inserts.
table LMB_CONF_VIEWFIELDS created.
inserting rows ...

0 inserts.
table LMB_CONF_VIEWS created.
inserting rows ...

0 inserts.
table LMB_CRONTAB created.
inserting rows ...

0 inserts.
table LMB_CURRENCY created.
inserting rows ...

3 inserts.
table LMB_DBPATCH created.
inserting rows ...

410 inserts.
table LMB_FIELD_TYPES created.
inserting rows ...

45 inserts.
table LMB_FIELD_TYPES_DEPEND created.
inserting rows ...

0 inserts.
table LMB_FONTS created.
inserting rows ...

0 inserts.
table LMB_FORM_LIST created.
inserting rows ...

0 inserts.
table LMB_FORMS created.
inserting rows ...

0 inserts.
table LMB_GROUPS created.
inserting rows ...

1 inserts.
table LMB_GTAB_GROUPDAT created.
inserting rows ...

0 inserts.
table LMB_GTAB_PATTERN created.
inserting rows ...

0 inserts.
table LMB_GTAB_ROWSIZE created.
inserting rows ...

0 inserts.
table LMB_GTAB_STATUS_SAVE created.
inserting rows ...

16 inserts.
table LMB_HISTORY_ACTION created.
inserting rows ...

0 inserts.
table LMB_HISTORY_BACKUP created.
inserting rows ...

0 inserts.
table LMB_HISTORY_UPDATE created.
inserting rows ...

0 inserts.
table LMB_HISTORY_USER created.
inserting rows ...

1 inserts.
table LMB_INDIZE_D created.
inserting rows ...

0 inserts.
table LMB_INDIZE_DS created.
inserting rows ...

0 inserts.
table LMB_INDIZE_F created.
inserting rows ...

0 inserts.
table LMB_INDIZE_FS created.
inserting rows ...

0 inserts.
table LMB_INDIZE_HISTORY created.
inserting rows ...

0 inserts.
table LMB_INDIZE_W created.
inserting rows ...

0 inserts.
table LMB_LANG created.
inserting rows ...

8735 inserts.
table LMB_LANG_DEPEND created.
inserting rows ...

568 inserts.
table LMB_MIMETYPES created.
inserting rows ...

110 inserts.
table LMB_REMINDER created.
inserting rows ...

0 inserts.
table LMB_REMINDER_LIST created.
inserting rows ...

0 inserts.
table LMB_REPORT_LIST created.
inserting rows ...

0 inserts.
table LMB_REPORTS created.
inserting rows ...

0 inserts.
table LMB_RULES_ACTION created.
inserting rows ...

208 inserts.
table LMB_RULES_DATASET created.
inserting rows ...

0 inserts.
table LMB_RULES_FIELDS created.
inserting rows ...

69 inserts.
table LMB_RULES_REPFORM created.
inserting rows ...

0 inserts.
table LMB_RULES_TABLES created.
inserting rows ...

2 inserts.
table LMB_SELECT_D created.
inserting rows ...

0 inserts.
table LMB_SELECT_P created.
inserting rows ...

0 inserts.
table LMB_SELECT_W created.
inserting rows ...

0 inserts.
table LMB_SESSION created.
inserting rows ...

1 inserts.
table LMB_SNAP created.
inserting rows ...

0 inserts.
table LMB_SNAP_SHARED created.
inserting rows ...

0 inserts.
table LMB_SQLRESERVED created.
inserting rows ...

323 inserts.
table LMB_TABLETREE created.
inserting rows ...

0 inserts.
table LMB_TRIGGER created.
inserting rows ...

0 inserts.
table LMB_UGLST created.
inserting rows ...

0 inserts.
table LMB_UMGVAR created.
inserting rows ...

105 inserts.
table LMB_USER_COLORS created.
inserting rows ...

44 inserts.
table LMB_USERDB created.
inserting rows ...

1 inserts.
table LMB_USRGRP_LST created.
inserting rows ...

0 inserts.
table LMB_WFL created.
inserting rows ...

0 inserts.
table LMB_WFL_HISTORY created.
inserting rows ...

0 inserts.
table LMB_WFL_INST created.
inserting rows ...

0 inserts.
table LMB_WFL_TASK created.
inserting rows ...

0 inserts.
table LMB_INDIZE_DS (sid) indexed.
table LMB_SELECT_W (sort) indexed.
table LMB_GTAB_GROUPDAT (dat_id) indexed.
table LMB_INDIZE_FS (wid) indexed.
table LMB_INDIZE_FS (fid) indexed.
table LMB_INDIZE_DS (wid) indexed.
table LMB_SELECT_D (dat_id) indexed.
table LMB_INDIZE_D (sid) indexed.
table LMB_INDIZE_F (sid) indexed.
table LMB_INDIZE_F (fid) indexed.
table LMB_INDIZE_D (ref) indexed.
table LMB_SELECT_W (pool) indexed.
table LMB_SELECT_W (wert) indexed.
table LMB_INDIZE_D (wid) indexed.
table LMB_INDIZE_W (metaphone) indexed.
table LMB_INDIZE_DS (ref) indexed.
table LMB_SELECT_D (w_id) indexed.
table LMB_INDIZE_F (wid) indexed.
table LMB_INDIZE_FS (sid) indexed.
table LMB_INDIZE_W (val) indexed.
rebuild foreign keys... done
adding stored procedures ... done
rebuild trigger... done
rebuild Sequences... failed​

was kann hierfür die Ursache sein?

[Norbert]

Es sieht so aus, dass in der Tabelle LMB_Charts als Feldname das reservierte Word FUNCTION verwendet wird und dies vom MSSQL Server abgelehnt wird.
Außerdem scheint es ein Problem bei rebuild der Sequences zu geben.

[Axel Westhagen]

Hallo Norbert

Welche Version von MSSQL und des Sybase Treibers (freetds) nutzt du?
Hast du den freetds auch wie beschrieben gepached ?

Gruß
Axel

[Norbert]

Hallo Axel,

die MSSQL Version ist10.50.6220.0

ich verwende die neueste freetds Version ( v1.00.24) und so wie es aussieht ist die Stelle schon gepached. Auf jeden Fall sieht sie anders aus als in eurer Beschreibung

odbc_set_sql_type_info(col, drec, stmt->dbc->env->attr.odbc_version);

            drec->sql_desc_fixed_prec_scale = (col->column_prec && col->column_scale) ? SQL_TRUE : SQL_FALSE;
            if (!tds_dstr_dup(&drec->sql_desc_label, &col->column_name))
                    goto memory_error;

            if (tds_dstr_isempty(&col->table_column_name)) {
                    if (!tds_dstr_dup(&drec->sql_desc_name, &col->column_name))
                            goto memory_error;
            } else {
                    if (!tds_dstr_dup(&drec->sql_desc_name, &col->table_column_name))
                            goto memory_error;
                    if (!tds_dstr_dup(&drec->sql_desc_base_column_name, &col->table_column_name))
                            goto memory_error;
            }

Beim compilieren wurde auch dies TDS Version 8.0 nicht akzeptiert. Ich habe es darauf mit 7.4 probiert.

[Norbert]

Ich komme hier leider nicht weiter. Habe gesehen, dass auf dem MS SQL Server alle Tabellen in Upper Case angelegt werden. Ist das normal so bzw. wer kann mir hier weiterhelfen?

[Axel Westhagen]

Das uppercase ist richtig da die meisten Datenbanken keine casesensitiven Tabellennamen/Felder unterstützen. In Limbas werden so alle Tabellen/Felder für alle Datenbanken vereinheitlicht. So ist eine Migration unterschiedlicher Datenbanken möglich. Da diese sowieso in der Beschreibung von Limbas beliebig benannt werden können ist das kein Nachteil.

Ich konnte mir noch nicht die neue freetds Version anschauen oder testen.
Hast du schon mal die Version 0.82 incl. Patch probiert? Der Patch erlaubt Aliasnamen ohne die Limbas nicht funktioniert. Diese Version hat gut funktioniert

Gruß
Axel

[Axel Westhagen]

ich habe eine entsprechende Version von freetds zur verfügung gestellt:
http://www.limbas.org/wiki/MSSQL#freetds

[Norbert]

Hallo Axel,

ich bekomme immer noch ähnliche Fehler, kann aber schon mal eine neue Tabelle anlegen und damit arbeiten. Ich weiß allerdings nicht, wie sich nachfolgende Fehlermeldungen auf den Betrieb auswirken

drop existing trigges ... done
drop existing constraints ... done

table LDMS_FAVORITES_2 created.

inserting rows ...

0 inserts.

table LDMS_FILES_3 created.

inserting rows ...

0 inserts.

table LDMS_META_2 created.

inserting rows ...

0 inserts.

table LDMS_RULES_2 created.

inserting rows ...

3 inserts.

table LDMS_STRUCTURE_2 created.

inserting rows ...

4 inserts.

table LMB_ACTION_2 created.

inserting rows ...

206 inserts.

table LMB_ACTION_DEPEND_2 created.

inserting rows ...

2 inserts.

table LMB_ATTRIBUTE_D_2 created.

inserting rows ...

0 inserts.

table LMB_ATTRIBUTE_P_2 created.

inserting rows ...

0 inserts.

table LMB_ATTRIBUTE_W_2 created.

inserting rows ...

0 inserts.

table LMB_CHART_LIST_2 created.

inserting rows ...

2 inserts.
CREATE TABLE LMB_CHARTS (ID NUMERIC(10) NOT NULL,CHART_ID SMALLINT ,FIELD_ID SMALLINT ,AXIS SMALLINT ,FUNCTION SMALLINT ,COLOR VARCHAR(8) ,PRIMARY KEY(ID))

creating table LMB_CHARTS failed!

table LMB_COLORSCHEMES_2 created.

inserting rows ...

2 inserts.

table LMB_CONF_FIELDS_2 created.

inserting rows ...

69 inserts.

table LMB_CONF_GROUPS_2 created.

inserting rows ...

1 inserts.

table LMB_CONF_TABLES_2 created.

inserting rows ...

2 inserts.

table LMB_CONF_VIEWFIELDS_2 created.

inserting rows ...

0 inserts.

table LMB_CONF_VIEWS_2 created.

inserting rows ...

0 inserts.

table LMB_CRONTAB_2 created.

inserting rows ...

0 inserts.

table LMB_CURRENCY_2 created.

inserting rows ...

3 inserts.

table LMB_DBPATCH_2 created.

inserting rows ...

410 inserts.

table LMB_FIELD_TYPES_2 created.

inserting rows ...

45 inserts.

table LMB_FIELD_TYPES_DEPEND_2 created.

inserting rows ...

0 inserts.

table LMB_FONTS_2 created.

inserting rows ...

0 inserts.

table LMB_FORM_LIST_2 created.

inserting rows ...

0 inserts.

table LMB_FORMS_2 created.

inserting rows ...

0 inserts.

table LMB_GROUPS_2 created.

inserting rows ...

1 inserts.

table LMB_GTAB_GROUPDAT_2 created.

inserting rows ...

0 inserts.

table LMB_GTAB_PATTERN_2 created.

inserting rows ...

0 inserts.

table LMB_GTAB_ROWSIZE_2 created.

inserting rows ...

0 inserts.

table LMB_GTAB_STATUS_SAVE_2 created.

inserting rows ...

16 inserts.

table LMB_HISTORY_ACTION_2 created.

inserting rows ...

0 inserts.

table LMB_HISTORY_BACKUP_2 created.

inserting rows ...

0 inserts.

table LMB_HISTORY_UPDATE_2 created.

inserting rows ...

0 inserts.

table LMB_HISTORY_USER_2 created.

inserting rows ...

1 inserts.

table LMB_INDIZE_D_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_DS_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_F_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_FS_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_HISTORY_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_W_2 created.

inserting rows ...

0 inserts.

table LMB_LANG_2 created.

inserting rows ...

8735 inserts.

table LMB_LANG_DEPEND_2 created.

inserting rows ...

568 inserts.

table LMB_MIMETYPES_2 created.

inserting rows ...

110 inserts.

table LMB_REMINDER_2 created.

inserting rows ...

0 inserts.

table LMB_REMINDER_LIST_2 created.

inserting rows ...

0 inserts.

table LMB_REPORT_LIST_2 created.

inserting rows ...

0 inserts.

table LMB_REPORTS_2 created.

inserting rows ...

0 inserts.

table LMB_RULES_ACTION_2 created.

inserting rows ...

208 inserts.

table LMB_RULES_DATASET_2 created.

inserting rows ...

0 inserts.

table LMB_RULES_FIELDS_2 created.

inserting rows ...

69 inserts.

table LMB_RULES_REPFORM_2 created.

inserting rows ...

0 inserts.

table LMB_RULES_TABLES_2 created.

inserting rows ...

2 inserts.

table LMB_SELECT_D_2 created.

inserting rows ...

0 inserts.

table LMB_SELECT_P_2 created.

inserting rows ...

0 inserts.

table LMB_SELECT_W_2 created.

inserting rows ...

0 inserts.

table LMB_SESSION_2 created.

inserting rows ...

INSERT INTO LMB_SESSION_2 (ID,USER_ID,GROUP_ID,LOGOUT,ERSTDATUM,IP,FILESTRUCT_CHANGED,TABLE_CHANGED,SNAP_CHANGED) VALUES(12rbb7cvvhrjtsjijj1qhb0nn6ublua2798p06ju8118q2lq8qa1,1,1,'FALSE','2016-11-21 13:08:00','127.0.0.1','FALSE','FALSE','FALSE')

1 failure on rows!

table LMB_SNAP_2 created.

inserting rows ...

0 inserts.

table LMB_SNAP_SHARED_2 created.

inserting rows ...

0 inserts.

table LMB_SQLRESERVED_2 created.

inserting rows ...

323 inserts.

table LMB_TABLETREE_2 created.

inserting rows ...

0 inserts.

table LMB_TRIGGER_2 created.

inserting rows ...

0 inserts.

table LMB_UGLST_2 created.

inserting rows ...

0 inserts.

table LMB_UMGVAR_2 created.

inserting rows ...

105 inserts.

table LMB_USER_COLORS_2 created.

inserting rows ...

44 inserts.

table LMB_USERDB_2 created.

inserting rows ...

1 inserts.

table LMB_USRGRP_LST_2 created.

inserting rows ...

0 inserts.

table LMB_WFL_2 created.

inserting rows ...

0 inserts.

table LMB_WFL_HISTORY_2 created.

inserting rows ...

0 inserts.

table LMB_WFL_INST_2 created.

inserting rows ...

0 inserts.

table LMB_WFL_TASK_2 created.

inserting rows ...

0 inserts.

table LMB_INDIZE_DS_2 (sid) indexed.

table LMB_SELECT_W_2 (sort) indexed.

table LMB_GTAB_GROUPDAT_2 (dat_id) indexed.

table LMB_INDIZE_FS_2 (wid) indexed.

table LMB_INDIZE_FS_2 (fid) indexed.

table LMB_INDIZE_DS_2 (wid) indexed.

table LMB_SELECT_D_2 (dat_id) indexed.

table LMB_INDIZE_D_2 (sid) indexed.

table LMB_INDIZE_F_2 (sid) indexed.

table LMB_INDIZE_F_2 (fid) indexed.

table LMB_INDIZE_D_2 (ref) indexed.

table LMB_SELECT_W_2 (pool) indexed.

table LMB_SELECT_W_2 (wert) indexed.

table LMB_INDIZE_D_2 (wid) indexed.

table LMB_INDIZE_W_2 (metaphone) indexed.

table LMB_INDIZE_DS_2 (ref) indexed.

table LMB_SELECT_D_2 (w_id) indexed.

table LMB_INDIZE_F_2 (wid) indexed.

table LMB_INDIZE_FS_2 (sid) indexed.

table LMB_INDIZE_W_2 (val) indexed.
rebuild foreign keys... done
adding stored procedures ... done
rebuild trigger... done
rebuild Sequences... failed​

[Axel Westhagen]

Wie du siehst wurden die alten Tabellen nicht gelöscht und alle neuen Tabellen mit *_2 angelegt.
Also erst mal alle Tabellen löschen und dann nochmal installieren. Am einfachsten die Datenbank löschen und neu anlegen.
Die beiden Fehler in LMB_SESSION und LMB_CHART erst mal ignorieren.

Gruß
Axel