Assertion Error with a query
rkishore999 Sep 24, 2009 3:15 PMI'm trying the following query which is a bit big. I get Assertion error. I'm posting the query here.
SELECT snetmap.contact_name, snetmap.contact_id FROM ( SELECT e.customer_id, d.network_id FROM CUST_MASTER a, NET_MASTER b, (SELECT customer_id, network_id from CUST_NET_MAT group by customer_id, network_id) c, NET_DETAILS d, CUST_DETAILS e WHERE a.customer_id_pk = c.customer_id AND b.network_id_pk = c.network_id AND c.network_id = d.network_id AND a.customer_id_pk = e.customer_id AND d.ACTIVE = 'Y' GROUP BY e.customer_id, d.network_id ) snet, ( SELECT a.network_id, a.contact_id, b.contact_name FROM CUST_NET_MAT A, CSD_DATAUPDATERS B WHERE customer_id in (SELECT e.customer_id FROM CUST_MASTER a, NET_MASTER b, (SELECT customer_id, network_id from CUST_NET_MAT group by customer_id, network_id) c, NET_DETAILS d, CUST_DETAILS e WHERE a.customer_id_pk = c.customer_id AND b.network_id_pk = c.network_id AND c.network_id = d.network_id AND a.customer_id_pk = e.customer_id AND d.ACTIVE = 'Y') AND network_id in (SELECT d1.network_id FROM CUST_MASTER a1, NET_MASTER b1, (SELECT customer_id, network_id from CUST_NET_MAT group by customer_id, network_id) c1, NET_DETAILS d1, CUST_DETAILS e1 WHERE a1.customer_id_pk = c1.customer_id AND b1.network_id_pk = c1.network_id AND c1.network_id = d1.network_id AND a1.customer_id_pk = e1.customer_id AND d1.ACTIVE = 'Y') AND a.dataupdaters_id = b.DATAUPDATERS_ID_PK GROUP BY a.network_id, a.dataupdaters_id, b.DATAUPDATERS_NAME ) snetmap, CUST_CUST_MAP c WHERE snet.network_id = snetmap.network_id AND snet.customer_id = c.ced_customer_id AND c.strd_customer_id = 60202 GROUP BY snetmap.contact_name, snetmap.contact_id LIMIT 3
I have debugged the server code a bit. It is failing in the LanguageBuildFactory.translate(Criteria criteria) method. criteria is coming as an instance of "DependentSetCriteria", but there is no code in the method to translate the dependentSetCriteria. I hope I'm not confusing.
Regards
Ram