http://opendata.kedirikab.go.id/dataset/3782/csv/download_excel?p=dataset%2F3782%2Fcsv%2Fdownload_excel

ErrorController

Request

GET Parameters

Key Value
p
"dataset/3782/csv/download_excel"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"error_controller"
_stopwatch_token
"b4423d"
exception
Symfony\Component\ErrorHandler\Error\OutOfMemoryError {#263644
  -error: [
    "type" => 1
    "message" => "Allowed memory size of 134217728 bytes exhausted (tried to allocate 10485760 bytes)"
    "file" => "/var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php"
    "line" => 395
  ]
  #message: "Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10485760 bytes)"
  #code: 0
  #file: "/var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php"
  #line: 395
  trace: {
    /var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php:395 {
      PhpOffice\PhpSpreadsheet\Collection\Cells->add($cellCoordinate, Cell $cell) …
      › sscanf($cellCoordinate, '%[A-Z]%d', $column, $row);$this->index[$cellCoordinate] = (--$row * self::MAX_COLUMN_ID) + Coordinate::columnIndexFromString((string) $column);}
    /var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:1401 {
      PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->createNewCell($coordinate): Cell …
      › $cell = new Cell(null, DataType::TYPE_NULL, $this);$this->cellCollection->add($coordinate, $cell);}
    /var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:1289 {
      PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->getCell($coordinate): Cell …
      › 
      ›     return $cell ?? $sheet->createNewCell($finalCoordinate);}
    }
    /var/www/html/open_data/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:3019 {
      PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->fromArray(array $source, $nullValue = null, $startCell = 'A1', $strictNullComparison = false) …
      ›     // Set cell value    $this->getCell($currentColumn . $startRow)->setValue($cellValue);}
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:363 {
      App\Controller\Frontend\DatasetController->downloadExcel(?string $id, string $tipe, TPublikasiRepository $tPublikasiRepo, TVariabelRepository $tVariabelRepo) …
      › 
      › $sheet->fromArray($dataset, null, 'A2');}
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller$response = $controller(...$arguments);}
    /var/www/html/open_data/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/open_data/vendor/symfony/http-kernel/Kernel.php:202 {
      App\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->getHttpKernel()->handle($request, $type, $catch);} finally {
    }
    /var/www/html/open_data/public/index.php:20 {
      {main} …
      › $request = Request::createFromGlobals();$response = $kernel->handle($request);$response->send();
    }
    /var/www/html/open_data/public/index.php:0 {
      › 
      › ""
      › <?php
    }
  }
}
logger
null

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, br, zstd, deflate"
authorization
""
connection
"close"
host
"opendata.kedirikab.go.id"
user-agent
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
x-forwarded-for
"192.168.60.9"
x-forwarded-proto
"https"
x-forwarded-scheme
"https"
x-php-ob-level
"1"
x-real-ip
"192.168.60.9"

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
"Fri, 22 Nov 2024 03:17:43 GMT"
x-debug-exception
"Error%3A%20Allowed%20memory%20size%20of%20134217728%20bytes%20exhausted%20%28tried%20to%20allocate%2010485760%20bytes%29"
x-debug-exception-file
"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fphpoffice%2Fphpspreadsheet%2Fsrc%2FPhpSpreadsheet%2FCollection%2FCells.php:395"
x-debug-token
"0517b5"

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_TOKEN
"4a81432adf56aeb6aadfffa65ab70ab1"
API_URL
"http://172.16.16.68/api_/opendata.php"
APP_CLIENT_ADDRESS
"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"
APP_CLIENT_CONTACT
"Telp. (0354) 682152"
APP_CLIENT_EMAIL
""
APP_CLIENT_NAME
"Kabupaten Kediri"
APP_CLIENT_SHORTNAME
"Kabupaten Kediri"
APP_ENV
"dev"
APP_ICON
"assets/logo/logo_masbup.png"
APP_ICON_LOGO
"assets/logo/kota_kediri.png"
APP_NAME
"Open Data Kediri"
APP_SECRET
"302717838b52f3d1699a25e8e3ef6a9d"
COLOR_DANGER
"#b20238;"
COLOR_INFO
"#e8d21d;"
COLOR_PRIMARY
"#039fbe;"
COLOR_WARNING
"#cf1578;"
DATABASE_URL
"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"
OPEN_DATA_ICON
"assets/logo/logo_masbup_merah.png"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CONTEXT_DOCUMENT_ROOT
"/var/www/html/open_data/public/"
CONTEXT_PREFIX
""
DOCUMENT_ROOT
"/var/www/html/open_data/public/"
GATEWAY_INTERFACE
"CGI/1.1"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, br, zstd, deflate"
HTTP_AUTHORIZATION
""
HTTP_CONNECTION
"close"
HTTP_HOST
"opendata.kedirikab.go.id"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_X_FORWARDED_FOR
"192.168.60.9"
HTTP_X_FORWARDED_PROTO
"https"
HTTP_X_FORWARDED_SCHEME
"https"
HTTP_X_REAL_IP
"192.168.60.9"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF
"/index.php"
QUERY_STRING
"p=dataset/3782/csv/download_excel"
REDIRECT_QUERY_STRING
"p=dataset/3782/csv/download_excel"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/dataset/3782/csv/download_excel"
REMOTE_ADDR
"172.16.25.100"
REMOTE_PORT
"37440"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"http"
REQUEST_TIME
1732245394
REQUEST_TIME_FLOAT
1732245394.4241
REQUEST_URI
"/dataset/3782/csv/download_excel"
SCRIPT_FILENAME
"/var/www/html/open_data/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"172.16.16.52"
SERVER_ADMIN
"[no address given]"
SERVER_NAME
"opendata.kedirikab.go.id"
SERVER_PORT
"80"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SIGNATURE
""
SERVER_SOFTWARE
"Apache"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_SECRET,DATABASE_URL,API_URL,API_TOKEN,APP_NAME,OPEN_DATA_ICON,APP_ICON,APP_ICON_LOGO,APP_CLIENT_NAME,APP_CLIENT_SHORTNAME,APP_CLIENT_ADDRESS,APP_CLIENT_CONTACT,APP_CLIENT_EMAIL,COLOR_PRIMARY,COLOR_WARNING,COLOR_INFO,COLOR_DANGER"

Parent Request

Return to parent request (token = 62f82a)

Key Value
_controller
"App\Controller\Frontend\DatasetController::downloadExcel"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"dataset_excel"
_route_params
[
  "id" => "3782"
  "tipe" => "csv"
]
_security_firewall_run
"_security_main"
_stopwatch_token
"c1a3a1"
id
"3782"
tipe
"csv"