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 for Me (Login required).

Search for additional results

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