Schema generation hangs due to insufficient resource


 Product(s):APM Implementation and Performance Management
 Version(s):7
 Environment:N/A
 Area:N/A
 Subarea:N/A

Problem Description

During a migration of customizations from a Development Environment to a QA environment the automatic schema generation seemed to take an extraordinarily long time, appearing to hang.

Solution

Upon investigating it was found that the server resources were over extended. Increasing the available resources allowed the schema to generate without issue. When upgrading or migrating information between environments should always include a step to ensure that all automated actions such as scheduled actions and backups should be done before pushing changes, this includes checking the server manager for any processes in transaction prior to running the event. This usually results in sufficient resources being freed to handle most data transfers. In this particular case not enough resource was available to "get over the hump" for the data migration and schema generation. The Customizations migration and Schema generation completed successfully once enough resources became available on the server.