We recently upgraded to new servers for Tessitura, and now, both test and productions servers get BCP Out failure messages when trying to do extractions. We have created a new proxy account, it is a Windows login account called MCFTA\tessproxy…it is a domain admin, an admin on the servers, and we have assigned all permissions as outlined in the documentation from Tessitura regarding creating a proxy account, setting up xp_cmdshell, etc. At the end of the document there is a test job that can be run…when I run the test job, it is successful and writes the files specified. When we try to do extractions, we get an error in the View Log that shows:
To me, the login line (highlighted) looks suspect, but I am not the staff person that runs extractions and have not viewed this log before so am not sure if this is “normal” or not.
Also, when I view the job history in SQL Agent, I see this:
I have tried everything I can think of and have had no luck. I am also working with the Tessitura Help desk but we have not been able to find the resolution yet. I wonder if anyone has run across this same issue, or might have some ideas of what to check.
Penny Tabor
IT Manager
Midland Center for the Arts
Midland, MI 48640
Penny,
I had the same problem. I followed the steps from here and got it working.
http://www.tessituranetwork.com/network/Learning/Tessitura%20Knowledgebase/Extractions%20Lists/Other/16105.aspx
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor Sent: Wednesday, December 05, 2012 11:29 AM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] Extractions BCP Out failing
I just tried the test job using the path of \\mcftaapps\apps\tessitura\extractions and it worked fine, so there is no problem accessing the server path directly from the SQL…there is something preventing it from accessing it through Tessitura.
Thanks for the suggestion.
Penny
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Patrick Drew Sent: Tuesday, December 04, 2012 8:41 PM To: Tabor, Penny Subject: RE: [Tessitura Technical Forum] Extractions BCP Out failing
Our proxy account database server login doesn't have a user in the impresario database, but it does in master db. Its default schema is dbo.
I see the test job in the documentation has you writing to the database server's c drive. Have you tried the test job writing to the extraction directory?
Also, have you tried including the drive letter in the MESS_OUTPUT value, e.g. "\\mcftaapps\c\apps\extractions" ?
From: Penny Tabor <bounce-pennytabor2237@tessituranetwork.com> Sent: 12/4/2012 9:09:34 AM
Good thoughts, but BCP fails for all users that have tried, including myself and the admin account…but I checked our proxy account (which is supposed to be used to run BCP) has the default schema of dbo…what does your proxy account have as the schema? We are still on version 10 also. THANKS!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Patrick Drew Sent: Monday, December 03, 2012 4:51 PM To: Tabor, Penny Subject: Re: [Tessitura Technical Forum] Extractions BCP Out failing
Hi Penny,
Is BCP only failing for this user? Total stab in the dark, but what is the default schema for the database user? I had some problems with extractions not working for a few colleagues because their default schema had somehow been changed to dbo. As soon as I changed it back to the named instance it worked fine. Of course, this was in v10 so it may not be applicable.
Patrick.
From: Penny Tabor <bounce-pennytabor2237@tessituranetwork.com> Sent: 11/29/2012 9:52:32 AM
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!