Column ambiguously defined error in SOLR delta import

[Chandan khatua]

Hi 

 

 

I have the bellow query in data-config.xml, but it throws an error while
running the delta query: "java.sql.SQLSyntaxErrorException: ORA-00918:
column ambiguously defined".

Full data import is running fine.

 

Kindly suggest the changes required.

 

 

<entity 

      name="messages" pk="ERROR_MSG_PK" transformer='DateFormatTransformer'

      query="SELECT emsg.ERROR_MSG_PK,emsg.MESSAGE

FROM exc_source_msg msg,exc_error_msg emsg

where emsg.source='XYZ_TERMINAL'

AND msg.source_system_enterprise_pk IN

  (SELECT sse.source_system_enterprise_pk

  FROM inf_source_system_enterprise sse

  WHERE sse.enterprise_id='ABC'

  ) and msg.error_msg_pk=emsg.error_msg_pk"

                  deltaQuery="select emsg.ERROR_MSG_PK as ERROR_MSG_PK from
exc_error_msg emsg,exc_source_msg msg  where
to_char(emsg.update_date,'YYYY-MM-DD HH24:MI:SS') &gt;
'${dataimporter.last_index_time}' "

      dataSource="db">

 

 

 

Thanking you,

 

-Chandan