CMDB Approach

Gaurav Sharma6
Tera Contributor

‎06-24-2024 02:47 AM

Hi Experts,

we configured around 200 columns in a custom table extending out of the box CMDB table and while migrating the change to higher environment, the column labels were copied blank(empty column labels). So we have to split into 6 tables with 30 to 35 columns each to complete the implementation in 2023. As part of new requirement, we have to configure around 500 columns to the custom table and looking for recommendation to avoid the issues which we faced earlier.
What is the best method\ approach we can use to avoid custom column and table related issues like (number of column, length of column) in ServiceNow CMDB.

0 Helpfuls
  • 258 Views
1 REPLY 1

AJ-TechTrek
Giga Sage
Giga Sage

‎07-03-2024 01:34 AM

Hi @Gaurav Sharma6 ,

 

I hope below information will help you.

 

  • The system can only have a maximum of 1000 columns per table. Although 1000 columns is a specified limit, this limit doesn't mean you can physically have 1000 columns within a table. The number of columns within a table is defined by the database used in the ServiceNow datacenter, not by the Now Platform.
  • Every table, regardless of storage engine, has a maximum row size of 65,535 bytes. Storage engines may place additional constraints on this limit, reducing the effective maximum row size.
  • The system can't have more than 10 medium-length or longer String fields to a single table. Attempting to save a large number of characters in 11 or more String fields can result in the following error: Syntax Error or Access Rule Violation detected by database (Row size too large (> 8126).
  • When you create fields, the u_ prefix is automatically added to the column name. If the column label that you enter contains leading numeric characters, they are replaced by the u_ prefix.

For more information on database limitations and general questions on tables in your ServiceNow instance, see KB0749585

 

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/field-admini....

 

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thank You

AJ - TechTrek with AJ

Linkedin:- https://www.linkedin.com/in/ajay-kumar-66a91385/

YouTube:- https://www.youtube.com/@learnitomwithaj

ServiceNow Community Rising Star 2024

0 Helpfuls