Hi,
I'm trying to add a few string type of field to my custom FunctionalCi class.
After reached a certain number of string the syncro table does not let creating another string type field
Currently my CI class parent is Datacenterdevice.
I have 4 xsi:type=AttributeString and 6 other type which are although different type of attributes the syncro table use simple varchar for them.
I'm using 10.1.22-MariaDB MariaDB Server
Failed to issue SQL query: query = ALTER TABLE assdbsynchro_data_test_sync ADD (customfield1 TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,customfield2 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci);, mysql_errno = 1118, mysql_error = Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
My quetion would be, is there a limitation that i can only create an 'n' number of varchar fields?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
You can create a child object :/
Or if you don't use some fields, remove them !
Either of the above solution chosen, you'll have to write a custom iTop module. See this for informations : https://www.itophub.io/wiki/page?id=2_7_0%3Acustomization%3Astart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm trying to add a few string type of field to my custom FunctionalCi class.
After reached a certain number of string the syncro table does not let creating another string type field
Currently my CI class parent is Datacenterdevice.
I have 4 xsi:type=AttributeString and 6 other type which are although different type of attributes the syncro table use simple varchar for them.
I'm using 10.1.22-MariaDB MariaDB Server
Failed to issue SQL query: query = ALTER TABLE
assdbsynchro_data_test_syncADD (customfield1TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,customfield2VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci);, mysql_errno = 1118, mysql_error = Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBsMy quetion would be, is there a limitation that i can only create an 'n' number of varchar fields?
Also, how can i remove certain field like enclosure_id,rack_id etc the once i dont use.
Is there any impact on ITOP if i remove it in the mariadb?
Hello,
You can create a child object :/
Or if you don't use some fields, remove them !
Either of the above solution chosen, you'll have to write a custom iTop module. See this for informations : https://www.itophub.io/wiki/page?id=2_7_0%3Acustomization%3Astart
Hello,
Can you please explain creating child object?