Hello,

I have an app with multiple companies. Each company is seeing only his orders and invoices.
My problem is that in TestMode when I login with company A - I create some orders and I can see this comap order list...
If I publish same BSV in Production and I login with company A - I create some orders but I cannot see any of his orders... In the same query, orders are not listed...
I use MySql and if I login via phpmyadmin the orders are in the database. Strange thing.
I think it's related with SQL because I created new BSV and imported my last version of the bsv. Same tests and there the data is ok in both TestMode and Production.

The problem is that users entered some data in my production app and cannot move bsv.

Have someone of you met this situation?
Please advice.
Thx.

8 days later

Hi

it's happening again.

Another app, same topology. Multiple users, multiple companies, in test mode everything is ok, but in production mode some companies don't see their customers, products, etc...

Anyone?

Have you checked the logs to see if the query is failing? Maybe if you provide details of the query we may be able to help.

Cheers Rod

13 days later

Hello,
I think is something in my rules. I have created another app and same thing
This is a multi-tenant app in which I protect records of companies of each other with PROTECT rules.

I have this BO's:
Company
UsersCompany (with CompanyAdmin and CompanyOperator ACL levels)
Invoices

In Invoices BO I have this rules:

To initialize the Company:
If Invoices.Company IS UNDEFINED Then
Invoices.Company=LoggedInUsersCompany.Company

To protect from otehr companies:
If TYPE(LoggedInSystemUser)='UsersCompany' AND LoggedInUsersCompany.Company<>Invoices.Company Then
READ PROTECT Invoices FROM CompanyAdmin AND CompanyOperator

If I create a query of the INVOICES, I do not see any of new created invoices and in the log of AwareIM server when I try to view this query I see this:

Value of [RegularUser, UsersCompany] could not be resolved
INFO: OutputAdaptor1.Controller has commited 1400 transactions
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
INFO: InputAdaptor1.Controller has commited 1400 transactions
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved
Value of [RegularUser, UsersCompany] could not be resolved

Anyone can help? I will greatly appreciate.
Thank you