最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Dynamics AX 2012 R3 Retail Error when syncing metadata: ‘The table [Table] does not exist’

网络文摘 William 818浏览 0评论

You may see the error ‘The table NoSaleFiscalDocumentTransaction_BRT does not exist’ when attempting to sync the metadata via the ‘Sync Metadata’ (Figure 1) in AX 2012 R3 Retail (Figure 2) This is because the temporary table for the tables in question need to be run. The ‘…T’ at the end of the error (.._BRT in this case) indicates its temporary for the main table. The tables where these are created are determined through the subjobs for that PJob. So you’ll need to do this when you add tables to sync back/forth between the POS and AX. You generate these temporary tables by clicking on the ‘Create staging table’ button in the scheduler job form (Figure 3). You only need to do this for ‘Pull’ type schedule jobs. You can determine which these are via the ‘Is Upload’ check box. Best practices dictates that your Pjobs should always be named with the prefix ‘P-…’ if the ‘Is Upload’ box is checked. NOTE: When you click ‘Create staging table’, there are AOT objects created. Make sure you are in the correct layer/model where you want these created. Upon clicking on the ‘Create staging table’ button, you will see the information in Figure 4. The tables are created in the AOT. You can verify if you want. Then go back and hit the ‘Sync metadata’ button and you’ll see the successful sync in Figure 5.

0
Figure 1 – ‘Sync metadata’ button on the Retail Scheduler parameters
1
 Figure 2 – The Error thrown when attempting to sync the metadata
2
Figure 3 – The P-Job with ‘Create Staging table’ button
3
Figure 4 – The TempDB tables created from ‘Create Staging table’ button
4
Figure 5 – What you see when you successfully sync metadata

转载请注明:ww12345678 的部落格 | AX Helper » Dynamics AX 2012 R3 Retail Error when syncing metadata: ‘The table [Table] does not exist’

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址