Skip to main content
Solved

Workflow - CommServDBQuery cannot use temp tables?


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

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

View original
Did this answer your question?

2 replies

Forum|alt.badge.img+4
  • Vaulter
  • 12 replies
  • 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


Forum|alt.badge.img+1
  • Author
  • Byte
  • 2 replies
  • September 21, 2023

HI Yeshwantth

 

Perfect thanks, that works.

 

Regards

Michael


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings