https://integral.dirmov.mil.ec/aspirantes/registro/salvar/encuesta?p=aspirantes%2Fregistro%2Fsalvar%2Fencuesta

Method
GET
HTTP Status
500
IP
200.105.247.85
Profiled on
Token
16dadd

ErrorController

Request

GET Parameters

Key Value
p 
"aspirantes/registro/salvar/encuesta"

POST Parameters

Key Value
_xml_http_request 
"true"
encuesta 
[
  "cedula" => "2250210339"
  "cursos" => [
    ""
    "1"
    "2"
  ]
  "uniforme" => "M38"
  "jockey" => "58"
  "calzado" => "40"
  "camiseta" => "38"
  "estudios_finalizados" => "SF"
]

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"3afc25"
exception 
Doctrine\DBAL\Exception\DriverException {#1395
  #message: """
    An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: ""\n
    CONTEXT:  unnamed portal parameter $1 = ''
    """
  #code: 7
  #file: "/data/produccion/integral/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php"
  #line: 87
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1398 …}
  -query: Doctrine\DBAL\Query {#1397 …}
  trace: {
    /data/produccion/integral/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 {
      Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › 
      ›     return new DriverException($exception, $query);
      › }
    }
    /data/produccion/integral/vendor/doctrine/dbal/src/Connection.php:1818 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /data/produccion/integral/vendor/doctrine/dbal/src/Connection.php:1761 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
    }
    /data/produccion/integral/vendor/doctrine/dbal/src/Connection.php:1034 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:750 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array $criteria, $entity = null, $assoc = null, array $hints = [], $lockMode = null, $limit = null, array $orderBy = null) …
      › [$params, $types] = $this->expandParameters($criteria);
      › $stmt             = $this->conn->executeQuery($sql, $params, $types);
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:768 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(array $identifier, $entity = null) …
      › {
      ›     return $this->load($identifier, $entity);
      › }
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:521 {
      Doctrine\ORM\EntityManager->find($className, $id, $lockMode = null, $lockVersion = null) …
      ›     default:
      ›         return $persister->loadById($sortedId);
      › }
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:199 {
      Doctrine\ORM\EntityRepository->find($id, $lockMode = null, $lockVersion = null) …
      › {
      ›     return $this->_em->find($this->_entityName, $id, $lockMode, $lockVersion);
      › }
    }
    /data/produccion/integral/src/Controller/AspirantesController.php:848 {
      App\Controller\AspirantesController->salvaReclutaProceso(&$data) …
      › {
      ›     $curso = $em->getRepository('App\\Entity\\Curso')->find($curso);
      ›     if ($curso)
    }
    /data/produccion/integral/src/Controller/AspirantesController.php:457 {
      App\Controller\AspirantesController->registroSalvarEncuestaAction() …
      › 
      › $id = $this->salvaReclutaProceso($data);
      › 
    }
    /data/produccion/integral/vendor/symfony/http-kernel/HttpKernel.php:153 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /data/produccion/integral/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /data/produccion/integral/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /data/produccion/integral/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /data/produccion/integral/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /data/produccion/integral/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/data/produccion/integral/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#133 …8}

Request Headers

Header Value
accept 
"application/json, text/javascript, */*; q=0.01"
accept-encoding 
"gzip, deflate, br, zstd"
accept-language 
"es-ES,es;q=0.9"
authorization 
""
connection 
"keep-alive"
content-length 
"280"
content-type 
"application/x-www-form-urlencoded; charset=UTF-8"
cookie 
"_ga=GA1.1.800957427.1725714171; _ga_C7TYWRCF3N=GS1.1.1726802015.2.0.1726802017.0.0.0"
host 
"integral.dirmov.mil.ec"
origin 
"https://integral.dirmov.mil.ec"
referer 
"https://integral.dirmov.mil.ec/aspirantes/registro/linea"
sec-ch-ua 
""Chromium";v="128", "Not;A=Brand";v="24", "Google Chrome";v="128""
sec-ch-ua-mobile 
"?1"
sec-ch-ua-platform 
""Android""
sec-fetch-dest 
"empty"
sec-fetch-mode 
"cors"
sec-fetch-site 
"same-origin"
user-agent 
"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36"
x-php-ob-level 
"1"
x-requested-with 
"XMLHttpRequest"

Request Content

Raw

encuesta%5Bcedula%5D=2250210339&encuesta%5Bcursos%5D%5B%5D=&encuesta%5Bcursos%5D%5B%5D=1&encuesta%5Bcursos%5D%5B%5D=2&encuesta%5Buniforme%5D=M38&encuesta%5Bjockey%5D=58&encuesta%5Bcalzado%5D=40&encuesta%5Bcamiseta%5D=38&encuesta%5Bestudios_finalizados%5D=SF&_xml_http_request=true

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"application/json"
date 
"Fri, 20 Sep 2024 04:13:49 GMT"
vary 
"Accept"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B22P02%5D%3A%20Invalid%20text%20representation%3A%207%20ERROR%3A%20%20invalid%20input%20syntax%20for%20type%20integer%3A%20%22%22%0ACONTEXT%3A%20%20unnamed%20portal%20parameter%20%241%20%3D%20%27%27"
x-debug-exception-file 
"%2Fdata%2Fproduccion%2Fintegral%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87"
x-debug-token 
"16dadd"

Cookies

Request Cookies

Key Value
_ga 
"GA1.1.800957427.1725714171"
_ga_C7TYWRCF3N 
"GS1.1.1726802015.2.0.1726802017.0.0.0"

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV 
"dev"
APP_SECRET 
"c4d61b67844c8a03b086ad08643ebb84"
DATABASE_URL 
"postgresql://postgres:@integral2024@200.6.25.30:5432/integral_produccion"
LOCK_DSN 
"semaphore"
MAILER_DSN 
"smtp://dirmov1@bfound.ec:Molero1401Dlrowcp2301@darnell.nocdirect.com:465"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"
ws_dinardap 
"http://interoperabilidad.dinardap.gob.ec:7979/interoperador?wsdl"
ws_dinardap_v2 
"http://interoperabilidad.dinardap.gob.ec/interoperador-v2?wsdl"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTENT_LENGTH 
"280"
CONTENT_TYPE 
"application/x-www-form-urlencoded; charset=UTF-8"
CONTEXT_DOCUMENT_ROOT 
"/data/produccion/integral/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/data/produccion/integral/public"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"application/json, text/javascript, */*; q=0.01"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br, zstd"
HTTP_ACCEPT_LANGUAGE 
"es-ES,es;q=0.9"
HTTP_AUTHORIZATION 
""
HTTP_CONNECTION 
"keep-alive"
HTTP_COOKIE 
"_ga=GA1.1.800957427.1725714171; _ga_C7TYWRCF3N=GS1.1.1726802015.2.0.1726802017.0.0.0"
HTTP_HOST 
"integral.dirmov.mil.ec"
HTTP_ORIGIN 
"https://integral.dirmov.mil.ec"
HTTP_REFERER 
"https://integral.dirmov.mil.ec/aspirantes/registro/linea"
HTTP_SEC_CH_UA 
""Chromium";v="128", "Not;A=Brand";v="24", "Google Chrome";v="128""
HTTP_SEC_CH_UA_MOBILE 
"?1"
HTTP_SEC_CH_UA_PLATFORM 
""Android""
HTTP_SEC_FETCH_DEST 
"empty"
HTTP_SEC_FETCH_MODE 
"cors"
HTTP_SEC_FETCH_SITE 
"same-origin"
HTTP_USER_AGENT 
"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36"
HTTP_X_REQUESTED_WITH 
"XMLHttpRequest"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=aspirantes/registro/salvar/encuesta"
REDIRECT_HTTPS 
"on"
REDIRECT_HTTP_AUTHORIZATION 
""
REDIRECT_QUERY_STRING 
"p=aspirantes/registro/salvar/encuesta"
REDIRECT_SCRIPT_URI 
"https://integral.dirmov.mil.ec/aspirantes/registro/salvar/encuesta"
REDIRECT_SCRIPT_URL 
"/aspirantes/registro/salvar/encuesta"
REDIRECT_SSL_TLS_SNI 
"integral.dirmov.mil.ec"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/aspirantes/registro/salvar/encuesta"
REMOTE_ADDR 
"200.105.247.85"
REMOTE_PORT 
"48218"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1726805629
REQUEST_TIME_FLOAT 
1726805629.1599
REQUEST_URI 
"/aspirantes/registro/salvar/encuesta"
SCRIPT_FILENAME 
"/data/produccion/integral/public/index.php"
SCRIPT_NAME 
"/index.php"
SCRIPT_URI 
"https://integral.dirmov.mil.ec/aspirantes/registro/salvar/encuesta"
SCRIPT_URL 
"/aspirantes/registro/salvar/encuesta"
SERVER_ADDR 
"200.6.25.29"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"integral.dirmov.mil.ec"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.52 (Ubuntu) Server at integral.dirmov.mil.ec Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.52 (Ubuntu)"
SSL_TLS_SNI 
"integral.dirmov.mil.ec"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MESSENGER_TRANSPORT_DSN,DATABASE_URL,MAILER_DSN,LOCK_DSN,ws_dinardap,ws_dinardap_v2"

Parent Request

Return to parent request (token = 2e5381)

Key Value
_controller 
"App\Controller\AspirantesController::registroSalvarEncuestaAction"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"aspirante_salva_encuesta"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"d0d434"