No Matching Tables Found on Application Import

surendrab over 7 years ago

I am trying to import an application to an 16.1 source environment to 16.1 target environment but getting error when trying to verify the datastore : The error I get is :
No matching tables found!

The data store cannot be published until the mappings between its entities and the tables in the selected data source have been verified.

Please check the data source configuration and test data source communication from the application server (More Info)

Please correct the annotation error and re-import the data type definition (More Info)

One or more of the data entities cannot be mapped to the table structure in the selected data source. Please choose an option for creating the necessary tables or select a type that matches the existing tables.

The data source schema does not match the type mappings: Missing table: contentfreeformrule (APNX-2-4056-000)
Any help would be greatly appreciated!!!!

Discussion posts and replies are publicly visible

0 Jin Pheh
Certified Associate Developer
over 7 years ago

Your new environment doesn't have the database table(s) that your application requires. The last line of the error message says "Missing table: contentfreeformrule".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sagarl511
A Score Level 2
over 7 years ago

Can you check the sql file which is generated while verifying the data store entity. It contains ddl statements which needs to be executed on the environment. Based on that sql file you may be able to determine which tables exactly are not being mapped.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 surendrab over 7 years ago

Thanks for the response. We don't have table named "contentfreeformrule" or CDT named as such. We did not had this issue before but after recently upgrading fro 7.11 t0 16.1 we are facing this issue. Where can I get the sql file that is generated while verifying data store entity?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sagarl511
A Score Level 2
over 7 years ago

@surendrab - On opening of any data store you can see option to Verify data store. Also you can download DDL script on adding the any entity. Also on clicking of verify if tables does not match , it throws error and also allows to download DDL sql file where you will find all the uncommented sql statements which corresponds to unmatched tables.

Also it will be better if you can monitor logs when you try to import or publish data store as it seems that your error is something different as you specified that there is no entity in your data store - contentfreeformrule
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 srivallin
Certified Lead Developer
over 6 years ago

Hi,

I am facing similar issue while deploying into UAT. The table exists in the database, table name and data types all seems to be correct but getting error. This stopping from importing new rules to UAT. Did you find an answer.

Thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Vinay Kumar Rai over 6 years ago

I think you only import the CDT, please import DataStore and CDT both
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 6 years ago in reply to Vinay Kumar Rai

Is there any change in the CDT fields or is there any addition of columns ... and if already the old cdt is existing that might also not work . may be you can also check this option too
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nellorea0001 over 5 years ago in reply to harshav

I'm also facing the same issue as below, when I have created the CDT and assigned the CDT in as rule inputs in my form, now while creating a data store and verifying the mappings I get the below error.

One or more of the data entities cannot be mapped to the table structure in the selected data source. Please choose an option for creating the necessary tables or select a type that matches the existing tables.

The data source schema does not match the type mappings: Missing table: cdtinputfields (APNX-2-4056-000)

Any accurate answer would be greatly appreciated!!!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kumar Agniwesh
A Score Level 1
over 5 years ago in reply to nellorea0001

Could you please suggest if you have ran any query to create the table? If not save and publish the Data store to create the desired table . Just keep in mind that your table name would be "cdtinputfields "
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Umesh Patel over 5 years ago in reply to nellorea0001

Hi,
Please check CDT fields and types with the database table and columns types. There will be some mismatch between type e.g. Boolean , Char(1) etc. Just cross check both of this and you will be able to identify the problem.
Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel