Question

Error while execute list method in a Smart object

  • 19 February 2023
  • 1 reply
  • 63 views

Badge +1

Hello,

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:

Severity: Error
Error Message: Database 'dbname__OLD_Act_TBDel_ImportAt2024' cannot be opened because it is offline.
InnerException Message:

Note that if we create the method (that provided the error) in a new smart object, it works normally ...


1 reply

Userlevel 3
Badge +10

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.

Reply