1 Reply Latest reply on Apr 30, 2018 12:34 PM by Carisa Chang

    Internal server error datasourceException

    a a

      connect oracle database, when I publish workbook,error is following,image001(04-28-09-24-20).png

       

       

      desktop log is following :

       

      {"ts":"2018-04-27T18:03:03.344","pid":2612,"tid":"7dc","sev":"warn","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"AUTOUPDATE: AutoUpdate not allowed when running trial builds."}

      {"ts":"2018-04-27T18:03:06.760","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabui:publish-workbook-to-workgroup","name":"tabui:publish-workbook-to-workgroup"}}

      {"ts":"2018-04-27T18:03:06.838","pid":2612,"tid":"a50","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"Autosave beginning"}

      {"ts":"2018-04-27T18:03:06.901","pid":2612,"tid":"a50","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"Autosave ended"}

      {"ts":"2018-04-27T18:03:39.773","pid":2612,"tid":"92c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-load","v":{"cns":"AbstractQueryHistoryV3Z","elapsed-ms":"0","key-hash":"3049642366","key-size-b":"172","outcome":"miss"}}

      {"ts":"2018-04-27T18:03:39.773","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-trydownload-done","v":{"candidateQueries":"0","dataSources":"1","downloadedQueries":"0"}}

      {"ts":"2018-04-27T18:03:39.773","pid":2612,"tid":"a18","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-load","v":{"cns":"AbstractQueryHistoryV3Z","elapsed-ms":"0","key-hash":"3049642366","key-size-b":"172","outcome":"miss"}}

      {"ts":"2018-04-27T18:03:39.773","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-trydownload-done","v":{"candidateQueries":"0","dataSources":"1","downloadedQueries":"0"}}

      {"ts":"2018-04-27T18:03:39.867","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:03:39.867","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-post","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:03:39.867","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:03:39.867","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-post","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-info","v":"Received for processing a query batch of 1 queries."}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"a50","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-info","v":"Starting parallel processing of query jobs."}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"a50","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-optimize-fusions","v":{"fusion-count":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"a50","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-optimize-dependencies","v":{"dependency-count":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"b6c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-query-begin","v":{"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-id":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"b6c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"get-cached-query","v":{"class":"dataengine","kind":"abstract","mem-outcome":"hit"}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"b6c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-query-end","v":{"cache-hit":"abstract","elapsed":0.001,"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-id":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-batch-summary","v":{"elapsed":0.003,"elapsed-compute-keys":0,"elapsed-sum":0.001,"job-count":1,"jobs":[{"cache-hit":"abstract","elapsed":0.001,"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-abstract":"<query aggregation='true' caching='normal' hierarchize-rows='false' include-empty='false'>\n  <fields>\n    <field column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[yr:BUDAT:ok]' />\n    <output column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[sum:Number of Records:qk]' />\n    <output column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[yr:BUDAT:ok]' />\n  </fields>\n</query>\n","query-id":0}]}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-data-interpreter","v":{}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-data-interpreter","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-partition-interpreter","v":{}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-partition-interpreter","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-x-set-interp","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-x-axis-descriptor","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-y-set-interp","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-y-axis-descriptor","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"partition-data","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"sort-panes","v":{"elapsed":0.001}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-visual-model-producer","v":{}}

      {"ts":"2018-04-27T18:03:39.882","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"vmp-generate-axis-encodings","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:03:39.905","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-visual-model-producer","v":{"elapsed":0.01}}

      {"ts":"2018-04-27T18:03:39.924","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"render-pipeline: BeginScene using Qt"}

      {"ts":"2018-04-27T18:03:47.251","pid":2612,"tid":"7dc","sev":"warn","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"AUTOUPDATE: AutoUpdate not allowed when running trial builds."}

      {"ts":"2018-04-27T18:18:36.085","pid":2612,"tid":"7dc","sev":"warn","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"AUTOUPDATE: AutoUpdate not allowed when running trial builds."}

      {"ts":"2018-04-27T18:18:45.664","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabui:publish-workbook-to-workgroup","name":"tabui:publish-workbook-to-workgroup"}}

      {"ts":"2018-04-27T18:19:17.366","pid":2612,"tid":"92c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-load","v":{"cns":"AbstractQueryHistoryV3Z","elapsed-ms":"0","key-hash":"3049642366","key-size-b":"172","outcome":"miss"}}

      {"ts":"2018-04-27T18:19:17.366","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-trydownload-done","v":{"candidateQueries":"0","dataSources":"1","downloadedQueries":"0"}}

      {"ts":"2018-04-27T18:19:17.382","pid":2612,"tid":"22c","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-load","v":{"cns":"AbstractQueryHistoryV3Z","elapsed-ms":"0","key-hash":"3049642366","key-size-b":"172","outcome":"miss"}}

      {"ts":"2018-04-27T18:19:17.382","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"ec-trydownload-done","v":{"candidateQueries":"0","dataSources":"1","downloadedQueries":"0"}}

      {"ts":"2018-04-27T18:19:17.475","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:19:17.475","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-post","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:19:17.475","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-pre","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:19:17.475","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"command-post","v":{"args":"tabdoc:get-marks-color-uber-effects pane-spec=\"0\" worksheet=\"BSEG_WE_test\"","name":"tabdoc:get-marks-color-uber-effects"}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-info","v":"Received for processing a query batch of 1 queries."}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"a18","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-info","v":"Starting parallel processing of query jobs."}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"a18","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-optimize-fusions","v":{"fusion-count":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"a18","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-optimize-dependencies","v":{"dependency-count":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"360","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-query-begin","v":{"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-id":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"360","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"get-cached-query","v":{"class":"dataengine","kind":"abstract","mem-outcome":"hit"}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"360","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-query-end","v":{"cache-hit":"abstract","elapsed":0.002,"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-id":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"qp-batch-summary","v":{"elapsed":0.004,"elapsed-compute-keys":0.001,"elapsed-sum":0.002,"job-count":1,"jobs":[{"cache-hit":"abstract","elapsed":0.002,"owner-component":"DataInterpreter","owner-dashboard":"","owner-worksheet":"","query-abstract":"<query aggregation='true' caching='normal' hierarchize-rows='false' include-empty='false'>\n  <fields>\n    <field column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[yr:BUDAT:ok]' />\n    <output column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[sum:Number of Records:qk]' />\n    <output column='[federated.07u9zub07lamso11wa1nl1v4k8wv].[yr:BUDAT:ok]' />\n  </fields>\n</query>\n","query-id":0}]}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-data-interpreter","v":{}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-data-interpreter","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-partition-interpreter","v":{}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-partition-interpreter","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-x-set-interp","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-x-axis-descriptor","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-y-set-interp","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"compute-y-axis-descriptor","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"partition-data","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"sort-panes","v":{"elapsed":0.001}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"begin-visual-model-producer","v":{}}

      {"ts":"2018-04-27T18:19:17.491","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"vmp-generate-axis-encodings","v":{"elapsed":0}}

      {"ts":"2018-04-27T18:19:17.517","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"end-visual-model-producer","v":{"elapsed":0.012}}

      {"ts":"2018-04-27T18:19:17.532","pid":2612,"tid":"7dc","sev":"info","req":"-","sess":"-","site":"{7C57F50E-D85F-43C4-A43E-C4A377D6B534}","user":"-","k":"msg","v":"render-pipeline: BeginScene using Qt"}