# Jasper Reports error on Docker instance

**URL:** <https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634>\
**Category:** Developers\
**Tags:** jasper, english\
**Created:** [July 26, 2019, 11:50am UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634 "2019-07-26T11:50:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![gskharmujai](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/g/838e76/32.png) [@gskharmujai](https://forum.metasfresh.org/u/gskharmujai)\
**Post date:** [July 26, 2019, 11:50am UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/1 "2019-07-26T11:50:08Z")

</div>

Hi,

I have setup metasfresh using docker instance with has tag : 5.112.2\_16237\_gh5358app and i got this problem when trying to generate reports for printing.

The error that is displayed when i try to print is :

```
There was an unexpected error (type=Internal Server Error, status=500).

FileNotFoundException: http://aaa.bbb.ccc.ddd:8080/adempiereJasper/ReportServlet?AD_Process_ID=500007&AD_PInstance_ID=1415155&AD_Language=en_US&output=PDF 

Additional parameters: URL: http://aaa.bbb.ccc.ddd:8080/adempiereJasper/ReportServlet?AD_Process_ID=500007&AD_PInstance_ID=1415155&AD_Language=en_US&output=PDF 

```

Can you please help me out with this problem.

---

<div class="post-metadata">

**Author:** ![metasnw](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/metasnw/32/23_2.png) [@metasnw](https://forum.metasfresh.org/u/metasnw)\
**Post date:** [July 29, 2019, 10:47am UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/2 "2019-07-29T10:47:07Z")

</div>

hi George,

are you trying to access the default reports of metasfresh or your own ?

cheers,  
Norbert

---

<div class="post-metadata">

**Author:** ![gskharmujai](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/g/838e76/32.png) [@gskharmujai](https://forum.metasfresh.org/u/gskharmujai)\
**Post date:** [July 29, 2019, 1:16pm UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/3 "2019-07-29T13:16:27Z")

</div>

Hi Norbert,

I have tried in a fresh docker installation & also adding custom reports.

Both times i get the same error.

---

<div class="post-metadata">

**Author:** ![metasnw](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/metasnw/32/23_2.png) [@metasnw](https://forum.metasfresh.org/u/metasnw)\
**Post date:** [August 5, 2019, 1:23pm UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/4 "2019-08-05T13:23:19Z")

</div>

hi George,

you need to make sure metasfresh tries to find the jasper server on the right hostname.  
Please check what this query result is:  
`select value from ad_sysconfig WHERE name ILIKE 'de.metas.adempiere.report.jasper.JRServerServlet';`

It should be this for Default Release DOCKER systems:  
`http://app:8282/adempiereJasper/ReportServlet`

If a report container is installed (needs manual installation) its like this:  
`http://reports:8282/adempiereJasper/ReportServlet`

If you have a dedicated Installation without Docker its the actual hostname:  
`http://<yourserver-hostname>:8080/adempiereJasper/ReportServlet`

cheers,  
Norbert

---

<div class="post-metadata">

**Author:** ![metasnw](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/metasnw/32/23_2.png) [@metasnw](https://forum.metasfresh.org/u/metasnw)\
**Post date:** [August 5, 2019, 1:33pm UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/5 "2019-08-05T13:33:27Z")

</div>

Here is a nice command that sets the value for docker instance (thx @julian.bischof) :

```auto
docker exec -u postgres <yourinstance> psql -d metasfresh -c "UPDATE ad_sysconfig SET value='http://app:8282/adempiereJasper/ReportServlet' WHERE name ILIKE 'de.metas.adempiere.report.jasper.JRServerServlet';"

```

---

<div class="post-metadata">

**Author:** ![gskharmujai](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/g/838e76/32.png) [@gskharmujai](https://forum.metasfresh.org/u/gskharmujai)\
**Post date:** [August 7, 2019, 10:30am UTC](https://forum.metasfresh.org/t/jasper-reports-error-on-docker-instance/1634/6 "2019-08-07T10:30:46Z")

</div>

I have tried running this command and when i try to print Sales Orders i got this error instead

There was an unexpected error (type=Internal Server Error, status=500).  
ServiceConnectionException: java.net.ConnectException: Connection refused (Connection refused)

**Update:** i tried with the full name of the app like metasfresh-docker\_app\_1 and the reports are generated.

Thanks @metasnw for the fix.
