Working with Metadata

about the metadata validator docid\ hcygo3qn4vdsxxcunjwggabout validating metadata docid\ hcygo3qn4vdsxxcunjwggviewing the metadata validator docid\ hcygo3qn4vdsxxcunjwggvalidating metadata docid\ hcygo3qn4vdsxxcunjwggviewing validation results docid\ hcygo3qn4vdsxxcunjwggviewing specific validation results docid\ hcygo3qn4vdsxxcunjwggfixing metadata validation errors and warnings docid\ hcygo3qn4vdsxxcunjwgg about the metadata validator has a metadata validator the metadata validator finds errors and warnings in the metadata, including mismatches and misconfigurations the metadata validator performs metadata validation database schema consistency between the database and metadata definitions settings and data references expression validation validates the expressions contained in the database and application group errors (only shown when metadata is checked) checks if there are any unused forms or lists in the application the tool lists any differences in related fields, missing or invalid references, and exceptions in the source and target business objects and can then fix these errors the metadata validator auto fix function is currently in beta mode starting in release 2016 2, the metadata validator also finds errors and warnings for reverse relationships (also known as paired relationships) and relationships that are not well defined, such as the following relationships (including self relationships) that do not have a reverse relationship this does not apply to relationships that intentionally do not have a reverse relationship or to relationships with a reverse relationship that does not have a tag that identifies the reverse pair relationships with cardinality but the cardinality of the reverse relationship is not the opposite for example, if a relationship has a cardinality of 1 to many, then the reverse relationship must have a cardinality of many to 1 or the application displays an error refer to relationship cardinality docid\ szcp qyw98hbg7iwleeu2 for more information about cardinality relationships that use a link field as a foreign key but the reverse relationship does not use the same foreign key relationships with push constraints but the reverse relationship does not have reversed versions of the push constraints relationships with a constraint but the reverse relationship does not have the reverse constraint relationships where the primary key is not always the recid relationships where the foreign key is neither a < link > recid nor a validated field in the format < field > valid link table based relationships with invalid cardinality the cardinality for these relationships should always be many to many relationships with a null foreign key, except for link table based relationships constraint based relationships with invalid cardinality the cardinality for these relationships should always be either one to one or one to many constraint based relationships with a foreign key that is not null relationships marked with invalid direction attributes for example, a relationship with a normal direction has the primary key in the current business object and the foreign key in the related business object and the cardinality is either one to one or one to many relationships with invalid link field sharing across multiple business objects refer to about relationships docid\ x5d0o2 odcuegqejwo ho for more information about relationships about validating metadata the process for validating metadata is view the metadata validation configuration and then run the validation by selecting run validation in the metadata validation configuration workspace refer to viewing the metadata validator docid\ hcygo3qn4vdsxxcunjwgg and validating metadata docid\ hcygo3qn4vdsxxcunjwgg view the results of the validation run in the metadata validation run workspace refer to viewing validation results docid\ hcygo3qn4vdsxxcunjwgg fix any errors that the application found, from the metadata auto fix workspace refer to fixing metadata validation errors and warnings docid\ hcygo3qn4vdsxxcunjwgg viewing the metadata validator to access the metadata validator, do one of the following in , select more to open the workspace selector the list of available workspaces appears in the search objects field, enter metadata validation config from the configuration console, select build > automation tools > metadata validation config the application displays the metadata validation config workspace select list view to review the default validation settings the application displays either true or false for each of the following items metadata sql schema settings expressions group errors validating metadata you can only run one validation job at a time you have to wait for the current job to finish before you start a new one to access the metadata validator, do one of the following in , select more to open the workspace selector the list of available workspaces appears in the search objects field, enter metadata validation config from the configuration console, select build > automation tools > metadata validation config the application displays the metadata validation config workspace by default all of the options are checked change the settings if needed if you make changes, select save note that changes may have been made previously select run validation the application starts the validation while it is running, the validator lists its status the status can be running, completed, or error this process can take up to 30 minutes to complete, depending on the size of your tenant database to evaluate the status of the validation, select refresh viewing validation results to access the metadata validator in , select more to open the workspace selector the application di splays the list of available workspaces in the search objects field, enter metadata validation run from the configuration console, select build > automation tools > metadata validation run the application displays the metadata validation run workspace, including the following information field description batch number a unique number that the application assigns every time the metadata validator runs the application increments this number by one every time it runs database version the current application database metadata version status the status of the validation can be running, completed, or error only one job can have the status of running at any time progress the status of the validation if it is running metadata displays true if the application validated the metadata, or false if it did not sql schema displays true if the application validated the microsoft sql schema, or false if it did not settings displays true if the application validated the settings, or false if it did not expressions displays true if the application validated the expressions, or false if it did not group errors displays true if the application validated the group errors, or false if it did not started by the name of the user who ran the validation started on the date and time when the validation started ended on the date and time when the validation completed fix status the status of the auto fix feature can be either running or not running fix run date time the date and time when the auto fix feature was last run viewing specific validation results access the metadata validator as described in viewing validation results docid\ hcygo3qn4vdsxxcunjwgg to review the results of a specific job, double click the job number the application displays the following information on each of the following tabs field description batch mode enum the type of validation can be one of the following expressions metadata settings sql schema metadata type enum the business object type, such as layout, quick action, rule, rule override, table, and so on metadata sub type enum the subcategory or the key items inside the metadata such as the table metadata, calculated rules, fields, indexes, form, list, data references, and so on table ref the name of the table with the message message type enum the message type, such as expression parse error, field not found in relationship, and so on message severity the severity of the message can be one of the following error warning information validation message a text message with detailed information to review the errors, select the errors tab the application displays the errors that apply to this validation run you can fix certain errors by using the metadata autofix feature refer to fixing metadata validation errors and warnings docid\ hcygo3qn4vdsxxcunjwgg the following table lists the errors that you can fix, but does not list the errors that cannot be fixed message type meaning childpanelusesmissedrelationship the child tab in the layout references a relationship that no longer exists the validator code allows usage of specific group member business objects (for example, ci computer) as long as the relationship references the corresponding group base business object (for example, ci) the auto fix removes from the layout definition any erroneous child tabs that do not have a valid relationship assigned to them fielddiffersfrombasetable the attributes for a field in a group member business object (for example, ci computer) must not differ from those of the group base business object (for example, ci) the auto fix reconciles the properties of the base and member business object fields such as data type and length, so that all the fields have the accommodating property for example, if a base business object text field has a size of 50 characters and is defined as text, but the member business object field has a size of 100 characters and is defined as unicode text, the fields in the base and all member business objects are updated to be 100 characters and unicode text fielddiffersfromcontracttable the attributes for a field in a concrete business object must be the same as the attributes of the same field in any contract that it implements the auto fix reconciles the properties of the contract and concrete business object fields such as data type and length, so that all the fields have the accommodating property for example, if a contract business object text field has a size of 50 characters and is defined as text, but the concrete business object field has a size of 100 characters and is defined as unicode text, the fields in the contract and all concrete business objects are updated to be 100 characters and unicode text fieldnullablemismatch the nullable attribute of a business object field does not match the actual nullable state of the corresponding column in the table or view the auto fix tries to set the allow null property of the column to what is set in the field if the field is set to false and the database column has a null value, the auto fix logs an exception and the auto fix fails fieldshouldbeuniqueinrelationship to enforce the relationship constraint for one to one relationships, the foreign key field must be marked as unique this fix marks the foreign key field as unique by creating a unique index the auto fix does not precheck for redundant data in the foreign key field, so a runtime error with the unique key error will result during the auto fix in such cases at this point, you must either manually update the relationship so that it is no longer a one to one relationship, or remove the redundant data in the auto fix column indexnotfoundforuniquefield a field that is marked as unique must have a corresponding metadata unique index to check this, the validator does not match based on naming conventions (such as " unique" suffix), but looks in the database for such an indexes, before reporting an error if there is no such index, this fix creates one in both the metadata and the database missingexpressiontreeerror for metadata consistency, all expression references must refer to a valid expression and not be null the validator identifies cases of null expressions this fix creates an expression that returns a constant null to replace each null references pairedrelationshipcardinalitydiffer relationships with cardinality but the cardinality of the reverse relationship is not the opposite for example, if a relationship has a cardinality of 1 to many, then the reverse relationship must have a cardinality of many to 1 or the application displays an error pairedrelationshiprelatedforeignkeydiffer relationships that use a link field as a foreign key but the reverse relationship does not use the same foreign key pairedrelationshipsamedirection relationships marked with invalid direction attributes for example, a relationship with a normal direction has the primary key in the current business object and the foreign key in the "other" business object and the cardinality is either one to one or one to many redundantrecidforconcreteobject there are concrete business objects (for example, account) that inherit their recid from a contract that it implements (for example, frs compositecontract entity) the field must not be inherited, so that only the recid field in the concrete business object is present the auto fix removes the redundant recid field which is inherited from the corresponding contract business object, leaving only the recid column directly from the concrete business object as the sole recid field sqlschemacolumndatatypeincompatible the validator checks for incompatible data types for each field in a business object and the corresponding column in the database table or view the auto fix tries to update the column data type in the database and corresponding changes in metadata the auto fix does not update cases like, if cpucount is defined as numeric in a business object ci#computer as compared to varchar in database table sqlschemacolumnlengthmismatch the validator checks for length mismatch for a business object field as described by the metadata and the corresponding column in the database table or view the auto fix expands either the field length or column length to match the other length for example, if the field length is 10 and the column length is 20, the auto fix updates the field length to 20 alternatively, if the field length is 20 and the column length is 10, the auto fix updates the column length to 20 sqlschemaindexnotfoundforuniquefield a field that is marked as unique does not have a corresponding unique index in the database the auto fix creates a new unique index for the field sqlschemaprimarykeynotfound there is no primary key index for the database table or view based on the primary key field designated in the business object (typically the recid) the auto fix creates a new primary key index for the key field to review the warnings, select the warnings tab the application displays the warnings that apply to this validation run you can fix certain warnings by using the metadata autofix feature refer to fixing metadata validation errors and warnings docid\ hcygo3qn4vdsxxcunjwgg the following table lists the warnings that you can fix, but does not list the warnings that cannot be fixed message type meaning fieldnullablemismatch the nullable attribute of a business object field does not match the actual nullable state of the corresponding column in the table or view the auto fix tries to set the allow null property of the column to what is set in the field if the field is set to false and the database column has a null value, the auto fix logs an exception and the auto fix fails relatedfieldlengthmismatch a validated field in a business object has a different field length than the key field of the corresponding validation business object the auto fix updates the validated field to have the same size as the field from the corresponding business object for example, assume that the status field in the incident business object is defined with a length of 50, and is validated from the status field in the incidentstatus business object if the latter field is defined with a length of 100, then the auto fix updates the status field in the incident business object to be unicode text to be 100 as well relatedfieldtypemismatch a validated field in a business object has a different field type than the key field of the corresponding validation business object the auto fix updates the validated field to have the same type as the field from the corresponding business object for example, assume that the status field in the incident business object is defined as text, and is validated from the status field in the incidentstatus business object if the latter field is defined as unicode text, then the auto fix updates the update the status field in the incident business object to be unicode text as well sqlschemacolumndatatypeincompatible the validator checks for incompatible data types for each field in a business object and the corresponding column in the database table or view the auto fix tries to update the column data type in the database and corresponding changes in metadata the auto fix does not update cases like, if cpucount is defined as numeric in a business object ci#computer as compared to varchar in database table sqlschemaindexnotfound the validator checks for an index defined for the microsoft sql table or view, but does not exist in the corresponding metadata definition the auto fix creates an index in the metadata based on the index in the database sqlschemaindexnotfoundforuniquefield a field that is marked as unique does not have a corresponding unique index in the database the auto fix creates a new unique index for the field sqlschemaprimarykeynotfound there is no primary key index for the database table or view based on the primary key field designated in the business object (typically the recid) the auto fix creates a new primary key index for the key field unusedform the validator checks for forms that are not referenced by any layout definitions this fix deletes all such forms unusedgrid the validator checks for lists that are not referenced by any layout definitions this fix deletes all such lists unusedpicklist there are pick lists that are not referenced by any layout definitions to review the validation messages, select the validations tab the application displays the validation messages that apply to this validation run to review all of the errors, warnings, and validation messages, select the all tab the application displays all of the errors, warnings, and validation messages that apply to this validation run to view the validation configuration details, select the validation configuration tab fixing metadata validation errors and warnings after you have configured and run the metadata validator, the application populates the metadata auto fix (beta) workspace with information about available fixes the available fixes are grouped according to category and the application lists the last date that the autofix feature was run for each category each category has its own run button, so you must fix each one individually we recommend that you validate the metadata just before running the autofix feature check the value of the ended on field in the metadata validation config workspace to review the last date when the autofix feature was run metadata validation auto fix categories expressions missing expression tree simplify expressions metadata child panel uses missed relationship field differs from base table field differs from contract table field should be unique in relationship index not found for unique field redundant recid for concrete object related field length mismatch related field type mismatch unused form unused grid database db column data type mismatch db full text index not found db index not found db index not found for unique field incompatible db column data type index not found in metadata mismatch in db column length mismatch in db field nullable attribute missing db table primary key using the auto fix feature to fix the errors, you must run the metadata auto fix for one error at a time after fixing an error, you must validate the data again before fixing another error because fixing one error might change the data before you begin, validate the data refer to validating metadata docid\ hcygo3qn4vdsxxcunjwgg from the configuration console, select build > automation tools > metadata auto fix (beta) review the list of available fixes select run next to a category to fix the error the application displays started under the run button select reload auto fixes to reload the page the application refreshes the page and removes any errors that have been fixed the application updates the value of the last run field to fix another error, revalidate the data (refer to validating metadata docid\ hcygo3qn4vdsxxcunjwgg ), and repeat steps 1 4