Documentation

AEM Forms FDM error: Data Model [table_name] not present in the source

Last update: Mon Sep 22 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

If you are seeing the error Data model: [table_name] not present in the source in AEM Forms, check your database schema configuration. This issue occurs when there are mismatches between the Author and Publish environments or missing metadata in the database.

Description description

Environment

  • Product: Adobe Experience Manager (AEM) Forms
  • Version: 6.5
  • All environments

Issue/Symptoms

  • The error message Data model: [table_name] not present in the source is displayed when refreshing the FDM in the FDM editor.
  • The FDM (Form Data Model) works correctly on the Author instance but fails to retrieve data from the database in the Publish instance. This typically occurs due to discrepancies in database schema configurations or metadata inconsistencies between the Author and Publish environments.
  • Logs indicate that no table metadata records are returned for specific schemas, such as aemforsmschema.
  • Even after importing an FDM package built on one server into another, errors persist unless manual adjustments are made.
  • This is due to discrepancies in database schema configurations or metadata inconsistencies between the Author and Publish database schemas.

Resolution resolution

To resolve this issue, ensure that database schemas and configurations are consistent across all environments (Author and Publish). Follow these steps:

  1. Verify that the database schema and tables are created identically on both Author and Publish databases using the same commands or scripts. For steps, refer to Configure data sources in AEM 6.5 User Guide.
  2. Ensure that any differences in schema names, table names, JDBC driver or metadata between Author and Publish instances are eliminated.
  3. Build an FDM package on the Author instance after confirming it works correctly there. For steps, refer to Create Form Data Model (FDM) and Work with Form Data Model (FDM) in AEM as a Cloud Service User Guide.
  4. Import the same package into the Publish instance and edit the JDBC URI to point to Publish DB schema host, user and password. Avoid unnecessary changes. For steps, refer to SQL connections using JDBC DataSourcePool in AEM as a Cloud Service Tutorials.

By ensuring uniformity in schema setup across environments and leveraging logging for diagnostics, this issue can be resolved effectively.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f