Symptom
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
Read more...
Environment
SAP Workforce Time and Attendance 17.2 and higher
Keywords
KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , 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.