Solved

Server Error in '/AcumaticaERP' Application

  • 24 July 2023
  • 2 replies
  • 330 views

Server Error in '/AcumaticaERP' Application.

Found columns for index #0 not present in headers

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Found columns for index #0 not present in headers

Source Error:
 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:
 

[InvalidOperationException: Found columns for index #0 not present in headers]
PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.(IDataReader , IDictionary`2 ) +500
PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.Load(Func`1 adapterSupplier, MsSqlScripter scripter) +1076
PX.DbServices.Points.MsSql.NativeMetadata.MsSqlSchemaReader.GetIndices(String tableName, CacheUsage useCache) +112
PX.DbServices.Points.MsSql.NativeMetadata.MsSqlSchemaReader.buildTableHeaderFromColumnsAndIndices(String tableName) +707
PX.DbServices.Points.DbmsBase.SchemaReaderBase.(Int32 ) +131
PX.DbServices.Points.DbmsBase.PointDbmsBase.get_Schema() +46
PX.Data.DbSchemaCache.ensureCacheIsFilled() +240
PX.Data.DbSchemaCache.GetTableHeader(String tableName) +143
PX.Data.DbSchemaCache.getTableSetting(String tableName, Boolean selectablesHaveNoCompanyId) +98
PX.Data.PXDatabaseProviderBase.getCompanyID(String tableName, companySetting& setting) +361
PX.Data.PXDatabaseProviderBase.ResetSlot(String key, Type[] tables) +220
PX.Licensing.LicensingManager.InvalidateLicense() +104
PX.Licensing.LicensingManager.Autofac.IStartable.Start() +500
Autofac.Core.Resolving.Middleware.StartableMiddleware.Execute(ResolveRequestContext context, Action`1 next) +330
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next) +36

[DependencyResolutionException: An exception was thrown while activating PX.Licensing.LicensingManager.]
Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next) +214
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.Middleware.<>c__DisplayClass5_0.<Execute>b__0() +26
Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid id, Func`1 creator) +250
Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid primaryId, Nullable`1 qualifyingId, Func`1 creator) +105
Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action`1 next) +909
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next) +545
Autofac.Core.Resolving.Pipeline.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt) +233
Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request) +722
Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request) +335
Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(ResolveRequest request) +148
Autofac.Builder.StartableManager.StartStartableComponents(IDictionary`2 properties, IComponentContext componentContext) +562
Autofac.ContainerBuilder.Build(ContainerBuildOptions options) +217
Autofac.Extensions.DependencyInjection.AutofacServiceProviderFactory.CreateServiceProvider(ContainerBuilder containerBuilder) +42
PX.Hosting.HostBuilder.CreateServiceProvider(HostBuilderContext hostBuilderContext, IEnumerable`1 configureServicesActions, Func`2 providerFactory, IEnumerable`1 configureContainerActions) +686
PX.Hosting.HostBuilder.Build() +146
PX.Data.DependencyInjection.CompositionRoot.CreateContainer(Configuration configuration) +577
PX.Web.PXApplication.Application_Start(Object sender, EventArgs e) +119

[HttpException (0x80004005): An exception was thrown while activating PX.Licensing.LicensingManager.]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +517
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +185
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +168
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +277
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +369

[HttpException (0x80004005): An exception was thrown while activating PX.Licensing.LicensingManager.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +532
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +111
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +724
icon

Best answer by sweta68 24 July 2023, 07:14

View original

2 replies

Userlevel 7
Badge +10

Hi @hungtranvan15 ,

 

The error originates from the IndexReader class and leads to an unhandled exception in the LicensingManager class. To resolve the issue, it is recommended to review the application's database schema and verify the integrity of data, check the index definitions, and examine the relevant code responsible for database interactions.

 

Regards,

Sweta

Userlevel 1
Badge

HI @sweta68 

I have a customized project which is in the minor version of 23R1 then later i want to upgrade it to the 23.111.0019 when i compile the code build was successful but when trying to reload the website throws the following error can you please help me with this issue.


 

The licensing service configuration is invalid (case e) for assembly PX.LicensePolicy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The licensing service configuration is invalid (case e) for assembly PX.LicensePolicy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Source Error:
 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:
 

[InvalidOperationException: The licensing service configuration is invalid (case e) for assembly PX.LicensePolicy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]
PX.Licensing.LicensingManager.ThrowForFailedServiceVerification(String marker, String assemblyName) +111
PX.Licensing.LicensingManager.VerifyLicensePolicy() +153
PX.Licensing.LicensingManager.GetVerifiedManager(IServiceProvider services) +52
PX.Licensing.LicensingHostWrapper..ctor(IHost host) +53
PX.Data.DependencyInjection.CompositionRoot.CreateContainer(Configuration configuration) +740
PX.Web.PXApplication.Application_Start(Object sender, EventArgs e) in C:\build\code_repo\NetTools\PX.Web.Site\PXApplication.cs:55

[HttpException (0x80004005): The licensing service configuration is invalid (case e) for assembly PX.LicensePolicy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +517
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +185
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +168
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +277
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +369

[HttpException (0x80004005): The licensing service configuration is invalid (case e) for assembly PX.LicensePolicy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +532
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +111
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +719

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved