You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Encountered internal error as below while working with MonarcAppFO (Front Office) – version v2.13.3-p4
To Reproduce
Steps to reproduce the behavior:
This is an internal error and should be reproducible during testing of APIs.
To report to Monarc teams:
{"errors":[{"message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression AbstractService: Move the risk calculations methods into a separate helper class #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u0027monarc_cli.r0_.code\u0027 which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by","error":"error-exception","exception":{"class":"Doctrine\DBAL\Exception\DriverException","file":"/var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","line":118,"message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression AbstractService: Move the risk calculations methods into a separate helper class #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u0027monarc_cli.r0_.code\u0027 which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by","stacktrace":"#0 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1976): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\u003Econvert()\n#1 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1918): Doctrine\DBAL\Connection-\u003EhandleDriverException()\n#2 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1111): Doctrine\DBAL\Connection-\u003EconvertExceptionDuringQuery()\n#3 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php(31): Doctrine\DBAL\Connection-\u003EexecuteQuery()\n#4 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/Query.php(330): Doctrine\ORM\Query\Exec\FinalizedSelectExecutor-\u003Eexecute()\n#5 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(1218): Doctrine\ORM\Query-\u003E_doExecute()\n#6 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(1172): Doctrine\ORM\AbstractQuery-\u003EexecuteIgnoreQueryCache()\n#7 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(907): Doctrine\ORM\AbstractQuery-\u003Eexecute()\n#8 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Table/RecommendationTable.php(74): Doctrine\ORM\AbstractQuery-\u003EgetResult()\n#9 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/Traits/RecommendationsPositionsUpdateTrait.php(131): Monarc\FrontOffice\Table\RecommendationTable-\u003EfindLinkedWithRisksByAnrWithSpecifiedImportanceAndPositionAndExcludeRecommendations()\n#10 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/Traits/RecommendationsPositionsUpdateTrait.php(45): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003EupdateRecommendationsPositions()\n#11 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/AnrRecommendationRiskService.php(116): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003EupdateInstanceRiskRecommendationsPositions()\n#12 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Controller/ApiAnrRecommendationsRisksController.php(48): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003Ecreate()\n#13 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(460): Monarc\FrontOffice\Controller\ApiAnrRecommendationsRisksController-\u003Ecreate()\n#14 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(422): Laminas\Mvc\Controller\AbstractRestfulController-\u003EprocessPostData()\n#15 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractRestfulController-\u003EonDispatch()\n#16 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#17 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#18 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(306): Laminas\Mvc\Controller\AbstractController-\u003Edispatch()\n#19 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/core/src/Controller/Handler/AbstractRestfulControllerRequestHandler.php(31): Laminas\Mvc\Controller\AbstractRestfulController-\u003Edispatch()\n#20 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Middleware/RequestHandlerMiddleware.php(46): Monarc\Core\Controller\Handler\AbstractRestfulControllerRequestHandler-\u003Ehandle()\n#21 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\RequestHandlerMiddleware-\u003Eprocess()\n#22 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Middleware/AnrValidationMiddleware.php(112): Laminas\Stratigility\Next-\u003Ehandle()\n#23 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Next.php(52): Monarc\FrontOffice\Middleware\AnrValidationMiddleware-\u003Eprocess()\n#24 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next-\u003Ehandle()\n#25 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe-\u003Eprocess()\n#26 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc-middleware/src/MiddlewareController.php(58): Laminas\Stratigility\MiddlewarePipe-\u003Ehandle()\n#27 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Middleware\MiddlewareController-\u003EonDispatch()\n#28 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#29 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#30 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc-middleware/src/MiddlewareListener.php(85): Laminas\Mvc\Controller\AbstractController-\u003Edispatch()\n#31 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Middleware\MiddlewareListener-\u003EonDispatch()\n#32 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#33 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#34 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/public/index.php(34): Laminas\Mvc\Application-\u003Erun()\n#35 {main}"}}]}
Expected behavior
Fixing of this internal error.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Questions
Answers
Type of issue
Bug
OS version (server)
Debian, Ubuntu, ...
OS version (client)
MacOS, Win10, Ubuntu, ...
PHP version
7.0, 7.1...
MONARC version / git hash
2.9.XX, hash of the commit
Browser
Firefox, Chrome, Safari
Additional context
Add any other context about the problem here.
Describe the bug
Encountered internal error as below while working with MonarcAppFO (Front Office) – version v2.13.3-p4
To Reproduce
Steps to reproduce the behavior:
To report to Monarc teams:
{"errors":[{"message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression AbstractService: Move the risk calculations methods into a separate helper class #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u0027monarc_cli.r0_.code\u0027 which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by","error":"error-exception","exception":{"class":"Doctrine\DBAL\Exception\DriverException","file":"/var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","line":118,"message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression AbstractService: Move the risk calculations methods into a separate helper class #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u0027monarc_cli.r0_.code\u0027 which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by","stacktrace":"#0 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1976): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\u003Econvert()\n#1 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1918): Doctrine\DBAL\Connection-\u003EhandleDriverException()\n#2 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/dbal/src/Connection.php(1111): Doctrine\DBAL\Connection-\u003EconvertExceptionDuringQuery()\n#3 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php(31): Doctrine\DBAL\Connection-\u003EexecuteQuery()\n#4 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/Query.php(330): Doctrine\ORM\Query\Exec\FinalizedSelectExecutor-\u003Eexecute()\n#5 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(1218): Doctrine\ORM\Query-\u003E_doExecute()\n#6 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(1172): Doctrine\ORM\AbstractQuery-\u003EexecuteIgnoreQueryCache()\n#7 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/doctrine/orm/src/AbstractQuery.php(907): Doctrine\ORM\AbstractQuery-\u003Eexecute()\n#8 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Table/RecommendationTable.php(74): Doctrine\ORM\AbstractQuery-\u003EgetResult()\n#9 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/Traits/RecommendationsPositionsUpdateTrait.php(131): Monarc\FrontOffice\Table\RecommendationTable-\u003EfindLinkedWithRisksByAnrWithSpecifiedImportanceAndPositionAndExcludeRecommendations()\n#10 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/Traits/RecommendationsPositionsUpdateTrait.php(45): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003EupdateRecommendationsPositions()\n#11 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Service/AnrRecommendationRiskService.php(116): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003EupdateInstanceRiskRecommendationsPositions()\n#12 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Controller/ApiAnrRecommendationsRisksController.php(48): Monarc\FrontOffice\Service\AnrRecommendationRiskService-\u003Ecreate()\n#13 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(460): Monarc\FrontOffice\Controller\ApiAnrRecommendationsRisksController-\u003Ecreate()\n#14 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(422): Laminas\Mvc\Controller\AbstractRestfulController-\u003EprocessPostData()\n#15 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractRestfulController-\u003EonDispatch()\n#16 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#17 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#18 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php(306): Laminas\Mvc\Controller\AbstractController-\u003Edispatch()\n#19 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/core/src/Controller/Handler/AbstractRestfulControllerRequestHandler.php(31): Laminas\Mvc\Controller\AbstractRestfulController-\u003Edispatch()\n#20 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Middleware/RequestHandlerMiddleware.php(46): Monarc\Core\Controller\Handler\AbstractRestfulControllerRequestHandler-\u003Ehandle()\n#21 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\RequestHandlerMiddleware-\u003Eprocess()\n#22 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/monarc/frontoffice/src/Middleware/AnrValidationMiddleware.php(112): Laminas\Stratigility\Next-\u003Ehandle()\n#23 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/Next.php(52): Monarc\FrontOffice\Middleware\AnrValidationMiddleware-\u003Eprocess()\n#24 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next-\u003Ehandle()\n#25 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe-\u003Eprocess()\n#26 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc-middleware/src/MiddlewareController.php(58): Laminas\Stratigility\MiddlewarePipe-\u003Ehandle()\n#27 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Middleware\MiddlewareController-\u003EonDispatch()\n#28 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#29 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#30 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc-middleware/src/MiddlewareListener.php(85): Laminas\Mvc\Controller\AbstractController-\u003Edispatch()\n#31 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Middleware\MiddlewareListener-\u003EonDispatch()\n#32 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager-\u003EtriggerListeners()\n#33 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager-\u003EtriggerEventUntil()\n#34 /var/lib/monarc/releases/MonarcAppFO-v2.13.3-p4/public/index.php(34): Laminas\Mvc\Application-\u003Erun()\n#35 {main}"}}]}
Expected behavior
Fixing of this internal error.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context
Add any other context about the problem here.