I have extension table to add few fields to existing RetailTransactionTable in back office, channel db and offline db. In addition, I have a view with joins to ax.RetailTransactionTable and ext schema table. In the RetailCdxSchema extension, I have used the ext schema view instead of a ext table. The P-Job works fine but when transactions are created in offline mode, those transactions are not sent to channel db when connected to retail server again.
Event logs for retail server shows - Failed to merge data into table [EXT].[tablename]. Cannot read primary key column names from database.