TIBCO BusinessWorks™ ProcessMonitor(BWPM) Server error: “ORA-14400: inserted partition key does not map to any partition”.

TIBCO BusinessWorks™ ProcessMonitor(BWPM) Server error: “ORA-14400: inserted partition key does not map to any partition”.

book

Article ID: KB0093327

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks ProcessMonitor -
Not Applicable -

Description

Resolution:
Symptom
=======

TIBCO BusinessWorks™ ProcessMonitor(BWPM) Server throws a similar stack trace in the server.log.

**

2014-10-26 20:22:34,301 ERROR [Dataprovider:CHANNEL_EMS_QUEUE_HSCTIB2_DEFAULT_28.thread] dataprovider: sql exception in DpWorker occured
java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "BWPM_PRD.FUNC_INSERT_MONITOR_MAIN", line 1
ORA-06512: at "BWPM_PRD.PROC_MONITOR_MAIN", line 1
ORA-01403: no data found
ORA-06512: at line 1

**

Cause

=====

This error indicates that the BWPM setup seems to have a partitioned database where the partition for table NJAMS_T_MONITOR_MAIN does not exist for 2014-10-26. Note that part of the error shown in the first 2014-10-26 entry is the exact partition missed in the error message.


Resolution

========

If the data management job is running, run the DATA_MANAGEMENT job so it will create the required partition.

Issue/Introduction

TIBCO BusinessWorks™ ProcessMonitor(BWPM) Server error: “ORA-14400: inserted partition key does not map to any partition”.

Additional Information

NA