| Info | ||
|---|---|---|
| ||
This is the Beta version first official release of the Aptify Configuration Migration (CM) Tool. If you have any questions or problems using the tool please contact Aptify Technical Support. Your feedback is appreciated! |
...
Validates all database objects have valid Database Objects record references. Including views and stored procedures.
Solution
| Note |
|---|
...
If the failed data is present in the destination database then skip the validation rule and continue packing. |
- Open the entity(s) listed and go to DB Object tab.
- Verify that the linked database object is valid, if not create or link a valid database object.
- The query above will help you to find all linked database objects in the database.
...
| No Format | ||
|---|---|---|
| ||
SELECT EntityID,RepositoryObject FROM [ENTITY_DATABASE]..EntityrepObjRequirement WHERE RepositoryObject <> '' AND RepositoryObject NOT IN( SELECT p.Name + '.' + ob.Name FROM [ENTITY_DATABASE]..ObjectRepositoryObject ob INNER JOIN [ENTITY_DATABASE]..ObjectPackage p ON p.ID = ob.ObjectPackageID) |
Database Objects with GRANT SQL in the SQL Text
...
- Open that database object(s) listed and check the query written under the SQL tab.
- If it contains a Grant SQL statement, copy the code from the SQL tab to the Grant SQL tab.
| Tip | ||
|---|---|---|
|
...
Any base Views not contained within APTIFY as an Database Object Record will not be transferred. Consider creating a DB Object Record for any view found within this validation, and link it to an appropriate Entity. Otherwise, you will need to manually create the view on the destination. |
Invalid NULL Default Value for Entity Fields
...
Validates that entities that are linked to the entities selected for packing exist in the pack. All linked entities should present in the pack or on the destination server before unpacking.
Solution
| Note |
|---|
...
You do not need to pack these database objects if they exist on the destination server. |
- Verify if the above mentioned linked entities need to be included in this pack and re-pack.