• Replies 6 replies
  • Subscribers 336 subscribers
  • Views 205 views
  • Users 0 members are here
Related

Extractions BCP Out failing

Former Member
Former Member $organization

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    

                                     Comptia                                              

 

 

 

  • $organization

    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.

     

  • Former Member
    Former Member $organization

    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!

     

    Penny

     

    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

    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    

                                         Comptia                                              

     

     

     




    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!

  • $organization in reply to Former Member

    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" ? 

  • Former Member
    Former Member $organization

    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!

     

    Penny

     

    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

    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    

                                         Comptia                                              

     

     

     




    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!

  • Former Member
    Former Member $organization

    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!

     

    Penny

     

    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

    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    

                                         Comptia                                              

     

     

     




    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!




    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!

  • Former Member
    Former Member $organization

    Thanks Gloria…I have gone over this document half a dozen times already and nothing works.  I am wondering if perhaps the fact that the windows user name we created for the proxy user has 9 characters might be a culprit, since Tessitura user logins only recognize 8 characters?

     

    Penny

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Wednesday, December 05, 2012 4:24 PM
    To: Tabor, Penny
    Subject: RE: [Tessitura Technical Forum] Extractions BCP Out failing

     

    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!

     

    Penny

     

    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

    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    

                                         Comptia                                              

     

     

     




    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!




    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!