Good day Romy121
I assume you are using the community built EXCEL AS SMO Service broker? If so, I'd recommend directing this question to the developer of this broker in a form of a comment here: https://community.k2.com/t5/General-K2-Utilities/EXCEL-AS-SMO-SERVICE-BROKER/ba-p/86040?nobounce
K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
When editing a form in K2 Designer, an Error "Object reference not set to an instance of an object." appears.
This "Object reference not set to an instance of an object." error usually indicates that a Smartobject used by the Form/View could not be found or has an issue it may have been deleted or recreated with a different GUID.
1. As a troubleshooting step, please edit each of the Views that is used by this form there is maybe a view of this form that is also throwing the same "Object reference not set to an instance of an object." error. If so does this view use a Smartobject, and does this Smartobject exist and execute successfully from the SmartObject Servicer Tester Tool (C:Program Files(x86)K2 blackpearlBin).
2. Please also "Enable HostServer Logging" as per the steps below:
Replicating this error may give more details as to which Smartobject/GUID it is referencing.
A Stored Procedure that is executed by this SmartObject in the Form was not updated in this environment; had been updated in the source environment. Updating this Stored Procedure, refreshing the SQL Service Instance and updating it in the SmartObject resolved the issue.