Activities of "AuroraBMS"

Prerequisites

Please answer the following questions before submitting an issue. YOU MAY DELETE THE PREREQUISITES SECTION.

• What is your product version?
  • V11.0.1
• What is your product type (Angular or MVC)?
  • Angular
• What is product framework type (.net framework or .net core)?
  • Core

Good day ANZ team,

We are busy updating to V11.0.1 and attempting to implement Hangfire jobs for bulk data syncing. Previously we used to handle update & insert seperately which technically still works as individual processes but the actual parts that we want to start using is:InsertOrUpdateAndGetId We have tried a few routes of processing it but in the end even on a blank table that only needs to insert data it still fails.

This is the error we are getting when any inser/update function is processed without results existing already:

Abp.Domain.Uow.AbpDbConcurrencyException (DESKTOP-J0MPMEA:18476) The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions.

Abp.Domain.Uow.AbpDbConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions. ---> Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions.

The data does not get modified or removed as the table is still empty and the list of information is already fixed and is not altered during the add process.

We have tried process the data as below(most basic data model):

var id =_businessPartnerMasterData.InsertOrUpdateAndGetId(new BusinessPartnerMasterData() { Id = Convert.ToString(reader.GetValue("CardCode")), CardCode = Convert.ToString(reader.GetValue("CardCode")), CardName = Convert.ToString(reader.GetValue("CardName")), IsActive = Convert.ToString(reader.GetValue("validFor")) == "Y" ? true : false });

the same structure wrapped in a unit of work etc.

Could you please assist with how to correctly InsertOrUpdateAndGetId data with a hangfire process?

Please let me know if more info is required, but in general the above is what I get in error form once the process is "completed/failed".

HI @ismcagdas,

I'm experiecning the same issue currently.

I've tried using the bulk insert as well now. It was however on a freshly created project with a bunch of standard entities created without any custom code yet.

I've had this a few times when trying to use it on a from scratch project when you migrate versions and have been getting it for a while now. Attempted to use it with 11.0.1 now again as I am getting stuck on standard repository functions not working with hangfire. Below is the error:

ERROR_005: The monthly trial period is expired (2022-01-01). You can extend your trial by downloading the latest version as the beginning of every month. More information can be found here: https://entityframework-extensions.net/trial

System.Exception: ERROR_005: The monthly trial period is expired (2022-01-01). You can extend your trial by downloading the latest version as the beginning of every month. More information can be found here: https://entityframework-extensions.net/trial at .(ProviderType , Boolean , Boolean , Boolean , Boolean ) at Z.BulkOperations.BulkOperation.Execute() at Z.BulkOperations.BulkOperation.BulkInsert() at .BulkInsert[T](DbContext this, IEntityType entityType, IEnumerable1 list, Action1 options, SavingSelector savingSelector, Boolean forceSpecificTypeMapping) at .BulkInsert[T](DbContext this, IEnumerable1 entities, Action1 options, Boolean isBulkSaveChanges) at .(DbContext this, List1 , Action1 ) at .(DbContext this, StateManager , IReadOnlyList1 , Action1 ) at .(DbContext this, StateManager , IReadOnlyList1 , Action1 ) at .(DbContext this, Action1 , DbContext ) at DbContextExtensions.BulkSaveChanges(DbContext this, Action1 options) at DbContextExtensions.BulkSaveChanges(DbContext this) at BRM.Web.Startup.Hangfire.DataSyncs.Inbound.BusinessPartnerMasterDataInboundSync.Execute(Int32 number) in C:\Users\user\Source\Repos\BRMV11.0.1\aspnet-core\src\BRM.Web.Host\Startup\Hangfire\DataSyncs\Inbound\BusinessPartnerMasterDataInboundSync.cs:line 149 at Castle.Proxies.BusinessPartnerMasterDataInboundSyncProxy.Execute_callback(Int32 number) at Castle.Proxies.Invocations.BusinessPartnerMasterDataInboundSync_Execute.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.InterceptSynchronous(IInvocation invocation) at Castle.DynamicProxy.AsyncDeterminationInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.BusinessPartnerMasterDataInboundSyncProxy.Execute(Int32 number)

• What is your product version?
  • 10.30
• What is your product type (Angular or MVC):
  • Angular
• What is product framework type (.net framework or .net core)?
  • .net Core

Good day ANZ Team,

I have a few questions regarding the Xamarin part of the solution:

• Is there any way to specifically make the solution work offline and only go online once internet access is received or refresh is run?
  • The need for this comes in when working in rural areas or areas that do not have signal due to environment or restrictions.
  • The issue comes in when closnig the app completely it requires re-auth once starting up again.

-In the Xamarin project I found these 2 entries under class XamarinSharedModule: - Configuration.Localization.IsEnabled = false; - Configuration.BackgroundJobs.IsJobExecutionEnabled = false;

What exactly does those 2 fields allow for the xamarin project? I know Configuration.BackgroundJobs.IsJobExecutionEnabled from the standard project but not sure if this is some sort of job execution for the mobile device itself and if so how is it used?

Thanks in advance!

Found the issues. Default tenant is not seen as the main host but rather just another instance/tenant. So in order to actually access the real host on the system you have to untick the tenant and not handle the default tenant as the host and other tenants added on later as tenants only.

@bartkoolhaas check if you untick tenant after opening the site you should be able to see your menu's if multi tenancy is enabled for you.

Running this command will resolve you EF issue: dotnet tool install --global dotnet-ef

also the UI for the default theme is still broken in this version after being deployed

I am experiencing the same issue and I am quite urgently in need of a fix as the issues we are getting in the RC is too large to stay on and the versions in the last 6 months have been terribly bugged and overloaded with issues. Hoping that an update to 10.2.0 would resolve issues but now we are stuck with something that is even worse.... previous versions atleast gave us UI functionality and now we dont even have our custom functions available. Not all companies have the resources to resolve endless issues upon issues that gets shipped in what is supposed to be a stable version but is actually not ran through a basic level of QA.

Been a long time since there has been a stable release.

Deployed version: Menu Options available

Even the authorizations are not available and only standard base applicaiton auths are loading:

Debug/Test version: Menu options available Auths available:

When is the official 9.3 release date planned for or will it move to version 10 directly?

Just want to know as alot of the 9.3 issues are not present in the 10.0 or 10.1 task list which according due dates will be the 11 Nov.

Hi @ismcagdas,

No errors at all.

Prerequisites

Please answer the following questions before submitting an issue. YOU MAY DELETE THE PREREQUISITES SECTION.

• What is your product version? 9.3 RC.1
• What is your product type (Angular or MVC)? Angular
• What is product framework type (.net framework or .net core)? Core

If issue is about UI

• Which theme are you using? default theme
• What are the theme settings? default settings

Hi ANZ Team,

currently when deploying a test version of 9.3 RC1 the default them loads incorrectly.

Is there some sort of setting or config that needs to be taken into consideration? The other themes seems to work. Did not test all of them, however the 4 tested worked fine.

Regards, AuroraBMS