Skip to main content
Answer

error on update standard costs (unknown SQL Database Type)

  • October 13, 2025
  • 6 replies
  • 46 views
J
Varsity III
Forum|alt.badge.img

Has anyone gotten this error before? I am trying to update standard cost on a local version of acumatica. i have unpublished all customizations, restarted it, and restarted the computer but i keep getting this error. Below is the information from the trace. Im not sure what would be causing this but it wont let me update any costs. This instance is used solely for testing so its not obstructing our business process, but i am unable to do any tests with a sql view that i am making.

at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at PX.Data.PXDbTypeConverter.SqlDbTypeToPXDbType(SqlDbType sqlType) at PX.Data.PXDatabaseProviderBase.<SelectOriginalValues>d__156.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at PX.Data.PXDatabaseProviderBase.Update(Type table, PXDataFieldParam[] pars) at PX.Objects.IN.INUpdateStdCostProcess.UpdateStdCost(INUpdateStdCostRecord itemsite) at PX.Data.PXProcessingBase`1.<>c__DisplayClass100_0`1.<SetProcessDelegate>b__1(Graph g, Table r, CancellationToken _) at PX.Data.PXProcessing.<>c__DisplayClass9_0`2.<ProcessItem>b__0(TTable item, CancellationToken itemCancellationToken) at PX.Data.PXProcessing.ProcessItem[TTable](List`1 list, Int32 i, Action`2 action, PXProcessingInfo`1 info, CancellationToken cancellationToken) at PX.Data.PXProcessing.ProcessItem[TState,TTable](TState state, List`1 list, Int32 i, Action`3 action, PXProcessingInfo`1 info, CancellationToken cancellationToken) at PX.Data.PXProcessing.ProcessItemsParallel[TGraph,TTable](List`1 list, Action`3 action, Func`1 factory, PXParallelProcessingOptions parallelOpt, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass99_0`1.<SetProcessDelegateCore>b__0(List`1 list, CancellationToken cancellationToken) at PX.Data.PXProcessing`1.<>c__DisplayClass87_0.<Process>b__1(CancellationToken cancellationToken) at PX.Async.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken) at PX.Async.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at PX.Async.Internal.PXThreadPool.RunItem(RequestItem item) at PX.Async.Internal.PXThreadPool.Run() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

Best answer by justen0351

Update- in standard costs screen, it says it fails, but if i restart the sql database in SSMS, it will update it.  that is the only way the values get updated.

6 replies

darylbowman
Captain II
Forum|alt.badge.img+15

Is it possible your web.config is misconfigured? There are several sections regarding the database connection:
 

<px.core>
    <pxdatabase defaultProvider="PXSqlDatabaseProvider">
      <providers>
        <remove name="PXSqlDatabaseProvider" />
        <add name="PXSqlDatabaseProvider" type="PX.Data.PXSqlDatabaseProvider, PX.Data" connectionStringName="ProjectX" companyID="" secureCompanyID="False" />
        <!--<add name="PXSqlDatabaseProvider" type="PX.MySql.MySqlDatabaseProvider, PX.MySql" connectionStringName="ProjectX_MySql" companyID="" secureCompanyID="false" groupConcatMaxLength="1048576" />-->
      </providers>
    </pxdatabase>
//...
</px.core>
<configuration>
  //...
  <connectionStrings>
    <remove name="ProjectX" />
    <add name="ProjectX" providerName="System.Data.SqlClient" connectionString="Data Source=MASKED;Initial Catalog=Demo25R1;Integrated Security=False;User ID=user;Password=password;Encrypt=False;Trust Server Certificate=False" />
  </connectionStrings>
</configuration>

 

Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
J
Varsity III
Forum|alt.badge.img
  • justen0351
  • Author
  • Varsity III
  • October 13, 2025

​@darylbowman If it was that, wouldnt i have other issues as well? this is the only issue i have from standard acumatica processes in there. everything else works fine. It used to work fine but i tried to run one recently and it messed up and i havent been able to use it since.

darylbowman
Captain II
Forum|alt.badge.img+15

​If it was that, wouldnt i have other issues as well?

Seems like it, yeah. You can save other records?

Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
J
Varsity III
Forum|alt.badge.img
  • justen0351
  • Author
  • Varsity III
  • October 13, 2025

​@darylbowman everything else works fine. Updating standard costs is the only thing that doesn’t work. If I try to do any item in there, I get the error. I haven’t done any customization to that screen or table either. I just have a sql view that refers to ambomcosthistory table and I was trying to add a record to see the updated value and I get the error everytime I try to. 

darylbowman
Captain II
Forum|alt.badge.img+15

I see in the code that it’s doing a direct database update with PXUpdateJoin<>.Update and PXDatabase.Update, which explains why it’s behaving differently. I’m afraid I can’t be of much more help.

Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
J
Varsity III
Forum|alt.badge.img
  • justen0351
  • Author
  • Varsity III
  • Answer
  • October 13, 2025

Update- in standard costs screen, it says it fails, but if i restart the sql database in SSMS, it will update it.  that is the only way the values get updated.

darylbowman
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