StoredProcedures / Reports don’t work when AwareIM runs as Service

If you think that something doesn't work in Aware IM post your message here
Post Reply
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

StoredProcedures / Reports don’t work when AwareIM runs as Service

Post by jannes »

StoredProcedures and Reports in MariaDB don’t work when AwareIM runs as a Service...

There is no error displayed.
The system just ‘hangs’ after clicking a button to start a stored procedure or report.

The service is installed by clicking \bin\InstallService.bat (as Administator)

Does anyone recognize this issue ?
Attachments
Naamloos.png
Naamloos.png (858 Bytes) Viewed 5162 times
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: StoredProcedures / Reports don’t work when AwareIM runs as Service

Post by aware_support »

Does exactly the same report work in a Control Panel?

What is the output of Aware IM Server and Tomcat?

Note, that when running as a service memory is allocated differently - see the neighbouring thread https://awareim.com/forum/viewtopic.php?f=2&t=12077

It could be a memory issue.
Aware IM Support Team
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Re: StoredProcedures / Reports don’t work when AwareIM runs as Service

Post by jannes »

The reports and stored procedures work normally with Control Panel.

I changed :

\AwareIM\bin\awareim.conf
# Initial Java Heap Size (in MB)
# wrapper.java.initmemory=20
wrapper.java.initmemory=1024

# Maximum Java Heap Size (in MB)
# wrapper.java.maxmemory=256
wrapper.java.maxmemory=4096

\AwareIM\bin\wrapper.conf
# Initial Java Heap Size (in MB)
# 2021-07-26 wrapper.java.initmemory=20
wrapper.java.initmemory=1024

# Maximum Java Heap Size (in MB)
# 2021-07-26 wrapper.java.maxmemory=256
wrapper.java.maxmemory=4096

And started the services :
1) tomcat
2) awareim

Result : No difference.
Reports and stored procedures don't work when running AwareIM as service
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: StoredProcedures / Reports don’t work when AwareIM runs as Service

Post by aware_support »

Can you please answer ALL questions in the previous response?
Aware IM Support Team
Post Reply