SAP Knowledge Base Article - Preview

1925572 - Scheduled Batch Job not triggered produces error: <ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA> - SAP Data Services 4.x

Symptom

  • When running a scheduled SAP Data Services job using Data Services or BOE scheduler the following error is encountered:

(14.1) 10-10-13 16:38:04 (E) (5525:1262921504) CON-120404: Initialization
                                                           OCI call <OCIServerAttach> for connection <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =
                                                           <HOST>)(PORT = 1521)))(CONNECT_DATA =(SID=)))> failed: <ORA-12504: TNS:listener was not given the
                                                           SERVICE_NAME in CONNECT_DATA>


Read more...

Environment

  • SAP Data Services 4.x
  • SAP BusinessObjects Business Intelligence platform 4.0
  • Oracle 11g
  • Windows Server 2008 R2

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP Data Services 4.0 ; SAP Data Services 4.1

Keywords

BODS, schedule, OCI, COIServerAttach, CONNECT_DATA, TNS , KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.