Integration Builder - Error only in test mode

Michael Breitman

• 31 de marzo de 2020 16:22

Unable to run integration 'Database Integration' while opening record set with 'SELECT `TagIndex`, `PONum`, `Lot`, `LineNum`, `SupplierName`, `MatPartNo`, `CheckedBy`, `DateChecked`, `Finish`, `Hardness`, `Thickness`, `Width`, `Length`, `Alloy`, `MatTypeDesc`, `RawMatType`, `Spec`, `HEATnum`, `Section`, `Row`, `Weight`, `ID` FROM `tblMatInventoryTags`'. Details: ''I:\JTD_Renumbering\MatInventory_Test\MatPartData.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.'

 

Does anyone know how to fix this?  Bartender Support has not responded to my support ticket (almost 1 week since submitted).

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 6 de abril de 2020 19:31

  Not 100% sure but have you tried running the integration under a different user account rather than the default system account. You can specify the user credentials on the Integration tab (see below).

  Permission issues have caused a number of similar database type errors I have encountered with 2019.

   

  

  0

Iniciar sesión para dejar un comentario.