Hi, we are using Apex 18.1 and within an application we use an Interactive Report.
We can download the report as CSV, HTML but when trying to open as PDF it fails with "Adobe Reader cound not open 'xxxx.pdf' because it is either not a supported file type or because the file has been damaged ...".
When I edit the pdf file (all contents below) I can see an error in the first line (underlined) which I'm guessing is the problem. The report only has 5 columns displayed.
Has anyone had this problem before and got a fix or can offer anything to try?
Thanks.
<div id="ShowView_data_panel" class="a-IRR-reportView"><div class="a-Form-error">ORA-06502: PL/SQL: numeric or value error: character string buffer too small
</div></div>
</div>
</div>
</div>
</div>
</div>
<footer class="t-Footer">
<div class="t-Footer-body">
<div class="t-Footer-content"></div>
<div class="t-Footer-apex">
<div class="t-Footer-version">Release 1.0</div>
<div class="t-Footer-customize"></div>
</div>
</div>
<div class="t-Footer-top">
<a href="#top" class="t-Footer-topButton" id="t_Footer_topButton"><span class="a-Icon icon-up-chevron"></span></a>
</div>
</footer>
</div>
</div>
</div>
<div class="t-Body-inlineDialogs">
</div><input type="hidden" id="pPageItemsRowVersion" value="" /><input type="hidden" id="pPageItemsProtected" value="OUjxdl03qiooxE8RP76t2g3KOV4fHc0TRSJHbhYp_n-b5-cSTxlUHmSa5pps6SKRHMHjFI2kI9kgwSKFB7VdmLIQJjc_G68omtrryFfMzYGLl3o-03ly0ZZtuL3-sA9-QqKNCLLSVABasbMG9UhegZYMGFx-PMhjbTKIBOX3Qd3XZ6JOCfM99smMoCN34805DtZYgNhSVOSKi6rztg4nqPYhHPUUZz4CD6pXpZc5Y9kwnHHTKZap2k5wT2q29iyyelVQazgQzxjJ9buJxN36ida_Nv2Ecb5kUY8EtAJZEByUlIb7ms_ybqTnh4V2jkSIRVNTdH2xR7JKp9Z2-mhXcTNqI4f8hMdtiG-MMfQu6mrB9YzCO3K0_ATuFDzj9pggU_BHuABCbLxQ7i6-qdADInsjYnsKbsv2LkDRkrI7KNa0B41xLkvtQ0jEyvS7Ai2PLq8j2dwsBlqeqw9YK75ipDol6ar3XiR_vvt9mH1m9C7xGthAIy-dff5QlG0GrH92v1z-4eh1xZNwhTJV_3rgIUnQOdw_BgJuWvRSLXp8TowYxwEmMXv504Zbeppln67RsdY-R6DdBXrUCvGgWI5YpF7LIoQYwG9PWOdYCaXswC6eZBZoELFiB4lqftGlq4pnEYpkpEnKLWHiU0atSIhiuyzMnA-sJD9FS05TktLF6HrfmvQKkPefFPMG83ETdcjitJY2jpxSF1XLNSAXlWTl4_ifQhPksmkx8Phq2HS_WRjDeTvckntiXb7t7qa6lyJTSBkWS56TBvKkzFcbgrmNrWzCC1qO0S5z18nl1wPvntwd4RLydOUXIF-cEdc1U9h4KluHIm3-e7WtedBBjUfT0O5Nk78g3KcEotSuh_JvtwjGuXamDrPiT792FMmbXNRDWcag1Tju_Z31hGHHEeYLuMo5Uc8VA-S7NkLwdu7eAu7qWvUmG8Si2y7gYzVnG9wp0Bgm9BlRjcuISGEPmKiU1QsTjE3kDVwi3attRcRtyTNOCdPl8mEDowkX7flti06zqrvY3WS8xj6E2zEpo_-os8gTm51EdM8-pm45PpqlAuG1gr-Mk2YDd93sBbSF4H76cRZ873pVJTdTNopGHaw2nnilyIdlonyf3mDfpg1uwcOduEEdiWhUReZvgY9Xv-VUsuC5m-6xQBRWca7d-SrQYST13bdAfaGpEk1R1U9L5oV1M1zFgw25LR797bxOUM-WlSDcPcm_-SHOIQtTJmz3FZn1-y9exYE2VukpTIffKN8LVS_kmh8QM3MAd8SuMFlXO6rFHL6tF5XquWGLInfuBapgngpYDE2710wLBXZchMMi7fY7VmITr9qm52Hrkw3Um19ZO-L-7Jpu5Q6KlUnchqrljroz9AxAde7ZnY2FDyxtQl4VY0JKSOnilY-oQR0jCVFHcrha2KK0FRYZMjDI-OQoPNNZo4y4iwMUVr52xxAChzgROK9Kv91rOLt9ZdvIPlsk9gBzbEKfUxbRkoKAPL2P6xX0M8UDW9gd20YebL-DEeQhflce_kIX0u7mDYqwIaPhF-_thSkLD4B5uanDX5Awq741r7ujBg7szDX4foEji0WGnoOF0F1CAdd6r4Kg8e-csz_VQWZbdIlp6lk5YVUB7-_HiCeY739iFtClssNcB9mZpjYDltWAq7xj6oRb8azkku6AVgIrLsLP-HBp5UX476gGpP4P5n3s96CPgxk_olBuQwvRyZlDQIjOxLaBfPyGcHVb-9M3V8wQTdoZJJusgRxI_PbBzmWBBfy7VN-gOmYqwcEjSat9DqqZrpGx7xC9QIeM78E5vuoD0IGJmQ" /></form>
<script>
var apex_img_dir = "/i/", htmldb_Img_Dir = apex_img_dir;
</script>
<script src="/i/libraries/apex/minified/desktop_all.min.js?v=18.1.0.00.45"></script>
<script src="wwv_flow.js_messages?p_app_id=100&p_lang=en&p_version=18.1.0.00.45-2170751164582"></script>
<script src="/i/libraries/apex/minified/legacy_pre18.min.js?v=18.1.0.00.45"></script>
<script src="/i/libraries/apex/minified/legacy_18.min.js?v=18.1.0.00.45"></script>
<script src="/i/libraries/jquery-migrate/3.0.0/jquery-migrate-3.0.0.min.js?v=18.1.0.00.45"></script>
<script type="text/javascript">
apex.da.initDaEventList = function(){
apex.da.gEventList = [
{"triggeringElementType":"BUTTON","triggeringButtonId":"B1700549664090543","bindType":"bind","bindEventType":"click","anyActionsFireOnInit":false,actionList:[{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":true,"waitForResult":true,javascriptFunction:apex.da.executePlSqlCode,"ajaxIdentifier":"oYIIYrpEbXwxYsox0oMyyQrbyCgs2Oo4-q9yQLCqKu4","attribute01":"#P2_VIEW_NUMBER","attribute02":"#P2_SQL","attribute04":"N","action":"NATIVE_EXECUTE_PLSQL_CODE"},{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":true,"waitForResult":true,javascriptFunction:apex.da.executePlSqlCode,"ajaxIdentifier":"936phK28dzGdCv_4h30DyrF4KgyQcu_qp-VBH4PEoMA","attribute01":"#P2_VIEW_NUMBER","attribute04":"N","action":"NATIVE_EXECUTE_PLSQL_CODE"},{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":true,"affectedElementsType":"REGION","affectedRegionId":"ShowView",javascriptFunction:apex.da.refresh,"action":"NATIVE_REFRESH"}]}];
}
</script>
<script src="/i/libraries/apex/minified/widget.stickyWidget.min.js?v=18.1.0.00.45"></script>
<script src="/i/themes/theme_42/1.2/js/theme42.min.js?v=18.1.0.00.45"></script>
<script src="/i/libraries/oraclejet/4.2.0/js/libs/require/require.js?v=18.1.0.00.45"></script>
<script>
define("jquery",[],function(){return apex.jQuery});
define("hammerjs",[],function(){return Hammer});
define("jqueryui-amd/widget",[],function(){return apex.jQuery.widget});
define("jqueryui-amd/focusable",[],function(){return apex.jQuery.ui.focusable});
define("jqueryui-amd/position",[],function(){return apex.jQuery.ui.position});
define("jqueryui-amd/keycode",[],function(){return apex.jQuery.ui.keyCode});
define("jqueryui-amd/tabbable",[],function(){return { tabbable: function(){ apex.debug.info("Unexpected call: jQuery UI tabbable function"); }}});
define("jqueryui-amd/unique-id",[],function(){return apex.jQuery.fn});
</script>
<script src="/i/libraries/apex/minified/requirejs.jetConfig.min.js?v=18.1.0.00.45"></script>
<script src="/i/libraries/apex/minified/jetCommonBundle.min.js?v=18.1.0.00.45"></script>
<script src="/i/libraries/apex/minified/chartBundle.min.js?v=18.1.0.00.45"></script>
<script type="text/javascript">
apex.jQuery( function() {
apex.page.init( this, function() {
apex.jQuery.when.apply( apex.jQuery, apex.page.loadingDeferreds ).done(function() {
try {
(function(){apex.da.initDaEventList();})();
(function(){apex.da.init();})();
apex.theme42.initializePage.noSideCol();
apex.page.warnOnUnsavedChanges();
} finally {
apex.event.trigger(apex.gPageContext$,'apexreadyend');
}
});
});
});</script>
</body>
</html>