You may experience NFA 9.3.6 Sync failures with CAPC/NPC where you see errors in the ProductSyncWS.log:
0:00:47 3 - Pull - :
Column 'routerAddress' in field list is ambiguous
MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'routerAddress' in field list is ambiguous
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64&
0:00:47 3 - Pull - :
Unknown column 'r.ID' in 'field list'
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'r.ID' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
Due to some of the changes made in NFA 9.3.6, some additional SQL changes may have to be made for some customer environments.