Technical Tip: How to fix the Service Connector view when no options are displayed

[blarochelle]

Description	This article describes how to fix the Network -> Service Connector view after loading the page without any options returned to be able to configure a Service Connector. Options are shown to 'Create New', 'Edit', and 'Delete', however, there are no Service Connector options to be able to 'Create New', 'Edit', or 'Delete'.
Scope	FortiNAC v9.X.
Solution	The image shows the result when the Service Connector page is in a 'broken' state: /bsc/logs/output.master will show errors similar to the following: yams SEVERE :: 2024-12-31 10:17:22:497 :: #56235 :: Caused by: java.lang.IllegalArgumentException: Can not set int field com.bsc.api.messagingGateway.SMSMessagingGateway.maxMessageLength to null value yams SEVERE :: 2024-12-31 10:17:22:498 :: #56235 :: at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167) yams SEVERE :: 2024-12-31 10:17:22:498 :: #56235 :: at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171) yams SEVERE :: 2024-12-31 10:17:22:498 :: #56235 :: at sun.reflect.UnsafeIntegerFieldAccessorImpl.set(UnsafeIntegerFieldAccessorImpl.java:80) yams SEVERE :: 2024-12-31 10:17:22:498 :: #56235 :: at java.lang.reflect.Field.set(Field.java:764) yams SEVERE :: 2024-12-31 10:17:22:498 :: #56235 :: at org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:122) To resolve this issue, run the following commands. Note, that each line is a separate command: shutdownNAC mysql bsc -e "drop table MessagingGateway" mysql bsc -e "drop table SMSMessagingGateway" mysql bsc -e "drop table FormDataMessagingGateway" mysql bsc -e "update GlobalOption set value=-1 where name='upgrade.sms.version'" startupNAC