Jasper report Integration

@luisfmfernandes
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.

Thanks,
Luis.

@luisfmfernandes
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
execute_cmd(cmd)
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)
meta.resolve_class(classDict)
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)
create_jnienv()
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.

Thanks,
Luis.

@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.

Thanks,

Luís.