• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 72 views
  • Users 0 members are here
Related

Order Import BCP Errors

Former Member
Former Member $organization

Tessi Technical Guru's

I'm sending an SOS...we are trying to run the order import utility and receive and error Unable to open BCP error-file, AP_BCP_FILE failed. I've check the proxy account, it has permissions to the folder. We are using UNC paths and not mapped drives. I ran a trace and executed the SQL in SSMS, the last line of the results when executing TP_ORDER_IMPORT_MAIN say an valid uncontrolled batch type was not provided or the curent user group does not have access. I verified both of these items and they are both valid and accessible.

Anything else I should be checking?

Many thanks!

Naomi

  • $organization

    Two things in play here.  The first, “unable to open BCP error-file” generally means that either the file cannot be seen by the SQL Proxy Account (permissions issue) OR the file is locked by another application.  Check that the file exists and the folder has read/write permissions given to the SQL Proxy Account.  Then check to see that the log file isn’t open in Notepad or another application, which locks the file.

     

    Second issue is just simply a difference between running the utility in the application vs running in a query window.  In the application you have Tessitura user group security context.  In a query window you have to give the connection Tessitura user group security context.  This can be done by running the following:

     

    Execute AP_SET_CONTEXT ‘ug’, ‘Admin’

     

    Where “admin” is the user group…use Admin if you want all permissions.  The Order Import Utility and other batch utilities like it check permissions to the Batch Types (among all other things), which is why from a query window you are seeing the “Not a valid Uncontrolled batch type or user does not have permission” error.

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Tuesday, September 07, 2010 10:37 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Order Import BCP Errors

     

    Tessi Technical Guru's

    I'm sending an SOS...we are trying to run the order import utility and receive and error Unable to open BCP error-file, AP_BCP_FILE failed. I've check the proxy account, it has permissions to the folder. We are using UNC paths and not mapped drives. I ran a trace and executed the SQL in SSMS, the last line of the results when executing TP_ORDER_IMPORT_MAIN say an valid uncontrolled batch type was not provided or the curent user group does not have access. I verified both of these items and they are both valid and accessible.

    Anything else I should be checking?

    Many thanks!

    Naomi




    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

    Ryan,

     

    I had the permissions correct but what I didn’t have setup was the actual file name in the file path. I had the file path setup correctly in TR_IMPORT_ORDER_SET but I did not specify the file name.

    Thanks!

     

    Thank you and have a great day!

    Naomi Williams

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Tuesday, September 07, 2010 1:37 PM
    To: Naomi Williams
    Subject: RE: [Tessitura Technical Forum] Order Import BCP Errors

     

    Two things in play here.  The first, “unable to open BCP error-file” generally means that either the file cannot be seen by the SQL Proxy Account (permissions issue) OR the file is locked by another application.  Check that the file exists and the folder has read/write permissions given to the SQL Proxy Account.  Then check to see that the log file isn’t open in Notepad or another application, which locks the file.

     

    Second issue is just simply a difference between running the utility in the application vs running in a query window.  In the application you have Tessitura user group security context.  In a query window you have to give the connection Tessitura user group security context.  This can be done by running the following:

     

    Execute AP_SET_CONTEXT ‘ug’, ‘Admin’

     

    Where “admin” is the user group…use Admin if you want all permissions.  The Order Import Utility and other batch utilities like it check permissions to the Batch Types (among all other things), which is why from a query window you are seeing the “Not a valid Uncontrolled batch type or user does not have permission” error.

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Tuesday, September 07, 2010 10:37 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Order Import BCP Errors

     

    Tessi Technical Guru's

    I'm sending an SOS...we are trying to run the order import utility and receive and error Unable to open BCP error-file, AP_BCP_FILE failed. I've check the proxy account, it has permissions to the folder. We are using UNC paths and not mapped drives. I ran a trace and executed the SQL in SSMS, the last line of the results when executing TP_ORDER_IMPORT_MAIN say an valid uncontrolled batch type was not provided or the curent user group does not have access. I verified both of these items and they are both valid and accessible.

    Anything else I should be checking?

    Many thanks!

    Naomi




    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!