QMC 12.1 task reload error

[#1]

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

[aftenier]

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;

___________________________________________________________________________________