Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Fehler bei Update auf Open 0.9.9-6

    Scheduled Pinned Locked Moved Entwicklung
    11 Posts 2 Posters 2.7k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R Offline
      rgarcia
      last edited by

      Hallo,

      habe heute beim Update auf die Open Version 0.9.9-6 folgenden Fehler erhalten:

      
      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');':Unknown column 'isys_property_2_cat__isysgui_catg__id' in 'where clause'
      
      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');':Unknown column 'isys_property_2_cat__isysgui_cats__id' in 'where clause' 	
      
      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');':Unknown column 'isys_property_2_cat__isysgui_cats__id' in 'where clause' 	
      
      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');':Unknown column 'isys_property_2_cat__isysgui_cats__id' in 'where clause' 	
      
      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');':Unknown column 'isys_property_2_cat__isysgui_cats__id' in 'where clause' 	
      
      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');':Unknown column 'isys_property_2_cat__isysgui_cats__id' in 'where clause'
      
      

      Anbei habe ich das Update Protokoll angehängt.
      Jemand eine Idee?
      110819-160857-idoit_update.zip

      1 Reply Last reply Reply Quote 0
      • dsD Offline
        ds
        last edited by

        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

        1 Reply Last reply Reply Quote 0
        • R Offline
          rgarcia
          last edited by

          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 exist
          
          

          Bei 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
          
          1 Reply Last reply Reply Quote 0
          • dsD Offline
            ds
            last edited by

            Beim Update oder dem Script was ich gepostet habe?

            1 Reply Last reply Reply Quote 0
            • dsD Offline
              ds
              last edited by

              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

              1 Reply Last reply Reply Quote 0
              • R Offline
                rgarcia
                last edited by

                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 
                
                1 Reply Last reply Reply Quote 0
                • dsD Offline
                  ds
                  last edited by

                  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

                  1 Reply Last reply Reply Quote 0
                  • R Offline
                    rgarcia
                    last edited by

                    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 1 
                    

                    Log-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.

                    1 Reply Last reply Reply Quote 0
                    • dsD Offline
                      ds
                      last edited by

                      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) ".

                      1 Reply Last reply Reply Quote 0
                      • R Offline
                        rgarcia
                        last edited by

                        Ahhhhhh nun hat es Problemlos geklappt.
                        Vielen vielen Dank!

                        1 Reply Last reply Reply Quote 0
                        • dsD Offline
                          ds
                          last edited by

                          Kein Thema 🙂

                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post