SQL Error on various interface resources

Upgraded to 9.5 this morning and for the most part it went well. I have noticed, though, that some interface resources appear to be exhibiting a SQL error (see pic). It appears to only affect resources that use the 'Interface Index' as the sort criteria. I looked at what I believe is the resource in the Resources directory, but I don't really see anything wrong with it. Any ideas?

sql error.jpg

Find more posts tagged with

sql_error

sort_criteria

interface_index

Accepted answers

bleearg13

Posting solution here just in case someone else goes through the same issue.

After two weeks of an SW support rep insisting that my problem was with database deadlocks due to my DB being on a RAID5 partition (which I will fix), I found the problem today was with incorrect entries in the PropertyValue column of various resources in the ResourceProperties table. The original and incorrect value was:

Interfaces.InterfaceIndex:Interface Index,Interfaces.Status DESC:Interface Status,Interfaces.Caption:Interface Name,Interfaces.InterfaceTypeDescription:Type of Interface

The correct value should be:

Interfaces.Index:Interface Index,Interfaces.Status DESC:Interface Status,Interfaces.Caption:Interface Name,Interfaces.InterfaceTypeDescription:Type of Interface

After updating all the incorrect entries in the database, the sorting by Interface Index now works properly.

All comments

bshopp

Can you send me or post the filter query you are using

bleearg13

I am not using any filter query. I don't even have that option on these resources. I can only set the name of the resource and the sort order.

edit resource.jpg

bshopp

Might be best to open a support case to resolve

bleearg13

Posting solution here just in case someone else goes through the same issue.

Interfaces.InterfaceIndex:Interface Index,Interfaces.Status DESC:Interface Status,Interfaces.Caption:Interface Name,Interfaces.InterfaceTypeDescription:Type of Interface

The correct value should be:

Interfaces.Index:Interface Index,Interfaces.Status DESC:Interface Status,Interfaces.Caption:Interface Name,Interfaces.InterfaceTypeDescription:Type of Interface

After updating all the incorrect entries in the database, the sorting by Interface Index now works properly.