Exception detected!

An exception occurred while executing 'SELECT distinct NANO, TITULO, REVISTA, ISSN, WOS, SCOPUS, SPI, FECYT, AHCI, SSCI, SCIE, ESCI, CITAS_WOS, CITAS_SCOPUS,
ENLACE FROM vgir_publicaciones WHERE nano <= 2020 and DNI in ('42852946','43773093','42888491','03782834','42744167','52839973','42703302','42743128','44307522','42782495','45536932','00804619','78502818','45764685') order by nano desc,titulo':

ORA-01427: la subconsulta de una sola fila devuelve más de una fila

500 Internal Server Error - DBALException
1 linked Exception:
  • OCI8Exception »

[2/2] DBALException: An exception occurred while executing 'SELECT distinct NANO, TITULO, REVISTA, ISSN, WOS, SCOPUS, SPI, FECYT, AHCI, SSCI, SCIE, ESCI, CITAS_WOS, CITAS_SCOPUS,
ENLACE FROM vgir_publicaciones WHERE nano <= 2020 and DNI in ('42852946','43773093','42888491','03782834','42744167','52839973','42703302','42743128','44307522','42782495','45536932','00804619','78502818','45764685') order by nano desc,titulo':

ORA-01427: la subconsulta de una sola fila devuelve más de una fila  +

[1/2] OCI8Exception: ORA-01427: la subconsulta de una sola fila devuelve más de una fila  +

Logs  -

