There were errors found within the database while Validating. Please fix these errors and run the Validator again. Contact Aptify Support if you need help resolving these problems.

• Failed Validation Rules
  • Rule : Validate Dependent database objects
    1. Validates dependent database object for selected database objects are part of pack. All required database object should be present in the pack or on destination server.

    2. Record Name: spGeteBusiness6_0DirectoryMemberDetails

    4. Status: Failure to Validate

    5. Details: 1 record has been identified which contains invalid information. To get a list of the records to be reviewed, the following query should be executed:

       SELECT OBJECT_NAME(referencing_id) AS [Selected DBobject Name], referenced_entity_name as [First Level Dependent], STUFF( (SELECT ', ' + OBJECT_NAME(d2.referenced_id ) FROM sys.sql_expression_dependencies d2 WHERE d2.referencing_id = OBJECT_ID (sed.referenced_entity_name ) ORDER BY OBJECT_NAME(d2.referencing_id) FOR XML PATH('')), 1, 1, '') AS [Dependent Objects Nth Level] FROM sys.sql_expression_dependencies AS sed INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id WHERE referencing_id in (SELECT object_id FROM sys.objects WHERE name in ('spGeteBusiness6_0DirectoryMemberDetails'))

    6. Above SQL Result :

       Selected DBobject Name	First Level Dependent	Dependent Objects Nth Level
       spGeteBusiness6_0DirectoryMemberDetails
       vwPersons
       Address, Employee, FunctionRole, MemberStatusType, MemberType, Person, PhoneNumber, vwAddresses, vwCompanies, vwPersonExternalAccounts

    7. 
       Suggested Solution :
       NOTE: You do not need to pack these database objects if they already exist on the destination server.
       >> Verify if the above mentioned database objects need to be included in this pack and re-pack.

• Succeeded Validation Rules
  • Rule : Database Objects with GRANT SQL in the SQL Text
    1. Validates SQL and Grant SQL syntax is on separate tabs. With legacy versions, there are instances when both are included on one tab. This needs to be corrected before continuing.

    2. Record Name: spGeteBusiness6_0DirectoryMemberDetails

    4. Status: Validation Succeeded