Solved

Workflow - CommServDBQuery cannot use temp tables?

  • 19 September 2023
  • 2 replies
  • 23 views

Badge +1

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

icon

Best answer by Yeshwanth 20 September 2023, 09:01

View original

2 replies

Userlevel 1
Badge +3

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