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. Verify the list of dependent database object based on the selected database object. Please make sure that the entire required database object should be present in the selected pack or on destination server.

    2. Record Name: spSearchCompanyByID

    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 ('spSearchCompanyByID'))

    6. Above SQL Result :

       Selected DBobject Name	First Level Dependent	Dependent Objects Nth Level
       spSearchCompanyByID
       Company

    7. 
       Suggested Solution :
       
       >> Above mentioned DB Objects are missing in the pack.
       >> Please include above mentioned DB Objects in this pack and retry.
       >> NOTE: You may skip these DB Objects if it is exist in destination server.

• Succeeded Validation Rules
  • Rule : Database Objects with GRANT SQL in the SQL Text
    1. SQL Text and the Grant SQL is to be contained in segregated fields, but due to legacy processes, there are instances where these are both included in the SQL text field. This should be corrected by moving the Grant SQL to the Grant SQL tab.

    2. Record Name: spSearchCompanyByID

    4. Status: Validation Succeeded

  • Rule : Foreign Key Links to View Records
    1. All sub-entities of the views entity should have a genuine link to a view which exists in the Database.

    2. Record Name: Find People SOA

    4. Status: Validation Succeeded

  • Rule : Missing/Incorrect Process Components Object Reference
    1. Validation Step to find all Process Components Object References that do not exist due to a bad reference or from the removal of the object. A List of Objects which are referenced but do not is shown above.

    2. Record Name: Create Contact Log Record , Create ContactLogLinks Record

    4. Status: Validation Succeeded

  • Rule : Validate users
    1. Please verify Users,They have transferred from CGI using the User Transfer Tool.

    2. Record Name: sa

    4. Status: Validation Succeeded