07 02 2025 10:07:21 El Archivo 2025-02-07 - log_error.txt se ha creado ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDA4MDgsImlhdCI6MTczODk0MDc1OH0.RCFfuUTWJbQvdYOeegW7ZzZSxtLScw5QYDBhT70IEWQ -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 15:07:20 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274566 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 10:27:48 ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDIwMzgsImlhdCI6MTczODk0MTk4OH0._692gYEyHH9f0Ro_9c8AkBKh-KNffHUllzUXTD-DscM -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 15:27:48 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274566 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 10:28:59 ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDIxMDksImlhdCI6MTczODk0MjA1OX0.eRyUbnA0Mqno7Gbb7NSTq8VYZI-QryAVIe-Ok9w9nhA -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 15:28:58 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274566 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 566)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 525)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:566)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:525)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 10:32:29 ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDIzMTksImlhdCI6MTczODk0MjI2OX0.WBXQBTe_rNrWVI4PBp6K1L-tdQpwAxK6HAX2U55sSIU -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 15:32:28 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274350 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 10:33:36 ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDIzODYsImlhdCI6MTczODk0MjMzNn0.TWHN8r91laT-Gtmwy7msiFQnxzGxNhJ-kJN_4k-7NmI -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 15:33:35 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274350 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_80.rolesusuarios r
JOIN gamble_80.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_80.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 11:13:15 ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxNzM0MTIwOCIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg5NDQ3NjUsImlhdCI6MTczODk0NDcxNX0.WPsugrfsMMmA73-u606Su6zqp2bGP5AYsONzn_xQWNc -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Fri, 07 Feb 2025 16:13:15 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5BHV00N%5D%3A%20%3C%3CUnknown%20error%3E%3E%3A%207%20ERROR%3A%20%20connection%20for%20foreign%20table%20%22rolesusuarios%22%20cannot%20be%20established%0ADETAIL%3A%20%20ORA-12170%3A%20TNS%3ASe%20ha%20producido%20un%20timeout%20de%20conexi%C3%B3n X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 274350 An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established
DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)

// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}

in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)

private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}

in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)

Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{

in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)

return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)

} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)

}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

PDOException

SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)

. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);

in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)

$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {

in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)

if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*

Statement->executeQuery() in src/Services/Conexion.php (line 574)

} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));

Conexion->query_normal() in src/Services/Conexion.php (line 533)

case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}

Conexion->query() in src/Controller/PtatController.php (line 1925)

$sql_val_cargos = "SELECT DISTINCT r.role, r2.role FROM
gamble_70.rolesusuarios r
JOIN gamble_70.rolesusuarios r2 ON r2.loginusr = '$usuario_cv' AND r2.ROLE = 'ROL_VENTAENLINEA2'
JOIN gamble_70.contratosventa c ON c.login = r2.loginusr AND c.fechafinal IS null
WHERE r.loginusr = '$usuario' AND r.ROLE = 'ROL_VENPAGPREM'";
$result_val_cargos = $this->cnn->query('0', $sql_val_cargos);
if (count($result_val_cargos) > 0)
{
$respuesta["datos"] = "Debe ingresar a la App con el CV";
return $response->setContent(json_encode($respuesta));
}

in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)

$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);

in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)

{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}

in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)

$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)

$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)

$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};

Logs

No log messages

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

[1/3] PDOException
PDOException: SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR: connection for foreign table "rolesusuarios" cannot be established DETAIL: ORA-12170: TNS:Se ha producido un timeout de conexión at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:574) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:533) at App\Services\Conexion->query() (src/Controller/PtatController.php:1925) at App\Controller\PtatController->login_movil() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16)

[1/3] PDOException

PDOException:
SQLSTATE[HV00N]: <<Unknown error>>: 7 ERROR:  connection for foreign table "rolesusuarios" cannot be established
DETAIL:  ORA-12170: TNS:Se ha producido un timeout de conexión

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Services/Conexion.php:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1925)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)

07 02 2025 19:25:57 ************************************************************ -- -- MM-Error en Metodos Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3003 milliseconds (http://10.231.0.134:8094/ptat/metodos/metodos) in /var/www/html/serversoap/ptat_developer/metodos.php:72 Stack trace: #0 /var/www/html/serversoap/ptat_developer/metodos.php(72): http\Client->send() #1 {main} 07 02 2025 20:09:16 ************************************************************ -- LM-Error en proceso de Logeo Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3002 milliseconds (http://10.231.0.134:8094/ptat/login/login_movil) in /var/www/html/serversoap/ptat_developer/login_movil.php:59 Stack trace: #0 /var/www/html/serversoap/ptat_developer/login_movil.php(59): http\Client->send() #1 {main} 07 02 2025 20:09:22 ************************************************************ -- -- MM-Error en Metodos Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3002 milliseconds (http://10.231.0.134:8094/ptat/metodos/metodos) in /var/www/html/serversoap/ptat_developer/metodos.php:72 Stack trace: #0 /var/www/html/serversoap/ptat_developer/metodos.php(72): http\Client->send() #1 {main} 07 02 2025 20:29:16 ************************************************************ -- LM-Error en proceso de Logeo Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3003 milliseconds (http://10.231.0.134:8094/ptat/login/login_movil) in /var/www/html/serversoap/ptat_developer/login_movil.php:59 Stack trace: #0 /var/www/html/serversoap/ptat_developer/login_movil.php(59): http\Client->send() #1 {main} 07 02 2025 20:50:57 ************************************************************ -- -- MM-Error en Metodos Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3003 milliseconds (http://10.231.0.134:8094/ptat/metodos/metodos) in /var/www/html/serversoap/ptat_developer/metodos.php:72 Stack trace: #0 /var/www/html/serversoap/ptat_developer/metodos.php(72): http\Client->send() #1 {main} 07 02 2025 21:12:33 ************************************************************ -- -- MM-Error en Metodos Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3003 milliseconds (http://10.231.0.134:8094/ptat/metodos/metodos) in /var/www/html/serversoap/ptat_developer/metodos.php:72 Stack trace: #0 /var/www/html/serversoap/ptat_developer/metodos.php(72): http\Client->send() #1 {main} 07 02 2025 21:33:34 ************************************************************ -- LM-Error en proceso de Logeo Sem: http\Exception\RuntimeException: http\Client::send(): Timeout was reached; Connection timed out after 3000 milliseconds (http://10.231.0.134:8094/ptat/login/login_movil) in /var/www/html/serversoap/ptat_developer/login_movil.php:59 Stack trace: #0 /var/www/html/serversoap/ptat_developer/login_movil.php(59): http\Client->send() #1 {main}