IBM Support

Web Query - Scheduler issues after upgrading from prior releases

Troubleshooting


Problem

After upgrading to IBM DB2 Web Query for i V2R2M0 customers might encounter issues with their old schedules. Upon a open attempt of a schedule in Web Query they may hit an error stating "Error loading the schedule: "undefined( 500 - Application Server Error..." </p> </div> <div class="clearfix text-formatted field field--name-field-symptom field--type-text-long field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Symptom</h2> <p class="ibm-northstart-documentation-information-data">Upon a open attempt in Web Query they may hit an error stating <p></p> <p>"<b>Error loading the schedule: </b><b>undefined(<!DOCTYPE html> <HTML> <HEAD> <title>500 - Application Server Error..."</b></p> <p></p> <p>Here is a screen shot</p> <p></p> <br> <img src="/support/pages/system/files/support/nas/nastech.nsf/0/08f88ded2802aa0f852580dd006a8722/Symptom/0.208.gif" width="252" height="380" loading="lazy"><br> <br> <br> Even if a new schedule is created on any existing reports or newly created ones the similar error is received when they try to schedule it:<br> <br> <b>"Failed to retrieve the properties of the report... "</b><br> <br> <img src="/support/pages/system/files/support/nas/nastech.nsf/0/08f88ded2802aa0f852580dd006a8722/Symptom/0.AB36.gif" width="252" height="115" loading="lazy"><br> <br> <br> <br> <b>Note:</b> <br> All ports will be active, <br> Web Query starts fine and they are able to log in and out of the BI portal, <br> Health Checker will be clean,<br> There are no indications why this might be happening in the event.log.</p> </div> <div class="clearfix text-formatted field field--name-field-cause field--type-text-long field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Cause</h2> <p class="ibm-northstart-documentation-information-data">Some old files might be cached after upgrading</p> </div> <div class="clearfix text-formatted field field--name-field-environment field--type-text-long field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Environment</h2> <p class="ibm-northstart-documentation-information-data">Web Query 2.2.0 (after upgrading to WebQuery 2.2.0 from a previous release) <p>BI Portal (i.e. the 12331 URL)</p> </p> </div> <div class="clearfix text-formatted field field--name-field-diagnosis field--type-text-long field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Diagnosing The Problem</h2> <p class="ibm-northstart-documentation-information-data">Errors in Web Query while they attempt to open a schedule</p> </div> <div class="clearfix text-formatted field field--name-field-resolution field--type-text-long field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Resolving The Problem</h2> <p class="ibm-northstart-documentation-information-data">Although is seems unrelated this can be fixed if you simply <b><u>clears their browser cache</u></b><br /> <br /> - the reason this happens is that some old files might be cached after upgrading. <br /> This has a very high success rate so far. <br /> <br /> If they test it with Developer WorkBench it will work fine - they will be able to open the scheduler and/or edit, this might be used as a <b><u>circumvention</u></b> if clearing the browser cache does not work </p> </div> <div id="field-download-package-title"></div> <p></p> <p></p> <div id="taxonomy-table-list"></div> <div class="field--taxonomy" id="taxonomy-source"> [{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Web Query","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}] </div> </div> </div> </div> </div> </div> <div class="bx--col-md-2 bx--col-lg-4"> <div id="ibm-document-information" class="ibm-card"> <div class="ibm-card__content"> <div class="like_dislike"> <div class="field field--name-field-was-this-topic-helpful field--type-voting-api-field field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">Was this topic helpful?</h2> <p class="ibm-northstart-documentation-information-data"><div class="votingapi-widgets useful"><form class="node-troubleshooting-667933-vote-field-was-this-topic-helpful__vote-vote-votingapi-useful-form vote-form" id="vote-form" data-drupal-selector="node-troubleshooting-667933-vote-field-was-this-topic-helpful-vote-vote-votingapi-useful-form" action="/support/pages/web-query-scheduler-issues-after-upgrading-prior-releases" method="post" accept-charset="UTF-8"> <div class="js-form-item form-item js-form-type-select form-type-select js-form-item-value form-item-value form-no-label"> <select autocomplete="off" data-result-value="-1" data-vote-value="-1" data-style="default" data-show-own-vote="false" data-drupal-selector="edit-value" id="edit-value" name="value" class="form-select select2-widget" data-jquery-once-autocomplete="true" data-select2-autocomplete-list-widget="true" search-pagesize="10"><option value="-1">Not useful</option><option value="1">Useful</option></select> </div> <input autocomplete="off" data-drupal-selector="form-tzwmq6t1zmv6pawpsqvlj9avib2n3vbwinxk4tsbqbi" type="hidden" name="form_build_id" value="form-TZwMQ6t1zMV6PAWPsqvLj9aviB2N3VBWinXK4tSBqbI" /> <input data-drupal-selector="edit-node-troubleshooting-667933-vote-field-was-this-topic-helpful-vote-vote-votingapi-useful-form" type="hidden" name="form_id" value="node_troubleshooting_667933_vote_field_was_this_topic_helpful__vote_vote_votingapi_useful_form" /> <input data-drupal-selector="edit-submit" type="submit" id="edit-submit--2" name="op" value="Save" class="button button--primary js-form-submit form-submit" /> </form> </div> </p> </div> </div> <h3 class="ibm-h4 ibm-northstart-documentation-information-title">Document Information</h3> <div id="taxonomy-items"> </div> <p> <strong>Modified date:</strong> <br> 18 December 2019 </p> <div class='content-field_uid'> <div class="field field--name-field-uid field--type-string field--label-above"> <h2 class="ibm-h4 ibm-bold ibm-northstart-documentation-information-label">UID</h2> <p class="ibm-northstart-documentation-information-data">nas8N1021893</p> </div> </div> </div> </div> </div> </div> </div> </div> </article> </div> </div><div id="block-pagefeedbackmodal" class="bx--row block block-feedback block-page-feedback-modal"> <div class="content bx--offset-lg-2 bx--col-lg-14"> <p><a id="ibm-drupal-feedback" class="button button-action button--primary button--small use-ajax" data-dialog-options="{"width":670,"dialogClass": "modal-container"}" data-dialog-type="modal" href="javascript:void(0);">Page Feedback</a></p> </div> </div> </div> </div> </div> </div> </div> </div> </main> <div id="ibm-contact-module" class="drupal-feedback"> <h2 class="ibm-bold">Share your feedback</h2> <h3 class="ibm-bold">Need support?</h3> <ul class="ibm-live-assistance-list"> <li><a class="ibm-requestquote-link" href="javascript:void(0)">Submit feedback to IBM Support</a></li> <li><p class="ibm-icon-nolink ibm-phone-link">1-800-IBM-7378 (<strong>USA</strong>)</p></li> <li><a class="ibm-arrow-forward-link" href="//www.ibm.com/planetwide/index.html#region">Directory of worldwide contacts</a></li> </ul> </div> <dds-footer-container size="micro"></dds-footer-container> </div> </div> </div> <script src="/support/pages/core/assets/vendor/once/once.min.js?v=1.0.1"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/version-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/data-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/disable-selection-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/jquery-patch-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/scroll-parent-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/unique-id-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/focusable-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/keycode-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/plugin-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widget-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/labels-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/controlgroup-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/form-reset-mixin-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/mouse-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/checkboxradio-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/draggable-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/resizable-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/button-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/jquery.ui/ui/widgets/dialog-min.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/tabbable/index.umd.min.js?v=6.2.0"></script> <script src="/support/pages/core/assets/vendor/tua-body-scroll-lock/tua-bsl.umd.min.js?v=10.4.7"></script> <script src="/support/pages/core/misc/jquery.form.js?v=4.3.0"></script> <script src="/support/pages/modules/custom/entitlement_broker/js/entitlement_broker.js?v=1.x"></script> <script src="/support/pages/core/misc/progress.js?v=10.4.7"></script> <script src="/support/pages/core/assets/vendor/loadjs/loadjs.min.js?v=4.3.0"></script> <script src="/support/pages/core/misc/debounce.js?v=10.4.7"></script> <script src="/support/pages/core/misc/announce.js?v=10.4.7"></script> <script src="/support/pages/core/misc/message.js?v=10.4.7"></script> <script src="/support/pages/core/misc/ajax.js?v=10.4.7"></script> <script src="/support/pages/themes/contrib/stable/js/ajax.js?v=10.4.7"></script> <script src="/support/pages/core/misc/displace.js?v=10.4.7"></script> <script src="/support/pages/core/misc/jquery.tabbable.shim.js?v=10.4.7"></script> <script src="/support/pages/core/misc/position.js?v=10.4.7"></script> <script src="/support/pages/core/misc/dialog/dialog-deprecation.js?v=10.4.7"></script> <script src="/support/pages/core/misc/dialog/dialog.js?v=10.4.7"></script> <script src="/support/pages/core/misc/dialog/dialog.position.js?v=10.4.7"></script> <script src="/support/pages/core/misc/dialog/dialog.jquery-ui.js?v=10.4.7"></script> <script src="/support/pages/core/modules/ckeditor5/js/ckeditor5.dialog.fix.js?v=10.4.7"></script> <script src="/support/pages/core/misc/dialog/dialog.ajax.js?v=10.4.7"></script> <script src="/support/pages/modules/custom/feedback/js/feedback.js?v=10.4.7"></script> <script src="/support/pages/modules/custom/ibm_nps_feedback/js/ibm_nps_feedback.js?v=10.4.7"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.full.min.js"></script> <script src="/support/pages/modules/custom/select2boxes/js/select2boxes.js?v=4.0.5"></script> <script src="/support/pages/modules/custom/support_search/js/support_search.js?v=10.4.7"></script> <script src="/support/pages/modules/custom/votingapi_widgets/js/useful.js?v=1.2"></script> <link rel="stylesheet" type="text/css" href="/raa_Wr/dcBzPa/k/VAA/pBqffpoh/Xfm39b/dGZ5IS4B/bxBd/H3p9SilX"><script src="/raa_Wr/dcBzPa/k/VAA/pBqffpoh/Xfm39b/dGZ5IS4B/JFN1/LBw9EyMp" async defer></script><div id="sec-overlay" style="display:none;"><div id="sec-container"></div></div></body> </html>