topic RE: Reason: Internal : Retries 6 in Brasil https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39734#M28 <P>I'd suggest to check and review your use of unique tags. We have seen cases like this when many unique tags are in use. Check the database top tables report from SQL Server Management Studio and look for the table BPATag. If the total count of rows in this table is in the many thousands it may indicate a problem here. For some guidance on the correct use of tags please see the following KB article on the Portal :- <SPAN style="text-decoration: underline;"><A href="http://portal.blueprism.com/customer-support/support-center#/path/1437529062" target="_blank" rel="noopener">What is the recommended approach when working with Work Queue tags?</A></SPAN></P> <P>As an example, if you use something like a time or datetime as part of your tag this is not recommended as it will create lots of unique tags. Best to think of tags as a category.</P><BR /><BR />------------------------------<BR />John Cowell<BR />Senior Software Support Analyst<BR />Blue Prism<BR />------------------------------<BR /> Wed, 23 Dec 2020 15:59:00 GMT JohnCowell 2020-12-23T15:59:00Z Reason: Internal : Retries 6 https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39733#M27 I have a robotic park that is intermittently receiving the following error in the action of Get Next Item "<STRONG>Reason: Internal: Retries 6, The statement or function must be executed in the context of a user transaction. error 51000, level 16, state 1, procedure usp_getnextcase, line 1, message: Failed to get app lock for work queue item</STRONG> ", what is impacting the execution of the robots as a whole, would anyone have experienced a similar problem? <BR /><BR />PS: We recently migrated from version 6.3.2 to 6.7.3<BR /><BR />------------------------------<BR />Jean Félix Silva<BR />Indra<BR />InternshipRPA Developer - Blue prism junior developer<BR />------------------------------<BR /> Tue, 08 Dec 2020 18:49:00 GMT https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39733#M27 Jean_FélixSilva 2020-12-08T18:49:00Z RE: Reason: Internal : Retries 6 https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39734#M28 <P>I'd suggest to check and review your use of unique tags. We have seen cases like this when many unique tags are in use. Check the database top tables report from SQL Server Management Studio and look for the table BPATag. If the total count of rows in this table is in the many thousands it may indicate a problem here. For some guidance on the correct use of tags please see the following KB article on the Portal :- <SPAN style="text-decoration: underline;"><A href="http://portal.blueprism.com/customer-support/support-center#/path/1437529062" target="_blank" rel="noopener">What is the recommended approach when working with Work Queue tags?</A></SPAN></P> <P>As an example, if you use something like a time or datetime as part of your tag this is not recommended as it will create lots of unique tags. Best to think of tags as a category.</P><BR /><BR />------------------------------<BR />John Cowell<BR />Senior Software Support Analyst<BR />Blue Prism<BR />------------------------------<BR /> Wed, 23 Dec 2020 15:59:00 GMT https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39734#M28 JohnCowell 2020-12-23T15:59:00Z RE: Reason: Internal : Retries 6 https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39735#M29 Olá, Jean.<BR />Este problema foi resolvido?<BR />Você abriu um chamado sobre ele?<BR />A sugestão do John de rever as Tags é muito boa, e pode resolver o problema.<BR />Quando for um problema técnico, envolvendo mensagens de erros, é recomendado que vocês abram um chamado no suporte.<BR />Obrigado.<BR /><BR />------------------------------<BR />Sergio Bentim<BR />Customer Engineer<BR />Technical Support<BR />America/Mexico_City<BR />------------------------------<BR /> Thu, 07 Jan 2021 14:05:00 GMT https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39735#M29 SergioBentim 2021-01-07T14:05:00Z RE: Reason: Internal : Retries 6 https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39736#M30 <P>Olá Sergio,&nbsp;</P> <P>O problema foi resolvido migrando a base de dados do robô para uma conexão separada do app server, a aplicação das tags não era o problema, uma vez que estavam otimizadas conforme mesmo o artigo citado.&nbsp;</P> <P>O problema foi criado com mesmo com a interação da query que é executada no banco quando a action get next item. uma interação que não ocorria na versão anterior que usávamos e foi crescendo conforme a volumetria ia aumentando.</P> <P>Mas isolamos o projeto em um ambiente separado e foi resolvido o sintoma. Muito Obrigado.</P><BR /><BR />------------------------------<BR />Jean Félix Silva<BR />Indra<BR />InternshipRPA Developer - Blue prism developer<BR />------------------------------<BR /> Thu, 07 Jan 2021 14:22:00 GMT https://community.blueprism.com/t5/Brasil/Reason-Internal-Retries-6/m-p/39736#M30 Jean_FélixSilva 2021-01-07T14:22:00Z