Exception detected!

Отчет по Набор Монстры!B2 -> Отчет по Набор Монстры!B2 -> Cyclic Reference in Formula

500 Internal Server Error - Exception

Stack Trace

  1. in /srv/www2/sales.irev.ru/web/vendor/CodePlex/PHPExcel/PHPExcel/Cell.php at line 288  -
    1.             } catch ( Exception $ex ) {
    2. //                echo 'Calculation Exception: '.$ex->getMessage().'<br />';
    3.                 $result '#N/A';
    4.                 throw(new Exception($this->getParent()->getTitle().'!'.$this->getCoordinate().' -> '.$ex->getMessage()));
    5.             }
    6.             if ($result === '#Not Yet Implemented') {
  2. at PHPExcel_Cell ->getCalculatedValue ()
    in /srv/www2/sales.irev.ru/web/vendor/CodePlex/PHPExcel/PHPExcel/Writer/Excel5/Worksheet.php at line 441  +
  3. at PHPExcel_Writer_Excel5_Worksheet ->close ()
    in /srv/www2/sales.irev.ru/web/vendor/CodePlex/PHPExcel/PHPExcel/Writer/Excel5.php at line 171  +
  4. at PHPExcel_Writer_Excel5 ->save ('php://output')
    in /srv/www2/sales.irev.ru/web/src/Irev/StatisticsBundle/Model/ExcelReportFormer.php at line 84  +
  5. at ExcelReportFormer ->out ('Набор Монстры(2020-12-22-2020-12-22)')
    in /srv/www2/sales.irev.ru/web/src/Irev/StatisticsBundle/Controller/ReportController.php at line 179  +
  6. at ReportController ->applicationAction ('111', 'detail')
  7. at call_user_func_array (array(object(ReportController), 'applicationAction'), array('111', 'detail'))
    in kernel.root_dir/cache/dev/classes.php at line 4753  +
  8. at HttpKernel ->handleRaw (object(Request), '1')
    in kernel.root_dir/cache/dev/classes.php at line 4717  +
  9. at HttpKernel ->handle (object(Request), '1', true)
    in kernel.root_dir/cache/dev/classes.php at line 5586  +
  10. at HttpKernel ->handle (object(Request), '1', true)
    in kernel.root_dir/bootstrap.php.cache at line 565  +
  11. at Kernel ->handle (object(Request))
    in /srv/www2/sales.irev.ru/web/web/app_serv.php at line 25  +

Logs  -

1 error
  1. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  2. Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  3. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  4. Matched route "app_report" (parameters: "_controller": "Irev\StatisticsBundle\Controller\ReportController::applicationAction", "_locale": "ru", "appId": "111", "detail": "detail", "_route": "app_report")
  5. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  6. Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  7. Notified event "security.interactive_login" to listener "FOS\UserBundle\Security\InteractiveLoginListener::onSecurityInteractiveLogin".
  8. Joomla cookie for user "admin" authenticated
  9. Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
  10. Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController".
  11. Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  12. Notified event "kernel.controller" to listener "JMS\DiExtraBundle\EventListener\ControllerListener::onKernelController".
  13. Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  14. Notified event "kernel.controller" to listener "JMS\DiExtraBundle\EventListener\TemplateListener::onKernelController".
  15. SET NAMES UTF8 ([])
  16. SELECT MAX(r0_.begin) AS sclr0 FROM report_apple r0_ ([])
  17. SELECT r0_.id AS id0, r0_.provider AS provider1, r0_.provider_country AS provider_country2, r0_.units AS units3, r0_.developer_proceeds AS developer_proceeds4, r0_.begin AS begin5, r0_.end AS end6, r0_.customer_price AS customer_price7, r0_.promo_code AS promo_code8, r0_.subscription AS subscription9, r0_.period AS period10, r0_.cross_course AS cross_course11, r0_.usd_price AS usd_price12, r0_.application_id AS application_id13, r0_.country_id AS country_id14, r0_.customer_currency_id AS customer_currency_id15, r0_.proceeds_currency_id AS proceeds_currency_id16, r0_.type_apple_id AS type_apple_id17 FROM report_apple r0_ INNER JOIN product_type_apple p1_ ON r0_.type_apple_id = p1_.id WHERE (r0_.begin BETWEEN ? AND ?) AND r0_.application_id = ? AND p1_.type <> ? ORDER BY r0_.begin ASC ([{"date":"2020-12-22 00:00:00","timezone_type":3,"timezone":"Europe\/Moscow"},{"date":"2020-12-22 23:59:59","timezone_type":3,"timezone":"Europe\/Moscow"},"111","Updates"])
  18. SELECT t0.id AS id1, t0.internal_id AS internal_id2, t0.type AS type3, t0.sku AS sku4, t0.name AS name5, t0.title AS title6, t0.title_en AS title_en7, t0.version AS version8, t0.icon AS icon9, t0.out_part AS out_part10, t0.our_full AS our_full11, t0.parent_id AS parent_id12, t0.user_id AS user_id13 FROM application t0 WHERE t0.id = ? (["111"])
  19. Notified event "kernel.exception" to listener "Symfony\Component\Security\Http\Firewall\ExceptionListener::onKernelException".
  20. Notified event "kernel.exception" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelException".
  21. Notified event "kernel.exception" to listener "Symfony\Component\HttpKernel\EventListener\ExceptionListener::onKernelException".
  22. Exception: Отчет по Набор Монстры!B2 -> Отчет по Набор Монстры!B2 -> Cyclic Reference in Formula (uncaught exception) at /srv/www2/sales.irev.ru/web/vendor/CodePlex/PHPExcel/PHPExcel/Cell.php line 288
  23. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  24. Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  25. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  26. Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  27. Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  28. Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
  29. Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController".
  30. Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  31. Notified event "kernel.controller" to listener "JMS\DiExtraBundle\EventListener\ControllerListener::onKernelController".
  32. Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  33. Notified event "kernel.controller" to listener "JMS\DiExtraBundle\EventListener\TemplateListener::onKernelController".