Batch Runner Answered

Alex MacDonald

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

 

Comments

2 comments

Date Votes
  • Comment author
    Thomas
    • Official comment

    Converted to ticket

  • Comment author
    Alex MacDonald

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

     

    Cheers

     

    Alex

    0

Please sign in to leave a comment.