SAP Knowledge Base Article - Preview

2430074 - Error: ORA-02149: Specified partition does not exist in SAP Data Services


A job fails with the following error message in SAP Data Services:

(14.2) <Date><Time> (W) (8724:11572) VAL-030810: |Dataflow df_Test
                                                      Warning: The number of partitions in the table <Table Name> has been changed since it was imported.
                                                      The number of partitions in the table is <number>. The imported number of partitions was <different number>. Reimport the table to prevent
                                                      potential data loss.

(14.2) <Date><Time> (E) (8724:11976) DBS-070300: |Data flow df_Test q_Transform-JoinCacheReader3
                                                      SQL submitted to Oracle Server <Datastore> resulted in error <ORA-02149: Specified partition does not exist>



  • Data Services 14.2.x
  • Source Oracle


SAP BusinessObjects Business Intelligence platform 4.1


BODS, DS, Data Services, Oracle Partitions, Partition not found , 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 ONE Support launchpad (Login required).

Search for additional results

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