Hi everyone,
I need help, I have a powerbuilder 2022 and it is mounted on a server with windows server 2019, when I am running the application on Windows 11, I have an error when creating a dynamic datastore, it sends me the error: "Failed to retrieve the response status", but this only happens once in a while and I don't know why it happens, I add the code and the error.
It is also important to mention that after the error it starts having problems with database queries and then it resets without problem, do you know why it happens?
//Se crea la instancia para el Data Store
ids_data = Create DataStore
//Si no se indico una santencia
If Len(Trim(as_sq)) <= 0 Then
MessageBox("Error", "Error al crear el DataStore: Asignar sentencia válida", StopSign!)
Return -1
End If
//Validar conexión
IF Not SQLCA.of_IsConnected() AND len(gs_usuario) > 0 AND len(gs_pass) > 0 THEN
ls_usuario_cc = gs_usuario
ls_pwd_usuario_cc = gs_pass
ll_ret = f_coduserpass (ls_usuario_cc,ls_pwd_usuario_cc)
lb_ret = gnv_app.of_Connect (ls_usuario_cc,ls_pwd_usuario_cc)
IF lb_ret = False THEN
Return -1
ELSE
ib_transobject = False
END IF
END IF
IF ib_transobject = True Then
ls_sintax = itr_object.SyntaxFromSQL(as_sq,'Style(Type=Grid)', ls_error_sintax)
Else
ls_sintax = SQLCA.SyntaxFromSQL(as_sq,'Style(Type=Grid)', ls_error_sintax)
End If
IF Len(Trim(ls_error_sintax)) > 0 THEN
f_MessageBox("Human Error 1-2", "Error al crear el DataStore: "+ String(ib_transobject)+ "-" + ls_error_sintax + "-" + as_sq, StopSign!, ok!,1)
Return -1
ELSE
ids_data.Create(ls_sintax, ls_error_ds)
If Len(ls_error_ds) > 0 Then
f_MessageBox("Human Error 2", "Error al crear el DataStore: " + ls_error_ds, StopSign!, ok!,1)
Return -1
END If
END If
is_select = as_sq
is_sintax = ls_sintax