Aware IM User Forums

So you got the REST service working and you are now concerned with possibly sending multiple invoices and the same time, correct? Yes I want to prevent a collision Are you using the BO that has the REST service defined and is a singleton to store the data to be sent via the REST service? No, it is ...

Wrong. A singleton means there is only 1 actual object in the database for this BO. If your REST service is defined in a BO called MyRestSevice, you need to create 1 MyRestService in the DB. AwareIM will not let you create more than 1. I am still confused Picture this: There are 4 users working for...

The REST instance is a singleton but (from memory) you could use multiple different user/tenant keys stored in a user or a tenant record. Not sure I understand ,could you expand on this The singleton aspect is only related to the definition of the REST call, it can be parameterised. same goes for t...

The AwareIm REST setup must be a singleton, which means it's a single-user-only How could I have multiple users posting Invoices to a REST-based accounting API. It seems this is not possible with the standard configuration. Any suggestions on how to get some degree of multi-user functionality within...

PM me your email address and ill send you my version my.ini, there are some subtle differences but its worth a shot

Drop my.ini file into your Mysql setup (after renaming your version), change your port settings in AwareIM to 3307 and restart MySql

I am currently replicating the DB server to enable more intrusive tests. As suggested, install latest V5.7 version In the meantime send me your my.ini file so i can compare it with my install Also 1.have you tried to re create the query from scratch, I have had queries corrupt as a result of AwareI...

I'm afraid I will not know what to look for. Can you expand on the character in your query?

Dump the table to a text file or Excel and then explore the contents of each column for odd-looking things/characters that shouldn't be there.

Try using RemovedInvoiceItem prefix in a BO rule to find all instances above the removed LineNo and REDUCE found LineNos by 1: Absolutely Brilliant!! Works like a charm :shock: Thank you, I learned something new today :D InvoiceItem.LineNo>RemovedInvoiceItem.LineNo the "Removed" key word, I have ne...

Is there a chance of someone cracking this puzzle, I am pulling my hair out on this one I have an Invoice with InvoiceItems(child) and want to number the InvoiceItems in a logical number sequence of 1 to 50 As I CREATE each InvoiceItem, the new InvoiceItem.LineNo must + 1 on the previously added Inv...

Have you looked at your MySql error logs for clues
Also, inspect the my.ini file for limitations that may exist due to table growth.

What about some odd character in the data thats messing with the query, I had this once before on slow queries

Bringing AI tools into the configurator would be a game changer. To ensure its effectiveness, the AI system would need to undergo training based on the inner workings of AwareIM, rather than relying solely on publicly available information. I hope Vlad recognizes the immense potential presented here...

It should be able to write an Advanced script

Describe how to build an AwareIM app to manage a mechanics business

a better prompt would be : Build me an AwareIM App too manage a Mechanics business and return the BSV configuration file

...maybe a job for GPT-Engineer

As I said, in July several table indexes pointing to PHS_RID just went missing and slowed down a bunch of stuff. In light of this, I would re-deploy. Unless of course you have time to dig deeper. I would move a copy of the app to another machine with all the data and simulate the problem. Start a p...

1, When you run the slow query, have you monitored the memory usage. Does it spike or gradually grow. How much headroom is available afterwards. When the system is idle, reboot the server, take a memory usage reading and then run the query to establish its impact 2. In review, many indexes were simp...