Jasper report Integration

Hi I am trying to jasper report with erpnext. I created a saimple report named test. then connect it with jasper server. then import it in erpnext via jasper report apps. but i got an error. here I enclosed my jasperserver directory, jasperserver config, jasper report, and doctype screenshot.

Hi @shariful_rocky09.

I can’t see the error. Can you past it here?

Meanwhile, check if there is a erpnext folder in jasper server. You have to right click with the mouse to see the real path in jasper server. See This.


yeah erpnext folder exist in jasper server.
when I run the relevant report from upper right corner report motification then it shows this error
Traceback (innermost last):
File “/home/shariful/garments/apps/frappe/frappe/app.py”, line 69, in application
response = frappe.handler.handle()
File “/home/shariful/garments/apps/frappe/frappe/handler.py”, line 20, in handle
File “/home/shariful/garments/apps/frappe/frappe/handler.py”, line 37, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/shariful/garments/apps/frappe/frappe/init.py”, line 801, in call
return fn(*args, **newargs)
File “/home/shariful/garments/apps/jasper_erpnext_report/jasper_erpnext_report/core/JasperWhitelist.py”, line 172, in run_report
return jsr.run_report(data, docdata=docdata)
File “/home/shariful/garments/apps/jasper_erpnext_report/jasper_erpnext_report/core/JasperRoot.py”, line 263, in run_report
result = self.jps.run_remote_report_async(path, rdoc, data=data, params=params, pformat=pformat, ncopies=ncopies)
File “/home/shariful/garments/apps/jasper_erpnext_report/jasper_erpnext_report/core/JasperServer.py”, line 206, in run_remote_report_async
from jasper_erpnext_report.core.FrappeTask import FrappeTask
File “/home/shariful/garments/apps/jasper_erpnext_report/jasper_erpnext_report/core/FrappeTask.py”, line 6, in
from jnius.jnius import PythonJavaClass, java_method
File “/home/shariful/garments/env/src/pyjnius/jnius/init.py”, line 13, in
from .reflect import *
File “/home/shariful/garments/env/src/pyjnius/jnius/reflect.py”, line 14, in
class Class(with_metaclass(MetaJavaClass, JavaClass)):
File “/home/shariful/garments/env/local/lib/python2.7/site-packages/six.py”, line 808, in new
return meta(name, bases, d)
File “jnius/jnius_export_class.pxi”, line 43, in jnius.MetaJavaClass.new (jnius/jnius.c:17159)
File “jnius/jnius_export_class.pxi”, line 65, in jnius.MetaJavaClass.resolve_class (jnius/jnius.c:17555)
cdef JNIEnv *j_env = get_jnienv()
File “jnius/jnius_env.pxi”, line 11, in jnius.get_jnienv (jnius/jnius.c:3320)
default_env = get_platform_jnienv()
File “jnius/jnius_jvm_dlopen.pxi”, line 89, in jnius.get_platform_jnienv (jnius/jnius.c:3248)
File “jnius/jnius_jvm_dlopen.pxi”, line 58, in jnius.create_jnienv (jnius/jnius.c:2810)
raise SystemError(“Error calling dlopen({0}: {1}”.format(lib_path, dlerror()))
SystemError: Error calling dlopen(/usr/lib/jvm/java-8-oracle/jre/bin/jre/lib/amd64/server/libjvm.so: /usr/lib/jvm/java-8-oracle/jre/bin/jre/lib/amd64/server/libjvm.so: cannot open shared object file: No such file or directory

Hi again, @shariful_rocky09.

You must install pyjnius. Follow the instructions in jasper github.

I know that you don’t use the “local server”, but you must install it anyway.

Later i will try to remove this requirement.


@shariful_rocky09. I think it is fixed now.

Now there is no need to install pyjnius for jasper server only.

If you don’t install it yet, please update.