Skip to main content
Solved

Workflow - CommServDBQuery cannot use temp tables?

  • 19 September 2023
  • 2 replies
  • 28 views

Hi

Does anyone know if there are any restrictions in the workflow engine regarding the use of temporary tables in the CommservDBQuery activity? In the SSMS the query works fine.

 

 

When I run the above SQL query in the debug mode, I don’t get any output:

 

I also tried to use a table as variable, which did not work either.

The workflow engine runs on a dedicated server. Could this cause the issue?

 

Thanks for your inputs

Michael

2 replies

Userlevel 1
Badge +4

Hi @Michael.B ,

 

Can you add SET NOCOUNT ON at the beginning?

You can refer to documentation here - 

https://documentation.commvault.com/commvault/v11_sp20/article?p=49839.htm

 

Thanks,

Yeshwantth

Badge +1

HI Yeshwantth

 

Perfect thanks, that works.

 

Regards

Michael

Reply