Hi,
Looking for some guidance. We play in 3 venues but none are "home" to the Florida Orchestra. I have been trying to import the venue sales for the first time. They have not done this in the past. I am working towards streamlining this process for reporting.
I have been working with Tessitura for a few weeks troubleshooting the errors. We seem to have things mostly sorted out. I have an XML Format file as well as a txt Import order file. There is a TERMINATOR "\r\n" on the last import row.
The latest error is - Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". The import file data may be out of sync with the specified format file.
Has anyone encountered this issue and how did you resolve it?
I've researched the help guide, Troubleshoot section and a pop-up skill builder for Importing Orders. From there I looked at the T_DEFAULTS table and found 2 entries relating to OLE. See below screenshot. I'm not sure if I need to add any, one for xml and txt?
Thank you in advance!
Donna
Hi Donna,
I've had this happen before! It sounds like there's a disparity between the fields you're trying to import, and what is in the constituent import file format template. You need to be importing the same columns, in the same order they are listed in the template. Fingers crossed that's the only other issue!
Hi Kathleen,
The one thing that I know for sure is that the columns are in the same order. The person I am working with from Tessitura used Notepad++ yesterday and found some spaces. Something seems to be out of sync. I am so close.
Thanks for your feedback. This forum is a great networking and helpful tool.
Thanks,