Starts in:
1 DAY
21 HRS
56 MIN
17 SEC
Starts in:
1 D
21 H
56 M
17 S

Activities of "HDaoud"

All Question Answer
Newest Oldest
Invalid object name 'AbpSettingDefinitions' AND Invalid object name 'AbpTextTemplateDefinitionRecords'. #6079
Answer

this happened after upgrading from 7.3 to 7.4, I don't see these tables even after rerunning dbmigration. These tables are from the ABP framework. could you please elaborate on the steps to take to resolve the issue.

Invalid object name 'AbpSettingDefinitions' AND Invalid object name 'AbpTextTemplateDefinitionRecords'. #6079
Answer

Hello Support Team. Any update on what error is this? and what is the root cause?

Tenant switch not working on production #6071
Answer

This tried From https://support.abp.io/QA/Questions/3140/Wrong-path-of-TenantSwitchModal - This is causing 500 Error The login page won't load.

        Configure<AbpBundlingOptions>(options =>
        {
            options.ScriptBundles.Configure(
                LeptonXThemeBundles.Scripts.Global,
                bundle =>
                {
                    bundle.AddFiles("/Pages/Abp/MultiTenancy/tenant-switch.js");
                });
        });

AND

    Configure&lt;AbpBundlingOptions&gt;(options =>
    {
        options.ScriptBundles.Configure(
            StandardBundles.Scripts.Global,
            bundleConfiguration =>
            {
                bundleConfiguration.AddContributors(typeof(TenantSwitchBundle));
            }
        );
    });
Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

I followed the recommendations here specifically the instructions here and it is working now.

