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

BODS, DS, Data Services, Oracle Partitions, Partition not found , KBA , EIM-DS-EXE , Job Execution , Problem