SyncPreConfiguredExportRequestAction
Request
GET Parameters
Key | Value |
---|---|
params | [ "begin_at" => "2024-05-27" "end_at" => "2024-06-02" ] |
POST Parameters
No POST parameters
Uploaded Files
No files were uploaded
Request Attributes
Key | Value |
---|---|
_controller | "App\V4\Action\Export\SyncPreConfiguredExportRequestAction" |
_firewall_context | "security.firewall.map.context.api" |
_links | Fig\Link\GenericLinkProvider {#2432 -links: [ "000000002fb8d3250000000001c0a115" => Fig\Link\Link {#2429 -href: "https://dev.app.pol-crm.com/api/docs.jsonld" -rel: [ "http://www.w3.org/ns/hydra/core#apiDocumentation" => true ] -attributes: [] } ] } |
_route | "sync_preconfigured_export_request" |
_route_params | [ "id" => "01JS40W42YRM7H61G7085N9ZAV" ] |
_stopwatch_token | "26415d" |
data | App\V4\Entity\PreconfiguredExport {#1926 -id: "01JS40W42YRM7H61G7085N9ZAV" -customerId: "0662705af65c48908b017d8fb0724bac" -entity: null -tabId: null -label: "Prospects -> Appels prospection" -content: "SELECT u.id AS user_id, CONCAT(u.firstname, ' ', u.lastname) AS user_fullname, COUNT(DISTINCT t.id) AS count FROM `{{ db_crm }}`.task t INNER JOIN `{{ db_crm }}`.prospect p ON t.prospect_id = p.id INNER JOIN `pol_api_user`.user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN {{ begin_at }} AND {{ end_at }} AND t.task_type_id = 'b22120dfb798459284562e2c1e8b81a9' AND t.is_closed = 1 AND t.name NOT IN ('Contrôle de référence', 'Placement actif') AND p.prospect_type_id = '4cb33a8d6418427dae5d0c5df61791e3' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY u.id" -isAsync: false #createdAt: DateTime @1747926870 {#1938 : 2025-05-22 17:14:30.0 Europe/Paris (+02:00) } #updatedAt: DateTime @1747926870 {#1927 : 2025-05-22 17:14:30.0 Europe/Paris (+02:00) } #createdBy: "Utilisateur Système" #updatedBy: "Utilisateur Système" #deletedAt: null } |
id | "01JS40W42YRM7H61G7085N9ZAV" |
Request Headers
Header | Value |
---|---|
accept | "*/*" |
accept-encoding | "gzip" |
baggage | "sentry-trace_id=13a9b1e91b9b499fb15453b8d887868e,sentry-sample_rate=1,sentry-transaction=app%3Astats%3Apol,sentry-release=1.0.0%2Bno-version-set%40%7Bno%20ref,sentry-environment=local,sentry-sampled=true" |
cache-control | "no-cache" |
connection | "close" |
content-length | "0" |
content-type | "application/x-www-form-urlencoded" |
host | "dev.app.pol-crm.com" |
sentry-trace | "13a9b1e91b9b499fb15453b8d887868e-613411a06f044b25-1" |
traceparent | "00-13a9b1e91b9b499fb15453b8d887868e-613411a06f044b25-01" |
user-agent | "Symfony HttpClient (Curl)" |
x-accel-internal | "/internal-nginx-static-location" |
x-php-ob-level | "1" |
x-pol-auth | "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTgwMzAwNzcsImV4cCI6MTc1ODAzNzI3Nywicm9sZXMiOlsiUk9MRV9VU0VSIiwiUk9MRV9DVVNUT01FUiIsIlJPTEVfQURNSU4iLCJST0xFX1NZU1RFTSIsIlJPTEVfTU9EVUxFX01JQ1JPU09GVF9HUkFQSCIsIlJPTEVfTU9EVUxFX1RBRyIsIlBST1NQRUNUX1NIT1ciLCJQUk9TUEVDVF9DVUQiLCJDT05UQUNUX0NVRCIsIkNPTlRBQ1RfU0hPVyIsIlRBU0tfU0hPVyIsIlRBU0tfQ1VEIiwiUVVPVEVfU0hPVyIsIlFVT1RFX0NVRCIsIlFVT1RFX1JFR0VORVJBVEVfUFJJQ0VTIl0sImxvZ2luIjoic3lzdGVtXzA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwidXNlcl9pZCI6InN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyIsInVzZXJfZXh0ZXJuYWxfaWQiOm51bGwsImVtYWlsIjpudWxsLCJjdXN0b21lcl9pZCI6IjA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwiY3VzdG9tZXJfbmFtZSI6Ik5FV0NPIiwiY3VzdG9tZXJfZXh0ZXJuYWxfaWQiOiIxNzIwMTY0ODE0IiwiY3VzdG9tZXJfbWFpbGluZ19pZCI6IjMwMSIsImZpcnN0bmFtZSI6IlV0aWxpc2F0ZXVyIiwibGFzdG5hbWUiOiJTeXN0XHUwMGU4bWUiLCJsaXZlb0xvZ2luIjpudWxsLCJsaXZlb1Bhc3N3b3JkIjpudWxsLCJoYXNJbnRyYW5ldCI6ZmFsc2UsImxhbmd1YWdlIjoiRlIiLCJzZWN0aW9uc19sZWFkZWQiOltdLCJzZWN0aW9uc19tZW1iZXJzIjpbInN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyJdLCJpc19zZWN0aW9uc19hY3RpdmF0ZWQiOmZhbHNlLCJyZWZyZXNoX3Rva2VuIjoiMWMyMzNhODY0MGYxZmRlZDRmYTg3Mzk2ZWJlMDdjMjgxNDQzMjAwYjAyNDIxM2YwZTljNDU5NjgzZTI4NDI3YzRmMzk4NmViNjg4ZWE3OWExZWFmYTZjYmVjNzBiMWFjMDBmODk0MmMxMzI0Y2QzM2VlYjRlNzU5ZmIzYWQ5YTIifQ.cw1n8stjgqmfou8ZbZV7OQ4ejI0RC44lV3GHHFA44AIpQY4c6o4iObdoYkWL2Z9NwMH5gUgzZl419koXvCEPjbNpq9HiecyIstnQswpJ61Rp4hfvqPIIhm-C-gcompffAFSy7XtWtbyDk8KX9AoZofEoVxa-DFqNywEx6icbhyHmLv_5zz3MtgyxiAVjVBBWm5M3pkkzGDCxUmIy1LXfejYmSuenlsA7TeRNkid-CLOvZfawiWmJqk-GoyZNDlyG5zbPUWommpxu2r1b4l1ry7kOMYKKUtr5hbH_P1UXPXUwFQIh0p5cf_N7OH6MKtzfvOb972q9_1VvBfLKnwgwxBwRgRDnEA8T3Haheqk-aQ4ueqCCA4vots667Xe_anmXa8L5SGngMq306nR3J2gEnP9aKm6Ua3EojYfjIGohU-Tu90Z2bLY2dracF5nkcPxwB-18OlOz8qFd_Sj-qz7GwEup-NJzHwJrEysOpydtBF6TwmwGHlFOsmo5gdkTyvsxwDmzlrexhtfDU3yb10fPgzVfSmTTNaiMc_gU0D4A_CNa6sVV7q8fgvgaAZ8sWZjTM79nofVAuhHKIgsvrScX2gunQgwRngR_quxs-sTdMA19EA7cv2P73qJDT0fxB76XE721tBAx8DacbbLSbpX5RDVw-76V3LZE2et8VsyEqiQ" |
x-real-ip | "37.58.179.19" |
x-transaction-id | "middleware:508e96867658db11016e6d57a4aa7072aa04016f" |
Request Content
Request content not available (it was retrieved as a resource).
Response
Response Headers
Header | Value |
---|---|
cache-control | "private, must-revalidate" |
content-type | "text/html; charset=UTF-8" |
date | "Tue, 16 Sep 2025 13:41:18 GMT" |
expires | -1 |
link | "<https://dev.app.pol-crm.com/api/docs.jsonld>; rel="http://www.w3.org/ns/hydra/core#apiDocumentation"" |
pragma | "no-cache" |
x-debug-token | "a17a71" |
x-debug-token-link | "https://dev.app.pol-crm.com/_profiler/d42e26" |
x-previous-debug-token | "d42e26" |
x-robots-tag | "noindex" |
Cookies
Request Cookies
No request cookies
Response Cookies
No response cookies
Session
Session Metadata
No session metadata
Session Attributes
No session attributes
Flashes
Flashes
No flash messages were created.
Server Parameters
Server Parameters
Defined in .env
Key | Value |
---|---|
API_BUSINESS_HOST | "http://dev.pol-api-business.pol-crm.com" |
API_CRM_HOST | "http://dev.pol-api-crm.pol-crm.com" |
API_GED_HOST | "http://dev.pol-api-ged.pol-crm.com" |
API_LIVEO | "https://webservice.centrex.liveo.fr/ws/" |
API_MIDDLEWARE_HOST | "http://pol-middleware.localhost" |
API_NOTIFY_HOST | "http://dev.pol-api-notify.pol-crm.com" |
API_PARAM_HOST | "http://dev.pol-api-param.pol-crm.com" |
API_POL_MAILING | "http://mailing.sfi.fr/webservices" |
API_POL_MAILING_V2 | "https://dev.mailing.pol-crm.com" |
API_SEARCH_HOST | "http://dev.pol-api-search.pol-crm.com" |
API_SERVICE_PLENETUDE_HOST | "http://dev.plenetude.pol-crm.com" |
API_USER_HOST | "http://dev.pol-api-user.pol-crm.com" |
APP_ENV | "dev" |
APP_SECRET | "61ff627c8e96e9ac55fc1926e4878f2e" |
BDD_API_BUSINESS | "dev_pol_core" |
BDD_API_CRM | "dev_pol_core" |
BDD_API_GED | "dev_pol_core" |
BDD_API_NOTIFY | "dev_pol_core" |
BDD_API_PARAM | "dev_pol_core" |
BDD_API_SEARCH | "dev_pol_core" |
BDD_API_USER | "dev_pol_core" |
BDD_MIDDLEWARE | "dev_pol_core" |
BDD_SERVICE_PLENETUDE | "dev_pol_core" |
BEGIN_DATE | "2024-01-01" |
CORS_ALLOW_ORIGIN | "^https?://pol-(crm|prospect).localhost(:[0-9]+)?$" |
DATABASE_URL | "mysql://dev_pol_core:VTgooWkhcjebxLPy8E2ycoTjytrULgNQ@127.0.0.1:3306/dev_pol_core" |
END_DATE | "2025-01-31" |
FRONT_URL | "http://pol-crm.localhost" |
FTP_INTRANET_SFI_HOST | "preprod.intranet.sfimultimedia.com" |
FTP_INTRANET_SFI_PASSWORD | "iAw453e?iAw453e?" |
FTP_INTRANET_SFI_USER | "intranetpreprod" |
GED_ABSOLUTE_DIRECTORY_PATH | "/srv/pol-api-ged/application/data/ged" |
GEONAME_API_TOKEN | "ceciestuntestpourSfi/0000" |
IMPORT_ONDUPACK_PATH_FILE | "/httpdocs/app-pol-crm/dev/current/application/data/import_ondupack" |
INSEE_API_SIRENE_KEY | "09afd2bf-050b-465e-afd2-bf050b865e20" |
IS_MAINTENANCE | "false" |
JWT_PASSPHRASE | "7de1072d7a8fcab69679c1892deb39a7" |
JWT_PUBLIC_KEY | "%kernel.project_dir%/config/jwt/public.pem" |
JWT_SECRET_KEY | "%kernel.project_dir%/config/jwt/private.pem" |
JWT_WHITELIST_PATH | "%kernel.project_dir%/var/tokens" |
MAILER_URL | "smtp://127.0.0.1:1025" |
MAILING_ENV_USER | "depot_mailing_dev-xv42" |
MESSENGER_TRANSPORT_DSN_MIDDLEWARE | "amqp://sfiweb:sfiwweb0000@127.0.0.1:5672/%2f/dev_middleware_messages" |
MESSENGER_TRANSPORT_DSN_NOTIFY | "amqp://sfiweb:sfiwweb0000@127.0.0.1:5672/%2f/dev_notify_messages" |
MESSENGER_TRANSPORT_DSN_SEARCH | "amqp://sfiweb:sfiwweb0000@127.0.0.1:5672/%2f/dev_messages" |
MICROSOFT_GRAPH_API_CLIENT_ID | "3b7f02c4-aa14-4e54-a2b9-2ee1d5d17f8a" |
MICROSOFT_GRAPH_API_CLIENT_SECRET | "FID8Q~zfFRP~Gw-85LpaCj0VqrrRr__HMGpI-drP" |
MICROSOFT_GRAPH_API_NOTIFICATION_URL | "https://dev.app.pol-crm.com/api/microsoft-graph/outlook-subscription-configuration" |
MICROSOFT_GRAPH_API_REDIRECT_URI | "https://dev.pol-crm.com/microsoft-graph" |
MICROSOFT_GRAPH_API_SUBSCRIPTION_EXPIRED_AT | "+2 days" |
MICROSOFT_GRAPH_API_TOKEN_LIFETIME | "+2 days" |
MODULE_MICROSOFT_GRAPH_SECRET | "jqsFP7MjEx1FBe1138D3" |
MONOLOG_APPLICATION_ENVIRONMENT | "dev" |
MONOLOG_APPLICATION_NAME | "pol-middleware" |
MONOLOG_SUBJECT | "[DEV][%level_name%] POL-MIDDLEWARE - %message%" |
MONOLOG_TO_EMAIL | "polv3.log@sfi.fr" |
MYSQL_DATABASE | "dev_pol_core" |
MYSQL_HOST | "127.0.0.1" |
MYSQL_PASSWORD | "VTgooWkhcjebxLPy8E2ycoTjytrULgNQ" |
MYSQL_PORT | "3306" |
MYSQL_USER | "dev_pol_core" |
PREFIX_CUSTOMER_NAME_MAILING | "[DEV]" |
REDIS_ENABLE_V4 | "true" |
REDIS_PREFIX | "dev" |
REDIS_URL | "redis://127.0.0.1:6379" |
SECURITY_ENABLE_TOKEN_WHITELIST | "0" |
SENTRY_DSN | "https://99729cc06c8241e3b07e3f6ae9b6feec@sentry.sfimultimedia.com/9" |
SENTRY_ENVIRONMENT | "dev" |
SENTRY_PERFORMANCE_SAMPLE_RATE | "1.0" |
SFI_MAILING_URL | "https://mailing.sfi.fr/webservices/recupererContactPol.php" |
SFI_SSO_FORCE_CREDENTIALS | "87;707" |
SFI_SSO_MAILING_HOST | "https://mailing.sfi.fr/webservices/sso.php" |
SYSTEMUSER_0662705af65c48908b017d8fb0724bac_PASSWORD | "7G4k4WhQZDkkB5IGLRPcdfik5s58gf58f2g5s6W6T6BXfbYj2H_customer_newco" |
SYSTEMUSER_0662705af65c48908b017d8fb0724bac_USERNAME | "system_0662705af65c48908b017d8fb0724bac" |
SYSTEMUSER_customer_124_PASSWORD | "A6uraa5HQ87hY*unfx3$mr158!d7i*TX_customer_124" |
SYSTEMUSER_customer_124_USERNAME | "system_customer_124" |
SYSTEMUSER_customer_65_PASSWORD | "uBRJV4pUKP1wRk4iULwMnty93MPr4qr3Sod8jFlfJwZdURZB_customer_65" |
SYSTEMUSER_customer_65_USERNAME | "system_customer_65" |
SYSTEMUSER_customer_66_PASSWORD | "7G4k4WhQZDkkB5IGLRPcdfik3tOZfL4PVfs6W6T6BXfbYj2H_customer_66" |
SYSTEMUSER_customer_66_USERNAME | "system_customer_66" |
SYSTEMUSER_customer_98_PASSWORD | "wWZJwEgYjqLdPx77B1o9GR7r6r4Fvug82fmALJLvQCBjWD4G_customer_98" |
SYSTEMUSER_customer_98_USERNAME | "system_customer_98" |
SYSTEMUSER_e8919dbc01f34f79ab22b9c434f114eb_PASSWORD | "TPB5ccJCl4ZL5jurkpedelfwdEiYRt4g30xYM82" |
SYSTEMUSER_e8919dbc01f34f79ab22b9c434f114eb_USERNAME | "system_e8919dbc01f34f79ab22b9c434f114eb" |
Defined as regular env variables
Key | Value |
---|---|
APP_DEBUG | "1" |
CONTENT_LENGTH | "0" |
CONTENT_TYPE | "application/x-www-form-urlencoded" |
CONTEXT_DOCUMENT_ROOT | "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/current/application/public" |
CONTEXT_PREFIX | "" |
DOCUMENT_ROOT | "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/current/application/public" |
FCGI_ROLE | "RESPONDER" |
GATEWAY_INTERFACE | "CGI/1.1" |
HOME | "/var/www/vhosts/app.pol-crm.com" |
HTTPS | "on" |
HTTP_ACCEPT | "*/*" |
HTTP_ACCEPT_ENCODING | "gzip" |
HTTP_BAGGAGE | "sentry-trace_id=13a9b1e91b9b499fb15453b8d887868e,sentry-sample_rate=1,sentry-transaction=app%3Astats%3Apol,sentry-release=1.0.0%2Bno-version-set%40%7Bno%20ref,sentry-environment=local,sentry-sampled=true" |
HTTP_CACHE_CONTROL | "no-cache" |
HTTP_CONNECTION | "close" |
HTTP_HOST | "dev.app.pol-crm.com" |
HTTP_SENTRY_TRACE | "13a9b1e91b9b499fb15453b8d887868e-613411a06f044b25-1" |
HTTP_TRACEPARENT | "00-13a9b1e91b9b499fb15453b8d887868e-613411a06f044b25-01" |
HTTP_USER_AGENT | "Symfony HttpClient (Curl)" |
HTTP_X_ACCEL_INTERNAL | "/internal-nginx-static-location" |
HTTP_X_POL_AUTH | "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTgwMzAwNzcsImV4cCI6MTc1ODAzNzI3Nywicm9sZXMiOlsiUk9MRV9VU0VSIiwiUk9MRV9DVVNUT01FUiIsIlJPTEVfQURNSU4iLCJST0xFX1NZU1RFTSIsIlJPTEVfTU9EVUxFX01JQ1JPU09GVF9HUkFQSCIsIlJPTEVfTU9EVUxFX1RBRyIsIlBST1NQRUNUX1NIT1ciLCJQUk9TUEVDVF9DVUQiLCJDT05UQUNUX0NVRCIsIkNPTlRBQ1RfU0hPVyIsIlRBU0tfU0hPVyIsIlRBU0tfQ1VEIiwiUVVPVEVfU0hPVyIsIlFVT1RFX0NVRCIsIlFVT1RFX1JFR0VORVJBVEVfUFJJQ0VTIl0sImxvZ2luIjoic3lzdGVtXzA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwidXNlcl9pZCI6InN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyIsInVzZXJfZXh0ZXJuYWxfaWQiOm51bGwsImVtYWlsIjpudWxsLCJjdXN0b21lcl9pZCI6IjA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwiY3VzdG9tZXJfbmFtZSI6Ik5FV0NPIiwiY3VzdG9tZXJfZXh0ZXJuYWxfaWQiOiIxNzIwMTY0ODE0IiwiY3VzdG9tZXJfbWFpbGluZ19pZCI6IjMwMSIsImZpcnN0bmFtZSI6IlV0aWxpc2F0ZXVyIiwibGFzdG5hbWUiOiJTeXN0XHUwMGU4bWUiLCJsaXZlb0xvZ2luIjpudWxsLCJsaXZlb1Bhc3N3b3JkIjpudWxsLCJoYXNJbnRyYW5ldCI6ZmFsc2UsImxhbmd1YWdlIjoiRlIiLCJzZWN0aW9uc19sZWFkZWQiOltdLCJzZWN0aW9uc19tZW1iZXJzIjpbInN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyJdLCJpc19zZWN0aW9uc19hY3RpdmF0ZWQiOmZhbHNlLCJyZWZyZXNoX3Rva2VuIjoiMWMyMzNhODY0MGYxZmRlZDRmYTg3Mzk2ZWJlMDdjMjgxNDQzMjAwYjAyNDIxM2YwZTljNDU5NjgzZTI4NDI3YzRmMzk4NmViNjg4ZWE3OWExZWFmYTZjYmVjNzBiMWFjMDBmODk0MmMxMzI0Y2QzM2VlYjRlNzU5ZmIzYWQ5YTIifQ.cw1n8stjgqmfou8ZbZV7OQ4ejI0RC44lV3GHHFA44AIpQY4c6o4iObdoYkWL2Z9NwMH5gUgzZl419koXvCEPjbNpq9HiecyIstnQswpJ61Rp4hfvqPIIhm-C-gcompffAFSy7XtWtbyDk8KX9AoZofEoVxa-DFqNywEx6icbhyHmLv_5zz3MtgyxiAVjVBBWm5M3pkkzGDCxUmIy1LXfejYmSuenlsA7TeRNkid-CLOvZfawiWmJqk-GoyZNDlyG5zbPUWommpxu2r1b4l1ry7kOMYKKUtr5hbH_P1UXPXUwFQIh0p5cf_N7OH6MKtzfvOb972q9_1VvBfLKnwgwxBwRgRDnEA8T3Haheqk-aQ4ueqCCA4vots667Xe_anmXa8L5SGngMq306nR3J2gEnP9aKm6Ua3EojYfjIGohU-Tu90Z2bLY2dracF5nkcPxwB-18OlOz8qFd_Sj-qz7GwEup-NJzHwJrEysOpydtBF6TwmwGHlFOsmo5gdkTyvsxwDmzlrexhtfDU3yb10fPgzVfSmTTNaiMc_gU0D4A_CNa6sVV7q8fgvgaAZ8sWZjTM79nofVAuhHKIgsvrScX2gunQgwRngR_quxs-sTdMA19EA7cv2P73qJDT0fxB76XE721tBAx8DacbbLSbpX5RDVw-76V3LZE2et8VsyEqiQ" |
HTTP_X_REAL_IP | "37.58.179.19" |
PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY | "0" |
PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY | "0" |
PATH | "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" |
PHP_SELF | "/index.php" |
QUERY_STRING | "params%5Bbegin_at%5D=2024-05-27¶ms%5Bend_at%5D=2024-06-02" |
REDIRECT_HTTPS | "on" |
REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY | "0" |
REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY | "0" |
REDIRECT_QUERY_STRING | "params%5Bbegin_at%5D=2024-05-27¶ms%5Bend_at%5D=2024-06-02" |
REDIRECT_SSL_TLS_SNI | "dev.app.pol-crm.com" |
REDIRECT_STATUS | "200" |
REDIRECT_URL | "/api/v4/sync-preconfigured-export/01JS40W42YRM7H61G7085N9ZAV/export" |
REMOTE_ADDR | "37.58.179.19" |
REMOTE_PORT | "43618" |
REQUEST_METHOD | "POST" |
REQUEST_SCHEME | "https" |
REQUEST_TIME | 1758030078 |
REQUEST_TIME_FLOAT | 1758030078.432 |
REQUEST_URI | "/api/v4/sync-preconfigured-export/01JS40W42YRM7H61G7085N9ZAV/export?params%5Bbegin_at%5D=2024-05-27¶ms%5Bend_at%5D=2024-06-02" |
SCRIPT_FILENAME | "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/current/application/public/index.php" |
SCRIPT_NAME | "/index.php" |
SERVER_ADDR | "185.18.171.8" |
SERVER_ADMIN | "[no address given]" |
SERVER_NAME | "dev.app.pol-crm.com" |
SERVER_PORT | "443" |
SERVER_PROTOCOL | "HTTP/1.0" |
SERVER_SIGNATURE | "<address>Apache Server at dev.app.pol-crm.com Port 443</address>\n" |
SERVER_SOFTWARE | "Apache" |
SSL_TLS_SNI | "dev.app.pol-crm.com" |
SYMFONY_DOTENV_VARS | "APP_ENV,APP_SECRET,BDD_API_BUSINESS,BDD_API_CRM,BDD_API_GED,BDD_API_NOTIFY,BDD_API_PARAM,BDD_API_SEARCH,BDD_API_USER,BDD_MIDDLEWARE,BDD_SERVICE_PLENETUDE,MYSQL_HOST,MYSQL_PORT,MYSQL_USER,MYSQL_PASSWORD,MYSQL_DATABASE,DATABASE_URL,MAILER_URL,CORS_ALLOW_ORIGIN,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE,JWT_WHITELIST_PATH,MONOLOG_SUBJECT,MONOLOG_TO_EMAIL,MONOLOG_APPLICATION_NAME,MONOLOG_APPLICATION_ENVIRONMENT,MESSENGER_TRANSPORT_DSN_SEARCH,MESSENGER_TRANSPORT_DSN_NOTIFY,MESSENGER_TRANSPORT_DSN_MIDDLEWARE,SENTRY_DSN,SENTRY_ENVIRONMENT,SENTRY_PERFORMANCE_SAMPLE_RATE,IS_MAINTENANCE,SECURITY_ENABLE_TOKEN_WHITELIST,REDIS_ENABLE_V4,REDIS_URL,API_BUSINESS_HOST,API_CRM_HOST,API_GED_HOST,API_NOTIFY_HOST,API_PARAM_HOST,API_SEARCH_HOST,API_USER_HOST,API_MIDDLEWARE_HOST,API_SERVICE_PLENETUDE_HOST,API_POL_MAILING,API_POL_MAILING_V2,API_LIVEO,MAILING_ENV_USER,FTP_INTRANET_SFI_HOST,FTP_INTRANET_SFI_USER,FTP_INTRANET_SFI_PASSWORD,SFI_SSO_FORCE_CREDENTIALS,MICROSOFT_GRAPH_API_REDIRECT_URI,MICROSOFT_GRAPH_API_CLIENT_ID,MICROSOFT_GRAPH_API_NOTIFICATION_URL,MICROSOFT_GRAPH_API_CLIENT_SECRET,MICROSOFT_GRAPH_API_SUBSCRIPTION_EXPIRED_AT,MODULE_MICROSOFT_GRAPH_SECRET,INSEE_API_SIRENE_KEY,GEONAME_API_TOKEN,GED_ABSOLUTE_DIRECTORY_PATH,IMPORT_ONDUPACK_PATH_FILE,FRONT_URL,REDIS_PREFIX,SFI_SSO_MAILING_HOST,SFI_MAILING_URL,PREFIX_CUSTOMER_NAME_MAILING,MICROSOFT_GRAPH_API_TOKEN_LIFETIME,SYSTEMUSER_e8919dbc01f34f79ab22b9c434f114eb_USERNAME,SYSTEMUSER_e8919dbc01f34f79ab22b9c434f114eb_PASSWORD,SYSTEMUSER_customer_65_USERNAME,SYSTEMUSER_customer_65_PASSWORD,SYSTEMUSER_customer_66_USERNAME,SYSTEMUSER_customer_66_PASSWORD,SYSTEMUSER_customer_124_USERNAME,SYSTEMUSER_customer_124_PASSWORD,SYSTEMUSER_0662705af65c48908b017d8fb0724bac_USERNAME,SYSTEMUSER_0662705af65c48908b017d8fb0724bac_PASSWORD,SYSTEMUSER_customer_98_USERNAME,SYSTEMUSER_customer_98_PASSWORD,BEGIN_DATE,END_DATE" |
USER | "app-pol-crm" |
proxy-nokeepalive | "1" |
Sub Requests 1
ErrorController (token = d42e26)
Key | Value |
---|---|
_controller | "error_controller" |
_links | Fig\Link\GenericLinkProvider {#1840 -links: [ "000000002fb8dd400000000001c0a115" => Fig\Link\Link {#1816 -href: "https://dev.app.pol-crm.com/api/docs.jsonld" -rel: [ "http://www.w3.org/ns/hydra/core#apiDocumentation" => true ] -attributes: [] } ] } |
_stopwatch_token | "2eabf4" |
exception | Doctrine\DBAL\Exception\ConnectionException {#2506 -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1944 …} #message: """ An exception occurred while executing 'SELECT u.id AS user_id, CONCAT(u.firstname, ' ', u.lastname) AS user_fullname, COUNT(DISTINCT t.id) AS count FROM `dev_pol_core`.task t INNER JOIN `dev_pol_core`.prospect p ON t.prospect_id = p.id INNER JOIN `pol_api_user`.user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN ? AND ? AND t.task_type_id = 'b22120dfb798459284562e2c1e8b81a9' AND t.is_closed = 1 AND t.name NOT IN ('Contrôle de référence', 'Placement actif') AND p.prospect_type_id = '4cb33a8d6418427dae5d0c5df61791e3' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY u.id' with params ["2024-05-27", "2024-06-02"]:\n \n SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'dev_pol_core'@'localhost' for table 'user' """ #code: 0 #file: "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/releases/20250911181322/application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" #line: 112 -previous: Doctrine\DBAL\Driver\PDO\Exception {#1944 …} : { { Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException($message, DriverException $exception) … › |
logger | Symfony\Bridge\Monolog\Logger {#1516 #name: "request" #handlers: [ Monolog\Handler\RotatingFileHandler {#1502 #filename: "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/shared/application/var/log/dev.log" #maxFiles: 14 #mustRotate: false #nextRotation: DateTime @1758060000 {#1503 : 2025-09-17 00:00:00.0 Europe/Paris (+02:00) } #filenameFormat: "{filename}-{date}" #dateFormat: "Y-m-d" #stream: stream resource @2436 : false : true : false : "plainfile" : "STDIO" : "a" : 0 : true : "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/shared/application/var/log/dev-2025-09-16.log" : [] } #url: "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/shared/application/var/log/dev-2025-09-16.log" -errorMessage: null #filePermission: null #useLocking: false -dirCreated: true #level: 100 #bubble: true #formatter: Monolog\Formatter\LineFormatter {#386 …} #processors: [ Monolog\Processor\PsrLogMessageProcessor {#1687} ] } Symfony\Bridge\Monolog\Handler\ConsoleHandler {#1515 -output: null -verbosityLevelMap: [ 16 => 400 32 => 300 64 => 250 128 => 200 256 => 100 ] -consoleFormaterOptions: [] #level: 100 #bubble: true #formatter: null #processors: [] } Monolog\Handler\FingersCrossedHandler {#1693 #handler: Monolog\Handler\BufferHandler {#1684 …} #activationStrategy: Monolog\Handler\FingersCrossed\ErrorLevelActivationStrategy {#1647 …} #buffering: false #bufferSize: 0 #buffer: [] #stopBuffering: true #passthruLevel: null #level: 100 #bubble: true #formatter: null #processors: [] } ] #processors: [ App\Service\Monolog\ELKProcessor {#1698 -applicationName: "pol-middleware" -applicationEnvironment: "dev" } Symfony\Bridge\Monolog\Processor\DebugProcessor {#1686 -records: [ "000000002fb8da6f0000000001c0a115" => [ [ "timestamp" => 1758030078 "message" => "Matched route "{route}"." "priority" => 200 "priorityName" => "INFO" "context" => [ "route" => "sync_preconfigured_export_request" "route_parameters" => [ "_route" => "sync_preconfigured_export_request" "_controller" => "App\V4\Action\Export\SyncPreConfiguredExportRequestAction" "id" => "01JS40W42YRM7H61G7085N9ZAV" ] "request_uri" => "https://dev.app.pol-crm.com/api/v4/sync-preconfigured-export/01JS40W42YRM7H61G7085N9ZAV/export?params%5Bbegin_at%5D=2024-05-27¶ms%5Bend_at%5D=2024-06-02" "method" => "POST" ] "channel" => "request" ] [ "timestamp" => 1758030078 "message" => "Checking for guard authentication credentials." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_key" => "api" "authenticators" => 1 ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Checking support on guard authenticator." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_key" => "api" "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Calling getCredentials() on guard authenticator." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_key" => "api" "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Passing guard token information to the GuardAuthenticationProvider" "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_key" => "api" "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "lexik_jwt_authentication.on_jwt_authenticated" "listener" => "App\Security\JWTAuthenticatedEventListener::onLexikJwtAuthenticationOnJwtAuthenticated" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Guard authentication successful!" "priority" => 200 "priorityName" => "INFO" "context" => [ "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authentication\Token\JWTUserToken {#481 #rawToken: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTgwMzAwNzcsImV4cCI6MTc1ODAzNzI3Nywicm9sZXMiOlsiUk9MRV9VU0VSIiwiUk9MRV9DVVNUT01FUiIsIlJPTEVfQURNSU4iLCJST0xFX1NZU1RFTSIsIlJPTEVfTU9EVUxFX01JQ1JPU09GVF9HUkFQSCIsIlJPTEVfTU9EVUxFX1RBRyIsIlBST1NQRUNUX1NIT1ciLCJQUk9TUEVDVF9DVUQiLCJDT05UQUNUX0NVRCIsIkNPTlRBQ1RfU0hPVyIsIlRBU0tfU0hPVyIsIlRBU0tfQ1VEIiwiUVVPVEVfU0hPVyIsIlFVT1RFX0NVRCIsIlFVT1RFX1JFR0VORVJBVEVfUFJJQ0VTIl0sImxvZ2luIjoic3lzdGVtXzA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwidXNlcl9pZCI6InN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyIsInVzZXJfZXh0ZXJuYWxfaWQiOm51bGwsImVtYWlsIjpudWxsLCJjdXN0b21lcl9pZCI6IjA2NjI3MDVhZjY1YzQ4OTA4YjAxN2Q4ZmIwNzI0YmFjIiwiY3VzdG9tZXJfbmFtZSI6Ik5FV0NPIiwiY3VzdG9tZXJfZXh0ZXJuYWxfaWQiOiIxNzIwMTY0ODE0IiwiY3VzdG9tZXJfbWFpbGluZ19pZCI6IjMwMSIsImZpcnN0bmFtZSI6IlV0aWxpc2F0ZXVyIiwibGFzdG5hbWUiOiJTeXN0XHUwMGU4bWUiLCJsaXZlb0xvZ2luIjpudWxsLCJsaXZlb1Bhc3N3b3JkIjpudWxsLCJoYXNJbnRyYW5ldCI6ZmFsc2UsImxhbmd1YWdlIjoiRlIiLCJzZWN0aW9uc19sZWFkZWQiOltdLCJzZWN0aW9uc19tZW1iZXJzIjpbInN5c3RlbV8wNjYyNzA1YWY2NWM0ODkwOGIwMTdkOGZiMDcyNGJhYyJdLCJpc19zZWN0aW9uc19hY3RpdmF0ZWQiOmZhbHNlLCJyZWZyZXNoX3Rva2VuIjoiMWMyMzNhODY0MGYxZmRlZDRmYTg3Mzk2ZWJlMDdjMjgxNDQzMjAwYjAyNDIxM2YwZTljNDU5NjgzZTI4NDI3YzRmMzk4NmViNjg4ZWE3OWExZWFmYTZjYmVjNzBiMWFjMDBmODk0MmMxMzI0Y2QzM2VlYjRlNzU5ZmIzYWQ5YTIifQ.cw1n8stjgqmfou8ZbZV7OQ4ejI0RC44lV3GHHFA44AIpQY4c6o4iObdoYkWL2Z9NwMH5gUgzZl419koXvCEPjbNpq9HiecyIstnQswpJ61Rp4hfvqPIIhm-C-gcompffAFSy7XtWtbyDk8KX9AoZofEoVxa-DFqNywEx6icbhyHmLv_5zz3MtgyxiAVjVBBWm5M3pkkzGDCxUmIy1LXfejYmSuenlsA7TeRNkid-CLOvZfawiWmJqk-GoyZNDlyG5zbPUWommpxu2r1b4l1ry7kOMYKKUtr5hbH_P1UXPXUwFQIh0p5cf_N7OH6MKtzfvOb972q9_1VvBfLKnwgwxBwRgRDnEA8T3Haheqk-aQ4ueqCCA4vots667Xe_anmXa8L5SGngMq306nR3J2gEnP9aKm6Ua3EojYfjIGohU-Tu90Z2bLY2dracF5nkcPxwB-18OlOz8qFd_Sj-qz7GwEup-NJzHwJrEysOpydtBF6TwmwGHlFOsmo5gdkTyvsxwDmzlrexhtfDU3yb10fPgzVfSmTTNaiMc_gU0D4A_CNa6sVV7q8fgvgaAZ8sWZjTM79nofVAuhHKIgsvrScX2gunQgwRngR_quxs-sTdMA19EA7cv2P73qJDT0fxB76XE721tBAx8DacbbLSbpX5RDVw-76V3LZE2et8VsyEqiQ" #providerKey: "api" -user: App\Security\User {#460 …} -roles: [ Symfony\Component\Security\Core\Role\Role {#758 -role: "ROLE_USER" } Symfony\Component\Security\Core\Role\Role {#760 -role: "ROLE_CUSTOMER" } Symfony\Component\Security\Core\Role\Role {#759 -role: "ROLE_ADMIN" } Symfony\Component\Security\Core\Role\Role {#414 -role: "ROLE_SYSTEM" } Symfony\Component\Security\Core\Role\Role {#761 -role: "ROLE_MODULE_MICROSOFT_GRAPH" } Symfony\Component\Security\Core\Role\Role {#762 -role: "ROLE_MODULE_TAG" } Symfony\Component\Security\Core\Role\Role {#763 -role: "PROSPECT_SHOW" } Symfony\Component\Security\Core\Role\Role {#764 -role: "PROSPECT_CUD" } Symfony\Component\Security\Core\Role\Role {#765 -role: "CONTACT_CUD" } Symfony\Component\Security\Core\Role\Role {#766 -role: "CONTACT_SHOW" } Symfony\Component\Security\Core\Role\Role {#767 -role: "TASK_SHOW" } Symfony\Component\Security\Core\Role\Role {#768 -role: "TASK_CUD" } Symfony\Component\Security\Core\Role\Role {#769 -role: "QUOTE_SHOW" } Symfony\Component\Security\Core\Role\Role {#770 -role: "QUOTE_CUD" } Symfony\Component\Security\Core\Role\Role {#771 -role: "QUOTE_REGENERATE_PRICES" } ] -roleNames: [ "ROLE_USER" "ROLE_CUSTOMER" "ROLE_ADMIN" "ROLE_SYSTEM" "ROLE_MODULE_MICROSOFT_GRAPH" "ROLE_MODULE_TAG" "PROSPECT_SHOW" "PROSPECT_CUD" "CONTACT_CUD" "CONTACT_SHOW" "TASK_SHOW" "TASK_CUD" "QUOTE_SHOW" "QUOTE_CUD" "QUOTE_REGENERATE_PRICES" ] -authenticated: true -attributes: [] } "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Guard authenticator set no success response: request continues." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Remember me skipped: it is not configured for the firewall." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "authenticator" => "App\Security\JWTTokenWhitelistAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "debug.security.authorization.vote" "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "debug.security.authorization.vote" "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\V4\Dev\EventSubscriber\DisableProfilerOnProfilerEventSubscriber::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\EventListener\DebugRequestListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\EventListener\DebugRequestListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\EventListener\RequestListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::resolveControllerName" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\Filter\QueryParameterValidateListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\EventListener\AddFormatListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\DoctrineFilter\CustomerFilterEventSubscriber::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelRequestEvent" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Sentry\SentryBundle\EventListener\TracingRequestListener::handleKernelRequestEvent" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurity" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Sentry\SentryBundle\EventListener\SubRequestListener::handleKernelRequestEvent" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\EventListener\DeserializeListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelRequestEvent" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurityPostDenormalize" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "ApiPlatform\Core\Bridge\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "App\V4\EventSubscriber\Sentry\RegisterTransactionIdEventSubscriber::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.request" "listener" => "Stof\DoctrineExtensionsBundle\EventListener\BlameListener::onKernelRequest" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.entity AS entity_3, t0.tab_id AS tab_id_4, t0.label AS label_5, t0.content AS content_6, t0.is_async AS is_async_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_at AS deleted_at_12 FROM preconfigured_export t0 WHERE t0.id = ? AND ((t0.customer_id = '0662705af65c48908b017d8fb0724bac'))" "priority" => 100 "priorityName" => "DEBUG" "context" => [ "01JS40W42YRM7H61G7085N9ZAV" ] "channel" => "doctrine" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelControllerEvent" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller_arguments" "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "Notified event "{event}" to listener "{listener}"." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments" ] "channel" => "event" ] [ "timestamp" => 1758030078 "message" => "SELECT u.id AS user_id, CONCAT(u.firstname, ' ', u.lastname) AS user_fullname, COUNT(DISTINCT t.id) AS count FROM `dev_pol_core`.task t INNER JOIN `dev_pol_core`.prospect p ON t.prospect_id = p.id INNER JOIN `pol_api_user`.user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN :begin_at AND :end_at AND t.task_type_id = 'b22120dfb798459284562e2c1e8b81a9' AND t.is_closed = 1 AND t.name NOT IN ('Contrôle de référence', 'Placement actif') AND p.prospect_type_id = '4cb33a8d6418427dae5d0c5df61791e3' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY u.id" "priority" => 100 "priorityName" => "DEBUG" "context" => [ "begin_at" => "2024-05-27" "end_at" => "2024-06-02" ] "channel" => "doctrine" ] [ "timestamp" => 1758030078 "message" => """ Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred while executing 'SELECT u.id AS user_id, CONCAT(u.firstname, ' ', u.lastname) AS user_fullname, COUNT(DISTINCT t.id) AS count FROM `dev_pol_core`.task t INNER JOIN `dev_pol_core`.prospect p ON t.prospect_id = p.id INNER JOIN `pol_api_user`.user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN ? AND ? AND t.task_type_id = 'b22120dfb798459284562e2c1e8b81a9' AND t.is_closed = 1 AND t.name NOT IN ('Contrôle de référence', 'Placement actif') AND p.prospect_type_id = '4cb33a8d6418427dae5d0c5df61791e3' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY u.id' with params ["2024-05-27", "2024-06-02"]:\n \n SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'dev_pol_core'@'localhost' for table 'user'" at /var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/releases/20250911181322/application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 """ "priority" => 500 "priorityName" => "CRITICAL" "context" => [ "exception" => Doctrine\DBAL\Exception\ConnectionException {#2506 -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1944 …} #message: """ An exception occurred while executing 'SELECT u.id AS user_id, CONCAT(u.firstname, ' ', u.lastname) AS user_fullname, COUNT(DISTINCT t.id) AS count FROM `dev_pol_core`.task t INNER JOIN `dev_pol_core`.prospect p ON t.prospect_id = p.id INNER JOIN `pol_api_user`.user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN ? AND ? AND t.task_type_id = 'b22120dfb798459284562e2c1e8b81a9' AND t.is_closed = 1 AND t.name NOT IN ('Contrôle de référence', 'Placement actif') AND p.prospect_type_id = '4cb33a8d6418427dae5d0c5df61791e3' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY u.id' with params ["2024-05-27", "2024-06-02"]:\n \n SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'dev_pol_core'@'localhost' for table 'user' """ #code: 0 #file: "/var/www/vhosts/app.pol-crm.com/httpdocs/app-pol-crm/dev/releases/20250911181322/application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" #line: 112 -previous: Doctrine\DBAL\Driver\PDO\Exception {#1944 …} : { { Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException($message, DriverException $exception) … › |