Skip to main content

Search

Search

DB maintenance (SQL) error ID 10107

Comments

2 comments

  • Avatar
    Xabier Clemente
    Moderator

    Hi Sven,

    Welcome to the BarTender Community Forums!

    Could you tell us what BarTender Edition are you running? This information can be located on the "Help > About" tab on BarTender Designer. In case this is an Automation edition, please keep in mind this would require the system database to be stored locally or it will not function correctly.

    Was the BarTender System Database moved to a new location? Also, are we using an account with administrative rights when trying to run database maintenance?

    Finally, we would recommend you update your BarTender 2016 Service Release to the latest revision (BT2016 R9), as it contains several bugfixes and security patches. You can find instructions on how to update to the latest revision on the previous link.

    Thank you in advance.

    0
  • Avatar
    Sven L.

    Hello and thanks for your reply.

    - it's automation. why does the database have to be locally? this was never explained during install and setup. it doesn't even make sense when using SQL as a program doesn't care if the SQL server is on 127.0.0.1 or elsewhere. it's on our SQL server which is another VM server on our local network, but not the same machine as our APPS server where bartender resides. we don't want any data to be stored on our apps server, that's why we have a separate database server.

    - no, it has always been there for the past 3years, we just didn't notice the problem until now

    - yes, the admin console was executed with admin rights

    - we will update to R9, but patchnotes don't seem to mention anything about this problem. also, like you said above it might be because the database is not on the same server?

    0

Please sign in to leave a comment.