• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Extract constituents failed

Christopher Jones
$organization

I'm trying to extract constituents, having successfully generated counts, but each time I try, the process fails at the BCP stage with the error message

***BCP OUT failed! more info in ....\extract16.err

However, the err report is not being created. Does anyone have any ideas why this is happening?

Thanks, Christopher

  • Former Member
    Former Member $organization
    For us, this has usually been because of some obscure problem withthe chain of permissions required to run extractions successfully.
    There is a good Knowledgebase solution, that walks you through a  series of checks and tests, called "Since installing SQL 2005, extractions are not working. What could be the problem?" (Old TASK # 16105)
     
     
    You should walk through that, as a first step.
     
     

    KEN MCSWAIN BUSINESS SOLUTIONS MANAGER

    KEN.MCSWAIN@SYDNEYOPERAHOUSE.COM

    T+61 2 9250 7876  F+61 2 9251 7821 M+61 418 659 360

     

    SYDNEY OPERA HOUSE BENNELONG POINT

    GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

    SYDNEYOPERAHOUSE.COM

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christopher Jones
    Sent: Tuesday, 21 April 2009 20:02
    To: Ken McSwain
    Subject: [Tessitura Technical Forum] Extract constituents failed

    I'm trying to extract constituents, having successfully generated counts, but each time I try, the process fails at the BCP stage with the error message

    ***BCP OUT failed! more info in ....\extract16.err

    However, the err report is not being created. Does anyone have any ideas why this is happening?

    Thanks, Christopher




    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.
    Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • $organization in reply to Former Member

    Hi Christopher, We had exactly this problem, quite a while ago. There was a permissions issue with the share on the server, so we created a new AD security group. Also, I think we had an issue with the account which runs the reports, but as it was a while ago I'm not sure about that.

    Good luck. Debbie

  • Former Member
    Former Member $organization

    Christopher,

       From your description of the problem and the error you are getting, it sounds like the proxy account is not working.  I'll email a document for you to review the settings for the proxy account and dbowner of the databases. 

    Naomi