https://dashboard-sgn.appdev.web.id/_profiler/598948/search/results?ip=74.7.227.18&limit=10&p=_profiler%2F1ff470%2Fsearch%2Fresults&url=https%3A%2F%2Fdashboard-sgn.appdev.web.id%2Ffavicon.ico%26amp%3Bamp%3Bamp%3Bamp%3Bquot%26amp%3Bamp%3Bamp%3Bquot%3B%26amp%3Bquot%3B%26quot%3B%3Famp%253Bamp%253Bamp%253Bamp%253Bquot%3D%26amp%253Bamp%253Bamp%253Bquot%253B%3D%26amp%253Bquot%253B%3D%26p%3Dfavicon.ico%26quot%253B%3D

Method
GET
HTTP Status
500
IP
57.141.18.12
Profiled on
Token
598ee4

ErrorController

Request

GET Parameters

Key Value
ip 
"74.7.227.18"
limit 
"10"
p 
"_profiler/1ff470/search/results"
url 
"https://dashboard-sgn.appdev.web.id/favicon.ico&quot"""?amp%3Bamp%3Bamp%3Bamp%3Bquot=&amp%3Bamp%3Bamp%3Bquot%3B=&amp%3Bquot%3B=&p=favicon.ico&quot%3B="

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_firewall_context 
"security.firewall.map.context.dev"
_stopwatch_token 
"cea937"
exception 
Doctrine\DBAL\Exception\DriverException {#1679
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1688 …}
  #message: """
    An exception occurred while executing 'INSERT INTO session (id, ip, referrer, user_agent, query_string, utm_source, utm_medium, utm_campaign, utm_term, utm_content, loan_term, rep_apr, created, lifetime_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [1239367, "57.141.18.12", "", "Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/145.0.0.0 Safari\/537.36 (compatible; meta-externalagent\/1.1 (+https:\/\/developers.facebook.com\/docs\/sharing\/webmasters\/crawler))", "ip=74.7.227.18&limit=10&p=_profiler%2F1ff470%2Fsearch%2Fresults&url=https%3A%2F%2Fdashboard-sgn.appdev.web.id%2Ffavicon.ico%26amp%3Bamp%3Bamp%3Bamp%3Bquot%26amp%3Bamp%3Bamp%3Bquot%3B%26amp%3Bquot%3B%26quot%3B%3Famp%253Bamp%253Bamp%253Bamp%253Bquot%3D%26amp%253Bamp%253Bamp%253Bquot%253B%3D%26amp%253Bquot%253B%3D%26p%3Dfavicon.ico%26quot%253B%3D", "", "", "", "", "", "", "", "2026-08-04 05:21:54", 1239089]:\n
    \n
    SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(255)
    """
  #code: 0
  #file: "/var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php"
  #line: 102
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1688 …}
  trace: {
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:102 {
      Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException($message, DriverException $exception) …
      › 
      ›     return new DriverException($message, $exception);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 {
      Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) …
      › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
      ›     return $driver->convertException($msg, $driverEx);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159 {
      Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Driver $driver, Throwable $driverEx, $sql, array $params = []) …
      › 
      ›     return self::wrapException($driver, $driverEx, $msg);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226 {
      Doctrine\DBAL\Connection->handleExceptionDuringQuery(Throwable $e, string $sql, array $params = [], array $types = []): void …
      ›     $sql,
      ›     $this->resolveParams($params, $types)
      › )
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:185 {
      Doctrine\DBAL\Statement->execute($params = null) …
      › 
      ›     $this->conn->handleExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:226 {
      Doctrine\DBAL\Statement->executeStatement(array $params = []): int …
      › 
      › $this->execute($params);
      › 
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:290 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() …
      › 
      › $stmt->executeStatement();
      › 
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/orm/src/UnitOfWork.php:1188 {
      Doctrine\ORM\UnitOfWork->executeInserts(): void …
      › 
      › $postInsertIds = $persister->executeInserts();
      › 
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/orm/src/UnitOfWork.php:448 {
      Doctrine\ORM\UnitOfWork->commit($entity = null) …
      ›     // in the database.
      ›     $this->executeInserts();
      › }
    }
    /var/www/html/dashboard_sgn/vendor/doctrine/orm/src/EntityManager.php:414 {
      Doctrine\ORM\EntityManager->flush($entity = null) …
      › 
      ›     $this->unitOfWork->commit($entity);
      › }
    }
    /var/www/html/dashboard_sgn/var/cache/dev/ContainerHIp5z2W/EntityManager_9a5be93.php:136 {
      ContainerHIp5z2W\EntityManager_9a5be93->flush($entity = null) …
      › 
      ›     return $this->valueHolder9748e->flush($entity);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/kematjaya/visitor-tracking-bundle/src/EventListener/VisitorTrackingSubscriber.php:202 {
      Kematjaya\VisitorTrackingBundle\EventListener\VisitorTrackingSubscriber->generateSessionAndLifetime(Request $request): void …
      › 
      › $this->entityManager->flush($session);
      › 
    }
    /var/www/html/dashboard_sgn/vendor/kematjaya/visitor-tracking-bundle/src/EventListener/VisitorTrackingSubscriber.php:83 {
      Kematjaya\VisitorTrackingBundle\EventListener\VisitorTrackingSubscriber->onKernelRequest(RequestEvent $event): void …
      › if (!$request->cookies->has(self::COOKIE_SESSION)) {
      ›     $this->generateSessionAndLifetime($request);
      ›     
    }
    /var/www/html/dashboard_sgn/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › try {
      ›     ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › } finally {
    }
    /var/www/html/dashboard_sgn/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
      Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, ?string $eventName = null): object …
      › if ($listeners) {
      ›     $this->callListeners($listeners, $eventName, $event);
      › }
    }
    /var/www/html/dashboard_sgn/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, ?string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
    }
    /var/www/html/dashboard_sgn/vendor/symfony/http-kernel/HttpKernel.php:139 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › $event = new RequestEvent($this, $request, $type);
      › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
      › 
    }
    /var/www/html/dashboard_sgn/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/html/dashboard_sgn/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/html/dashboard_sgn/public/index.php:20 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#282 …9}

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, deflate, zstd"
authorization 
""
connection 
"keep-alive"
host 
"dashboard-sgn.appdev.web.id"
user-agent 
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 (compatible; meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler))"
x-php-ob-level 
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Mon, 03 Aug 2026 22:21:54 GMT"
vary 
"Accept"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20%27INSERT%20INTO%20session%20%28id%2C%20ip%2C%20referrer%2C%20user_agent%2C%20query_string%2C%20utm_source%2C%20utm_medium%2C%20utm_campaign%2C%20utm_term%2C%20utm_content%2C%20loan_term%2C%20rep_apr%2C%20created%2C%20lifetime_id%29%20VALUES%20%28%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%2C%20%3F%29%27%20with%20params%20%5B1239367%2C%20%2257.141.18.12%22%2C%20%22%22%2C%20%22Mozilla%5C%2F5.0%20%28Windows%20NT%2010.0%3B%20Win64%3B%20x64%29%20AppleWebKit%5C%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Chrome%5C%2F145.0.0.0%20Safari%5C%2F537.36%20%28compatible%3B%20meta-externalagent%5C%2F1.1%20%28%2Bhttps%3A%5C%2F%5C%2Fdevelopers.facebook.com%5C%2Fdocs%5C%2Fsharing%5C%2Fwebmasters%5C%2Fcrawler%29%29%22%2C%20%22ip%3D74.7.227.18%26limit%3D10%26p%3D_profiler%252F1ff470%252Fsearch%252Fresults%26url%3Dhttps%253A%252F%252Fdashboard-sgn.appdev.web.id%252Ffavicon.ico%2526amp%253Bamp%253Bamp%253Bamp%253Bquot%2526amp%253Bamp%253Bamp%253Bquot%253B%2526amp%253Bquot%253B%2526quot%253B%253Famp%25253Bamp%25253Bamp%25253Bamp%25253Bquot%253D%2526amp%25253Bamp%25253Bamp%25253Bquot%25253B%253D%2526amp%25253Bquot%25253B%253D%2526p%253Dfavicon.ico%2526quot%25253B%253D%22%2C%20%22%22%2C%20%22%22%2C%20%22%22%2C%20%22%22%2C%20%22%22%2C%20%22%22%2C%20%22%22%2C%20%222026-08-04%2005%3A21%3A54%22%2C%201239089%5D%3A%0A%0ASQLSTATE%5B22001%5D%3A%20String%20data%2C%20right%20truncated%3A%207%20ERROR%3A%20%20value%20too%20long%20for%20type%20character%20varying%28255%29"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fhtml%2Fdashboard_sgn%2Fvendor%2Fdoctrine%2Fdbal%2Flib%2FDoctrine%2FDBAL%2FDriver%2FAbstractPostgreSQLDriver.php:102"
x-debug-token 
"598ee4"

Cookies

Request Cookies

No request cookies

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
API_PERMOHONAN 
"http://localhost/integrasi_jatim/web/service.php/permohonan/create"
API_TOKEN 
"4a81432adf56aeb6aadfffa65ab70ab1"
API_URL 
"http://localhost/integrasi_jatim/web/service.php/open_data"
API_URL_OLD 
"http://localhost/integrasi_jatim/web/api_/opendata.php"
APP_ENV 
"dev"
APP_SECRET 
"302717838b52f3d1699a25e8e3ef6a9d"
DATABASE_URL 
"postgresql://postgres:piramida123@127.0.0.1:5432/dashboard_sgn?serverVersion=13&charset=utf8"
JWT_PASSPHRASE 
"e557345f3645bff8b5c64b3bfbea17d3183d27950c4476b624e967fef440c329"
JWT_PUBLIC_KEY 
"%kernel.project_dir%/config/jwt/public.pem"
JWT_SECRET_KEY 
"%kernel.project_dir%/config/jwt/private.pem"
MAILER_DSN 
"null://null"
TOKEN_POST_PERMOHONAN 
"7iMOZJ30lYngX8Gw68LHc=Kd69vzu02GnjDAnvz9VPxPDKAI25O!BFjtiDGF-xg!"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/html/dashboard_sgn/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/html/dashboard_sgn/public"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/var/www"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, zstd"
HTTP_AUTHORIZATION 
""
HTTP_CONNECTION 
"keep-alive"
HTTP_HOST 
"dashboard-sgn.appdev.web.id"
HTTP_USER_AGENT 
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 (compatible; meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler))"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=_profiler/598948/search/results&p=_profiler/1ff470/search/results&limit=10&ip=74.7.227.18&url=https://dashboard-sgn.appdev.web.id/favicon.ico%26amp;amp;amp;amp;quot%26amp;amp;amp;quot;%26amp;quot;%26quot;?amp%253Bamp%253Bamp%253Bamp%253Bquot%3D%26amp%253Bamp%253Bamp%253Bquot%253B%3D%26amp%253Bquot%253B%3D%26p%3Dfavicon.ico%26quot%253B%3D"
REDIRECT_HTTPS 
"on"
REDIRECT_QUERY_STRING 
"p=_profiler/598948/search/results&p=_profiler/1ff470/search/results&limit=10&ip=74.7.227.18&url=https://dashboard-sgn.appdev.web.id/favicon.ico%26amp;amp;amp;amp;quot%26amp;amp;amp;quot;%26amp;quot;%26quot;?amp%253Bamp%253Bamp%253Bamp%253Bquot%3D%26amp%253Bamp%253Bamp%253Bquot%253B%3D%26amp%253Bquot%253B%3D%26p%3Dfavicon.ico%26quot%253B%3D"
REDIRECT_SCRIPT_URI 
"https://dashboard-sgn.appdev.web.id/_profiler/598948/search/results"
REDIRECT_SCRIPT_URL 
"/_profiler/598948/search/results"
REDIRECT_SSL_TLS_SNI 
"dashboard-sgn.appdev.web.id"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/_profiler/598948/search/results"
REMOTE_ADDR 
"57.141.18.12"
REMOTE_PORT 
"20568"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1785795714
REQUEST_TIME_FLOAT 
1785795714.7765
REQUEST_URI 
"/_profiler/598948/search/results?p=_profiler/1ff470/search/results&limit=10&ip=74.7.227.18&url=https://dashboard-sgn.appdev.web.id/favicon.ico%26amp;amp;amp;amp;quot%26amp;amp;amp;quot;%26amp;quot;%26quot;?amp%253Bamp%253Bamp%253Bamp%253Bquot%3D%26amp%253Bamp%253Bamp%253Bquot%253B%3D%26amp%253Bquot%253B%3D%26p%3Dfavicon.ico%26quot%253B%3D"
SCRIPT_FILENAME 
"//var/www/html/dashboard_sgn/public/index.php"
SCRIPT_NAME 
"/index.php"
SCRIPT_URI 
"https://dashboard-sgn.appdev.web.id/_profiler/598948/search/results"
SCRIPT_URL 
"/_profiler/598948/search/results"
SERVER_ADDR 
"103.103.137.118"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"dashboard-sgn.appdev.web.id"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.58 (Ubuntu) Server at dashboard-sgn.appdev.web.id Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.58 (Ubuntu)"
SSL_TLS_SNI 
"dashboard-sgn.appdev.web.id"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_URL,API_URL_OLD,API_URL,API_TOKEN,TOKEN_POST_PERMOHONAN,API_PERMOHONAN,MAILER_DSN,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE"
USER 
"www-data"
proxy-nokeepalive 
"1"

Parent Request

Return to parent request (token = 78961b)

Key Value
_controller 
"web_profiler.controller.profiler::searchResultsAction"
_firewall_context 
"security.firewall.map.context.dev"
_remove_csp_headers 
true
_route 
"_profiler_search_results"
_route_params 
[
  "token" => "598948"
]
_stopwatch_token 
"fb4a5d"
token 
"598948"