Solved

Server Error in '/AcumaticaERP' Application

  • 24 July 2023
  • 2 replies
  • 234 views
H

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

S
Rank
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

H
Rank
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


Terms & ConditionsCookie settings
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