• Upgrade SQL Server? Gotchas?

    Hey all,

    A third-party CMMS system is offering to send us a MS SQl Server BAK file containing the full system database, daily, so we can mount it on our SQL Server and have all data locally for our own reporting, etc.

    Problem is, they are backing up from SQL Server 2014 and our SQL Server is 2012. This server is the database upon which our on=premise DocuWare system resides.

    We are on DW 6.11 with all hotfixes installed. Can we simply upgrade SQL Server from 2012 to 2014 without issue? I am assuming so, just wanted to make sure.

    For that matter, should we just go all the way to SQL Server 2016? Will that work OK for DocuWare 6.11? we do not have the resources to try all this on a test server and test every single file cabinet and task manager setup. If all goes haywire, we would simply restore the entire DocuWare server image (which includes SQL Server) from backup (the server is virtualized). Apolgies if there is a upported database listing somewhere that I missed (I did search the forum but couldn't find anything quite specific to our scenario).

    Let me know any gotchas with upgrading SQL Server behind DocuWare, and any downside to just going all the way to SQL Server 2016. We might as well, assuming it doesn't have any obviously pitfalls.

     

    Thanks,

    Joe Kaufman

  • Gilles,

    Gilles,

    That makes complete sense -- a "whole word" sort of motifier. Though, in 6.11 if I search for "ant" I got 22 documents highlighting the word "QUANTITY". If I threw asterisks on either side of "ant" I got over 200 hits, also finding the word "ATTRACTANT". I am not sure I understand why a straight "ant" found inside QUANTITY would not also be found in ATTRACTANT. A "contains" should be a contains whether a search term is found at the start, middle, or end of a word.

    Definitely differing results, though!

    The "?" makes complete sense, though -- that is a good example you offer.

     

    Thanks,

    Joe Kaufman

  • Giles,

    Giles,

    That is weird if they changed that -- but might I ask why you would need a wildcard like "*" in full-text search? Isn't full-text searching inherently a "contains" situation (i.e. a term with wildcards on both sides, *<term>*)? To put it another way, I cannot imagine a search term with an asterisk returning anything other than what is found for the base search term?

    Not sure about "?" -- does something like a Google search generate different results based on positional wildcards? I'm off to test!

     

    Thanks,

    Joe Kaufman

  • Larry,

    Larry,

    Glad you figured it out! Welcome to the powerful world of SQL!  *smile*

     

    Thanks,

    Joe Kaufman

  • Query

    Larry,

    I assume you are using MySQL Workbench? I do not have an example of accessing DocuWare with that, since our database is MS SQL Server. But the methodology is the same.

    Assuming you are connected, you need to go to the correct database, or "schema" as MySQL calls them. I have attached a picture of accessing a MySQL database I have set up to store weather data from my personal weather station at home, just to give a feel for how the databases are listed.

    I have also attached what a DocuWare database listing looks like in SQL Server. AS you can see, file cabinet data is in a database/scheme called "dwdata". Expand that database and find the table representing the file cabinet. It should have a similar name, though certain characters are converted to underscores and the name will be in all capital letters.

    Once you have the table visible, right-click on it and choose "Select Rows" from the menu. This will generate a query to return all rows in the table, such as:

    SELECT * FROM <schema name>.<table name>;

    If you just want the count of records, you can use this for your query:

    SELECT COUNT(*) AS NumRecs FROM <schema name>.<table name>;

    That will just return the singleton field denoting th enumber of records in the table, and that should be your number of documents in the file cabinet.

    Hope this helps!

    Thanks,
    Joe Kaufman

    https://www.docuware.com/sites/default/files/forums-images/dw_mysql.png

    https://www.docuware.com/sites/default/files/forums-images/dw_mssql.png

  • Just do a SQL query

    Larry,

    Can you access the SQL Server under the data and see how many documetns are in the cabinet? That's the easiest way to count at this point... This must be on-premise, right? You can download SQL Server Management Studio and access the SQL Server database directly (or MySQL explorer, if that is the db), and then do a quick select query.

     

    Thanks,

    Joe Kaufman

  • Bernie,

    Bernie,

    Did you even try rebooting the server entirely? And that still didn't bring the link back?

    Yes, you can have multiple links. They display down the side of the viewer, and can each point to their own criteria and result list.  That is, if you can make them appear.  *smile*

     

    Thanks,

    Joe Kaufman

  • Refresh issue?

    Bernie,

    On 6.11 (so, using the DW Admin Desktop tool to create related document links), I once had an issue where it seemed like links took a while to show up. No matter how much I refreshed and applied, it took some time and then the link would appear right as I was about to call support.

    How long have you been waiting? Have you tried bouncing the DW services on the server (if this is on-premise) or bouncing the whole server? Just to see if the links appear and so you know it is a caching/timing/event queue issue.

    And, of course, have you checked the permissions for the result list the link generates? I do not think the links themselves have permissions (I do not see any at a glance, anyway), but I am not sure what happens if the user has access to the file cabinet but not the result list the link leads to.

    When we have had things non-visible in the past, at least half the time it was because we had not granted proper permissions somewhere along the long line of things being used...

     

    Thanks,

    Joe Kaufman

  • Thanks!

    Phil,

    Thanks for the detailed confirmation on that -- good to know!

     

    Thanks,

    Joe Kaufman

  • Test

    Connie,

    I just changed my DocuWare password via the DW Admin tool so that it is different from my Windows password. I was still able to log into DocuWare via Windows Authentication, and then when I used DocuWare authentication I had to use the different password I had just changed to. 

    I can't be sure it works the same way when it comes to expiration and password compliance rules, though. Anyone close to expiring that you can test with? It looks to me like WIndows authentication works regardless of the DocuWare login. I have had uses that never logged in with DocuWare authentication and so have never even changed their password away from the original (we do not enforce any rules or expirations, though).

     

    Thanks,

    Joe Kaufman