For documents of type ODBC or ODBC Dynamics, several diagnostics tools are available.
You can find these tools on the Document page > Action Pane > Development tab > ODBC group.
For an explanation of the tools see this table:
Tool | Description |
|---|
SQL table script | For testing purposes, you can generate the SQL script to generate the relevant tables. |
Show query | Based on the document setup, you can show the query. The query shows how the data is read in the SQL database.
You can copy the query for testing purposes. |
Fix enums | Enums in both AX 2012 and D365 F&SCM are expressed in integers. However, in D365 F&SCM you can derive from enums. As a consequence, the same integer can have a different meaning. The Fix enums tools checks for and ODBC Dynamics document if the enum setup is correct: If a field is an enum, it checks if the enum setup in AX 2012 is the same as in D365 F&SCM. If not, the document field setup is changed in this way: If a field is a string with the ODBCEnumName filled, it checks if the enum setup in D365 F&SCM is the same as in AX 2012 or if the enum difference can be ignored. If not the same and difference cannot be ignored, the document field setup is changed in this way: Type => Integer Field length => 10 ODBCEnumName => empty
The Fix enums tool is only available for ODBC Dynamics documents with handler BisDocumentODBCAXDynamics.
|
All indexes | Shows the indexes used in the other database, for example an AX 2012 database or another database. As a document designer, you can use this to see which indexes you can use or to verify if you use the right indexes in the document setup. |
Get SQL info | You can get two types of information (in a ZIP file): SQL server plan: To open it, use SQL Server Manager or another applicable tool. You can check how the query works and get advice on how to improve the query setup in the document. Query: The query that is used to read the SQL database.
When clicked, on the dialog, fill in the parameters and click OK: Test quantity: The number of records you want to process to test the query. Page number: If you use paging in your document setup, enter the number of pages you want to test. Record field: If you use a range in your document setup, you can enter the related record field to only test the records in the range. From date: You can enter a date to limit testing to recent records.
|