Batch Runner

Answered

Alex MacDonald

• May 01, 2017 14:15

I'm having an issue with a batch runner configuration.

 

The preview shows 3 results to export but when i run the export it fails.

 

Is there any advice?  The returned error is very generic and doesn't help.

 

My select statement is

Select *
from ORDR
Where U_XPO_Status in ('A','U','D') and DocStatus='O' and CANCELED='N'

 

This works for stock transfers but not for orders.

 

It did work for one order though.

 

 

The returned error message is

Key: 19342 : Message: Could not execute docKey: 19342. Error: Error getting data from SQL : at UniversalFunctions.Functions.FileExporter.Control.SqlController.GetLineDictionaryFromSql(String key, String sql, LogController logController) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\UniversalFunctions\Functions\FileExporter\Control\SqlController.cs:line 107
at UniversalFunctions.Functions.FileExporter.Function.GetBodyExportDictionary(ConfigurationFileExporter configurationFileExporter, String key, LogController logging) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\UniversalFunctions\Functions\FileExporter\Function.cs:line 404
at UniversalFunctions.Functions.FileExporter.Function.ActivateFileExport(ConfigurationFileExporter configurationFileExporter, String key, LogController logging) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\UniversalFunctions\Functions\FileExporter\Function.cs:line 210
at UniversalFunctions.Functions.FileExporter.Function.ActivateFunctionForBatch(List`1 docKeys, String universalFunction, Boolean doLogging) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\UniversalFunctions\Functions\FileExporter\Function.cs:line 150

 

Vote

0

• Official comment

  

  Thomas

  • May 02, 2017 10:00

  Converted to ticket
• 

  Alex MacDonald

  • May 02, 2017 10:12

  Hey, thanks for the reply.  I did get this working in the end and it was an error in my SQL.

   

  Cheers

   

  Alex

Please sign in to leave a comment.