Description:
The TIBCO BusinessWorks ProcessMonitor (BWPM) job NJAMS_JOB_UPDATE_DATA_PROVIDER_STATISTICS fails with the following: ORA-01843: not a valid month is caused by an incorrect timestamp format setting in the Oracle client configuration. 
Symptoms:
The stack trace seen in TIBCO BusinessWorks ProcessMonitor(BWPM) server.log:

2015-07-07 08:23:01,044 DEBUG [LOCAL_Worker-1] com.faizsiegeln.njams.util.JDBCUtilities: sqlString= { call PROC_UPDATE_DP_STATISTICS('495db066-4678-4d12-8555-197f97ab8b28','2',23937502,29161,0,11570927,0,0) }
2015-07-07 08:23:01,044 TRACE [LOCAL_Worker-1] com.faizsiegeln.njams.dataprovider.DataProviderStatistics: could not update dp statistics
java.sql.SQLDataException: ORA-01843: ce n'est pas un mois valide
ORA-06512: à "TIBCO_BWPM.PROC_UPDATE_DP_STATISTICS", ligne 13
ORA-06512: à ligne 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4709)
    at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10613)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3611)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
    at com.faizsiegeln.njams.util.JDBCUtilities.doDatabaseCall1(JDBCUtilities.java:631)
    at com.faizsiegeln.njams.util.JDBCUtilities.doDatabaseCall0(JDBCUtilities.java:600)
    at com.faizsiegeln.njams.util.JDBCUtilities.doDatabaseCall0(JDBCUtilities.java:586)
    at com.faizsiegeln.njams.util.JDBCUtilities.doDatabaseCall(JDBCUtilities.java:562)
    at com.faizsiegeln.njams.domainmodel.dao.jdbc.JdbcStatisticInfoDAO.updateDataProviderStatistic(JdbcStatisticInfoDAO.java:47)
    at com.faizsiegeln.njams.dataprovider.DataProviderStatistics.persist(DataProviderStatistics.java:206)
    at com.faizsiegeln.njams.dataprovider.DataProviderStatistics.persist(DataProviderStatistics.java:250)
    at com.faizsiegeln.njams.dataprovider.DataProviderStatistics.refresh(DataProviderStatistics.java:162)
    at com.faizsiegeln.njams.dataprovider.DataProviderStatistics.update(DataProviderStatistics.java:141)
    at com.faizsiegeln.njams.jobs.JobDataProviderStatistics.execute(JobDataProviderStatistics.java:18)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
2015-07-07 08:23:01,044 DEBUG [LOCAL_Worker-1] JobController: end job NJAMS_JOB_UPDATE_DATA_PROVIDER_STATISTICS by trigger NJAMS_JOB_UPDATE_DATA_PROVIDER_STATISTICS on scheduler LOCAL
2015-07-07 08:23:01,045 DEBUG [LOCAL_QuartzSchedulerThread] org.quartz.core.QuartzSchedulerThread: batch acquisition of 1 triggers
2015-07-07 08:23:02,397 TRACE [http-bio-11090-exec-7] com.faizsiegeln.njams.servlet.filter.LogServletFilter: Servlet called: Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0 Path: /SystemIssuesServlet QueryString: action=download&file=server.log&nodeId=495db066-4678-4d12-8555-197f97ab8b28


Cause:
The error 'com.faizsiegeln.njams.dataprovider.DataProviderStatistics: could not update dp statistics' is seen in server.logs if NLS-settings in the database are unsupported. TIBCO BusinessWorks ProcessMonitor(BWPM) needs locale as en_US.