Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

Posted on by 60

After the Retail components installed on the VM and ran the 1070 - Channel configuration Job from Distribution Scheduled and run now, and waited for a couple of minutes and Check the download sessions, I'm able to see the record on 1070 and status shows as  Started and later it will convert to "Apply failed" in download session.

I have followed the Microsoft Retail component installation guide.

Here is the error message captured in the message column and also in the event viewer. Both messages are identical.

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:[ax].[COMPANYIMAGE] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Exception occured in GetPrimaryKeyColumnNames ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.GetPrimaryKeyColumnNamesException: Primary key is not defined on table: COMPANYIMAGE, schema: ax
at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.GetPrimaryKeyColumnNames(SqlConnection connection, SqlTransaction transaction)
at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
--- End of inner exception stack trace ---
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 Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)

Based on the error message, what I understood is Asyncclient services are trying to get the primary key column from the CompanyImage table to perform a write operation and unable to fetch. So I have deleted the primary key and recreated the primary constraint and also the same with indexes. But no luck :(

Can someone help me with this? 

Here are the troubleshooting performed:

1. Recycle the Retail Async Client services in Windows Services.

2. Recycle the AOS services.

3. Perform Sync Metadata under parameters --> Retail scheduler parameters

4. Verified Indexes on the ax.companyimage and also check the data in the table. 0 records exist.

5.  Drop the company image table and recreated the table.

6. Verified the configuration file of both Retail Async clients, Retail Async Server, Retail Sync services.

7. Verify the connectivity between the Async server and Async Client by running the AsyncClientconfigurationUtility and seen connection successful message

Is there anything I have missed during the installation or any sequence of Schedule jobs executes.

Thanks in Advance.

Categories:
  • RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Hi Chandra ,

    Please open new thread for the new error .

  • chandra Meesala Profile Picture
    chandra Meesala 60 on at
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Due to this Im not able to launch the POS Application. Im getting the Register doesnt exist.how ever the register is exist and attached to the store.

    Please find the POS application errror message.

    <E2ETraceEvent xmlns="schemas.microsoft.com/.../E2ETraceEvent"><System xmlns="schemas.microsoft.com/.../Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2020-07-23T08:19:31.4145135Z" /><Source Name="RetailNetTracer" /><Correlation ActivityID="{a33ea7bf-d69b-452c-95b7-ae9d13a75588}" /><Execution ProcessName="POS" ProcessID="8756" ThreadID="1" /><Channel/><Computer>server</Computer></System><ApplicationData>ApplicationSettings.LoadSettingsForTerminal(): System.Exception: Information about register: GGSHYD-1 was not found..<System.Diagnostics xmlns="schemas.microsoft.com/.../E2ETraceEvent><E2ETraceEvent xmlns="schemas.microsoft.com/.../E2ETraceEvent"><System xmlns="schemas.microsoft.com/.../Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2020-07-23T08:19:31.6945361Z" /><Source Name="RetailNetTracer" /><Correlation ActivityID="{a33ea7bf-d69b-452c-95b7-ae9d13a75588}" /><Execution ProcessName="POS" ProcessID="8756" ThreadID="1" /><Channel/><Computer>server</Computer></System><ApplicationData>LSRetailPosis.Settings.ApplicationSettings: System.Exception: Information about register: GGSHYD-1 was not found.&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.LoadSettingsForTerminal(Terminal terminal)&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.InitializeSettings(String[] args).<System.Diagnostics xmlns="schemas.microsoft.com/.../E2ETraceEvent><E2ETraceEvent xmlns="schemas.microsoft.com/.../E2ETraceEvent"><System xmlns="schemas.microsoft.com/.../Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2020-07-23T08:19:31.7315392Z" /><Source Name="RetailNetTracer" /><Correlation ActivityID="{a33ea7bf-d69b-452c-95b7-ae9d13a75588}" /><Execution ProcessName="POS" ProcessID="8756" ThreadID="1" /><Channel/><Computer>server</Computer></System><ApplicationData>LSRetailPosis.POS.Program: System.Exception: Information about register: GGSHYD-1 was not found.&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.LoadSettingsForTerminal(Terminal terminal)&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.InitializeSettings(String[] args)&#xD;&#xA;   at LSRetailPosis.POS.Program.InitializeAndLoadPOS(String[] args, Boolean owned, SplashScreenForm splashScreenForm).<System.Diagnostics xmlns="schemas.microsoft.com/.../E2ETraceEvent><E2ETraceEvent xmlns="schemas.microsoft.com/.../E2ETraceEvent"><System xmlns="schemas.microsoft.com/.../Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2020-07-23T08:19:52.8922439Z" /><Source Name="RetailNetTracer" /><Correlation ActivityID="{a33ea7bf-d69b-452c-95b7-ae9d13a75588}" /><Execution ProcessName="POS" ProcessID="8756" ThreadID="1" /><Channel/><Computer>server</Computer></System><ApplicationData>LSRetailPosis.POS.Program: LSRetailPosis.PosisException ---> System.Exception: Information about register: GGSHYD-1 was not found.&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.LoadSettingsForTerminal(Terminal terminal)&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.InitializeSettings(String[] args)&#xD;&#xA;   at LSRetailPosis.POS.Program.InitializeAndLoadPOS(String[] args, Boolean owned, SplashScreenForm splashScreenForm)&#xD;&#xA;   --- End of inner exception stack trace ---&#xD;&#xA;   at LSRetailPosis.POS.Program.InitializeAndLoadPOS(String[] args, Boolean owned, SplashScreenForm splashScreenForm)&#xD;&#xA;   at LSRetailPosis.POS.Program.Main(String[] args).<System.Diagnostics xmlns="schemas.microsoft.com/.../E2ETraceEvent><E2ETraceEvent xmlns="schemas.microsoft.com/.../E2ETraceEvent"><System xmlns="schemas.microsoft.com/.../Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2020-07-23T08:19:52.8952450Z" /><Source Name="RetailNetTracer" /><Correlation ActivityID="{a33ea7bf-d69b-452c-95b7-ae9d13a75588}" /><Execution ProcessName="POS" ProcessID="8756" ThreadID="1" /><Channel/><Computer>server</Computer></System><ApplicationData>LSRetailPosis.POS.Program: System.Exception: Information about register: GGSHYD-1 was not found.&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.LoadSettingsForTerminal(Terminal terminal)&#xD;&#xA;   at LSRetailPosis.Settings.ApplicationSettings.InitializeSettings(String[] args)&#xD;&#xA;   at LSRetailPosis.POS.Program.InitializeAndLoadPOS(String[] args, Boolean owned, SplashScreenForm splashScreenForm).<System.Diagnostics xmlns="schemas.microsoft.com/.../E2ETraceEvent>

  • chandra Meesala Profile Picture
    chandra Meesala 60 on at
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Logfile.txtHi Shaimaa,

    After adding the missing table which is related to 1070 job, started executing sucessfull(Available --> download --> applied). But now i'm getting different error for the different job 1090 - Register.

    Here is the error message:

    Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessSourceRequestHeaderException: ProcessTargetRequestHeader failed due to an InvalidOperationException.

    connectionString: Data Source=SQLSERVER01;Initial Catalog=HYDStoreChannelDB;Integrated Security=True;Connect Timeout=60;Application Name="Commerce Data Exchange Async Client" ---> System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.

      at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)

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

      at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)

      at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)

      at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)

      at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)

      at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)

      at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)

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

      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)

      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 Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)

    Im not sure what i need to do. All the options are exhausted. One more interesting thing, what i found from the AsyncClientService.exe_00 is invalid column "ROWVERSION". For more details Im attaching you the log. This file huge and unformated file. Please be careful.

  • chandra Meesala Profile Picture
    chandra Meesala 60 on at
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Thank you Shaimaa. I have raised microsoft ticket. Im not sure how long it will take. In mean while i have verified that some of the tables are missing when i'm comparing with Subjobs and Retail channel db. is there way i can run it  that can update the Channel db and Dynamics AX db both are db are insync

  • Suggested answer
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Hi Chandra,

    So I would suggest you to open support request for further investigation as may be accessing your system to check the issue will be required .

  • chandra Meesala Profile Picture
    chandra Meesala 60 on at
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    HI Shaimaa, Thank you so much for the help. I'm sorry for the delay in response. I have verified it and found AX table and Subjob fields of the companyimage table are identical.

    Here are the details:

    pastedimage1594285422915v1.png

    AOT:

    pastedimage1594285439190v2.png

    I have tried to perform the below

    pastedimage1594285471348v3.png

    From the Database side, I have checked the table (company image)

    pastedimage1594285643444v4.png

    Still, I'm getting the same error.

  • RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Can you check this table from HQ side and check subjob fields mapping ?, if this field exists please remove it from fields mapping as it's not a part from AX schema table

  • chandra Meesala Profile Picture
    chandra Meesala 60 on at
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Thank you Shaimaa.

    I tried your script. But still, I'm getting the error message. Please find the below exception msg captured from Download session & Event viewer.

                   Error Message from the Download session

                   ---------------------------------------

    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:[ax].[COMPANYINFO] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while creating temporary table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.CreateTempTableException: Query: SELECT TOP 0 [CNAE_BR],[DATAAREA],[RECID] INTO [#ax_COMPANYINFO_13843e75-5b42-4fee-9510-ed4505a34805] FROM [ax].[COMPANYINFO];

    ALTER TABLE [#ax_COMPANYINFO_13843e75-5b42-4fee-9510-ed4505a34805] ADD PRIMARY KEY ([RECID]);

    ---> System.Data.SqlClient.SqlException: Invalid column name 'CNAE_BR'.

      at System.Data.SqlClient.SqlConnection.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& usedCache, Boolean asyncWrite, Boolean inRetry)

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

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

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

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(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 Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)

      ---------------------------------------

      Error Message from the Event Viewer

      ApplySessionFileToClientDatabase encountered Exception. Error Details: 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:[ax].[COMPANYINFO] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while creating temporary table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.CreateTempTableException: Query: SELECT TOP 0 [CNAE_BR],[DATAAREA],[RECID] INTO [#ax_COMPANYINFO_80ca526a-e788-477b-92b6-ded65503a40f] FROM [ax].[COMPANYINFO];

    ALTER TABLE [#ax_COMPANYINFO_80ca526a-e788-477b-92b6-ded65503a40f] ADD PRIMARY KEY ([RECID]);

    ---> System.Data.SqlClient.SqlException: Invalid column name 'CNAE_BR'.

      at System.Data.SqlClient.SqlConnection.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& usedCache, Boolean asyncWrite, Boolean inRetry)

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

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

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

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(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 Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)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:[ax].[COMPANYINFO] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while creating temporary table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.CreateTempTableException: Query: SELECT TOP 0 [CNAE_BR],[DATAAREA],[RECID] INTO [#ax_COMPANYINFO_80ca526a-e788-477b-92b6-ded65503a40f] FROM [ax].[COMPANYINFO];

    ALTER TABLE [#ax_COMPANYINFO_80ca526a-e788-477b-92b6-ded65503a40f] ADD PRIMARY KEY ([RECID]);

    ---> System.Data.SqlClient.SqlException: Invalid column name 'CNAE_BR'.

      at System.Data.SqlClient.SqlConnection.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& usedCache, Boolean asyncWrite, Boolean inRetry)

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

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

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

      at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(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 Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)

  • Suggested answer
    RE: AX 2012 R3 CU12 - Retail - 1070 - Channel Configuration Job Failed

    Hi Chandra ,

    Below is the table definition from standard environment  Please execute the below script to drop the current one and recreate it 

    pastedimage1594023408358v2.png

    ALTER TABLE [ax].[COMPANYIMAGE] DROP CONSTRAINT [DF_COMPANYIMAGE_REFTABLEID]
    GO

    ALTER TABLE [ax].[COMPANYIMAGE] DROP CONSTRAINT [DF_COMPANYIMAGE_REFRECID]
    GO

    ALTER TABLE [ax].[COMPANYIMAGE] DROP CONSTRAINT [DF_COMPANYIMAGE_REFCOMPANYID]
    GO

    /****** Object: Table [ax].[COMPANYIMAGE] Script Date: 7/6/2020 1:13:44 AM ******/
    DROP TABLE [ax].[COMPANYIMAGE]
    GO

    /****** Object: Table [ax].[COMPANYIMAGE] Script Date: 7/6/2020 1:13:44 AM ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE [ax].[COMPANYIMAGE](
    [RECID] [bigint] NOT NULL,
    [IMAGE] [varbinary](max) NULL,
    [REFCOMPANYID] [nvarchar](4) NOT NULL,
    [REFRECID] [bigint] NOT NULL,
    [REFTABLEID] [int] NOT NULL,
    [DATAAREAID] [nvarchar](4) NOT NULL,
    [ROWVERSION] [timestamp] NOT NULL,
    CONSTRAINT [I_-253444906_2053811754] PRIMARY KEY CLUSTERED
    (
    [REFCOMPANYID] ASC,
    [REFTABLEID] ASC,
    [REFRECID] ASC,
    [DATAAREAID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    GO

    ALTER TABLE [ax].[COMPANYIMAGE] ADD CONSTRAINT [DF_COMPANYIMAGE_REFCOMPANYID] DEFAULT ('') FOR [REFCOMPANYID]
    GO

    ALTER TABLE [ax].[COMPANYIMAGE] ADD CONSTRAINT [DF_COMPANYIMAGE_REFRECID] DEFAULT ((0)) FOR [REFRECID]
    GO

    ALTER TABLE [ax].[COMPANYIMAGE] ADD CONSTRAINT [DF_COMPANYIMAGE_REFTABLEID] DEFAULT ((0)) FOR [REFTABLEID]
    GO

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans