SAP Knowledge Base Article - Preview

2074226 - Multiple entries in Batch job for one proj causes "ORA-01427: single-row subquery returns more than one row" - Data Services 4.1 SP2

Symptom

After migration of a project in a local repository of DS 3.2 into upgraded version of DS 4.1, on execution in batch job configuration tab of Data Services management console:

  • Duplicated (3 copies) entries of same job were observed for same project
  • Clicking on execute presented error : "ORA-01427: single-row subquery returns more than one row"
  • AL_projects table has a single entry of project
  • Creating a new project does not help

Read more...

Environment

  • SAP BusinessObjects BI platform 4.0 SP4
  • SAP BusinessObjects Data Services 4.1 SP2
  • - Job server is AIX 6.1
  • - (upgrade from DS 3.2)
  • Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  • Windows XP

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP Data Services 4.1 ; SAP Data Services XI 3.2

Keywords

DS  Migration 3.2 4.1 , KBA , EIM-DS-SVR , Data Services Administration/Server , 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.