Error while adding child table in Adv DB

Situation:

Error faced in setting values while adding a child table in an Adv DB schema.

Error:

com.adeptia.indigo.utils.IndigoException: Error in setting values = {}, at XPath =DB/VISION_CLAIM/VISION_PROVIDER/, Related Key(s) = "PROVIDER_ID","EYEMED_LOCATION_ID","EYEMED_LOCATION_NBR"
at com.adeptia.indigo.services.transport.db.AdvancedDatabaseSource.executeQuery(AdvancedDatabaseSource.java:941)
at com.adeptia.indigo.services.transport.db.AdvancedDatabaseSource.writeOutputStreamCallback(AdvancedDatabaseSource.java:452)

Cause:

When there is any change made in Adv DB schema's query after adding, deleting, altering child table fields but no change is made in DB event's query as per the updated Adv DB shcema's query then this error is caused.

Solution:

Query used in Database event should match the query used in the Advance DB Schema where child table is being added.