You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This article describes how to generate a Customization Analysis Report for your model. It also describes some best practice rules that are included in the report, and provides suggestions for fixing errors and warnings that are associated with these rules.
What is the Customization Analysis Report?
The Customization Analysis Report is a tool that analyzes your customization and extension models, and runs a predefined set of best practice rules. The report is one of the requirements of the solution certification process. The report is in the form of a Microsoft Excel workbook.
How to generate the report
The xppbp.exe tool is located in c:\packages\bin or I:\AosService\PackagesLocalDirectory\bin.
To generate the Customization Analysis Report, run the following command in a development environment.
This section describes all best practice rules (errors, warnings, or informational messages) that can appear on the Issues List page of the report and provides suggestions for fixing the issues. Issues are of the metadata or code type. For all code issues, keep in mind that, if the warning or error occurs in a method that you've overlaid, the lines of code that violate the rule might belong to a model in a lower layer. In that case, you're not responsible for fixing warnings and errors in code that isn't yours.
BPCheckPackReturnsConnull
Description
This rule applies to all classes that implement the SysPackable interface. It makes sure that the Pack method doesn't return Connull().
Error message
Container pack method returns connull in a Runbase derived class
Issue type/severity
Code/Warning
How to fix it
Update the return value of the Pack method, or return Super() when applicable.
BPCheckParametersModified
Description
This rule fails if a parameter of a method is modified inside a method.
Error message
Parameter 1% in method %1 are modified inside the method
Issue type/severity
Code/Warning
How to fix it
Refactor your code. Parameters must be modified by the caller, not within the called method.
BPCheckSQLCode
Description
This rule fails if your X++ code contains direct SQL code.
Error message
SQL code found in method %1
Issue type/severity
Code/Warning
How to fix it
Refactor your code to use X++ to access the database.
BPCheckNestedLoopInCode
Description
This rule fails if it finds a while select loop nested within a loop.
Error message
Nested data access loop found in %1 method
Issue type/severity
Code/Warning
How to fix it
Refactor your code to use joins instead of nested data access loops. If you can't refactor the code without altering the business logic of your method, document an exception when you submit your Customization Analysis Report to Microsoft.
BPCheckInsertMethodInLoop
Description
This rules fails if it finds a call to the method insert nested inside a loop. We recommend that you use InsertRecordList. This rule doesn't apply to InMemory tables.
Error message
Insert method can be replaced with RecordInsertList in method %1
Issue type/severity
Code/Warning
How to fix it
Refactor your code to use set-based operations, such as InsertRecordList.
BPCheckSelectwithJoin
Description
This rule fails if it finds nested select statements that aren't joined.
Error message
Nested select statement in %1 method can be joined
Issue type/severity
Code/Warning
How to fix it
Refactor your code to use joins instead of a nested select statement. If you can't refactor the code without altering the business logic of your method, document an exception when you submit your Customization Analysis Report to Microsoft.
BPFunctionCallwithSelect
Description
This rule fails if a function call is found within a select statement.
Error message
Function call found in select statement in method %1
Issue type/severity
Code/Warning
How to fix it
Assign the function's return value to a local variable before you call the select statement, and use the local variable in the select statement.
BPCheckinvalidExecuteQuery
Description
This rule fails if a call to addRange is found after a call to super() in the ExecuteQuery method.
Error message
Add range after super() should not be added in ExecuteQuery method for form %1
Issue type/severity
Code/Warning
How to fix it
Refactor your code to avoid this pattern.
BPCheckInvalidInitFormMethod
Description
This rule makes sure that you don't initialize form controls and data sources in a form's init method before you call super(). It fails if it finds a statement that uses element or this before the call to super() (this.aMethod() or element.aMethod()). An informational message is shown only for some allowed patterns, such as initializing number sequences (numberSeqPreInit).
Error message
Form element statements should not be used before super() in init method of form %1
Issue type/severity
Code/Info or Warning
How to fix it
Refactor your code to access form controls and data after the call to super(). If your code doesn't initialize any form control and doesn't access any form data sources before super(), document an exception when you submit your Customization Analysis Report to Microsoft.
BPCheckEmptyLoop
Description
This rule fails if it finds loops that have no statements.
Error message
Empty loop found in method %1 in class %2
Issue type/severity
Code/Warning
How to fix it
Remove the loop from your code.
BPCheckLockQueryRange
Description
This rule fails if the code calls AddRange in the init method of the form, and doesn't set the range as locked or hidden.
Error message
Range should be locked or hidden in form %1
Issue type/severity
Code/Warning
How to fix it
Add QueryBuildRange.status(RangeStatus::Locked) or QueryBuildRange.status(RangeStatus::Hidden) after the call to AddRange.
BPCheckSkipStatementValidation
Description
This rule reports an informational message if it finds a set-based operation that doesn't have Skip statements.
When update_recordset is found, the rule checks for skipDataMethods(true). The rule applies only when the update method on the table is overridden.
When insert_recordset is found, the rule checks for skipDataMethods(true). The rule applies only when the insert method on the table is overridden.
When delete_from is found, the rule checks for skipDeleteActions(true). The rule applies only when the insert method on the table is overridden.
This is an informational message that highlights the need to call skip methods to take full advantage of the performance gains of set-based operations. If skip methods are not used, the execution falls back to a row-by-row operation.
Error message
Set-based operation must invoke Skip statements in method %1 in class %2; otherwise, execution will fall back to a row by row operation.
Issue type/severity
Code/Information
How to fix it
Use skipDataMethods(true) or skipDeleteActions(true) when applicable.
BPCheckNoTTSTryBlock
Description
This rule fails if it finds a try statement within a tts block that isn't handled correctly.
Error message
Tts block with Try statement does not explicitly catch exceptions in method %1
Issue type/severity
Code/Warning
How to fix it
Use the code example that follows this table.
The following examples show when the rule will fail or pass. Use these examples as guidelines to refactor your code.
This rule checks for table methods that have no source code. Empty table methods cause record-set operations on the table to fall back to a row-by-row operation.
Error message
%1 table has an empty %2 method
Issue type/severity
Code/Warning
How to fix it
Remove this method from your code.
BPCheckBatchJobsEnabled
Description
This rule makes sure that all classes that extend RunBaseBatch have a canGoBatch method that returns true.
Error message
Custom job is not batch-enabled in class %1
Issue type/severity
Code/Warning
How to fix it
The canGoBatch method must return true for all batch classes.
BPCheckDisplayMethodCached
Description
For each control that is bound to a data method, this rules fails if one of these conditions is met:
The Cache Data Method property is set to Auto, the corresponding table display/edit method doesn't have the SysClientCacheDataMethodAttribute, and the init method of the data source doesn't use CacheAddMethod.
The Cache Data Method property is set to No, and the init method of the data source doesn't use CacheAddMethod.
Error message
Display method %1 in form %2 not cached
Issue type/severity
Code/Warning
How to fix it
Use the note that follows this table.
You can fix this warning by using one of the following patterns:
Set the Cache Data Method property to Yes.
Set the Cache Data Method property to Auto, and mark the data method of the table with the SysClientCacheDataMethodAttribute attribute. Here is an example.
Use CacheAddMethod in the init method of the form to mark the method as cached.
BPCheckSQLQueryInInit
Description
This rule fails if a data access query that has a while loop is found in the init method of a form. This pattern could cause performance issues when the form is initialized.
Error message
SQL query with while loop was found in init method of form %1
Issue type/severity
Code/Warning
How to fix it
Refactor your code to avoid this pattern.
BPCheckNewQueryWithForm
Description
This rule fails if it finds the new Query() statement in the init or executeQuery method of a form.
Error message
Data source query overridden in form method %1
Issue type/severity
Code/Warning
How to fix it
Refactor your code to avoid this pattern.
BPCheckSelectForUpdateAbsent
Description
This rule fails if Select ForUpdate is used to select records, but an update isn't being performed. This rules doesn't apply to tables that are enabled for Optimistic Concurrency Control (OCC).
Error message
Select ForUpdate not implemented in method %1
Issue type/severity
Code/Warning
How to fix it
Use Select instead of Select ForUpdate, or set the OCC Enabled property to Yes on the table.
BPCheckTablePropertyMismatch
Description
This rule fails when the table belongs to a table group but doesn't have the appropriate Cache Lookup value. The rule fails if one of these conditions is met:
The Table Group property is set to Main, and the Cache Lookup property is set to NotinTTS or EntireTable.
The Table Group property is set to Group or Parameter, and the Cache Lookup property is set to NotinTTS.
The Table Group property is set to WorksheetHeader, WorksheetLine, or Transaction, and the Cache Lookup property is set to Found, FoundAndEmpty, or EntireTable.
Error message
%1 table has an invalid combination of table group and cache lookup
Issue type/severity
MetaData/Warning
How to fix it
Set an appropriate Cache Lookup value on the table.
BPCheckMissingDeleteActions
Description
This rule validates that the value of either a delete action or the On Delete property of a table relation isn't equal to None. The rule isn't triggered when the related or current table is a tempDB, in memory table, reference table, staging table, or parameter table.
Error message
Delete actions missing in table %1 which is related to table %2 with relation name %3
Issue type/severity
MetaData/Warning
How to fix it
Set a delete action value that isn't equal to None.
BPCheckAddressModel
Description
This rule fails if a table field is of the AddressZipCodeId or AddressStateId type. These types indicate that the code didn't uptake the newer Address framework.
Error message
Field %1 of table %2 is not part of address location model
Issue type/severity
MetaData/Warning
How to fix it
Replace these types with any other appropriate EDT type in the Directory model.
BPCheckDimensionModel
Description
This rule fails if a table field is of the Dimension or LedgerAccount type. These types indicate that the code didn't uptake the newer Financial Dimension framework.
Error message
Field %1 of table %2 is not part of financial dimension framework
Issue type/severity
MetaData/Warning
How to fix it
Replace these types with any other appropriate EDT type in the Dimensions model.
BPCheckNumberofNewFields
Description
This rule verifies that no more than 10 fields were added to a table during the process of customizing or extending that table. This rule doesn't apply to staging tables.
Error message
Number of new fields in table %1 is greater than
Issue type/severity
Metadata/Warning
How to fix it
Refactor your schema and create related tables instead of adding too many fields to an existing table.
BPCheckEnumUpgradeIssue
Description
This rule fails when the following condition is met: When you customize an enum (overlayer), new enum values are less than the maximum existing value + 10. This rules doesn't apply to extensible enums.
Error message
Enum %1 will have upgrade issues
Issue type/severity
MetaData/Warning
How to fix it
Use larger enum values, or extend the enum.
BPCheckPassiveJoinUse
Description
This rule validates that, when a form allows for pre-loading of data, the link type of tab page data sources is passive. The rule fails if all the following conditions are met:
A form has the AllowPreLoading property set to Yes.
A tab page on the form is bound to a top-level data source.
The data source's Join Source property is set.
The data source's Link Type property isn't set to Passive.
Error message
New message suggest: "Use passive joins on data sources %1 bound to a tab page control in form %2"
Issue type/severity
MetaData/Warning
How to fix it
Set the AllowPreLoading property to No on the form, or use passive joins on the data source. Passive joins require that you explicitly program when the query of a tab page is run.
BPCheckAlternateKeyAbsent
Description
This rule verifies that tables that have a unique index have at least one alternate key.
Error message
Table %1 does not have an alternate key
Issue type/severity
MetaData/Warning
How to fix it
Set the Alternate Key property to Yes on a unique index of the table.
BPCheckBaseTableModified
Description
This rule discourages the customization (overlayering) of a list of specific base tables that are shipped by Microsoft. Examples are the SourceDocumentHeader and SourceDocumentLine tables.