17 02 2025 00:08:56 El Archivo 2025-02-17 - log_error.txt se ha creado ************************************************************ -- -- 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} 17 02 2025 00:29:11 ************************************************************ -- 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} 17 02 2025 14:38:20 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzM5ODIwNjQ1LCJleHAiOjE3Mzk4Mjk2NDV9.eBzTEq43py_g7V9W_3cc2Bp2xUMcGl6HxxLGIGcdvQU -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Mon, 17 Feb 2025 19:38: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%5B42P01%5D%3A%20Undefined%20table%3A%207%20ERROR%3A%20%20no%20existe%20la%20relaci%C3%83%C2%B3n%20%C3%82%C2%ABvinculado%C3%82%C2%BB%0ALINE%201%3A%20SELECT%20VINNOMBRE%20FROM%20vinculado%20WHERE%20VINCEDULA%20%3D%20%27123%27%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5E X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:71 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: 274666 An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: no existe la relación «vinculado» LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123' ^ (500 Internal Server Error)

Symfony Exception

PDOException Exception TableNotFoundException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: no existe la relación «vinculado»
LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123'
^

Exceptions 3

Doctrine\DBAL\Exception\ TableNotFoundException

  1.             case '42703':
  2.                 return new InvalidFieldNameException($exception$query);
  3.             case '42P01':
  4.                 return new TableNotFoundException($exception$query);
  5.             case '42P07':
  6.                 return new TableExistsException($exception$query);
  7.             case '08006':
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  $this->exceptionConverter->convert($driverException$query);
  7.         if ($exception instanceof ConnectionLost) {
  8.             $this->close();
  9.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql$params$types));
  7.     }
  8.     /** @internal */
  9.     final public function convertException(Driver\Exception $e): DriverException
  10.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5788)
  1.         $response->headers->set('HTTP_AUTHENTICATION'$token_auth);
  2.         return $response->setContent(json_encode($respuesta));
  3.       }
  4.       $sql_manager "SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '$nit'";
  5.       $res_manager $this->cnn->query('0'$sql_manager);
  6.       if (count($res_manager) <= 0)
  7.         $info $mensaje "No se encontro el proveedor, solicite el registro en manager.";
  8.       else
  9.       {
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42P01]: Undefined table: 7 ERROR: no existe la relación «vinculado» LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123' ^

  1.         } else {
  2.             $code     $exception->getCode();
  3.             $sqlState null;
  4.         }
  5.         return new self($exception->getMessage(), $sqlState$code$exception);
  6.     }
  7. }
  1.         }
  2.         try {
  3.             $this->stmt->execute($params);
  4.         } catch (PDOException $exception) {
  5.             throw Exception::new($exception);
  6.         }
  7.         return new Result($this->stmt);
  8.     }
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5788)
  1.         $response->headers->set('HTTP_AUTHENTICATION'$token_auth);
  2.         return $response->setContent(json_encode($respuesta));
  3.       }
  4.       $sql_manager "SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '$nit'";
  5.       $res_manager $this->cnn->query('0'$sql_manager);
  6.       if (count($res_manager) <= 0)
  7.         $info $mensaje "No se encontro el proveedor, solicite el registro en manager.";
  8.       else
  9.       {
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

PDOException

SQLSTATE[42P01]: Undefined table: 7 ERROR: no existe la relación «vinculado» LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123' ^

  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5788)
  1.         $response->headers->set('HTTP_AUTHENTICATION'$token_auth);
  2.         return $response->setContent(json_encode($respuesta));
  3.       }
  4.       $sql_manager "SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '$nit'";
  5.       $res_manager $this->cnn->query('0'$sql_manager);
  6.       if (count($res_manager) <= 0)
  7.         $info $mensaje "No se encontro el proveedor, solicite el registro en manager.";
  8.       else
  9.       {
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Logs

No log messages

Stack Traces 3

[3/3] TableNotFoundException
Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  no existe la relación «vinculado»
LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123'
                              ^

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:71
  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:5788)
  at App\Controller\PtatController->metodos()
     (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[42P01]: Undefined table: 7 ERROR:  no existe la relación «vinculado»
LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123'
                              ^

  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:5788)
  at App\Controller\PtatController->metodos()
     (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[42P01]: Undefined table: 7 ERROR:  no existe la relación «vinculado»
LINE 1: SELECT VINNOMBRE FROM vinculado WHERE VINCEDULA = '123'
                              ^

  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:5788)
  at App\Controller\PtatController->metodos()
     (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)