3351202 - CUSTOM EXPORT POLICY - ERROR MESSAGE "JAVA.SQL.SQLEXCEPTION: MISSING IN OR OUT PARAMETER AT INDEX::"

These are an example error messages which can show up when running a Custom Export Policy, displayed as an error detail message, dependent on the database type:

Oracle Database:
"Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 2"

Here is a full example stack trace:
 

[ERROR] 2017-11-14 12:14:13 Error exporting data:
[ERR_DTL] 2017-11-14 12:14:13 com.workforcesoftware.Exceptions.InternalApplicationException: Error getting records to export
[ERR_DTL] 2017-11-14 12:14:13 com.workforcesoftware.Exceptions.InternalApplicationException: Error getting records to export
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.exportDataToFile(CustomExport.java:107)
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.execute(CustomExport.java:77)
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExportJobTask.doTask(CustomExportJobTask.java:59)
at com.workforcesoftware.BatchJobs.BThreadPoolWorker$1.execute(BThreadPoolWorker.java:98)
at com.workforcesoftware.runtime.ResourceTracker.executeThenRelease(ResourceTracker.java:194)
at com.workforcesoftware.runtime.ResourceTracker.executeOperationAndReleaseResources(ResourceTracker.java:111)
at com.workforcesoftware.BatchJobs.BThreadPoolWorker.runTask(BThreadPoolWorker.java:94)
at com.workforcesoftware.BatchJobs.BThreadPoolWorker.access$500(BThreadPoolWorker.java:33)
at com.workforcesoftware.BatchJobs.BThreadPoolWorker$WorkerRunnable.run(BThreadPoolWorker.java:190)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1878)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3815)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.workforcesoftware.Util.LoggingInvocationHandler.invoke(LoggingInvocationHandler.java:70)
at com.workforcesoftware.Util.DB.SQLInvocationHandler.invoke(SQLInvocationHandler.java:48)
at com.workforcesoftware.Util.DB.StatementProxyHandler.executeLikeCall(StatementProxyHandler.java:115)
at com.workforcesoftware.Util.DB.StatementProxyHandler.invoke(StatementProxyHandler.java:190)
at com.workforcesoftware.Util.DB.PreparedStatementProxyHandler.invoke(PreparedStatementProxyHandler.java:179)
at com.sun.proxy.$Proxy19.executeQuery(Unknown Source)
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.exportDataToFile(CustomExport.java:99)
... 9 more

SQL Server Database:
"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 2. "

Here is a full example stack trace:

[ERROR]	2017-11-17 10:42:01 Error exporting data: 
[ERR_DTL]	2017-11-17 10:42:01 com.workforcesoftware.Exceptions.InternalApplicationException: Error getting records to export 
[ERR_DTL]	2017-11-17 10:42:01 com.workforcesoftware.Exceptions.InternalApplicationException: Error getting records to export 
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.exportDataToFile(CustomExport.java:107) 
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.execute(CustomExport.java:77) 
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExportJobTask.doTask(CustomExportJobTask.java:59)
at com.workforcesoftware.BatchJobs.BThreadPoolWorker$1.execute(BThreadPoolWorker.java:98) 
at com.workforcesoftware.runtime.ResourceTracker.executeThenRelease(ResourceTracker.java:194) 
at com.workforcesoftware.runtime.ResourceTracker.executeOperationAndReleaseResources(ResourceTracker.java:111) 
at com.workforcesoftware.BatchJobs.BThreadPoolWorker.runTask(BThreadPoolWorker.java:94) 
at com.workforcesoftware.BatchJobs.BThreadPoolWorker.access$500(BThreadPoolWorker.java:33) 
at com.workforcesoftware.BatchJobs.BThreadPoolWorker$WorkerRunnable.run(BThreadPoolWorker.java:190) 
at java.lang.Thread.run(Thread.java:748) 
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 2. 
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) 
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildParamTypeDefinitions(SQLServerPreparedStatement.java:260)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildPreparedStrings(SQLServerPreparedStatement.java:219)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(SQLServerPreparedStatement.java:612) 
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:400)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) 
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) 
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) 
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) 
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) 
at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:498) 
at com.workforcesoftware.Util.LoggingInvocationHandler.invoke(LoggingInvocationHandler.java:70) 
at com.workforcesoftware.Util.DB.SQLInvocationHandler.invoke(SQLInvocationHandler.java:48) 
at com.workforcesoftware.Util.DB.StatementProxyHandler.executeLikeCall(StatementProxyHandler.java:115) 
at com.workforcesoftware.Util.DB.StatementProxyHandler.invoke(StatementProxyHandler.java:190) 
at com.workforcesoftware.Util.DB.PreparedStatementProxyHandler.invoke(PreparedStatementProxyHandler.java:179) 
at com.sun.proxy.$Proxy20.executeQuery(Unknown Source) 
at com.workforcesoftware.InterfacePrograms.CustomExport.CustomExport.exportDataToFile(CustomExport.java:99) 
... 9 more

SAP Workforce Time and Attendance 17.2 and higher 

KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , Problem