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

QueryID: 11
SQL: SELECT count(*) as cnt FROM vw_portal_MPDB_Pane1_KBC
Count: 19

SQL with filter: SELECT count(*) as cnt FROM vw_portal_MPDB_Pane1_KBC WHERE (1=1) AND (1=1) AND (1=1) AND (1=1)
Count with filter: 19

SQL with filter & forcing=false: SELECT * FROM vw_portal_MPDB_Pane1_KBC 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 => 2P320/10/26 16:14RFSAX-187761BX-208915  book adjustment cost in NeonKBC SecuritieseXimius  KBC Securities.eXimi...Released
Line 03 => 3P319/10/26 13:58BugAX-187689BX-208841  WM is not able to finish digital onboardin...KBC SecuritieseXimius  onboarding.supportAssess 2nd Line
Line 04 => 4P316/10/26 14:57BugAX-187630BX-208746  Mismatch in costs in NeonKBC SecuritieseXimius  David EerdekensReleased
Line 05 => 5P316/10/26 09:50RFSAX-187578BX-208693  Reset Azure userKBC SecuritieseXimius  Steven Van WalleReleased
Line 06 => 6P316/10/26 09:12BugInternBX-208691  Process Execution History LogKBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 07 => 7P315/10/26 11:26BugInternBX-208641  FE UI admin Fix Messages filter on time as...KBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 08 => 8P315/10/26 09:50RFSAX-187520BX-208629  New Azure user - Digital Onboarding - KBC ...KBC SecuritieseXimius  Steven Van WalleReleased
Line 09 => 9P314/10/26 16:40BugInternBX-208597  eXimiusManagementService stays on 'Stoppin...KBC SecuritieseXimius  rd.eximiusAssess 3rd Line
Line 10 => 10P313/10/26 16:18RFSAX-187413BX-208513  Integration errors - TransactionsKBC SecuritieseXimius  Steven Van WalleReleased
Line 11 => 11P305/10/26 10:18RFSAX-186985BX-208050  Query for all the potential receiver of a ...KBC SecuritieseXimius  Steven Van WalleAssess 2nd Line
Line 12 => 12P325/09/26 08:55RFSAX-186594BX-207606  KBC employees with onboarding roleKBC SecuritieseXimius  Steven Van WalleReleased
Line 13 => 13P307/09/26 08:17BugAX-185812BX-206763  Medium Vulnerability - Lodash Prototype Po...KBC SecuritieseXimius  onboarding.supportOn Hold
Line 14 => 14P302/09/26 16:31RFSInternBX-206631  Client report : portfolio with first trans...KBC SecuritieseXimius  Hilde van WezemaelAssess 2nd Line
Line 15 => 15P305/03/26 15:39BugInternBX-199059  UDF on Party does not give the correct val...KBC SecuritieseXimius  Hilde van WezemaelAssess 2nd Line
Line 16 => 16P318/02/26 09:27RFSAX-178481BX-198222  report all-in fee indicatorKBC SecuritiesOther  Eline Van OostReleased
Line 17 => 17P317/06/25 10:31RFIAX-169728BX-188019  Ask for info - Foreign Withholding TaxKBC SecuritieseXimius  KBC Securities.eXimi...Info Requested
Line 18 => 18P328/10/21 16:34RFEInternBX-133017  Ui Lite : Position - details/ transactions...KBC SecuritieseXimius  finfactor.eXimiusOn Hold
Line 19 => 19P307/11/19 08:58RFEInternBX-116985  KBC Investor Portal Digital InboxKBC SecuritieseXimius  Change Manager eXimi...Assess 2nd Line