Activities of "paul.harriman"

I will get back to you tomorrow, hopefully to close this ticket. Your solution works

Attached are the logs. the file is a zip file, i had to rename it so i could attach it. so just rename to .zip and expand

I

• deleted all org units using the app, they were soft deleted
• i added 2 root nodes
• i deleted 1 root node and only 1 was deleted

But when we have org units and then add the 2 root nodes (w/out children), all toot nodes w/out children are removed.

In the video i sent you, it has org units already, then i added the root nodes. this is the only way we can reproduce it

sent you a video in your email, file would not attach

essentially i just created 2 root nodes with nothing underneath them, and then deleted one of them

Ok, will email you the github address and some sample data

maliming,

If i try and create a new solution it does not replicate. if i go to another one of our web apps w/o organizations it doesn't replicate. we have 2 sites with Organization Units, and both show the issue.

if we profile the database we see the following (below). These queries is what we see that are deleting A root unit. does this help, we are thinking something in the abp code is generating these updates to soft delete the root units. does this help??

exec sp_executesql N'SET NOCOUNT ON;
UPDATE [AbpOrganizationUnits] SET [ConcurrencyStamp] = @p0, [DeleterId] = @p1, [DeletionTime] = @p2, [EntityVersion] = @p3, [IsDeleted] = @p4, [LastModificationTime] = @p5, [LastModifierId] = @p6
OUTPUT 1
WHERE [Id] = @p7 AND [ConcurrencyStamp] = @p8;
UPDATE [AbpOrganizationUnits] SET [ConcurrencyStamp] = @p9, [DeleterId] = @p10, [DeletionTime] = @p11, [EntityVersion] = @p12, [IsDeleted] = @p13, [LastModificationTime] = @p14, [LastModifierId] = @p15
OUTPUT 1
WHERE [Id] = @p16 AND [ConcurrencyStamp] = @p17;
',N'@p7 uniqueidentifier,@p0 nvarchar(40),@p8 nvarchar(40),@p1 uniqueidentifier,@p2 datetime2(7),@p3 int,@p4 bit,@p5 datetime2(7),@p6 uniqueidentifier,@p16 uniqueidentifier,@p9 nvarchar(40),@p17 nvarchar(40),@p10 uniqueidentifier,@p11 datetime2(7),@p12 int,@p13 bit,@p14 datetime2(7),@p15 uniqueidentifier',@p7='2DD45B3F-FC4C-F749-710C-3A16AABE55AD',@p0=N'6998127558414af1ba91d23d7eae1efb',@p8=N'5982a4fcdced4c46b96f30f825e4be3c',@p1='5C9DCA98-2173-FD84-F648-3A13DD86C3AA',@p2='2024-12-05 14:45:07.8682894',@p3=1,@p4=1,@p5='2024-12-0514:45:07.8745836',@p6='5C9DCA98-2173-FD84-F648-3A13DD86C3AA',@p16='84635BED-107A-2839-4C7B-3A16AABE6877',@p9=N'7801f92d8df747819280d309958c8f4c',@p17=N'182ea7d4d3734024873fa2f58f37c7d2',@p10='5C9DCA98-2173-FD84-F648-3A13DD86C3AA',@p11='2024-12-05 14:45:07.8736023',@p12=1,@p13=1,@p14='2024-12-05 14:45:07.8745117',@p15='5C9DCA98-2173-FD84-F648-3A13DD86C3AA'

UPDATE [AbpOrganizationUnits] SET [ConcurrencyStamp] = @p0, [DeleterId] = @p1, [DeletionTime] = @p2, [EntityVersion] = @p3, [IsDeleted] = @p4, [LastModificationTime] = @p5, [LastModifierId] = @p6
OUTPUT 1
WHERE [Id] = @p7 AND [ConcurrencyStamp] = @p8

UPDATE [AbpOrganizationUnits] SET [ConcurrencyStamp] = @p9, [DeleterId] = @p10, [DeletionTime] = @p11, [EntityVersion] = @p12, [IsDeleted] = @p13, [LastModificationTime] = @p14, [LastModifierId] = @p15
OUTPUT 1
WHERE [Id] = @p16 AND [ConcurrencyStamp] = @p17

hi

id=21b23e64-f077-728f-ef0e-3a169f4cf11b

Can you check if the id is the id of TestA?

Yes it is the id and the other id's that were soft deleted are unique

