Skip to main content
Answer

Server Error in '/AcumaticaERP' Application

  • July 24, 2023
  • 3 replies
  • 677 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

Best answer by sweta68

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

    3 replies

    S
    Semi-Pro III
    Forum|alt.badge.img+9
    • sweta68
    • Semi-Pro III
    • Answer
    • July 24, 2023

    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
    Chris Hackett
    H
    Jr Varsity III
    Forum|alt.badge.img
    • harikanthm60
    • Jr Varsity III
    • April 2, 2024

    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
    andriitkachenko
    Jr Varsity III
    Forum|alt.badge.img+6

    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.dll, PX.LicensePolicy.pdb, PX.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).

    Andrii Tkachenko | Sprinterra | https://www.sprinterra.com/ | If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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