1 error
  1. INFO - Matched route "detalle" (parameters: "_controller": "PI\GIRBundle\Controller\publicoController::detalleAction", "idGrupo": "2880", "_route": "detalle")
  2. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  3. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  4. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  5. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
  6. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  7. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  8. DEBUG - Notified event "kernel.request" to listener "Qandidate\Common\Symfony\HttpKernel\EventListener\JsonRequestTransformerListener::onKernelRequest".
  9. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
  10. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  11. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  12. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  13. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
  14. DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
  15. DEBUG - Notified event "kernel.request" to listener "Ps\PdfBundle\EventListener\PdfListener::onKernelRequest".
  16. DEBUG - Notified event "kernel.request" to listener "GA\ActasTFTBundle\Listener\MaintenanceListener::onKernelRequest".
  17. DEBUG - Notified event "kernel.request" to listener "GA\ActasTFTBundle\Services\actasTFTService::onKernelRequest".
  18. DEBUG - Notified event "kernel.request" to listener "DOCENTIA\DocentiaBundle\Services\permisosService::onKernelRequest".
  19. DEBUG - Notified event "kernel.request" to listener "GA\EBAUBundle\Services\plazosService::onKernelRequest".
  20. DEBUG - Notified event "kernel.request" to listener "GP\PDIPermisosLicenciasBundle\Services\permisosService::onKernelRequest".
  21. DEBUG - Notified event "kernel.controller" to listener "Ps\PdfBundle\EventListener\PdfListener::onKernelController".
  22. DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  23. DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
  24. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
  25. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  26. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
  27. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
  28. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
  29. DEBUG - ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'
  30. DEBUG - SELECT a.* FROM (SELECT y0_.ID AS ID0, v1_.ADENOM AS ADENOM1, y2_.ANDIPA AS ANDIPA2, v1_.AWEB AS AWEB3, CASE WHEN SUBSTR(v1_.AWEB, 1, 4) = 'http' THEN v1_.AWEB ELSE 'http://' || v1_.AWEB END AS SCLR4, v1_.ARAMA1 AS ARAMA15, v1_.AMAILA AS AMAILA6, v1_.ADENOM80 AS ADENOM807, v1_.ADIRCOM AS ADIRCOM8, v1_.APENOM AS APENOM9, y0_.APRODUC AS APRODUC10, y0_.NPRODUC AS NPRODUC11, y0_.NANO AS NANO12, y0_.NCODGRUPO AS NCODGRUPO13, y0_.CNEAI AS CNEAI14, y0_.CNEAI2 AS CNEAI215 FROM VGIRDATOSFIJOS v1_, YPI4021 y2_, YPI4001 y0_ WHERE v1_.IDGRUPO = y2_.IDGRUPO AND y0_.ID = v1_.IDGRUPO AND y2_.ATIPO = '1' AND v1_.IDGRUPO = 2880) a WHERE ROWNUM <= 1
  31. DEBUG - SELECT y0_.ID AS ID0, y1_.ID AS ID1 FROM YPI4011 y0_, YPI4001 y1_ WHERE y0_.DFPUBLI IS NOT NULL AND y0_.ID = y1_.NANO AND y1_.NCODGRUPO = 115 AND y1_.AESTADO = 'V' ORDER BY y0_.ID DESC
  32. DEBUG - SELECT adenom80, instituto, packgir.descriptores('2880', 0, 'E') desc_esp, packgir.descriptores('2880', 0, 'I') desc_ing FROM vgirdatosfijos WHERE idgrupo='2880'
  33. DEBUG - SELECT OU_ID FROM accedacris.prod_gir WHERE codigo_grupo='115'
  34. DEBUG - SELECT p.apenom adenom, p.dni ANDIPA, atipo, packgir.es_activo(m.andipa, '2020') activo FROM ypi4021 m, vgirapenom p WHERE atipo in ('1','2') AND m.andipa=p.dni AND m.idgrupo='2880' ORDER BY atipo, adenom
  35. DEBUG - SELECT distinct upper( n.aape1a || ' '|| n.aape2a || ', '|| n.anomba) adenom FROM ypi4021 m, ypi4031 n WHERE atipo='3' AND m.id=n.idmiembro AND m.idgrupo='2880' ORDER BY adenom
  36. DEBUG - SELECT distinct l.adenom, p.apenom responsable, l.adesc_es, l.adesc_ing,l.publicacion1 publicacion1, l.publicacion2 publicacion2,l.publicacion3 publicacion3,l.publicacion4 publicacion4,l.publicacion5 publicacion5, l.proyecto1 proyecto1,l.proyecto2 proyecto2,l.proyecto3 proyecto3,l.proyecto4 proyecto4,l.proyecto5 proyecto5, packgir.descriptores('2880', l.id, 'E') desc_esp, packgir.descriptores('2880', l.id, 'I') desc_ing FROM ypi4041 l, vgirapenom p WHERE l.idgrupo='2880' AND l.dni=p.dni(+) ORDER BY adenom
  37. DEBUG - SELECT distinct NANO, TITULO, REVISTA, ISSN, WOS, SCOPUS, SPI, FECYT, AHCI, SSCI, SCIE, ESCI, CITAS_WOS, CITAS_SCOPUS, ENLACE FROM vgir_publicaciones WHERE nano <= 2020 and DNI in ('42852946','43773093','42888491','03782834','42744167','52839973','42703302','42743128','44307522','42782495','45536932','00804619','78502818','45764685') order by nano desc,titulo
  38. CRITICAL - Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT distinct NANO, TITULO, REVISTA, ISSN, WOS, SCOPUS, SPI, FECYT, AHCI, SSCI, SCIE, ESCI, CITAS_WOS, CITAS_SCOPUS, ENLACE FROM vgir_publicaciones WHERE nano <= 2020 and DNI in ('42852946','43773093','42888491','03782834','42744167','52839973','42703302','42743128','44307522','42782495','45536932','00804619','78502818','45764685') order by nano desc,titulo': ORA-01427: la subconsulta de una sola fila devuelve más de una fila" at /var/www/html/symfony/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
  39. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  40. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  41. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ErrorsLoggerListener::injectLogger".
  42. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
  43. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
  44. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
  45. DEBUG - Notified event "kernel.request" to listener "Qandidate\Common\Symfony\HttpKernel\EventListener\JsonRequestTransformerListener::onKernelRequest".
  46. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
  47. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
  48. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
  49. DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
  50. DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
  51. DEBUG - Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
  52. DEBUG - Notified event "kernel.request" to listener "Ps\PdfBundle\EventListener\PdfListener::onKernelRequest".
  53. DEBUG - Notified event "kernel.request" to listener "GA\ActasTFTBundle\Listener\MaintenanceListener::onKernelRequest".
  54. DEBUG - Notified event "kernel.request" to listener "GA\ActasTFTBundle\Services\actasTFTService::onKernelRequest".
  55. DEBUG - Notified event "kernel.request" to listener "DOCENTIA\DocentiaBundle\Services\permisosService::onKernelRequest".
  56. DEBUG - Notified event "kernel.request" to listener "GA\EBAUBundle\Services\plazosService::onKernelRequest".
  57. DEBUG - Notified event "kernel.request" to listener "GP\PDIPermisosLicenciasBundle\Services\permisosService::onKernelRequest".
  58. DEBUG - Notified event "kernel.controller" to listener "Ps\PdfBundle\EventListener\PdfListener::onKernelController".
  59. DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
  60. DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
  61. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
  62. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
  63. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
  64. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
  65. DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".

Stack Trace (Plain Text)  +