Oracle Endeca Integrator Sanbox projects

raji

• February 28, 2014 00:00

• Answered

Follow

Hi all,

I am new to Oracle endeca Information Discovery. I have integrated EBS with Oracle endeca Information Discovery with the help of below document.

Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID 1562372.1).

I am trying to run ar (sanbox) in Clover ETL Integrator. While running this will refer the FullLoad.grf in common(sandbox).

This FullLoad.grf contains 4 phase named,
1.Audit Insert
2.InitData store
3.Reset Data Store
4.Load Configuration

Error occurred in Error Audit Component(DB_EXECUTE)

ORA-01756: quoted string not properly terminated

Code in Audit Update

$out.0.UpdateAuditSQL = 'UPDATE FND_EID_ETL_AUDITS SET ' +
'etl_run_end_date = SYSDATE, ' +
'etl_run_status = \'E\', ' +
'etl_comments = \'' + grfMessage + '\', ' +
'last_updated_by = ${FND_USER}, ' +
'last_update_date = SYSDATE, ' +
'last_update_login = ${FND_USER} ' +
'WHERE etl_run_end_date IS NULL AND ' +
'eid_instance_id = ${INSTANCE_ID} AND ' +
'etl_run_audit_id = ( SELECT MAX(etl_run_audit_id) ' +
'FROM fnd_eid_etl_audits WHERE ' +
'eid_data_store_name = \'${DATA_DOMAIN_NAME}\' AND ' +
'eid_instance_id = ${INSTANCE_ID} AND ' +
'etl_load_type = \'${LOAD_TYPE}\' AND ' +
'etl_run_lang = \'${LANGUAGE_CODE}\' AND ' +
'created_by = ${FND_USER})';

Guide me regarding this issue.

Thanks in advance.

• Audit Update Error.JPG

• 

  admin

  • February 28, 2014 14:57

  0

  Comment actions Permalink

  Hi Raji,
  
  There is "Print statements" property on DBExecute so please enable it. Then in Console you should see SQL statement actually sent to DB.
  
  My guess is that parameters (like ${LANGUAGE_CODE}) in CTL2 code you sent contains quotes - so breaks result statement. If you build SQL statement on your own, you need to take a care of quotes escaping.
  
  I hope this helps.
• 

  raji

  • March 04, 2014 05:22

  0

  Comment actions Permalink

  Hi Kubosj,
  
  Thanks for your replay. Its helpful to me.
  
  After recreating the Data Domain of ar, graph of ar(sanbox) run successfully.
  
  I have checked Data Source in Endeca Studio. ar,ar-oirdspt and ar-oirtrx are in connection success. I have attached this for your reference.
  
  While opening the ar dashboard page i'm getting errors.
  
  Please find the attachment and guide me regarding this.
  
  Thanks in advance.

  • AR.JPG
  • AR Datasource.JPG
• 

  admin

  • March 04, 2014 09:13

  0

  Comment actions Permalink

  Hi Raji,
  
  This question is out of CloverETL scope. Please contact Endeca/Oracle support for getting help.

Please sign in to leave a comment.