PDF file generation error

Sanath_Udayawansa2 · August 22, 2020, 10:00am

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/pdf.py”, line 38, in get_pdf
filedata = pdfkit.from_string(html, False, options=options or {})
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pdfkit/api.py”, line 72, in from_string
return r.to_pdf(output_path)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pdfkit/pdfkit.py”, line 156, in to_pdf
raise IOError(‘wkhtmltopdf reported an error:\n’ + stderr)
OSError: wkhtmltopdf reported an error:
QSslSocket: cannot resolve CRYPTO_num_locks
QSslSocket: cannot resolve CRYPTO_set_id_callback
QSslSocket: cannot resolve CRYPTO_set_locking_callback
QSslSocket: cannot resolve sk_free
QSslSocket: cannot resolve sk_num
QSslSocket: cannot resolve sk_pop_free
QSslSocket: cannot resolve sk_value
QSslSocket: cannot resolve SSL_library_init
QSslSocket: cannot resolve SSL_load_error_strings
QSslSocket: cannot resolve SSLv3_client_method
QSslSocket: cannot resolve SSLv23_client_method
QSslSocket: cannot resolve SSLv3_server_method
QSslSocket: cannot resolve SSLv23_server_method
QSslSocket: cannot resolve X509_STORE_CTX_get_chain
QSslSocket: cannot resolve OPENSSL_add_all_algorithms_noconf
QSslSocket: cannot resolve OPENSSL_add_all_algorithms_conf
QSslSocket: cannot resolve SSLeay
QSslSocket: cannot call unresolved function CRYPTO_num_locks
QSslSocket: cannot call unresolved function CRYPTO_set_id_callback
QSslSocket: cannot call unresolved function CRYPTO_set_locking_callback
QSslSocket: cannot call unresolved function SSL_library_init
QSslSocket: cannot call unresolved function SSLv23_client_method
QSslSocket: cannot call unresolved function sk_num
Exit with code 1 due to network error: ContentNotFoundError
QSslSocket: cannot call unresolved function CRYPTO_num_locks
QSslSocket: cannot call unresolved function CRYPTO_set_id_callback
QSslSocket: cannot call unresolved function CRYPTO_set_locking_callback

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 62, in application
response = frappe.api.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/api.py”, line 55, in handle
return frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 61, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1054, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/print_format.py”, line 92, in download_pdf
frappe.local.response.filecontent = get_pdf(html)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/pdf.py”, line 46, in get_pdf
frappe.throw(_(“PDF generation failed because of broken image links”))
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 377, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’, is_minimizable=is_minimizable)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 356, in msgprint
_raise_exception()
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 316, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.ValidationError: PDF generation failed because of broken image links

rtdany10 · August 22, 2020, 10:54am

Install libssl1.0-dev

Make sure image links are proper and working.

Similar issue: wkhtmltopdf throws "QSslSocket: cannot resolve CRYPTO_num_locks" when using a template · Issue #2 · amra/DocumentationAsCode · GitHub
Please go through.

markus · September 28, 2021, 9:19am

I got the following error trying to export. Solution was to delete all stylesheet links and script tags linking to files that were pointing to non-existing files. (“assets/bootstrap/css/bootstrap.min.css” for example)

Just commenting in case anybody else has the same issue and finds this thread!

    Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/pdf.py", line 39, in get_pdf
    filedata = pdfkit.from_string(html, False, options=options or {})
  File "/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pdfkit/api.py", line 72, in from_string
    return r.to_pdf(output_path)
  File "/home/frappe/frappe-bench/env/lib/python3.6/site-packages/pdfkit/pdfkit.py", line 156, in to_pdf
    raise IOError('wkhtmltopdf reported an error:\n' + stderr)
OSError: wkhtmltopdf reported an error:
Exit with code 1 due to network error: ContentNotFoundError


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 64, in application
    response = frappe.api.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/api.py", line 59, in handle
    return frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 24, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 64, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1064, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/print_format.py", line 92, in download_pdf
    frappe.local.response.filecontent = get_pdf(html)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/pdf.py", line 47, in get_pdf
    frappe.throw(_("PDF generation failed because of broken image links"))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 377, in throw
    msgprint(msg, raise_exception=exc, title=title, indicator='red', is_minimizable=is_minimizable)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 356, in msgprint
    _raise_exception()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 316, in _raise_exception
    raise raise_exception(msg)
frappe.exceptions.ValidationError: PDF generation failed because of broken image links

wojosc · June 30, 2023, 11:12pm

might be related to:

github.com/frappe/frappe

wkhtmltopdf ContentNotFoundError

opened 07:24AM - 20 Jan 23 UTC

AJM-LSC

bug

