Search found 100 matches

by jannes
Sun Mar 03, 2024 7:31 pm
Forum: Problem reports
Topic: FIND records | not found | subroutine
Replies: 1
Views: 131

FIND records | not found | subroutine

Table “Person” contains : id name language 1 Jannes dutch 2 Chris english 3 Mark english 4 Jim english Process : "DoFindSub" with just 1 rule : LoggedInBackofficeUser.Cnt=LoggedInBackofficeUser.Cnt + 1 Test 1) FIND Person WHERE Person.language = ‘english’ DoFindSub Result : DoFindSub is executed 3 t...
by jannes
Thu Feb 22, 2024 11:31 pm
Forum: Problem reports
Topic: BAS_UD_2 not found
Replies: 0
Views: 123

BAS_UD_2 not found

Every minute there is reported (in tab : Server Output) : 2024-02-23 00:35:16,370 ERROR -Execution Exception after starting system process message Internal error. Invalid rule IF CURRENT_TIME='00:30' AND CURRENT_DATE>=22/02/2024 THEN __BAS_UD_2 rule '__BAS_UD_2' uses process '__BAS_UD_2' which has n...
by jannes
Fri Feb 16, 2024 12:26 pm
Forum: Problem reports
Topic: Performance issue
Replies: 0
Views: 175

Performance issue

I have a serious performance issue. Just doing 1 simple update in the AIM-application generates almost 12.000 SQL-statements ... :cry: The steps to see these SQL-statements are : Step 1) Start AwareIM application. Go to the form. Step 2) In MariaDB : SET GLOBAL log_output = 'TABLE'; SET GLOBAL gener...
by jannes
Mon Feb 12, 2024 8:07 am
Forum: General discussion and questions about Aware IM
Topic: V9 NEW FEATURES discussion
Replies: 16
Views: 13647

Re: V9 NEW FEATURES discussion

"Data" is also a reserved word now in V9
by jannes
Sat Feb 10, 2024 9:08 pm
Forum: General discussion and questions about Aware IM
Topic: Dynamic order by
Replies: 1
Views: 186

Dynamic order by

Is there a way to do an order by depending on a BO-field ?

User 1 likes to have the query initially ordered by "Person.Name DESC"
User 2 likes to initially order by: "Person.ID ASC"

How to achieve this ?
by jannes
Thu Oct 26, 2023 11:59 am
Forum: Problem reports
Topic: NmbInstantMessages
Replies: 1
Views: 37275

NmbInstantMessages

The system is adding a lot of these messages (in the log /Tomcat output)
How to disable / stop it ?
by jannes
Wed Jun 28, 2023 8:20 pm
Forum: Problem reports
Topic: Unable to connect to my application securely in HTTPS
Replies: 1
Views: 13524

Re: Unable to connect to my application securely in HTTPS

Did you try to start AwareIM as administrator ?
by jannes
Wed Jan 25, 2023 6:31 pm
Forum: General discussion and questions about Aware IM
Topic: Cant get Scale_Image to work
Replies: 14
Views: 23702

Re: Cant get Scale_Image to work

In the meantime I developed a resize application / module (in Delphi). It is called in rule2. Until now it works fine, pictures are resized / scaled from 3 a 4 Mb to 15 a 20 kB. Rule0 IF FILE_EXISTS ('c:/mytemp/' +PersPeri.ID + '.jpg') = 'Yes' THEN DELETE FILE 'c:/mytemp/' +PersPeri.ID + '.jpg' Rule...
by jannes
Mon Jan 23, 2023 6:52 pm
Forum: General discussion and questions about Aware IM
Topic: Cant get Scale_Image to work
Replies: 14
Views: 23702

Re: Cant get Scale_Image to work

I'm using in the business rules : IF IMAGE_WIDTH (PersPeri.Foto2) <= 300 AND IMAGE_HEIGHT(PersPeri.Foto2) <= 300 THEN END PROCESS ELSE IF IMAGE_WIDTH (PersPeri.Foto2) > IMAGE_HEIGHT (PersPeri.Foto2) THEN PersPeri.Foto2 = SCALE_IMAGE(PersPeri.Foto2, 300, IMAGE_HEIGHT (PersPeri.Foto2) / IMAGE_WIDTH (P...
by jannes
Sun Nov 27, 2022 11:37 pm
Forum: General discussion and questions about Aware IM
Topic: Return multiple instances
Replies: 3
Views: 2622

Re: Return multiple instances

Hi Jaymer, Thanks replying. It works with some tables, but not with all tables, very strange. In that case a database-error is returned : "Could not connect to address=(host=localhost)(port=3306)(type=master) : Address already in use:" After this I have to restart AIM or reboot the server. I'm not a...
by jannes
Tue Nov 22, 2022 9:05 pm
Forum: General discussion and questions about Aware IM
Topic: Return multiple instances
Replies: 3
Views: 2622

Return multiple instances

I would like to get a list of records in the response of a service. The process is : FIND ALL Regio "The service reply will return object" : Regio "Multiple instances of the object will be returned" is ticked. See attachment. Unfortunately the service will not give a response. The system hangs. So t...
by jannes
Tue Jun 21, 2022 7:56 am
Forum: Problem reports
Topic: Retrieve a list of payments via REST-API (SOLVED)
Replies: 4
Views: 4917

Re: Retrieve a list of payments via REST-API (SOLVED)

Mail from Vladmir :
the bug is confirmed. It is now fixed and the fix will be available in the next maintenance build. Thank you.
by jannes
Fri Jun 17, 2022 1:13 pm
Forum: Problem reports
Topic: Retrieve a list of payments via REST-API (SOLVED)
Replies: 4
Views: 4917

Re: Retrieve a list of payments via REST-API

The workaround is to declare attributes twice.

See the attached BSV.

It's strange behaviour.
Investigation is in progress.

To be continued.

= Jannes
by jannes
Thu Jun 16, 2022 10:00 pm
Forum: Problem reports
Topic: Retrieve a list of payments via REST-API (SOLVED)
Replies: 4
Views: 4917

Re: Retrieve a list of payments via REST-API

I attached a small BSV. It can be used to discover the issue. It needs an API-key to be entered in SystemSettings. I will send it via PM. The zip also contains the expected JSON-file. Request "GetListPayments" will not return the “_embedded” payments. It returns only the “count”. The other request “...
by jannes
Wed Jun 15, 2022 4:39 pm
Forum: Problem reports
Topic: Retrieve a list of payments via REST-API (SOLVED)
Replies: 4
Views: 4917

Retrieve a list of payments via REST-API (SOLVED)

I'm struggling to retrieve a list of payments via REST-API.

The structure of the response has 5 levels.
Could that be the problem ?

api_mollie_paymentlist.json_as_.zip
Rename *.zip to *.json
(25.03 KiB) Downloaded 722 times
levels.png
levels.png (4.99 KiB) Viewed 4890 times