web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Synonym tables - POS?
Microsoft Dynamics AX (Archived)

Synonym tables - POS?

(0) ShareShare
ReportReport
Posted on by Community Member

Due to size limitations on SQL Express, we're being forced to either purge variant data, or look into our options using a synonym table. 

The INVENTDIM table on our POS is 30% of our database. We've moved the table to it's own database, then created a synonym tied to it. The POS seems to launch fine and product appears to be scanning correctly.  However, when I try to push an A/N-1040 (INVENTDIM), I always get a 'failed to execute write'. 

Has anybody played with synonyms before, in regards to the POS? 

*This post is locked for comments

I have the same question (0)
  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: Synonym tables - POS?

    Hi,

    I didn't have experience of using synonyms before, but could you, please, write the full error you receive? ('failed to execute write' is very common)

    Maybe we will find the way to fix your issue

    Regards,

    Oksana

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    Thanks for the interest in helping, Oksana.

    The full error is below.

    [ERROR]

    Target request handler failed to process target request header: ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests.

    ProcessWriteRequestException: Write request on table:[dbo].[INVENTDIM] failed to ex

    [/ERROR]

    Unfortunately, the error column is limited to its characters, so the error gets cut off.

    The user running the sync service on the POS is set as an admin on the POS as well as sysadmin on the database. Below is how we setup the database.

    Databases:

    AxRetailPOS

    ---All POS tables, except for the INVENTDIM

    AxRetailDIM

    ---Only the INVENTDIM table lives here.

    This is the script we used for the synonym.

    [SCRIPT]

    USE [AxRetailPOS]

    GO

    CREATE SYNONYM [dbo].[INVENTDIM] FOR [AxRetailDIM].[dbo].[INVENTDIM]

    GO

    [\SCRIPT]

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    why don't you consider moving the store database to a Full SQL edition rather than Express. continuing the use of Express edition is going to bring you more hiccups.  

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    Purely due to cost. SQL standard has quite a price tag. We have 122 stores(122 databases). The cost will be higher than finding a solution to stay below the 10GB limit on express.

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: Synonym tables - POS?

    Hi,

    You can find full error (without cut) in log file of Sync service (Picture below). Please, have a look there and post full error.

    2016_2D00_04_2D00_02_5F00_16_2D00_25_2D00_35.png

    Regards,

    Oksana 

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    For some reason I can't get the log file to generate. No files get created or custom files don't fill will logs.  

    I've tried more troubleshooting. I found the synonym isn't the issue. It's that the synonym points to a different local database. If I rename the INVENTDIM table to INVENTDIM_OLD, then create a synonym on the same database to point to the renamed table, the synonym works and the N jobs pushes data. However, as soon as I try to use the table on a separate local database, it fails. I feel this might be a SQL issues, but I'm not super familiar with SQL.

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    I was able to get the synce service logging enabled. Below is the error I receive when sending over a batch job to the INVENTDIM table.

    [ERROR]

    2016.4.15 11:39:47:427 (4988) [1] CCommMgr::HandleException: Target request handler failed to process target request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[dbo].[INVENTDIM] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while performing write operation on table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.PerformWriteOperationException: Query: MERGE [dbo].[INVENTDIM] AS dst

    USING (SELECT [CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID] FROM [#dbo_INVENTDIM_9ba7d36e-5fad-4fc6-93cd-7de52aded8f7]) AS src

    ON (dst.[DATAAREAID]=src.[DATAAREAID] AND dst.[INVENTDIMID]=src.[INVENTDIMID])

    WHEN MATCHED THEN

     UPDATE SET [CONFIGID]=src.[CONFIGID],[INVENTBATCHID]=src.[INVENTBATCHID],[INVENTCOLORID]=src.[INVENTCOLORID],[INVENTLOCATIONID]=src.[INVENTLOCATIONID],[INVENTSERIALID]=src.[INVENTSERIALID],[INVENTSIZEID]=src.[INVENTSIZEID],[INVENTSTYLEID]=src.[INVENTSTYLEID],[RECID]=src.[RECID],[WMSLOCATIONID]=src.[WMSLOCATIONID]

    WHEN NOT MATCHED THEN

     INSERT ([CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID])

     VALUES (src.[CONFIGID],src.[DATAAREAID],src.[INVENTBATCHID],src.[INVENTCOLORID],src.[INVENTDIMID],src.[INVENTLOCATIONID],src.[INVENTSERIALID],src.[INVENTSIZEID],src.[INVENTSTYLEID],src.[RECID],src.[WMSLOCATIONID]);

    DROP TABLE [#dbo_INVENTDIM_9ba7d36e-5fad-4fc6-93cd-7de52aded8f7];

    ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'WMSPALLETID', table 'AxRetailDIM.dbo.INVENTDIM'; column does not allow nulls. UPDATE fails.

    The statement has been terminated.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      at CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)

    2016.4.15 11:40:5:36 (4988) [1] CCommMgr::HandleException: Target request handler failed to process target request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[dbo].[INVENTDIM] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while performing write operation on table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.PerformWriteOperationException: Query: MERGE [dbo].[INVENTDIM] AS dst

    USING (SELECT [CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID] FROM [#dbo_INVENTDIM_5c6da785-da26-4e81-b171-28ad2314b41c]) AS src

    ON (dst.[DATAAREAID]=src.[DATAAREAID] AND dst.[INVENTDIMID]=src.[INVENTDIMID])

    WHEN MATCHED THEN

     UPDATE SET [CONFIGID]=src.[CONFIGID],[INVENTBATCHID]=src.[INVENTBATCHID],[INVENTCOLORID]=src.[INVENTCOLORID],[INVENTLOCATIONID]=src.[INVENTLOCATIONID],[INVENTSERIALID]=src.[INVENTSERIALID],[INVENTSIZEID]=src.[INVENTSIZEID],[INVENTSTYLEID]=src.[INVENTSTYLEID],[RECID]=src.[RECID],[WMSLOCATIONID]=src.[WMSLOCATIONID]

    WHEN NOT MATCHED THEN

     INSERT ([CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID])

     VALUES (src.[CONFIGID],src.[DATAAREAID],src.[INVENTBATCHID],src.[INVENTCOLORID],src.[INVENTDIMID],src.[INVENTLOCATIONID],src.[INVENTSERIALID],src.[INVENTSIZEID],src.[INVENTSTYLEID],src.[RECID],src.[WMSLOCATIONID]);

    DROP TABLE [#dbo_INVENTDIM_5c6da785-da26-4e81-b171-28ad2314b41c];

    ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'WMSPALLETID', table 'AxRetailDIM.dbo.INVENTDIM'; column does not allow nulls. UPDATE fails.

    The statement has been terminated.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      at CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)

    2016.4.15 11:40:21:504 (4988) [1] CCommMgr::HandleException: Target request handler failed to process target request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[dbo].[INVENTDIM] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while performing write operation on table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.PerformWriteOperationException: Query: MERGE [dbo].[INVENTDIM] AS dst

    USING (SELECT [CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID] FROM [#dbo_INVENTDIM_c1463bf6-baa5-4baa-b53b-f84bd7529ca5]) AS src

    ON (dst.[DATAAREAID]=src.[DATAAREAID] AND dst.[INVENTDIMID]=src.[INVENTDIMID])

    WHEN MATCHED THEN

     UPDATE SET [CONFIGID]=src.[CONFIGID],[INVENTBATCHID]=src.[INVENTBATCHID],[INVENTCOLORID]=src.[INVENTCOLORID],[INVENTLOCATIONID]=src.[INVENTLOCATIONID],[INVENTSERIALID]=src.[INVENTSERIALID],[INVENTSIZEID]=src.[INVENTSIZEID],[INVENTSTYLEID]=src.[INVENTSTYLEID],[RECID]=src.[RECID],[WMSLOCATIONID]=src.[WMSLOCATIONID]

    WHEN NOT MATCHED THEN

     INSERT ([CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID])

     VALUES (src.[CONFIGID],src.[DATAAREAID],src.[INVENTBATCHID],src.[INVENTCOLORID],src.[INVENTDIMID],src.[INVENTLOCATIONID],src.[INVENTSERIALID],src.[INVENTSIZEID],src.[INVENTSTYLEID],src.[RECID],src.[WMSLOCATIONID]);

    DROP TABLE [#dbo_INVENTDIM_c1463bf6-baa5-4baa-b53b-f84bd7529ca5];

    ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'WMSPALLETID', table 'AxRetailDIM.dbo.INVENTDIM'; column does not allow nulls. UPDATE fails.

    The statement has been terminated.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      at CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)

    [\ERROR]

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: Synonym tables - POS?

    Hi,

    Looks like the main error is Cannot insert the value NULL into column 'WMSPALLETID', table 'AxRetailDIM.dbo.INVENTDIM'; column does not allow nulls. UPDATE fails.

    Please, verify your SQL script forINVENTDIM table in AxRetailDIM database: it should have default value (empty) for WMSPALLETID field (like shown on picture below)

    2016_2D00_04_2D00_18_5F00_21_2D00_21_2D00_39.jpg


    Regards,
    Oksana

  • Community Member Profile Picture
    Community Member on at
    RE: Synonym tables - POS?

    Thanks for the reply. That fixed the NULL error!   But now we're getting a new error. It seems we're hitting a timeout period now..  Is there a Sync Service parameter that I can increment to allocate enough time for the job to process?  

    [ERROR]

    2016.4.20 16:24:36:628 (3596) [1] CCommMgr::HandleException: Target request handler failed to process target request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[dbo].[INVENTDIM] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while performing write operation on table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.PerformWriteOperationException: Query: INSERT INTO [dbo].[INVENTDIM] ([CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID]) SELECT [CONFIGID],[DATAAREAID],[INVENTBATCHID],[INVENTCOLORID],[INVENTDIMID],[INVENTLOCATIONID],[INVENTSERIALID],[INVENTSIZEID],[INVENTSTYLEID],[RECID],[WMSLOCATIONID] FROM [#dbo_INVENTDIM_e043939e-98c6-4bdd-bea3-121b1758e1c2];

    DROP TABLE [#dbo_INVENTDIM_e043939e-98c6-4bdd-bea3-121b1758e1c2];

    ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

      --- End of inner exception stack trace ---

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

      at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()

      at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()

      at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()

      at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction)

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader)

      at CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)

    [\ERROR]

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: Synonym tables - POS?

    Hi,

    It's nice the NULL error was fixed :)

    Try to configure

    1) Thread Time-out in Service configuration wizard: technet.microsoft.com/.../jj679908.aspx

    2) Service Time-out in AX: technet.microsoft.com/.../jj677387.aspx

    Regards,

    Oksana

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans