Aware IM User Forums

See this example : The process : EXEC_SP `DoCount` WITH `@regel`='SELECT count(DISTINCT plaats) FROM persoon' FIND All Msg DISPLAY MESSAGE Msg.Regel The stored procedure in the DB : CREATE DEFINER=`root`@`localhost` PROCEDURE `devtest`.`docount`(IN regel varchar(2000)) BEGIN DELETE FROM msg; EXECUTE...

When using a not persisted BO MariaDB is falling in sleep.
It takes 10 a 30 minutes before an update or insert is processed.

What can be the reason ?

Is there anyone who faced this problem before ?

The answer of Vladimir :

If domains already exist, then yes, you have to import the BSV manually.
There is no work around for this yet.

It is possible to publish a BSV via a script to 1 or more (production) domains ? - Export the BSV from the development domain - Create new (minor) version in another (production) domain(s) - Import BSV into another domain(s) - Publish BSV in domain(s) Isn’t it also already part of AwareIm like creat...

It is solved by adding in ..AwareIM\TomCat\conf\web.xml (replace <mysite> in your own url(s) ) : <filter> <filter-name>CorsFilter</filter-name> <filter-class>org.apache.catalina.filters.CorsFilter</filter-class> <init-param> <param-name>cors.allowed.origins</param-name> <param-value>https://www.apac...

Another party is using our exposed webservices. They say : the browser needs a CORS header in the response of the REST-API call. Therefore I added these lines in ..AwareIM\TomCat\webapps\AwareIM\WEB-INF\web.xml and ..AwareIM\TomCat\conf\web.xml <filter> <filter-name>CorsFilter</filter-name> <filter-...

The binary data can be retrieved via :

WebResult.Foto=IMAGE_DATA(Persoon.Foto)

WebResult.Foto must be a (big) PlainText (MEDIUMTEXT)

regards
Jannes

Thnx to Himanshu!

1) Exposing : https://cloud.f...:8444/AwareIM/REST/PVGE/GetPass?LidNr=101407&KodeExtern=1155 See complete link in pm 2) Service "GetPass" : Process : WebGetPass [x] Third parties will .. Service will retun object : WebResult REST Service Settings Use default URL JSON format Do not encode undefined s...

Hi Jaymer,

I changed the text of the post.
I hope it makes more sense now.

regards
Jannes

A REST API call retrieves data from a person. It works fine but the photo (format = Picture, stored in database) is not returned. This field is missing in the response. According to a tip on the forum, DOCDATA should be used in the attribute. WebResult.Photo=Person.Photo.DOCDATA But this doesn't wor...

A way to get it working : Export the BSV as a XML, change the XML 1) Set the operand to "false" <operation name="Del" type="delete_object" operand="false" css_class="" display_text="false"> 2) Add in the business-rule: use_in_on_change="true" <rule name="Rule1" use_in_on_change="true" > <rule_text> ...

Thnx, I now use : If Child WAS ADDED TO Parent.oo_Child Then INCREASE Parent.Amount BY AddedChild.Amount If Child WAS REMOVED FROM Parent.oo_Child Then REDUCE Parent.Amount BY RemovedChild.Amount instead of Parent.Amount=SUM Child.Amount WHERE (Child IN Parent.oo_Child) but the amount is still not r...

Hi Pointswell, Thnx replying. It's all about deleting a child record. The SUM is working but the updated amount is not updated in the MAIN-form (Parent) when DELETING a child: Not OK The updated amount - is updated correctly in the MAIN-form (Parent) when ADDING a child: OK - is updated in the Paren...

Auto-refresh doesn't work as expected when deleting a record (in a child BO) See the attached BSV : 1) Orderheader / OrderLines : it works OK 2) Parent / Child : deleting the child-record doesn't refresh the sum-total What could be the difference why 2) isn't working ... What I did : - The parent ha...

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