Search found 1191 matches

by Rennur
Wed Feb 21, 2024 9:57 pm
Forum: Problem reports
Topic: missing fontawesome icons in V9
Replies: 4
Views: 295

Re: missing fontawesome icons in V9

Spelling? fa instead of far?
by Rennur
Wed Sep 06, 2023 12:20 am
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 113921

Re: Database latency - all suggestions appreciated, will compensate

My current thinking is that this is a database issue (MySQL 5.6).
My suggestion would be to upgrade to 5.7 or 8.0 (inc. Connector/J to 8.1)
by Rennur
Mon Aug 28, 2023 1:45 am
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 113921

Re: Database latency - all suggestions appreciated, will compensate

Related variable is the sort_buffer_size . Try setting same value as the join_buffer_size. https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_sort_buffer_size # If you see many sort_merge_passes per second in SHOW GLOBAL STATUS output, you can consider increasing the # sort_...
by Rennur
Sun Aug 27, 2023 11:32 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 113921

Re: Database latency - all suggestions appreciated, will compensate

# The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use # indexes and thus perform full table scans. join_buffer_size=256K I think the 256k default value for join_buffer_size is too low. I suggest increasing this to (M) value such as 64M (mi...
by Rennur
Thu Aug 24, 2023 12:43 am
Forum: General discussion and questions about Aware IM
Topic: *SOLVED* Numbering Line Items in a grid dilemma
Replies: 2
Views: 12452

Re: Numbering Line Items in a grid dilemma

Try using Removed InvoiceItem prefix in a BO rule to find all instances above the removed LineNo and REDUCE found LineNos by 1: If InvoiceItem WAS REMOVED FROM Invoice.InvoiceItem Then FIND InvoiceItem WHERE InvoiceItem IN Invoice.InvocieItem AND InvoiceItem.LineNo>RemovedInvoiceItem.LineNo REDUCE I...
by Rennur
Tue Apr 04, 2023 2:09 am
Forum: General discussion and questions about Aware IM
Topic: FIND instances of a referred object
Replies: 14
Views: 10039

Re: FIND instances of a referred object

If ThisRegularUser.Landfill IS UNDEFINED then FIND Project WHERE (Project IN ThisRegularUser.Project) FIND Landfill WHERE (Landfill IN ThisProject.Landfill OR Landfill IN OtherProject.Landfill) INSERT Landfill IN RegularUser.Landfill Try replacing ThisRegularUser WITH LoggedInRegularUser in your qu...
by Rennur
Wed Mar 29, 2023 12:46 am
Forum: General discussion and questions about Aware IM
Topic: How many Communication driven apps can we host on 1 server?
Replies: 15
Views: 22093

Re: How many Communication driven apps can we host on 1 server?

What about these lines in startupoptions.props: AWAREIM_SERVER_STARTUP=..\\JDK\\bin\\java -Xmx2000m -Xms20m -classpath ../lib/*;../CustomJars/* c<snip>... TOMCAT_STARTUP=..\\JDK\\bin\\java -Xmx2000m -classpath ../Tomcat/bin/bootstrap.jar;../Tomcat/bin/tomca <snip>... Yes you are correct. Adding par...
by Rennur
Wed Mar 29, 2023 12:39 am
Forum: General discussion and questions about Aware IM
Topic: V8 dropdown and combobox should default to basic usage
Replies: 13
Views: 35705

Re: V8 dropdown and combobox should default to basic usage

I haven't further experimented with version 8 or Kendo but I presume changing Kendo properties would be required.
by Rennur
Wed Mar 29, 2023 12:32 am
Forum: Problem reports
Topic: PDF.Downloader.Qakbot - security issue - Wkhtmltopdf
Replies: 2
Views: 14670

Re: PDF.Downloader.Qakbot - security issue - Wkhtmltopdf

I've scanned one of our .PDFs and did not detect any malware.
Invoice_679580-pdf-Jotti-s-malware-scan.png
Invoice_679580-pdf-Jotti-s-malware-scan.png (106 KiB) Viewed 14638 times
by Rennur
Wed Sep 14, 2022 11:38 pm
Forum: General discussion and questions about Aware IM
Topic: Certificate en https setup
Replies: 9
Views: 5397

Re: Certificate en https setup

I've implemented Digicert's SSL using a .p7b cert with Tomcat 9. You need to generate a keystore file .jks and use that file to configure Tomcat. Detailed steps can be found here https://www.digicert.com/kb/csr-ssl-installation/tomcat-keytool.htm My Tomcat 9 C:\AwareIM\Tomcat\conf\server.xml SSL con...
by Rennur
Thu Jun 23, 2022 3:07 am
Forum: General discussion and questions about Aware IM
Topic: Can I add Minutes to TimeStamp?
Replies: 12
Views: 7066

Re: Can I add Minutes to TimeStamp?

I would convert minutes to hours. I don't think the minutes function exists.
by Rennur
Mon Dec 20, 2021 10:25 pm
Forum: General discussion and questions about Aware IM
Topic: Create Users in Batch Process
Replies: 1
Views: 3061

Re: Create Users in Batch Process

Try:

Code: Select all

CREATE Employee FOR EACH PRMAST WITH ...
by Rennur
Mon Nov 15, 2021 5:02 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Does anyone else not like this error message?
Replies: 4
Views: 4452

Re: Does anyone else not like this error message?

The error message can be found in messages.props in the \bin\ folder.
by Rennur
Tue Jul 06, 2021 9:03 am
Forum: Problem reports
Topic: REST Service not reponse
Replies: 6
Views: 9206

Re: REST Service not reponse

Welcome to the forum! Try adding This prefix: FIND Application WHERE Application.ID=REST_Inputparameter.ApplicationId This Application.Status='Approved' FIND Application WHERE Application.ID=REST_Inputparameter.ApplicationId ThisApplication.Status='Approved' Also, should the REST_Inputparameter.Appl...
by Rennur
Tue Jun 15, 2021 2:44 am
Forum: General discussion and questions about Aware IM
Topic: Condition When Invisible
Replies: 5
Views: 5367

Re: Condition When Invisible

Code: Select all

I have checked and the values for LoggedInSystemUser.CanLockUnLockSystem are correct.
So no null values for either CanLockUnLockSystem and SystemIsLocked attributes in the database records?