Issue
When the user tries to open a form, the load time is very huge and the transaction will be timeout before the completion of the load. There will also the following warning messages in the node logs.
2019-11-29 08:44:19 (675) Default-thread-5 F947012FDBD9C8508F4CB1B239961993 txid=ca3b4dabdb1d *** Start #657300 /change_task.do, user: n.jakampudikuppuswam@snc
2019-11-29 08:44:19 (693) Default-thread-5 F947012FDBD9C8508F4CB1B239961993 txid=ca3b4dabdb1d WARNING *** WARNING *** Macro missing: conditional_focus_tag
2019-11-29 08:44:19 (863) Default-thread-5 F947012FDBD9C8508F4CB1B239961993 txid=ca3b4dabdb1d WARNING *** WARNING *** SizeAwareStringWriter@2965058: Large amount of data has been streamed: 1,048,700 bytes
2019-11-29 08:44:20 (214) Default-thread-5 F947012FDBD9C8508F4CB1B239961993 txid=ca3b4dabdb1d WARNING *** WARNING *** SizeAwareStringWriter@2965058: Large amount of data has been streamed: 2,102,256 bytes
There will also be some SQL queries on the syslog table.
Cause
The issue might because of having the 'Logs' related list in the form. Table 'syslog' will be loaded along with the form load and hence it takes a huge time.
Resolution
The issue will be resolved by removing the Logs related list. Since we cannot open the form from the affected view, follow the below steps.
1)Open the form from the view without the issue(change the view from list view to non-affected view).
2)Right-click on the header. Configure-->Related lists
3)In the View name, select the affected view.
4)From the Selected side of the slush bucket, remove Logs and save it.