Things to keep in mind for anyone reading this: 1- change all links to https. (for local development you can create self-signed certificates using Openssl and then use the recommendations mentioned here for chrome to accept it. 2- ensure that OpenIddictApplications table has the proper urls for your App application. 3- clear all tokens and cache from browser. 4- check in the Event viewer to make sure that both Auth and API applications are running. 5- Make sure you have the correct information in your web.config for both applications.

aspNetCore processPath=".\YOURAPP.HttpApi.Host.exe" arguments=".\YOURAPP.HttpApi.Host.dll" stdoutLogEnabled="false" stdoutLogFile=".\Logs\stdout" hostingModel="inprocess"
Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

Thanks Mahmut, I actually rerun with npm install --force, and all the errors gone with the exception of the one related to ./roles.component, but I am still having the same issue in the gif, the login page goes in a loop and I never see the main page.

After rebuilding the project, re running DbMigrate, the login loop is stopped but when visiting the Angular App, I get error related to redirect_uri

the value is the same one in the OpenIddictApplications

Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

I redeleted node_moduled and rerun npm install however this time I added --force now the only issue I see is in custom-roles.component.spec.ts Cannont find module ./roles.component

Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

Here is the npm ls:

├── @abp/ng.components@7.4.0 ├── @abp/ng.core@7.4.0 ├── @abp/ng.oauth@7.4.0 ├── @abp/ng.schematics@7.4.0 ├── @abp/ng.setting-management@7.4.0 ├── @abp/ng.theme.shared@7.4.0 ├── @angular-devkit/build-angular@16.2.7 ├── @angular-eslint/builder@16.2.0 ├── @angular-eslint/eslint-plugin-template@16.2.0 ├── @angular-eslint/eslint-plugin@16.2.0 ├── @angular-eslint/schematics@16.2.0 ├── @angular-eslint/template-parser@16.2.0 ├── @angular-material-components/datetime-picker@16.0.1 ├── @angular/animations@16.2.10 ├── @angular/cdk@16.2.9 ├── @angular/cli@16.2.7 ├── @angular/common@16.2.10 ├── @angular/compiler-cli@16.2.10 ├── @angular/compiler@16.2.10 ├── @angular/core@16.2.10 ├── @angular/forms@16.2.10 ├── @angular/language-service@16.2.10 ├── @angular/localize@16.2.10 ├── @angular/material@16.2.9 ├── @angular/platform-browser-dynamic@16.2.10 ├── @angular/platform-browser@16.2.10 ├── @angular/router@16.2.10 ├── @fullcalendar/angular@6.1.9 ├── @fullcalendar/core@6.1.9 ├── @fullcalendar/daygrid@6.1.9 ├── @ngtools/webpack@16.2.7 ├── @types/jasmine@5.1.1 ├── @types/node@20.8.7 ├── @typescript-eslint/eslint-plugin@6.9.0 ├── @typescript-eslint/parser@6.9.0 ├── @volo/abp.commercial.ng.ui@7.4.0 ├── @volo/abp.ng.account@7.4.0 ├── @volo/abp.ng.audit-logging@7.4.0 ├── @volo/abp.ng.gdpr@7.4.0 ├── @volo/abp.ng.identity@7.4.0 ├── @volo/abp.ng.language-management@7.4.0 ├── @volo/abp.ng.openiddictpro@7.4.0 ├── @volo/abp.ng.saas@7.4.0 ├── @volo/abp.ng.text-template-management@7.4.0 ├── @volo/ngx-lepton-x.core@2.4.1 ├── @volosoft/abp.ng.theme.lepton-x@2.4.1 ├── angular-calendar@0.31.0 ├── angular-moment@1.3.0 ├── angular-oauth2-oidc@15.0.1 ├── eslint@8.52.0 ├── fullcalendar@6.1.9 ├── jasmine-core@5.1.1 ├── karma-chrome-launcher@3.2.0 ├── karma-coverage@2.2.1 ├── karma-jasmine-html-reporter@2.1.0 ├── karma-jasmine@5.1.0 ├── karma@6.4.2 ├── ng-image-fullscreen-view@3.0.3 ├── ng-multiselect-dropdown@1.0.0 ├── ng-packagr@16.2.3 ├── ng2-pdf-viewer@10.0.0 ├── ngx-lightbox@3.0.0 ├── ngx-mat-datetime-picker@3.0.0 ├── print-js@1.6.0 ├── rxjs@7.8.1 ├── sweetalert2@11.7.32 ├── tslib@2.6.2 ├── typescript@4.9.5 └── zone.js@0.14.0

Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

Hello, Is there any update on this?

I deleted the node_module along with the yarn.lock and package-lock.json and run yarn install again, here is what I get:

Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

Also when going to /api swagger shows up but if I try to run the get roles for instance I get the following:

Deploying ABP EF Core v7.0 with Angular Front End v16.0 to IIS v10 #6033
Answer

Hi Anjali,

I republished the Dbmigrator, delete the database and run it again at the server.

The problem persists, here is the a snippet from the API log file

2023-10-23 00:57:24.936 -06:00 [ERR] Failed executing DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [a].[Id], [a].[DefaultValue], [a].[Description], [a].[DisplayName], [a].[ExtraProperties], [a].[IsEncrypted], [a].[IsInherited], [a].[IsVisibleToClients], [a].[Name], [a].[Providers]
FROM [AbpSettingDefinitions] AS [a]
2023-10-23 00:57:24.936 -06:00 [ERR] Failed executing DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [a].[Id], [a].[DefaultCultureName], [a].[DisplayName], [a].[ExtraProperties], [a].[IsInlineLocalized], [a].[IsLayout], [a].[Layout], [a].[LocalizationResourceName], [a].[Name], [a].[RenderEngine]
FROM [AbpTextTemplateDefinitionRecords] AS [a]
2023-10-23 00:57:24.937 -06:00 [ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Abp.SettingManagement.EntityFrameworkCore.SettingManagementDbContext'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpSettingDefinitions'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
ClientConnectionId:b2e7547a-ecdc-4507-b0d5-066e1d17cdb1
Error Number:208,State:1,Class:16
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpSettingDefinitions'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository`2.GetListAsync(Boolean includeDetails, CancellationToken cancellationToken)
ClientConnectionId:b2e7547a-ecdc-4507-b0d5-066e1d17cdb1
Error Number:208,State:1,Class:16
2023-10-23 00:57:24.938 -06:00 [ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Abp.TextTemplateManagement.EntityFrameworkCore.TextTemplateManagementDbContext'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpTextTemplateDefinitionRecords'.
   at Microsoft.Data.SqlClient.SqlCommand.&lt;&gt;c.&lt;ExecuteDbDataReaderAsync&gt;b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
ClientConnectionId:11cc8375-c7e7-4803-9d50-4952d5ba89cd
Error Number:208,State:1,Class:16
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpTextTemplateDefinitionRecords'.
   at Microsoft.Data.SqlClient.SqlCommand.&lt;&gt;c.&lt;ExecuteDbDataReaderAsync&gt;b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository`2.GetListAsync(Boolean includeDetails, CancellationToken cancellationToken)
   at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
   at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
   at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
   at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
ClientConnectionId:11cc8375-c7e7-4803-9d50-4952d5ba89cd
Error Number:208,State:1,Class:16
2023-10-23 00:57:24.940 -06:00 [ERR] Invalid object name 'AbpSettingDefinitions'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpSettingDefinitions'.
   at Microsoft.Data.SqlClient.SqlCommand.&lt;&gt;c.&lt;ExecuteDbDataReaderAsync&gt;b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository`2.GetListAsync(Boolean includeDetails, CancellationToken cancellationToken)
   at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
   at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
   at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
   at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
   at Volo.Abp.SettingManagement.StaticSettingSaver.UpdateChangedSettingsAsync(List`1 SettingRecords)
   at Volo.Abp.SettingManagement.StaticSettingSaver.SaveAsync()
   at Volo.Abp.SettingManagement.StaticSettingSaver.SaveAsync()
   at Volo.Abp.SettingManagement.StaticSettingSaver.SaveAsync()
   at Volo.Abp.SettingManagement.StaticSettingSaver.SaveAsync()
   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.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
   at Volo.Abp.SettingManagement.AbpSettingManagementDomainModule.<>c__DisplayClass8_0.<<SaveStaticSettingsToDatabaseAsync>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Polly.AsyncPolicy.<>c__DisplayClass40_0.<<ImplementationAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Polly.Retry.AsyncRetryEngine.ImplementationAsync[TResult](Func`3 action, Context context, CancellationToken cancellationToken, ExceptionPredicates shouldRetryExceptionPredicates, ResultPredicates`1 shouldRetryResultPredicates, Func`5 onRetryAsync, Int32 permittedRetryCount, IEnumerable`1 sleepDurationsEnumerable, Func`4 sleepDurationProvider, Boolean continueOnCapturedContext)
ClientConnectionId:b2e7547a-ecdc-4507-b0d5-066e1d17cdb1
Error Number:208,State:1,Class:16
2023-10-23 00:57:24.940 -06:00 [ERR] ---------- Exception Data ----------
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 16.00.4075
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 208
HelpLink.BaseHelpUrl = https://go.microsoft.com/fwlink
HelpLink.LinkId = 20476

2023-10-23 00:57:24.940 -06:00 [ERR] Invalid object name 'AbpTextTemplateDefinitionRecords'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AbpTextTemplateDefinitionRecords'.
   at Microsoft.Data.SqlClient.SqlCommand.&lt;&gt;c.&lt;ExecuteDbDataReaderAsync&gt;b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   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 ---

There is a table called AbpTextTemplateContents but not the TextTemplateDefinitionRecords

Showing 11 to 20 of 23 entries
Made with ❤️ on ABP v9.1.0-preview. Updated on November 20, 2024, 13:06