Skip to main content
Nintex Community Menu Bar
Question

Error while execute list method in a Smart object

  • February 19, 2023
  • 1 reply
  • 83 views

Forum|alt.badge.img+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

Forum|alt.badge.img+11
  • Nintex Employee
  • February 21, 2023

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.