5 Replies Latest reply on Dec 13, 2010 11:35 AM by Balaji Seshadri

    Error Executing INSERT in 7.2 Final

    Balaji Seshadri Newbie

      Please let me know why am i getting below error when i run below statement in 7.2,it was working fine in 7.2 CR1.

       

      Error: Remote org.teiid.api.exception.query.QueryPlannerException: Source command "INSERT INTO EPCSchema.ORBITAL_LOCATION (EPCSchema.ORBITAL_LOCATION.guid, EPCSchema.ORBITAL_LOCATION.name, EPCSchema.ORBITAL_LOCATION.satsnetworkid) SELECT orbital_location.* FROM (EXEC GetXml.getTextFiles('OrbitalLocation.xml')) AS f, XMLTABLE('$d/orbitalLocations/orbitalLocation' PASSING XMLPARSE(DOCUMENT F.file) AS d COLUMNS guid string PATH '@guid', name string PATH 'name', satsnetworkid string PATH 'satsnetworkid') AS orbital_location" contains non-pushdown constructs.

       

      Please let me know whats the fix.