• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Problem with Order Import utility

David Frederick
$organization

Hi all,

We are trying to run the Order Import utility, and when we execute the utility, it is giving us this error before it really does anything:

Select Error: SQLSTATE = 42000
Microsoft OLE DB Provider for SQL Server
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fs_user", or the name is ambiguous.

I ran SQL Server Profiler, and found out this relates to stored procedure dbo.tp_order_import_main. That procedure references the dbo.fs_user function, which does not appear to be on our server. I did a search both on the Tessitura Network and the TASK site for this function, but cannot locate the code.

Is there someone who can point me in the right direction?

Thanks!
David 

  • $organization

    David

     

    Might be best if you open a support ticket and then support will be able to provide you with the function fs_user.

     

    Cheers

    Sandra

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick
    Sent: Friday, 9 December 2011 7:32 AM
    To: Sandra Ashby
    Subject: [Tessitura Technical Forum] Problem with Order Import utility

     

    Hi all,

    We are trying to run the Order Import utility, and when we execute the utility, it is giving us this error before it really does anything:

    Select Error: SQLSTATE = 42000
    Microsoft OLE DB Provider for SQL Server
    Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fs_user", or the name is ambiguous.

    I ran SQL Server Profiler, and found out this relates to stored procedure dbo.tp_order_import_main. That procedure references the dbo.fs_user function, which does not appear to be on our server. I did a search both on the Tessitura Network and the TASK site for this function, but cannot locate the code.

    Is there someone who can point me in the right direction?

    Thanks!
    David 




    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!