No Matching Tables Found on Application Import

surendrab over 8 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

Parents

0 Vinay Kumar Rai over 7 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 7 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 6 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

Reply

0 nellorea0001 over 6 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

Children

0 Kumar Agniwesh
A Score Level 1
over 6 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 6 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
0 hrishikeshd0001 over 6 years ago in reply to nellorea0001

What is the backend database server. We had similar issues while using an Oracle database because Oracle requires synonyms to be created for each table with appropriate grant access
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel