NCOA Export BCP Errors

Rey,

I had that error sometime ago doing data conversion. What I did to resolve it was create a blank text file in the output file path name whatever your export is named i.e. export.txt, ran the job again and it updated that file with the data I needed.

Hey everyone,

Unfortunately, Naomi, I’m not answering your question about your BCP error importing orders. I’m adding my own.

All of a sudden, I’m getting an error similar to Naomi’s while attempting to EXPORT a file using the NCOA utility. Mine says:

SQLState = S1000, Native Error = 0

Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file

Return value from stored procedure AP_BCP_FILE: -109

When I check the procedure, there is no info on what an error of type -109 is.

HALP!

Rey

--

A. Rey Pamatmat

Tessitura Manager

The Public Theater

425 Lafayette Street

New York, NY 10003

(212) 539-8739

RPamatmat@PublicTheater.org

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!