Hi,
Just installed APEX 21.1 on oracle 19.4 (which had very old, unused apex ) and also new ORDS.
I've create a very simple interactive grid with: select 'literal hebrew' from dual.
The report run fine to screen and to csv/html, but whne downloading to pdf I get ORA-1403 No Data Found
I've tried both varchar2 and nvarchar2 datatypes - both single byte and unicode.
Any Idea what might be the problem ? It is not one of the 'known issues' published.
Thanks,
Hadar
-----------------------------------------------------
Technical Info (only visible for developers)
1. is_internal_error: true
2. apex_error_code: APEX.REGION.UNHANDLED_ERROR
3. ora_sqlcode: 100
4. ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1988 ORA-06512: at "APEX_210100.WWV_FLOW_PDF_FONT", line 6400 ORA-06512: at "APEX_210100.WWV_FLOW_PDF", line 3897 ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT_PDF", line 587 ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1067 ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1220 ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1982
5. component.type: APEX_APPLICATION_PAGE_REGIONS
6. component.id: 1757086381887632
7. component.name: Environment
8. error_backtrace:
9. ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1988
10. ORA-06512: at "APEX_210100.WWV_FLOW_PDF_FONT", line 6400
11. ORA-06512: at "APEX_210100.WWV_FLOW_PDF", line 3897
12. ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT_PDF", line 587
13. ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1067
14. ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1220
15. ORA-06512: at "APEX_210100.WWV_FLOW_DATA_EXPORT", line 1982
ORA-06512: at "APEX_210100.WWV_FLOW_IR_RENDER", line 12534
------------------------------
The pdf font table seem to be ok:
select *
from APEX_210100.WWV_FLOW_PDF_FONTS
;
ID IS_STANDARD FONT_NAME FAMILY_NAME FONT_STYLE FONT_WEIGHT LINE_HEIGHT FALLBACK_PRIORITY FONT_FILE
1 Y Courier-Bold Courier normal bold 1.051
2 Y Courier-BoldOblique Courier italic bold 1.051
3 Y Courier-Oblique Courier italic normal 1.055
4 Y Courier Courier normal normal 1.055
5 Y Helvetica-Bold Helvetica normal bold 1.19
6 Y Helvetica-BoldOblique Helvetica italic bold 1.19
7 Y Helvetica Helvetica normal normal 1.156
8 Y Symbol Symbol normal normal 1.303
9 Y Times-Bold Times normal bold 1.153
10 Y Times-BoldItalic Times italic bold 1.139
11 Y Times-Italic Times italic normal 1.1
12 Y Times-Roman Times normal normal 1.116
13 Y ZapfDingbats ZapfDingbats normal normal 0.963
15 N OracleSans-Regular Oracle Sans normal normal 1 (BLOB)
16 N OracleSans-Bold Oracle Sans normal bold 1 (BLOB)
17 N NotoSansJP-Regular Noto Sans JP normal normal 2 (BLOB)
18 N NotoSansJP-Bold Noto Sans JP normal bold 2 (BLOB)
19 N NotoSansKR-Regular Noto Sans KR normal normal 2 (BLOB)
20 N NotoSansKR-Bold Noto Sans KR normal bold 2 (BLOB)
21 N NotoSansSC-Regular Noto Sans SC normal normal 2 (BLOB)
22 N NotoSansSC-Bold Noto Sans SC normal bold 2 (BLOB)
23 N NotoSansTC-Regular Noto Sans TC normal normal 2 (BLOB)
24 N NotoSansTC-Bold Noto Sans TC normal bold 2 (BLOB)
25 N NotoSansArabic-Regular Noto Sans Arabic normal normal 2 (BLOB)
26 N NotoSansArabic-Bold Noto Sans Arabic normal bold 2 (BLOB)
27 N NotoSansHebrew-Regular Noto Sans Hebrew normal normal 2 (BLOB)
28 N NotoSansHebrew-Bold Noto Sans Hebrew normal bold 2 (BLOB)