Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Recently i am hitting some task reload issue in QMC.
As per below is the error it capture in the QVW log. The error shows failed to connect to my MYSQL database.
2017-05-15 07:00:33 0037 ODBC CONNECT32 TO *** (XUserId *** ***, XPassword *** ***)
2017-05-15 07:00:33 Error: Unknown GenericConnect error
2017-05-15 07:00:33 Unknown GenericConnect error
2017-05-15 07:00:33 Execution Failed
This issue started after i upgraded my QV server from 11.2 to 12.1.
Currently we are using 12.1 SR6.
I have enable server logging at MYSQL but it did not capture any error on this.
Any idea what is this error message about? It does not have error code that i can search for.
Appreciate any kind feedback on this.
Thanks in advance!
Chong Thai
Here we can provisionally resolve with the script below:
___________________________________________________________________________________
SET ErrorMode = 0;
LET ScriptErrorCount = 0;
LET vTentativas_Conexao_BD = 0;
LET vMax_Tentativas_Conexao_BD = 5;
SET vStatus_Conexao_BD = CARGA OK;
//Tenta conexão:
OLEDB CONNECT64 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxx;Data Source=oraprd11;Extended Properties=""] (XPassword is xxxx);
//Em caso de erro tenta novamente por até x vezes cfe parâmetro:
IF $(ScriptErrorCount) > 0 THEN
FOR vTentativas_Conexao_BD = 1 TO $(vMax_Tentativas_Conexao_BD)
IF $(ScriptErrorCount) > 0 THEN
LET ScriptErrorCount = 0;
LET vStatus_Conexao_BD = 'Erros: ' & '$(vTentativas_Conexao_BD)';
//Aguarda 5 segundos para nova tentativa de conexão e tenta novamente:
SLEEP 5000;
OLEDB CONNECT64 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxx;Data Source=oraprd11;Extended Properties=""] (XPassword is xxxxx);
ENDIF
//Sai do script em caso de sucesso (passar pela conexão novamente sem erros):
EXIT SCRIPT WHEN $(ScriptErrorCount) = 0;
NEXT
ENDIF
SET ErrorMode = 1;
___________________________________________________________________________________