Ignore the below info: this is debug info for ESCH. Continue with the green info

QueryID: 34
SQL: SELECT count(*) as cnt FROM vw_portal_MPDB_Pane1_SaaS_611
Count: 26
SQL with filter: SELECT count(*) as cnt FROM vw_portal_MPDB_Pane1_SaaS_611 WHERE (1=1) AND (1=1) AND (1=1) AND (1=1)
Count with filter: 26
SQL with filter & forcing=false: SELECT * FROM vw_portal_MPDB_Pane1_SaaS_611 WHERE (1=1) AND (1=1) AND (1=1) AND (1=1) order by createdRaw desc


Sometimes the dashboard crashes because Jira tickets contain illegal characters, that corrupt the data which is retrieved from the database.
For performance reasons, the HTML code is prefetched and then injected into the dashboard page. If an unexpected character coming from one of the Jira fields corrupts the HTML code, the dashboard crashes because the webpage can't render correctly.

HOW TO FIX THIS PROBLEM?
Check in the next raw data lines if you can find characters that were not correctly rendered (eg. ) or other non standard characters (eg. microsoft special quotes.
In most cases the illegal characters are part of the ticket title or description field.

In case you find them:
1. Check the BX Jira ticket and replace/remove them.
2. Wait about 3 minutes, which is the time needed to refresh the database (You can also refresh this page to see if the refresh has meanwhile happened)
3. Retry the dashboard screen.


Line 01 => 1P321/10/26 13:44RFIAX-187812BX-208969  Client can't log in via Itsme to NeonKBC SecuritieseXimius  KBC Securities.eXimi...Info Requested
Line 02 => 2P316/10/26 09:12BugInternBX-208691  Process Execution History LogKBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 03 => 3P315/10/26 11:26BugInternBX-208641  FE UI admin Fix Messages filter on time as...KBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 04 => 4P314/10/26 16:40BugInternBX-208597  eXimiusManagementService stays on 'Stoppin...KBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 05 => 5P313/10/26 10:07RFIAX-187363BX-208460  Big difference in YtD performance between ...Beaumont CapitaleXimius  Beaumont Capital.eXi...Info Requested
Line 06 => 6P317/09/26 08:47RFSInternBX-207191  BdL_concatenated_par_values no longer upda...FinfactoreXimius  Steven Van WalleAssess 2nd Line
Line 07 => 7P302/09/26 16:31RFSInternBX-206631  Client report : portfolio with first trans...KBC SecuritieseXimius  Hilde van WezemaelAssess 2nd Line
Line 08 => 8P319/08/26 10:46BugInternBX-205937  Remove BDPL files from overnight TODOLogivereXimius  Steven Van WalleAssess 2nd Line
Line 09 => 9P305/08/26 15:41RFSInternBX-205427  TODO - BCEE: redemption bonds not booked a...LogivereXimius  Hilde van WezemaelAssess 2nd Line
Line 10 => 10P304/08/26 14:10RFIAX-184609BX-205361  Vulnerability assessmentsEconopoliseXimius  Hilde van WezemaelInfo Requested
Line 11 => 11P302/07/26 10:17RFSInternBX-203975  Recon differencesLogivereXimius  Hilde van WezemaelInfo Requested
Line 12 => 12P322/06/26 15:37BugInternBX-203558  TODO Config FundSync batchFinfactoreXimius  Eline Van OostAssess 2nd Line
Line 13 => 13P304/06/26 14:54BugInternBX-202720  TODO Supression free user Providence - Ac...Providence CapitaleXimius  Eline Van OostAssess 2nd Line
Line 14 => 14P317/06/25 10:31RFIAX-169728BX-188019  Ask for info - Foreign Withholding TaxKBC SecuritieseXimius  KBC Securities.eXimi...Info Requested
Line 15 => 15P315/05/25 11:26BugInternBX-186793  TODO Transform .NET graphs to Crystal Repo...FinfactoreXimius  David EerdekensOn Hold
Line 16 => 16P316/01/25 11:27RFSAX-164509BX-181315  Implementation - fee management + reportFinfactoreXimius  Eline Van OostInfo Requested
Line 17 => 17P313/01/25 14:55RFSAX-164371BX-181155  Q reporting - Changes to salutationBeaumont CapitaleXimius  Eline Van OostInfo Requested
Line 18 => 18P319/12/24 14:34BugInternBX-180213  TODO - Errors and Warnings generation Repo...EconopoliseXimius  David EerdekensAssess 2nd Line
Line 19 => 19P319/12/24 13:54BugInternBX-180209  TODO - Errors and Warnings generation Repo...Providence CapitaleXimius  David EerdekensAssess 2nd Line
Line 20 => 20P319/12/24 13:22BugInternBX-180206  TODO - Errors and Warnings generation Repo...Partners2UeXimius  David EerdekensAssess 2nd Line
Line 21 => 21P318/10/24 05:22BugAX-161402BX-177292  Wrong benchmark valuesPartners2UeXimius  Partners2U.eXimiusInfo Requested
Line 22 => 22P314/10/24 17:57BugInternBX-177082  Transactions with date before or equal to ...Providence CapitaleXimius  rd.eximiusAssess 3rd Line
Line 23 => 23P313/09/24 12:49BugAX-159922BX-175473  Sharpe ratioPartners2UeXimius  David EerdekensInfo Requested
Line 24 => 24P302/09/24 19:45BugInternBX-174954  Econopolis report : logged errors TODOEconopoliseXimius  David EerdekensAssess 2nd Line
Line 25 => 25P302/08/24 10:10BugInternBX-173511  046 - creation missing products during ove...EconopoliseXimius  Steven Van WalleAssess 2nd Line
Line 26 => 26P323/02/22 16:34BugInternBX-135686  Possibility of fixed views on transactionsEconopoliseXimius  rd.eximiusAssess 3rd Line