Fehler bei Update auf Open 0.9.9-6
-
Hmm spiel mal dein Backup ein und führ folgendes Statement (in einem Schritt) aus:
DROP TABLE IF EXISTS `isys_property_2_cat`; CREATE TABLE `isys_property_2_cat` ( `isys_property_2_cat__id` int(10) unsigned NOT NULL AUTO_INCREMENT, `isys_property_2_cat__isysgui_catg__id` int(10) unsigned DEFAULT NULL, `isys_property_2_cat__isysgui_cats__id` int(10) unsigned DEFAULT NULL, `isys_property_2_cat__cat_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_columnname` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_columnname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`isys_property_2_cat__id`), KEY `isys_property_2_cat__isysgui_catg__id` (`isys_property_2_cat__isysgui_catg__id`), KEY `isys_property_2_cat__isysgui_cats__id` (`isys_property_2_cat__isysgui_cats__id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET @GLOBAL_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__GLOBAL'); SET @MODEL_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__MODEL'); SET @FF_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__FORMFACTOR'); SET @CPU_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__CPU'); SET @MEM_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__MEMORY'); SET @PC_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__POWER_CONSUMER'); SET @NET_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__NETWORK'); SET @STOR_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__STORAGE'); SET @APP_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__APPLICATION'); SET @ACC_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__ACCESS'); SET @BAK_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__BACKUP'); SET @EMERG_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__EMERGENCY_PLAN'); SET @FILE_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__FILE'); SET @CON_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__CONTACT'); SET @LOG_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__LOGBOOK'); SET @LOC_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__LOCATION'); SET @IMG_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__IMAGE'); SET @MAN_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__IMAGE'); SET @SND_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__SOUND'); SET @GRA_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__GRAPHIC'); SET @ACCOUNT_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__ACCOUNTING'); SET @PORT_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CMDB__SUBCAT__NETWORK_PORT'); SET @IFACE_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CMDB__SUBCAT__NETWORK_INTERFACE_P'); SET @IFACEL_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CMDB__SUBCAT__NETWORK_INTERFACE_L'); SET @STORCONT_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CMDB__SUBCAT__STORAGE__CONTROLLER'); SET @FCPORT_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__CONTROLLER_FC_PORT'); SET @SAN_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__SANPOOL'); SET @IP_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__IP'); SET @VER_ID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__VERSION'); SET @ENC_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__ENCLOSURE'); SET @BLD_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__BUILDING'); SET @ROOM_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__ROOM'); SET @SRV_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__SERVICE'); SET @SWITCH_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__SWITCH_NET'); SET @POBJ_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__POBJ'); SET @WAN_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__WAN'); SET @EP_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__EMERGENCY_PLAN'); SET @AC_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__AC'); SET @SSAN_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__SAN'); SET @WAP_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__ACCESS_POINT'); SET @MON_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__MONITOR'); SET @CLIENT_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__CLIENT'); SET @FCSWITCH_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__SWITCH_FC'); SET @ROUTER_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__ROUTER'); SET @PRT_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__PRT'); SET @SFILE_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__FILE'); SET @SAPP_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__APPLICATION'); SET @SNET_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__NET'); SET @CELL_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__CELL_PHONE_CONTRACT'); SET @MNT_ID = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__MAINTENANCE'); INSERT INTO `isys_property_2_cat` (`isys_property_2_cat__isysgui_catg__id`, `isys_property_2_cat__isysgui_cats__id`, `isys_property_2_cat__cat_type`, `isys_property_2_cat__property1_title`, `isys_property_2_cat__property1_columnname`, `isys_property_2_cat__property1_reference`, `isys_property_2_cat__property2_title`, `isys_property_2_cat__property2_columnname`, `isys_property_2_cat__property2_reference`) VALUES (@GLOBAL_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_PURPOSE', 'isys_catg_global_list__isys_purpose__id', 'isys_purpose', NULL, NULL, NULL), (@GLOBAL_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_CATEGORY', 'isys_catg_global_list__isys_catg_global_category__id', 'isys_catg_global_category', NULL, NULL, NULL), (@GLOBAL_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_AQUIRE', 'isys_catg_global_list__acquirementdate', NULL, NULL, NULL, NULL), (@MODEL_ID, NULL, 'g', 'LC__CMDB__CATG__MODEL_MANUFACTURE', 'isys_catg_model_list__isys_model_manufacturer__id', 'isys_model_manufacturer', NULL, NULL, NULL), (@MODEL_ID, NULL, 'g', 'LC__CMDB__CATG__MODEL_TITLE', 'isys_catg_model_list__isys_model_title__id', 'isys_model_title', NULL, NULL, NULL), (@MODEL_ID, NULL, 'g', 'LC__CMDB__CATG__MODEL_SERIAL', 'isys_catg_model_list__serial', NULL, NULL, NULL, NULL), (@MODEL_ID, NULL, 'g', 'LC__CMDB__CATG__MODEL_FIRMWARE', 'isys_catg_model_list__firmware', NULL, NULL, NULL, NULL), (@FF_ID, NULL, 'g', 'LC__CMDB__CATG__FORMFACTOR', 'isys_catg_formfactor_list__isys_catg_formfactor_type__id', 'isys_catg_formfactor_type', NULL, NULL, NULL), (@FF_ID, NULL, 'g', 'LC__CMDB__CATG__FORMFACTOR_RACKUNITS', 'isys_catg_formfactor_list__rackunits', NULL, NULL, NULL, NULL), (@FF_ID, NULL, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_HEIGHT', 'isys_catg_formfactor_list__installation_hight', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'), (@FF_ID, NULL, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_WIDTH', 'isys_catg_formfactor_list__installation_width', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'), (@FF_ID, NULL, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH', 'isys_catg_formfactor_list__installation_depth', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'), (@CPU_ID, NULL, 'g', 'LC__CMDB__CATG__CPU_TITLE', 'isys_catg_cpu_list__title', NULL, NULL, NULL, NULL), (@CPU_ID, NULL, 'g', 'LC__CMDB__CATG__CPU_MANUFACTURER', 'isys_catg_cpu_list__isys_catg_cpu_manufacturer__id', 'isys_catg_cpu_manufacturer', NULL, NULL, NULL), (@CPU_ID, NULL, 'g', 'LC__CMDB__CATG__CPU_TYPE', 'isys_catg_cpu_list__isys_catg_cpu_type__id', 'isys_catg_cpu_type', NULL, NULL, NULL), (@CPU_ID, NULL, 'g', 'LC__CMDB__CATG__CPU_FREQUENCY', 'isys_catg_cpu_list__isys_catg_cpu_frequency__id', 'isys_catg_cpu_frequency', NULL, NULL, NULL), (@MEM_ID, NULL, 'g', 'LC__CMDB_CATG__MEMORY_TITLE', 'isys_catg_memory_list__isys_memory_title__id', 'isys_memory_title', NULL, NULL, NULL), (@MEM_ID, NULL, 'g', 'LC__CMDB_CATG__MEMORY_MANUFACTURER', 'isys_catg_memory_list__isys_memory_manufacturer__id', 'isys_memory_manufacturer', NULL, NULL, NULL), (@MEM_ID, NULL, 'g', 'LC__CMDB_CATG__MEMORY_TYPE', 'isys_catg_memory_list__isys_memory_type__id', 'isys_memory_type', NULL, NULL, NULL), (@MEM_ID, NULL, 'g', 'LC__CMDB_CATG__MEMORY_QUANTITY', 'isys_catg_memory_list__quantity', NULL, NULL, NULL, NULL), (@MEM_ID, NULL, 'g', 'LC__CMDB_CATG__MEMORY_CAPACITY', 'isys_catg_memory_list__capacity', NULL, 'LC__CMDB_CATG__MEMORY_UNIT', 'isys_catg_memory_list__isys_memory_unit__id', 'isys_memory_unit'), (@PC_ID, NULL, 'g', 'LC__CMDB__CATG__POWER_CONSUMER_TITLE', 'isys_catg_power_consumer_list__isys_pc_title__id', 'isys_pc_title', NULL, NULL, NULL), (@PC_ID, NULL, 'g', 'LC__CMDB__CATG__POWER_CONSUMER__MANUFACTURE', 'isys_catg_power_consumer_list__isys_pc_manufacturer__id ', 'isys_pc_manufacturer', NULL, NULL, NULL), (@PC_ID, NULL, 'g', 'LC__CMDB__CATG__POWER_CONSUMER__MODEL', 'isys_catg_power_consumer_list__isys_pc_model__id', 'isys_pc_model', NULL, NULL, NULL), (@NET_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_TITLE', 'isys_catg_netp_list__title', NULL, NULL, NULL, NULL), (@NET_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_MANUFACTURER', 'isys_catg_netp_list__isys_iface_manufacturer__id', 'isys_iface_manufacturer', NULL, NULL, NULL), (@NET_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_MODEL', 'isys_catg_netp_list__isys_iface_model__id', 'isys_iface_model', NULL, NULL, NULL), (@NET_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_SERIAL', 'isys_catg_netp_list__serial', NULL, NULL, NULL, NULL), (@NET_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_SLOTNUMBER', 'isys_catg_netp_list__slotnumber', NULL, NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_CONTROLLER', 'isys_catg_stor_list__isys_catg_controller_list__id', 'isys_catg_controller_list', NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_CONNECTION_TYPE', 'isys_catg_stor_list__isys_stor_con_type__id', 'isys_stor_con_type', NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_HOTSPARE', 'isys_catg_stor_list__hotspare', NULL, NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_CAPACITY', 'isys_catg_stor_list__capacity', NULL, 'LC__CMDB_CATG__MEMORY_UNIT', 'isys_catg_stor_list__isys_stor_unit__id', 'isys_stor_unit'), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_TYPE', 'isys_catg_stor_list__isys_stor_type__id', 'isys_stor_type', NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_TITLE', 'isys_catg_stor_list__title', NULL, NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_MANUFACTURER', 'isys_catg_stor_list__isys_stor_manufacturer__id', 'isys_stor_manufacturer', NULL, NULL, NULL), (@STOR_ID, NULL, 'g', 'LC__CATG__STORAGE_MODEL', 'isys_catg_stor_list__isys_stor_model__id', 'isys_stor_model', NULL, NULL, NULL), (@APP_ID, NULL, 'g', 'LC__CMDB__CATG__APPLICATION_TITLE', 'isys_catg_application_list__title', NULL, NULL, NULL, NULL), (@APP_ID, NULL, 'g', 'LC__CMDB__CATG__APPLICATION_OBJ_APPLICATION', 'isys_catg_application_list__isys_connection__id', 'isys_connection', NULL, NULL, NULL), (@ACC_ID, NULL, 'g', 'LC__CMDB__CATG__ACCESS_TITLE', 'isys_catg_access_list__title', NULL, NULL, NULL, NULL), (@ACC_ID, NULL, 'g', 'LC__CMDB__CATG__ACCESS_TYPE', 'isys_catg_access_list__isys_access_type__id', 'isys_access_type', NULL, NULL, NULL), (@ACC_ID, NULL, 'g', 'LC__CMDB__CATG__ACCESS_URL', 'isys_catg_access_list__url', NULL, NULL, NULL, NULL), (@ACC_ID, NULL, 'g', 'LC__CMDB__CATG__ACCESS_PRIMARY', 'isys_catg_access_list__primary', NULL, NULL, NULL, NULL), (@BAK_ID, NULL, 'g', 'LC__CMDB__CATG__BACKUP__TITLE', 'isys_catg_backup_list__title', NULL, NULL, NULL, NULL), (@EMERG_ID, NULL, 'g', 'LC__CMDB__CATG__EMERGENCY_PLAN_TITLE', 'isys_catg_emergency_plan_list__title', NULL, NULL, NULL, NULL), (@FILE_ID, NULL, 'g', 'LC__CMDB__CATG__FILE_TITLE', 'isys_catg_file_list__title', NULL, NULL, NULL, NULL), (@CON_ID, NULL, 'g', 'LC__CMDB__CATG__CONTACT_TITLE', 'isys_catg_contact_list__isys_contact__id', 'isys_contact', NULL, NULL, NULL), (@LOG_ID, NULL, 'g', 'LC__CMDB__CATG__LOGBOOK', 'isys_catg_logb_list__isys_logbook__id', 'isys_logbook', NULL, NULL, NULL), (@LOC_ID, NULL, 'g', 'LC__CMDB__CATG__LOCATION_POS', 'isys_catg_location_list__pos', NULL, NULL, NULL, NULL), (@LOC_ID, NULL, 'g', 'LC__CMDB__CATG__LOCATION_FRONTSIDE', 'isys_catg_location_list__frontside', NULL, NULL, NULL, NULL), (@IMG_ID, NULL, 'g', 'LC__CMDB__CATG__IMAGE_TITLE', 'isys_catg_image_list__title', NULL, NULL, NULL, NULL), (@IMG_ID, NULL, 'g', 'LC__CMDB__CATG__IMAGE_OBJ_FILE', 'isys_catg_image_list__image_link', NULL, NULL, NULL, NULL), (@MAN_ID, NULL, 'g', 'LC__CMDB__CATG__MANUAL_TITLE', 'isys_catg_manual_list__title', NULL, NULL, NULL, NULL), (@SND_ID, NULL, 'g', 'LC__CMDB__CATG__TITLE', 'isys_catg_sound_list__title', NULL, NULL, NULL, NULL), (@SND_ID, NULL, 'g', 'LC__CMDB__CATG__MANUFACTURER', 'isys_catg_sound_list__isys_sound_manufacturer__id', 'isys_sound_manufacturer', NULL, NULL, NULL), (@GRA_ID, NULL, 'g', 'LC__CMDB__CATG__TITLE', 'isys_catg_graphic_list__title', NULL, NULL, NULL, NULL), (@GRA_ID, NULL, 'g', 'LC__CMDB__CATG__MANUFACTURER', 'isys_catg_graphic_list__isys_graphic_manufacturer__id', 'isys_graphic_manufacturer', NULL, NULL, NULL), (@GRA_ID, NULL, 'g', 'LC__CMDB__CATG__MEMORY', 'isys_catg_graphic_list__memory', NULL, 'LC__CMDB__CATG__GRAPHIC_MEMORY_UNIT', 'isys_catg_graphic_list__isys_memory_unit__id', 'isys_memory_unit'), (@ACCOUNT_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_AQUIRE', 'isys_catg_accounting_list__acquirementdate', NULL, NULL, NULL, NULL), (@ACCOUNT_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_GUARANTEE_PERIOD', 'isys_catg_accounting_list__guarantee_period', NULL, 'LC__CMDB__CATG__GLOBAL_GUARANTEE_PERIOD_UNIT', 'isys_catg_accounting_list__isys_guarantee_period_unit__id', 'isys_guarantee_period_unit'), (@ACCOUNT_ID, NULL, 'g', 'LC__CMDB__CATG__GLOBAL_PRICE', 'isys_catg_accounting_list__price', NULL, NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__TITLE', 'isys_catg_port_list__title', NULL, NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__TYPE', 'isys_catg_port_list__isys_port_type__id', 'isys_port_type', NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__PLUG', 'isys_catg_port_list__isys_plug_type__id', 'isys_plug_type', NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__NEGOTIATION', 'isys_catg_port_list__isys_port_negotiation__id', 'isys_port_negotiation', NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__DUPLEX', 'isys_catg_port_list__isys_port_duplex__id', 'isys_port_duplex', NULL, NULL, NULL), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__SPEED', 'isys_catg_port_list__port_speed_value', NULL, 'LC__CATG__MEMORY_UNIT', 'isys_catg_port_list__isys_port_speed__id', 'isys_port_speed'), (@PORT_ID, NULL, 'g', 'LC__CMDB__CATG__PORT__STANDARD', 'isys_catg_port_list__isys_port_standard__id', 'isys_port_standard', NULL, NULL, NULL), (@IFACE_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_TITLE', 'isys_catg_netp_list__title', NULL, NULL, NULL, NULL), (@IFACE_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_MANUFACTURER', 'isys_catg_netp_list__isys_iface_manufacturer__id', 'isys_iface_manufacturer', NULL, NULL, NULL), (@IFACE_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_MODEL', 'isys_catg_netp_list__isys_iface_model__id', 'isys_iface_model', NULL, NULL, NULL), (@IFACE_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_P_SERIAL', 'isys_catg_netp_list__serial', NULL, NULL, NULL, NULL), (@IFACE_ID, NULL, 'g' , 'LC__CMDB__CATG__INTERFACE_P_SLOTNUMBER', 'isys_catg_netp_list__slotnumber', NULL, NULL, NULL, NULL), (@IFACEL_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_L__TITLE', 'isys_netp_ifacel__title', NULL, NULL, NULL, NULL), (@IFACEL_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_L__TYPE', 'isys_netp_ifacel__isys_netx_ifacel_type__id', 'isys_netx_ifacel_type', NULL, NULL, NULL), (@IFACEL_ID, NULL, 'g', 'LC__CMDB__CATG__INTERFACE_L__STANDARD', 'isys_netp_ifacel__isys_netp_ifacel_standard__id', 'isys_netp_ifacel_standard', NULL, NULL, NULL), (@STORCONT_ID, NULL, 'g', 'LC__CATG__STORAGE_CONTROLLER_TITLE', 'isys_catg_controller_list__title', NULL, NULL, NULL, NULL), (@STORCONT_ID, NULL, 'g', 'LC__CATG__STORAGE_CONTROLLER_TYPE', 'isys_catg_controller_list__isys_controller_type__id', 'isys_controller_type', NULL, NULL, NULL), (@STORCONT_ID, NULL, 'g', 'LC__CATG__STORAGE_CONTROLLER_MANUFACTURER', 'isys_catg_controller_list__isys_controller_manufacturer__id', 'isys_controller_manufacturer', NULL, NULL, NULL), (@STORCONT_ID, NULL, 'g', 'LC__CATG__STORAGE_CONTROLLER_MODEL', 'isys_catg_controller_list__isys_controller_model__id', 'isys_controller_model', NULL, NULL, NULL), (@FCPORT_ID, NULL, 'g', 'LC__CATG__CONTROLLER_FC_PORT_TITLE', 'isys_catg_fc_port_list__title', NULL, NULL, NULL, NULL), (@FCPORT_ID, NULL, 'g', 'LC__CATG__CONTROLLER_FC_PORT_TYPE', 'isys_catg_fc_port_list__isys_fc_port_type__id', 'isys_fc_port_type', NULL, NULL, NULL), (@FCPORT_ID, NULL, 'g', 'LC__CATG__CONTROLLER_FC_PORT_MEDIUM', 'isys_catg_fc_port_list__isys_fc_port_medium__id', 'isys_fc_port_medium', NULL, NULL, NULL), (@FCPORT_ID, NULL, 'g', 'LC__CATG__CONTROLLER_FC_PORT_NODE_WWN', 'isys_catg_fc_port_list__wwn', NULL, NULL, NULL, NULL), (@FCPORT_ID, NULL, 'g', 'LC__CATG__CONTROLLER_FC_PORT_PORT_WWN', 'isys_catg_fc_port_list__wwpn', NULL, NULL, NULL, NULL), (@SAN_ID, NULL, 'g', 'LC__CATD__SANPOOL_TITLE', 'isys_catg_sanpool_list__title', NULL, NULL, NULL, NULL), (@SAN_ID, NULL, 'g', 'LC__CATD__SANPOOL_CAPACITY', 'isys_catg_sanpool_list__capacity', NULL, 'LC__CATG__MEMORY_UNIT', 'isys_catg_sanpool_list__isys_memory_unit__id', 'isys_memory_unit'), (@IP_ID, NULL, 'g', 'LC__CMDB__CATS__NET__TYPE', 'isys_catg_ip_list__isys_net_type__id', 'isys_net_type', NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__ADDRESS', 'isys_catg_ip_list__address', NULL, NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__SUBNETMASK', 'isys_catg_ip_list__mask', NULL, NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__DEFAULTGATEWAY', 'isys_catg_ip_list__gateway', NULL, NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__HOSTNAME', 'isys_catg_ip_list__hostname', NULL, NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__ASSIGN', 'isys_catg_ip_list__isys_ip_assignment__id', 'isys_ip_assignment', NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__DNSSERVER', 'isys_catg_ip_list__dns_server', NULL, NULL, NULL, NULL), (@IP_ID, NULL, 'g', 'LC__CATP__IP__DNSDOMAIN', 'isys_catg_ip_list__dns_domain', NULL, NULL, NULL, NULL), (@VER_ID, NULL, 'g', 'LC__CATG__SERVICEPACK', 'isys_catg_version_list__servicepack', NULL, NULL, NULL, NULL), (@VER_ID, NULL, 'g', 'LC__CATG__KERNEL', 'isys_catg_version_list__kernel', NULL, NULL, NULL, NULL), (@VER_ID, NULL, 'g', 'LC__CATG__PATCHES', 'isys_catg_version_list__hotfix', NULL, NULL, NULL, NULL), (NULL, @ENC_ID, 's', 'LC__CATG__RACK_HEIGHT_UNITS', 'isys_cats_enclosure_list__rack_units', NULL, NULL, NULL, NULL), (NULL, @ENC_ID, 's', 'LC__CATG__RACK_WIDTH', 'isys_cats_enclosure_list__rack_width', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'), (NULL, @ENC_ID, 's', 'LC__CATG__RACK_HEIGHT', 'isys_cats_enclosure_list__rack_height', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'), (NULL, @ENC_ID, 's', 'LC__CATG__RACK_DEPTH', 'isys_cats_enclosure_list__rack_depth', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'), (NULL, @BLD_ID, 's', 'LC__CATS__STREET', 'isys_cats_building_list__street_postal', NULL, NULL, NULL, NULL), (NULL, @BLD_ID, 's', 'LC__CATS__PCODE', 'isys_cats_building_list__postalcode', NULL, NULL, NULL, NULL), (NULL, @BLD_ID, 's', 'LC__CATS__CITY', 'isys_cats_building_list__city_postal', NULL, NULL, NULL, NULL), (NULL, @BLD_ID, 's', 'LC__CATS__COUNT_FLOOR', 'isys_cats_building_list__count_floor', NULL, NULL, NULL, NULL), (NULL, @ROOM_ID, 's', 'LC__CMDB__CATS__ROOM_TYPE', 'isys_cats_room_list__isys_room_type__id', 'isys_room_type', NULL, NULL, NULL), (NULL, @ROOM_ID, 's', 'LC__CMDB__CATS__ROOM_NUMBER', 'isys_cats_room_list__number', NULL, NULL, NULL, NULL), (NULL, @ROOM_ID, 's', 'LC__CMDB__CATS__ROOM_FLOOR', 'isys_cats_room_list__floor', NULL, NULL, NULL, NULL), (NULL, @SRV_ID, 's', 'LC__CMDB__CATS__SERVICE_SPECIFICATION', 'isys_cats_service_list__specification', NULL, NULL, NULL, NULL), (NULL, @SRV_ID, 's', 'LC__CMDB__CATS__SERVICE_MANUFACTURER', 'isys_cats_service_list__isys_service_manufacturer__id', 'isys_service_manufacturer', NULL, NULL, NULL), (NULL, @SRV_ID, 's', 'LC__CMDB__CATS__SERVICE_RELEASE', 'isys_cats_service_list__release', NULL, NULL, NULL, NULL), (NULL, @SWITCH_ID, 's', 'LC__CATG__SWITCH_MODULAR', 'isys_cats_switch_net_list__modular', NULL, NULL, NULL, NULL), (NULL, @SWITCH_ID, 's', 'LC__CATG__SWITCH_COUNT_SLOT', 'isys_cats_switch_net_list__count_slot', NULL, NULL, NULL, NULL), (NULL, @POBJ_ID, 's', 'LC__CMDB__CATS__POBJ_TYPE', 'isys_cats_pobj_list__isys_pobj_type__id', 'isys_pobj_type', NULL, NULL, NULL), (NULL, @POBJ_ID, 's', 'LC__CMDB__CATS__POBJ_VOLT', 'isys_cats_pobj_list__volt', NULL, NULL, NULL, NULL), (NULL, @POBJ_ID, 's', 'LC__CMDB__CATS__POBJ_WATT', 'isys_cats_pobj_list__watt', NULL, NULL, NULL, NULL), (NULL, @POBJ_ID, 's', 'LC__CMDB__CATS__POBJ_AMPERE', 'isys_cats_pobj_list__ampere', NULL, NULL, NULL, NULL), (NULL, @WAN_ID, 's', 'LC__CMDB__CATS__WAN_ROLE', 'isys_cats_wan_list__isys_wan_role__id', 'isys_wan_role', NULL, NULL, NULL), (NULL, @WAN_ID, 's', 'LC__CMDB__CATS__WAN_TYPE', 'isys_cats_wan_list__isys_wan_type__id', 'isys_wan_type', NULL, NULL, NULL), (NULL, @WAN_ID, 's', 'LC__CMDB__CATS__WAN_CAPACTIY_UNIT', 'isys_san_capacity_unit_isys_san_capacity_unit__id', 'isys_wan_capacity_unit', NULL, NULL, NULL), (NULL, @WAN_ID, 's', 'LC__CMDB__CATS__WAN_CAPACITY', 'isys_cats_wan_list__capacity', NULL, NULL, NULL, NULL), (NULL, @EP_ID, 's', 'LC__CMDB__CATS__EMERGENCY_PLAN_CALC_TIME_NEEDED', 'isys_cats_emergency_plan_list__calc_time_need', NULL, 'LC__CMDB__CATS__EMERGENCY_PLAN_UNIT_OF_TIME', 'isys_cats_emergency_plan_list__isys_unit_of_time__id', 'isys_unit_of_time'), (NULL, @EP_ID, 's', 'LC__CMDB__CATS__EMERGENCY_PLAN_PRACTICE_ACTUAL_DATE', 'isys_cats_emergency_plan_list__practice_actual_date', NULL, NULL, NULL, NULL), (NULL, @AC_ID, 's', 'LC__CATS__AC_TYPE', 'isys_cats_ac_list__isys_ac_type__id', 'isys_ac_type', NULL, NULL, NULL), (NULL, @AC_ID, 's', 'LC__CATS__AC_THRESHOLD', 'isys_cats_ac_list__threshold', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_temp_unit__id', 'isys_temp_unit'), (NULL, @AC_ID, 's', 'LC__CATS__AC_REFRIGERATING_CAPACITY', 'isys_cats_ac_list__capacity', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_ac_refrigerating_capacity_unit__id', 'isys_ac_refrigerating_capacity_unit'), (NULL, @AC_ID, 's', 'LC__CATS__AC_AIR_QUANTITY', 'isys_cats_ac_list__air_quantity', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_ac_air_quantity_unit__id', 'isys_ac_air_quantity_unit'), (NULL, @AC_ID, 's', 'LC__CATG__RACK_WIDTH', 'isys_cats_ac_list__width', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL), (NULL, @AC_ID, 's', 'LC__CATG__RACK_HEIGHT', 'isys_cats_ac_list__height', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL), (NULL, @AC_ID, 's', 'LC__CATG__RACK_DEPTH', 'isys_cats_ac_list__depth', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL), (NULL, @MNT_ID, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_NUMBER', 'isys_cats_maintenance_list__contract_number', NULL, NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_DURATION_START', 'isys_cats_maintenance_list__contract_duration_start', NULL, NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_DURATION_END', 'isys_cats_maintenance_list__contract_duration_end', NULL, NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_REACTION_RATE', 'isys_cats_maintenance_list__isys_maintenance_reaction_rate__id', 'isys_maintenance_reaction_rate', NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'LC__UNIVERSAL__COSTS', 'isys_cats_maintenance_list__costs', NULL, NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'LC__CMDB__CATG__DESCRIPTION', 'isys_cats_maintenance_list__contract_description', NULL, NULL, NULL, NULL), (NULL, @MNT_ID, 's', 'Support-URL', 'isys_cats_maintenance_list__support_url', NULL, NULL, NULL, NULL), (NULL, @SSAN_ID, 's', 'LC__CMDB__CATS__SAN_CAPACITY_VALUE', 'isys_cats_san_list__capacity', NULL, 'LC__CATG__MEMORY_UNIT', 'isys_cats_san_list__isys_stor_unit__id', 'isys_stor_unit'), (NULL, @WAP_ID, 's', 'LC__CATD__TITLE', 'isys_cats_access_point_list__title', NULL, NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_FUNCTION', 'isys_cats_access_point_list__isys_wlan_function__id', 'isys_wlan_function', NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_STANDARD', 'isys_cats_access_point_list__isys_wlan_standard__id', 'isys_wlan_standard', NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_CHANNEL', 'isys_cats_access_point_list__isys_wlan_channel__id', 'isys_wlan_channel', NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_BRODCAST_SSID', 'isys_cats_access_point_list__broadcast_ssid', NULL, NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_SSID', 'isys_cats_access_point_list__ssid', NULL, NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_MAC_FILTER', 'isys_cats_access_point_list__mac_filter', NULL, NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_AUTH', 'isys_cats_access_point_list__isys_wlan_auth__id', 'isys_wlan_auth', NULL, NULL, NULL), (NULL, @WAP_ID, 's', 'LC__CMDB__CATS__ACCESS_POINT_ENCRYPTION', 'isys_cats_access_point_list__isys_wlan_encryption__id', 'isys_wlan_encryption', NULL, NULL, NULL), (NULL, @MON_ID, 's', 'LC__CMDB__CATS__MONITOR_DISPLAY', 'isys_cats_monitor_list__display', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_monitor_list__isys_monitor_unit__id', 'isys_monitor_unit'), (NULL, @MON_ID, 's', 'LC__CMDB__CATS__MONITOR_TYPE', 'isys_cats_monitor_list__isys_monitor_type__id', 'isys_monitor_type', NULL, NULL, NULL), (NULL, @MON_ID, 's', 'LC__CMDB__CATS__MONITOR_RESOLUTION', 'isys_cats_monitor_list__isys_monitor_resolution__id', 'isys_monitor_resolution', NULL, NULL, NULL), (NULL, @CLIENT_ID, 's', 'LC__CMDB__CATS__CLIENT_TYPE', 'isys_cats_client_list__isys_client_type__id', 'isys_client_type', NULL, NULL, NULL), (NULL, @FCSWITCH_ID, 's', 'LC__CMDB__CATG__TITLE', 'isys_cats_switch_fc_list__title', NULL, NULL, NULL, NULL), (NULL, @FCSWITCH_ID, 's', 'LC__CMDB__CATS__SWITCH_FC_ACTIVE', 'isys_cats_switch_fc_list__unit_active', NULL, NULL, NULL, NULL), (NULL, @ROUTER_ID, 's', 'LC__CATG__SWITCH_MODULAR', 'isys_cats_router_list__modular', NULL, NULL, NULL, NULL), (NULL, @ROUTER_ID, 's', 'LC__CATG__SWITCH_COUNT_SLOT', 'isys_cats_router_list__count_slot', NULL, NULL, NULL, NULL), (NULL, @PRT_ID, 's', 'LC__CMDB__CATS__PRT_TYPE', 'isys_cats_prt_list__isys_cats_prt_type__id', 'isys_cats_prt_type', NULL, NULL, NULL), (NULL, @PRT_ID, 's', 'LC__CMDB__CATS__PRT_ISCOLOR', 'isys_cats_prt_list__iscolor', NULL, NULL, NULL, NULL), (NULL, @PRT_ID, 's', 'LC__CMDB__CATS__PRT_ISDUPLEX', 'isys_cats_prt_list__isduplex', NULL, NULL, NULL, NULL), (NULL, @PRT_ID, 's', 'LC__CMDB__CATS__PRT_EMULATION', 'isys_cats_prt_list__isys_cats_prt_emulation__id', 'isys_cats_prt_emulation', NULL, NULL, NULL), (NULL, @SFILE_ID, 's', 'LC__CMDB__CATG__GLOBAL_CATEGORY', 'isys_cats_file_list__isys_file_category__id', 'isys_file_category', NULL, NULL, NULL), (NULL, @SFILE_ID, 's', 'LC__CMDB__CATG__GLOBAL_GROUP', 'isys_cats_file_list__isys_file_group__id', 'isys_file_group', NULL, NULL, NULL), (NULL, @SFILE_ID, 's', 'LC__CMDB__CATG__VERSION', 'isys_cats_file_list__isys_file_version__id', 'isys_file_version', NULL, NULL, NULL), (NULL, @SAPP_ID, 's', 'LC__CMDB__CATS__APPLICATION_SPECIFICATION', 'isys_cats_application_list__specification', NULL, NULL, NULL, NULL), (NULL, @SAPP_ID, 's', 'LC__CMDB__CATS__APPLICATION_MANUFACTURER', 'isys_cats_application_list__isys_application_manufacturer__id', 'isys_application_manufacturer', NULL, NULL, NULL), (NULL, @SAPP_ID, 's', 'LC__CMDB__CATS__APPLICATION_RELEASE', 'isys_cats_application_list__release', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__TITLE', 'isys_cats_net_list__title', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__TYPE', 'isys_cats_net_list__isys_net_type__id', 'isys_net_type', NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__NET', 'isys_cats_net_list__address', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__MASK', 'isys_cats_net_list__mask', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__DEF_GW', 'isys_cats_net_list__def_gw', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__DHCP', 'isys_cats_net_list__dhcp', NULL, NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__DNS_SERVER', 'isys_cats_net_list__isys_net_dns_server__id', 'isys_net_dns_server', NULL, NULL, NULL), (NULL, @SNET_ID, 's', 'LC__CMDB__CATS__NET__DNS_DOMAIN', 'isys_cats_net_list__isys_net_dns_domain__id', 'isys_net_dns_domain', NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__TYPE', 'isys_cats_cp_contract_list__isys_cp_contract_type__id', 'isys_cp_contract_type', NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_cats_cp_contract_list__card_number', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__START_DATE', 'isys_cats_cp_contract_list__start_date', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__END_DATE', 'isys_cats_cp_contract_list__end_date', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__THRESHOLD', 'isys_cats_cp_contract_list__threshold_date', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_cats_cp_contract_list__phone_number', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_cats_cp_contract_list__pin', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_cats_cp_contract_list__pin2', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_cats_cp_contract_list__puk', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_cats_cp_contract_list__puk2', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_cats_cp_contract_list__tc_card_number', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_cats_cp_contract_list__tc_phone_number', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_cats_cp_contract_list__tc_pin', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_cats_cp_contract_list__tc_pin2', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_cats_cp_contract_list__tc_puk', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_cats_cp_contract_list__tc_puk2', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATS_CP_CONTRACT__SERIAL_NUMBER', 'isys_cats_cp_contract_list__serial_number', NULL, NULL, NULL, NULL), (NULL, @CELL_ID, 's', 'LC__CMDB__CATG__DESCRIPTION', 'isys_cats_cp_contract_list__description', NULL, NULL, NULL, NULL); SET @CATGID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__VIRTUAL_HOST'); INSERT INTO `isys_property_2_cat` (`isys_property_2_cat__isysgui_catg__id`, `isys_property_2_cat__isysgui_cats__id`, `isys_property_2_cat__cat_type`, `isys_property_2_cat__property1_title`, `isys_property_2_cat__property1_columnname`, `isys_property_2_cat__property1_reference`, `isys_property_2_cat__property2_title`, `isys_property_2_cat__property2_columnname`, `isys_property_2_cat__property2_reference`) VALUES (@CATGID, NULL, 'g', 'LC__CMDB__CATG__CLUSTER__ADMINISTRATION_SERVICE', 'isys_catg_virtual_host_list__administration_service', 'isys_connection', NULL, NULL, NULL); SET @CATGID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__VIRTUAL_HOST'); INSERT INTO `isys_property_2_cat` (`isys_property_2_cat__isysgui_catg__id`, `isys_property_2_cat__isysgui_cats__id`, `isys_property_2_cat__cat_type`, `isys_property_2_cat__property1_title`, `isys_property_2_cat__property1_columnname`, `isys_property_2_cat__property1_reference`, `isys_property_2_cat__property2_title`, `isys_property_2_cat__property2_columnname`, `isys_property_2_cat__property2_reference`) VALUES (@CATGID, NULL, 'g', 'LC__CMDB__CATG__CLUSTER__LICENSE_SERVER', 'isys_catg_virtual_host_list__license_server', 'isys_connection', NULL, NULL, NULL); SET @CATGID = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__VIRTUAL_HOST'); INSERT INTO `isys_property_2_cat` (`isys_property_2_cat__isysgui_catg__id`, `isys_property_2_cat__isysgui_cats__id`, `isys_property_2_cat__cat_type`, `isys_property_2_cat__property1_title`, `isys_property_2_cat__property1_columnname`, `isys_property_2_cat__property1_reference`, `isys_property_2_cat__property2_title`, `isys_property_2_cat__property2_columnname`, `isys_property_2_cat__property2_reference`) VALUES (@CATGID, NULL, 'g', 'LC__CMDB__OBJTYPE__VIRTUAL_HOST', 'isys_catg_virtual_host_list__virtual_host', NULL, NULL, NULL, NULL); ALTER TABLE `isys_property_2_cat` ADD CONSTRAINT `isys_property_2_cat_ibfk_2` FOREIGN KEY (`isys_property_2_cat__isysgui_cats__id`) REFERENCES `isysgui_cats` (`isysgui_cats__id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `isys_property_2_cat_ibfk_1` FOREIGN KEY (`isys_property_2_cat__isysgui_catg__id`) REFERENCES `isysgui_catg` (`isysgui_catg__id`) ON DELETE CASCADE ON UPDATE CASCADE;Und dann mach das Update noch einmal
-
Hallo ds,
nun erhalte ich folgende Meldungen:
isys_exception_database : Query error: 'SELECT isys_obj_type_2_isysgui_catg__id FROM isys_obj_type_2_isysgui_catgWHEREisys_obj_type_2_isysgui_catg__isys_obj_type__id = (SELECT isys_obj_type__id FROM isys_obj_type WHERE isys_obj_type__const = 'C__OBJTYPE__CONTAINER')AND isys_obj_type_2_isysgui_catg__isysgui_catg__id = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__IT_SERVICE');':Subquery returns more than 1 row isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_catg__id = (SELECT isysgui_catg__id FROM isysgui_catg WHERE isysgui_catg__const = 'C__CATG__PASSWD');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_cats__id = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__DBMS');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_cats__id = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__DATABASE_INSTANCE');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_cats__id = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__DATABASE_LINKS');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_cats__id = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__DATABASE_OBJECTS');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__id FROM isys_property_2_cat WHERE isys_property_2_cat__isysgui_cats__id = (SELECT isysgui_cats__id FROM isysgui_cats WHERE isysgui_cats__const = 'C__CATS__DATABASE_SCHEMA');':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__idFROM isys_property_2_catWHERE isys_property_2_cat__property1_columnname = 'isys_catg_nagios_list__is_active';':Table 'idoit_mandant.isys_property_2_cat' doesn't exist isys_exception_database : Query error: 'SELECT isys_property_2_cat__idFROM isys_property_2_catWHERE isys_property_2_cat__property1_columnname = 'isys_catg_nagios_list__name1';':Table 'idoit_mandant.isys_property_2_cat' doesn't existBei der Migration erhielt ich noch folgenden Fehler:
isys_exception_database : Query error: 'INSERT INTO isysgui_cats_2_subcategory (isysgui_cats_2_subcategory__isysgui_cats__id__parent, isysgui_cats_2_subcategory__isysgui_cats__id__child) VALUES (8,32)': Duplicate entry '8-32' for key 1 -
Beim Update oder dem Script was ich gepostet habe?
-
Achso kann ja nur beim Update gekommen sein
Hast du das SQL Script vor dem Update ausgefuehrt? Denn der meldet als Fehler, dass die Tabelle die durch das Script eigentlich hätte angelegt werden müssen, nicht existiert
-
Hallo ds,
du hast Recht. Hatte den Befehl von einem Kollegen ausführen lassen, welcher diesen über die MySQL Admin Tools ausführen wollte. Hierbei wurde dummerweise jedoch nur die erste Zeile des Befehls ausgeführt. Hab es nun eben selbst ausgeführt und das Update eingespielt. Das Update verlief bis auf die Migration soweit ohne Probleme.
Bei der Datenmigration, kam es nun zu folgendem Fehler:
isys_exception_database : Query error: 'INSERT INTO isysgui_cats_2_subcategory (isysgui_cats_2_subcategory__isysgui_cats__id__parent, isysgui_cats_2_subcategory__isysgui_cats__id__child) VALUES (8,32)': Duplicate entry '8-32' for key 1 -
Hmm dürfte eigentlich nicht vorkommen. Alle anderen Migrationen haben aber geklappt oder hat er deshalb komplett abgebrochen? Da müssten noch so 4-5 weitere gelaufen sein. Du könntest mal versuchen vor der Migration folgendes in der Datei updates/versions/v0.9.9-6/migration/isysgui_cats_subcategory.inc.php in Zeile 39 zu ändern:
von INSERT INTO in:
$l_insert = "REPLACE INTO isysgui_cats_2_subcategory (isysgui_cats_2_subcategory__isysgui_cats__id__parent, isysgui_cats_2_subcategory__isysgui_cats__id__child) ".
Gruß,
ds -
Jep der verlief Problemlos.
Die Befehlsanpassung hat leider auch nicht geholfen.
Nun erhalte ich folgende Meldung:isys_exception_database : Query error: 'INSERT INTO isysgui_cats_2_subcategory (isysgui_cats_2_subcategory__isysgui_cats__id__parent, isysgui_cats_2_subcategory__isysgui_cats__id__child) VALUES (77,75)': Duplicate entry '77-75' for key 1Log-Message
Implicit relations for it service components successfully migrated
Fix for guarantee periods was successful
Object status successfully migrated
Dependencies successfully migrated
–--FEHLER----
Port Speed has been fixed
Category successfully added
All database instances have been migrated. -
Ach ich glaube jetzt meckert er weiter unten… Versuch das mal in Zeile 88 auf anzupassen. Also so:
$l_insert = "REPLACE INTO isysgui_cats_2_subcategory (isysgui_cats_2_subcategory__isysgui_cats__id__parent, isysgui_cats_2_subcategory__isysgui_cats__id__child) ".
-
Ahhhhhh nun hat es Problemlos geklappt.
Vielen vielen Dank! -
Kein Thema