it looks like a task was created, so the documentation has not been created yet, correct? i looked at the documentation (https://docs.abp.io/en/commercial/latest/modules/cms-kit/index) and didn't notice anything new, but perhaps i am looking in the wrong place

to clear the redis chache i need to do something like this: https://github.com/abpframework/abp/issues/2793? yes the record does exist

So the pipeline in ci/cd ran several times, and it ran good, the last push got an error:

Run dotnet test ./aspnet-core --configuration Release --no-build Test run for /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.Application.Tests/bin/Release/net8.0/OtisEd.Zipline.Application.Tests.dll (.NETCoreApp,Version=v8.0) Microsoft (R) Test Execution Command Line Tool Version 17.9.0 (x64) Copyright (c) Microsoft Corporation. All rights reserved.

Starting test execution, please wait... A total of 1 test files matched the specified pattern. Test run for /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.EntityFrameworkCore.Tests/bin/Release/net8.0/OtisEd.Zipline.EntityFrameworkCore.Tests.dll (.NETCoreApp,Version=v8.0) Microsoft (R) Test Execution Command Line Tool Version 17.9.0 (x64) Copyright (c) Microsoft Corporation. All rights reserved.

Starting test execution, please wait... A total of 1 test files matched the specified pattern.

Passed! - Failed: 0, Passed: 122, Skipped: 0, Total: 122, Duration: 1 m 47 s - OtisEd.Zipline.EntityFrameworkCore.Tests.dll (net8.0) Test run for /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.TestBase/bin/Release/net8.0/OtisEd.Zipline.TestBase.dll (.NETCoreApp,Version=v8.0) Microsoft (R) Test Execution Command Line Tool Version 17.9.0 (x64) Copyright (c) Microsoft Corporation. All rights reserved.

Starting test execution, please wait... A total of 1 test files matched the specified pattern. No test is available in /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.TestBase/bin/Release/net8.0/OtisEd.Zipline.TestBase.dll. Make sure that test discoverer & executors are registered and platform & framework version settings are appropriate and try again.

Additionally, path to test adapters can be specified using /TestAdapterPath command. Example /TestAdapterPath:<pathToCustomAdapters>. Test run for /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.Domain.Tests/bin/Release/net8.0/OtisEd.Zipline.Domain.Tests.dll (.NETCoreApp,Version=v8.0) Microsoft (R) Test Execution Command Line Tool Version 17.9.0 (x64) Copyright (c) Microsoft Corporation. All rights reserved.

Starting test execution, please wait... A total of 1 test files matched the specified pattern.

Passed! - Failed: 0, Passed: 1, Skipped: 0, Total: 1, Duration: < 1 ms - OtisEd.Zipline.Domain.Tests.dll (net8.0) [xUnit.net 00:02:47.64] OtisEd.Zipline.ValidationSeverities.SeveritiesAppServiceTests.GetListAsync [FAIL] Failed OtisEd.Zipline.ValidationSeverities.SeveritiesAppServiceTests.GetListAsync [1 ms] Error Message: Volo.Abp.AbpInitializationException : An error occurred during the initialize Volo.Abp.Modularity.OnApplicationInitializationModuleLifecycleContributor phase of the module OtisEd.Zipline.ZiplineTestBaseModule, OtisEd.Zipline.TestBase, Version=8.0.0.0, Culture=neutral, PublicKeyToken=null: Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.. See the inner exception for details. ---- System.InvalidOperationException : Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized. Stack Trace: at Volo.Abp.Modularity.ModuleManager.InitializeModules(ApplicationInitializationContext context) at Volo.Abp.AbpApplicationBase.InitializeModules() at Volo.Abp.Testing.AbpIntegratedTest1..ctor() at OtisEd.Zipline.ValidationSeverities.SeveritiesAppServiceTests..ctor() in /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.Application.Tests/ValidationSeverities/SeverityApplicationTests.cs:line 15 at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean wrapExceptions) ----- Inner Stack Trace ----- at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Identity.EntityFrameworkCore.EfCoreIdentityUserRepository.FindByNormalizedUserNameAsync(String normalizedUserName, Boolean includeDetails, CancellationToken cancellationToken) at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue1.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func3 proceed) at Volo.Abp.Identity.IdentityDataSeeder.SeedAsync(String adminEmail, String adminPassword, Nullable1 tenantId) at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue1.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func3 proceed) at Volo.Abp.Data.DataSeeder.SeedAsync(DataSeedContext context) at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func3 proceed) at OtisEd.Zipline.ZiplineTestBaseModule.<>c__DisplayClass3_0.<<SeedTestData>b__0>d.MoveNext() in /home/runner/work/OtisEd.Zipline/OtisEd.Zipline/aspnet-core/test/OtisEd.Zipline.TestBase/ZiplineTestBaseModule.cs:line 60 --- End of stack trace from previous location --- at Nito.AsyncEx.Synchronous.TaskExtensions.WaitAndUnwrapException(Task task) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Nito.AsyncEx.AsyncContext.Run(Func`1 action) at Volo.Abp.Modularity.ModuleManager.InitializeModules(ApplicationInitializationContext context)

Failed! - Failed: 1, Passed: 221, Skipped: 0, Total: 222, Duration: 2 m 57 s - OtisEd.Zipline.Application.Tests.dll (net8.0) Error: Process completed with exit code 1.