I restore MS SQL database, and deploy K2 package, in smart object contains several methods to extract data as a list from tables, some methods work normally and provide data, other methods in the same smart object give following error:
Error Message: Database 'dbname__OLD_Act_TBDel_ImportAt2024' cannot be opened because it is offline.
Note that if we create the method (that provided the error) in a new smart object, it works normally ...
For the method that is failing, is it using the same Service Instance as the working one?
The flow is usually:
SmartObject Method > Service Object Method > Service Instance Configuration > LOB system
Perhaps it is working when you manually create it because there are more than one Service Instances; one is pointed to the correct SQL server/database and one that is pointed to an invalid SQL server or where the database is offline.