"Cannot reach your data" error on segment

Guillaume · April 28, 2021, 9:40am

@Guillaume_Cisco Thanks for your answer. To notice the problem has appear the day of the last update of Google Chrome. I’m trying and keep you informed.

Nevertheless, we face this issue on all browsers (Mozilla, Safari). The issue has appeared the same day.

Thanks

Guillaume_Cisco · April 28, 2021, 9:44am

Safari and chrome both use the webkit engine, so I think the limitation is related.
You can know more about the RFC and the browser implementation here (last update comes from Sept 2020).

The 414 http status code (Request-URI Too Long) status appears if a URI is longer than the server can handle.

In a nutshell, it looks like you encounters these issues since the last chrome update and because the SQL query is very big.

Guillaume · April 28, 2021, 10:02am

@Guillaume_Cisco

Just tried with version 86 of Chrome, same issue

Below is the message we have on this request on Google Chrome. CORS policy is on Forest’s side ? Have you change your policy on this subject these last days ?

Guillaume_Cisco · April 28, 2021, 10:13am

Thanks @Guillaume,

Are you sure you are well on the chrome 86? And it did not automatically updated it to the last version?

If I understand correctly you should have seen 413 http status code error and not CORS errors, right?
You can know more about how to test with an old version of chrome here.

We did not change anything from my knowledge regarding the CORS policy on Forest’s side.

Guillaume · April 28, 2021, 10:39am

Hi @Guillaume_Cisco

I confirm I try on Google 86 and I’ve blocked the update (the same way you suggest). To sum up :

I have NOT seen any 413 error (your colleague talked to me about it but I did not face it on my side)
I see 404 error and the message I forwarded to you above

Any other idea ?

Guillaume · April 28, 2021, 1:57pm

@Guillaume_Cisco

For your information, I’ve just tried to reduce the request and lightened it around 20%, and we still face the same issue

Thanks again for your investigation on your side

anon79585656 · April 29, 2021, 8:52am

Hello @Guillaume,

With Chrome 90 on my end, it seems the 414 error disappears when I truncate the URL you pasted above to its first 8770 characters (from 10049).
I get a 401 error which is normal as I am not authenticated on you platform.

That seems to be more that the 20% reduction you indicated earlier.

Could you please double check the length of the URL you tried?

Guillaume · April 29, 2021, 9:15am

Hi @anon79585656

The request (that I copy paste below) is 6493 character-long. So below the 8770 characters you tried.

