Skip to main content

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:
 

oInvalidOperationException: 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, TypeT] 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

rDependencyResolutionException: 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

rHttpException (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, MethodInfoI] handlers) +185
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfoI] handlers, IntPtr appContext, HttpContext context) +168
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +277
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +369

rHttpException (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

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


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:
 

   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

System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +517
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfoo] handlers) +185
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfoo] handlers, IntPtr appContext, HttpContext context) +168
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +277
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +369

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +532
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +111
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +719

Sorry for necroposting, but I stumbled upon this post when I was trying to resolve my issue. 

In case some will open this topic like me, here’s the fix that helped me:

My error said:

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

These cases are important. They tell what kind of issue happened.

Case e means that signature in the PX.LicensePolicy.sig file has been corrupted somehow. I’m a developer, and maybe I accidentally pushed files from one instance of a different version to this one. 

Anyway, the fix is to find the location of the ERP installation of the same version (version is crucial!), go to Files → Bin, and find all PX.LicensePolicy files (PX.LicensePolicy.dllPX.LicensePolicy.pdbPX.LicensePolicy.sig; subject to change depending on your version, so don’t freak out if you don’t have .pdb), copy them and paste them into your instance location → Bin (should have more-or-less the same files as ERP Bin folder, use that as your double-check).


Reply