Skip to main content
commvault.com commvault.com
Solved

Workflow - CommServDBQuery cannot use temp tables?

  • September 19, 2023
  • 2 replies
  • 51 views
M
Novice
Forum|alt.badge.img+2

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

Best answer by Yeshwanth

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

2 replies

Y
Vaulter
Forum|alt.badge.img+4
  • YeshwanthVaulter
  • Vaulter
  • Answer
  • September 20, 2023

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

christopherlecky
M
M
Novice
Forum|alt.badge.img+2
  • Michael.BNovice
  • Author
  • Novice
  • September 21, 2023

HI Yeshwantth

 

Perfect thanks, that works.

 

Regards

Michael

christopherlecky
Terms & ConditionsCookie settingsAccessibility statement