### Information about bug When I enter a `DocType` and click the `Print` button… and then click the `PDF` button I get the reported error. the original error was connection refused. `Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 69, in application response = frappe.api.handle() File "apps/frappe/frappe/api.py", line 54, in handle return frappe.handler.handle() File "apps/frappe/frappe/handler.py", line 45, in handle data = execute_cmd(cmd) File "apps/frappe/frappe/handler.py", line 83, in execute_cmd return frappe.call(method, **frappe.form_dict) File "apps/frappe/frappe/__init__.py", line 1595, in call return fn(*args, **newargs) File "apps/frappe/frappe/utils/print_format.py", line 129, in download_pdf pdf_file = frappe.get_print( File "apps/frappe/frappe/__init__.py", line 2028, in get_print return get_pdf(html, options=pdf_options, output=output) File "apps/frappe/frappe/utils/pdf.py", line 38, in get_pdf filedata = pdfkit.from_string(html, options=options or {}, verbose=True) File "env/lib/python3.10/site-packages/pdfkit/api.py", line 75, in from_string return r.to_pdf(output_path) File "env/lib/python3.10/site-packages/pdfkit/pdfkit.py", line 201, in to_pdf self.handle_error(exit_code, stderr) File "env/lib/python3.10/site-packages/pdfkit/pdfkit.py", line 155, in handle_error raise IOError('wkhtmltopdf reported an error:\n' + stderr) OSError: wkhtmltopdf reported an error: Exit with code 1 due to network error: ConnectionRefusedError` i added `"host_name": "http://127.0.0.1",` to the site_config.json suggested by a forum post that then produced the below error. ### Module selling ### Version **Installed Apps** ERPNext: v14.13.0 (version-14) Frappe Framework: v14.23.0 (version-14) Frappe HR: v1.0.0 (develop) Frappe LMS: v0.0.1 (main) Payments: v0.0.1 (develop) Wiki: v0.0.1 (master) ### Installation method docker ### Relevant log output / Stack trace / Full Error Message. ```shell Traceback (most recent call last): File "apps/frappe/frappe/utils/pdf.py", line 38, in get_pdf filedata = pdfkit.from_string(html, options=options or {}, verbose=True) File "env/lib/python3.10/site-packages/pdfkit/api.py", line 75, in from_string return r.to_pdf(output_path) File "env/lib/python3.10/site-packages/pdfkit/pdfkit.py", line 201, in to_pdf self.handle_error(exit_code, stderr) File "env/lib/python3.10/site-packages/pdfkit/pdfkit.py", line 155, in handle_error raise IOError('wkhtmltopdf reported an error:\n' + stderr) OSError: wkhtmltopdf reported an error: Exit with code 1 due to network error: ContentNotFoundError During handling of the above exception, another exception occurred: Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 69, in application response = frappe.api.handle() File "apps/frappe/frappe/api.py", line 54, in handle return frappe.handler.handle() File "apps/frappe/frappe/handler.py", line 45, in handle data = execute_cmd(cmd) File "apps/frappe/frappe/handler.py", line 83, in execute_cmd return frappe.call(method, **frappe.form_dict) File "apps/frappe/frappe/__init__.py", line 1595, in call return fn(*args, **newargs) File "apps/frappe/frappe/utils/print_format.py", line 129, in download_pdf pdf_file = frappe.get_print( File "apps/frappe/frappe/__init__.py", line 2028, in get_print return get_pdf(html, options=pdf_options, output=output) File "apps/frappe/frappe/utils/pdf.py", line 46, in get_pdf frappe.throw(_("PDF generation failed because of broken image links")) File "apps/frappe/frappe/__init__.py", line 525, in throw msgprint( File "apps/frappe/frappe/__init__.py", line 493, in msgprint _raise_exception() File "apps/frappe/frappe/__init__.py", line 442, in _raise_exception raise raise_exception(msg) frappe.exceptions.ValidationError: PDF generation failed because of broken image links ```

I have found, that when the file is not in /files/private/filename.png then I have no problem.

adam26d · February 2, 2024, 8:29am

how did you find these and delete them?

I’m running things on docker and this just started yesterday

Peter_G · March 27, 2024, 8:35pm

I have the same problem.
I have no images in my report. Example User Document, goto Print → HTML Preview and then to PDF.
I get

OSError: wkhtmltopdf reported an error:
Exit with code 1 due to network error: ContentNotFoundError

and as following error

frappe.exceptions.ValidationError: PDF-Generierung ist aufgrund fehlerhafter Verknüpfungen für Bilddateien fehlgeschlagen

I have tried all variants of host_name in site.config, but no success.
It is at this time a showstopper, because my app depends very much on the PDF functionality.

Yamen_Zakhour · March 28, 2024, 12:53am

I’m very dependant on PDF as well. Switching to Chrome Headless really solved lots of issues for me.

If you are hosted on Frappe Cloud check my fork which supports Frappe Cloud.

Chrome Pros: real WYSIWYG with support to latest css.

Limitations: No Repeating Letterheads & Page Numbering

Limitations can be solved with puppeteer/pyppeteer or in less technical methods like structuring print formats as a table and using pagedjs.

MinHyeong-Lee · March 28, 2024, 6:22am

Can you tell me your fork repo url?

I can’t find on github

Yamen_Zakhour · March 28, 2024, 9:51pm

elvis_ndegwa · October 14, 2024, 9:58am

I had the same problem,but i sorted it out by going to the server at location
**cd /etc** then i **sudo nano hosts**
then i added this line
127.0.0.1 erp.domain.com
this sorted my issue