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 , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

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