cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Warning! The maximum key length for a clustered index is 900 bytes - during Thingworx_9 installation

SOLVED
Regular Member

Warning! The maximum key length for a clustered index is 900 bytes - during Thingworx_9 installation

 While executing "thingworxMssqlSchemaSetup.bat" file during the installation of Thingworx 9.1, I am getting this below warning,

 

Warning! The maximum key length for a clustered index is 900 bytes. The index 'data_table_indexes_pkey' has maximum length of 902 bytes. For some combination of large values, the insert/update operation will fail.

 

Can anyone please describe me what this is about and what problems I have to face in future and how to resolve it?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Warning! The maximum key length for a clustered index is 900 bytes - during Thingworx_9 installa

As per information provided in help center this is an expected warning, so I think it can be ignored. Refer link below

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataSt...

 

View solution in original post

2 REPLIES 2

Re: Warning! The maximum key length for a clustered index is 900 bytes - during Thingworx_9 installa

As per information provided in help center this is an expected warning, so I think it can be ignored. Refer link below

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataSt...

 

View solution in original post

Re: Warning! The maximum key length for a clustered index is 900 bytes - during Thingworx9 install

Thanks @SachinSharma  for your response. 

 

I get that it is expected. I was hoping if anyone could explain me what this warning actually means and if I will face any issue in future.

 

Thanks,

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!