https://www.culturepay.fr/forest/TransferCode/count?fields[TransferCode]=id,member,validity_month&fields[member]=company_name&searchExtended=0&timezone=Europe/Paris&segmentQuery=SELECT transfer_codes.id FROM transfer_codes INNER JOIN members ON members.id = transfer_codes.member_id WHERE transfer_codes.id IN ( SELECT selection.tcId FROM(SELECT transfer_codes.id as tcId, CASE WHEN urssaf_payment_engaged = false AND urssaf_payment_managed_by_culturepay = true THEN urssaf_amount_cents + (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows WHERE cashflows.cash_ownerable_id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category = 2) ELSE 0 END as urssEng, CASE WHEN audiens_retraite_payment_engaged = false AND audiens_retraite_payment_managed_by_culturepay = true THEN audiens_retraite_amount_cents + (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows WHERE cashflows.cash_ownerable_id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category = 3) ELSE 0 END as retraiteEng, CASE WHEN audiens_prevoyance_payment_engaged = false AND audiens_prevoyance_payment_managed_by_culturepay = true THEN audiens_prevoyance_amount_cents + (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows WHERE cashflows.cash_ownerable_id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category = 4) ELSE 0 END as prevEng, CASE WHEN conges_spectacle_payment_engaged = false AND conges_spectacle_payment_managed_by_culturepay = true THEN conges_spectacle_amount_cents + (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows WHERE cashflows.cash_ownerable_id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category = 5) ELSE 0 END as ccsEng, CASE WHEN pole_emploi_payment_engaged = false AND pole_emploi_payment_managed_by_culturepay = true THEN pole_emploi_amount_cents + (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows WHERE cashflows.cash_ownerable_id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category = 6) ELSE 0 END as pesEng, ((SELECT CASE WHEN COUNT(cs.id) = 0 THEN 0 ELSE SUM(cs.amount_cents * (CASE WHEN cs.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows cs WHERE cs.cash_ownerable_id = transfer_codes.id AND cs.cash_ownerable_type = 'TransferCode') + (CASE WHEN urssaf_payment_engaged = true THEN - urssaf_amount_cents ELSE 0 END) + (CASE WHEN audiens_retraite_payment_engaged = true THEN - audiens_retraite_amount_cents ELSE 0 END) + (CASE WHEN audiens_prevoyance_payment_engaged = true THEN - audiens_prevoyance_amount_cents ELSE 0 END) + (CASE WHEN conges_spectacle_payment_engaged = true THEN - conges_spectacle_amount_cents ELSE 0 END) + (CASE WHEN pole_emploi_payment_engaged = true THEN - pole_emploi_amount_cents ELSE 0 END) - (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows INNER JOIN transfer_codes tc1 ON tc1.id = cashflows.cash_ownerable_id AND tc1.id = transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND ((cashflows.category = 2 AND tc1.urssaf_payment_engaged = true) OR (cashflows.category = 3 AND tc1.audiens_retraite_payment_engaged = true) OR (cashflows.category = 4 AND tc1.audiens_prevoyance_payment_engaged = true) OR (cashflows.category = 5 AND tc1.conges_spectacle_payment_engaged = true) OR (cashflows.category = 6 AND tc1.pole_emploi_payment_engaged = true))) + (CASE WHEN commission_payment_engaged = true THEN -other_commission_amount_cents +(SELECT CASE WHEN COUNT(contracts.id) = 0 THEN 0 ELSE SUM(-contracts.culturepay_commission_cents) END FROM contracts WHERE contracts.transfer_code_id = transfer_codes.id AND contracts.state >= 8 AND contracts.state <= 9) - (SELECT CASE WHEN COUNT(cashflows.id) = 0 THEN 0 ELSE SUM(cashflows.amount_cents * (CASE WHEN cashflows.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows INNER JOIN transfer_codes tc2 ON tc2.id = cashflows.cash_ownerable_id AND tc2.id = transfer_codes.id WHERE cashflows.cash_ownerable_id =transfer_codes.id AND cashflows.cash_ownerable_type = 'TransferCode' AND cashflows.category =10 AND tc2.commission_payment_engaged = true) ELSE 0 END) + (SELECT CASE WHEN COUNT(cs.id) = 0 THEN 0 ELSE SUM(cs.amount_cents * (CASE WHEN cs.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows cs INNER JOIN contracts c ON c.id = cs.cash_ownerable_id WHERE cs.cash_ownerable_type = 'Contract' AND c.transfer_code_id = transfer_codes.id) + (SELECT CASE WHEN COUNT(c.id) = 0 THEN 0 ELSE -SUM(c.definitive_to_be_paid_to_employee_amount_cents) END FROM contracts c WHERE c.transfer_code_id = transfer_codes.id AND c.payment_engaged = true) - (SELECT CASE WHEN COUNT(cs.id) = 0 THEN 0 ELSE SUM(cs.amount_cents * (CASE WHEN cs.accounting_category = 0 THEN -1 ELSE 1 END)) END FROM cashflows cs INNER JOIN contracts c ON c.id = cs.cash_ownerable_id WHERE cs.cash_ownerable_type = 'Contract' AND c.transfer_code_id = transfer_codes.id AND cs.category = 1)) as solde FROM transfer_codes INNER JOIN members m ON m.id = transfer_codes.member_id WHERE m.used_for_test = false AND closed = true AND first_summary_sent_at IS NOT NULL AND last_summary_sent_at IS NOT NULL AND NOT EXISTS( SELECT c.id FROM contracts c WHERE c.transfer_code_id = transfer_codes.id AND c.state >=8 AND c.state <= 9 AND c.payment_engaged = false AND c.pay_managed_by_culturepay = true AND c.definitive_to_be_paid_to_employee_amount_cents != 0 )) as selection WHERE (selection.urssEng <= selection.solde AND selection.urssEng > 0) OR (selection.retraiteEng <= selection.solde AND selection.retraiteEng > 0) OR (selection.prevEng <= selection.solde AND selection.prevEng > 0) OR (selection.ccsEng <= selection.solde AND selection.ccsEng > 0) OR (selection.pesEng <= selection.solde AND selection.pesEng >0 ))

anon79585656 · April 29, 2021, 9:26am

Thank you.

Do you still get a 414 error on this one? On my end I get a 401 error for both url encoded (8662 characters) and the one you pasted.

Guillaume · April 29, 2021, 9:30am

I confirm I’ve a 414 error on Mozilla, and a CORS error on Chrome

Topic		Replies	Views
Smart segment cannot reach data Help me!	9	400	January 18, 2021
Cannot reach my date Help me!	12	342	March 14, 2023
Cannot reach your data Help me!	51	3286	April 27, 2021
Max size for SQL request for segment? Help me!	3	641	May 28, 2020
Can't save changes in segments settings Help me!	12	556	July 17, 2020

"Cannot reach your data" error on segment

Related topics