Getting error while adding new entity to Datastore as table doesn't exists in DB - 17.3

Question

Actually we are promoting the code from dev(16.3) to 17.3 (UAT) 
 When adding the new entity it says datastore verified but adding this new entity to Datastore gives an error. 
 And this is working fine in 16.3 . 
 Any suggestions would be helpful. 
 
 That table is there in DB , I had verified it.

Ashvin Kapur · Answer

Soujanya, 
Is the CDT in the Data Store already? Or are you adding it with the second step above? If the data type is not already in the datastore, you will get the "Data store verification passed" message as expected in step 1, even if the table doesn't exist, since the new version of the XSD is not invalidating any data store. Then, when you add the entity to the data store, the error would be expected if the table doesn't exist. 
Secondly, if you've validated the table does in fact exist, verify that the table name is the same, that the grants and aliases are configured correctly, etc.