Design and Manufacturing solutions through Digital Prototyping and Interoperability

Tag Archives: management

@%#&! Autodesk Vault just overwrote my file

Recover Overwritten Vault CAD FilesIf you’ve used Autodesk Vault at any time, then its highly likely you have downloaded a file you already have checked out and overwrote a chunk of your work. Unfortunately that’s just one of several scenarios, which can result in you losing your work. The real trick to preventing this of course, is to check your work into Vault every couple of hours (similar to continually saving within your CAD application). Nevertheless, there could be a number of reasons why checking in your work continuously isn’t feasible. I often hear the comment “I wish Vault had a recycle bin”, I’ve even murmured those words myself and you know what it’s a reasonable request. Why can’t Vault create an old version of the files it’s overwriting? Although its likely possible, it could get mighty confusing.

Just over a year ago, one of my staff downloaded a skeletal / master model from Vault while trying to work around a problem he had, the problem was he already had it checked out, but worse he hadn’t checked in the file for a couple of days. He had created components, built a main assembly and even produced a drawing. Needless to say overwriting his skeletal model with what was essentially a template file, was highly undesirable. Don’t judge him though, he’s new to this Autodesk Inventor / Vault game, all while dealing with a temperamental VPN connection & a new replicated Vault, so he’s been doing a grand job. All of my staff and myself have all made this mistake once or twice.

Autodesk Vault Inventor Project File Old Versions Setting

In the past the Inventor Old Versions folder has been our first port of call, depending on how your Inventor Project File is setup, these folders can be a gold mine during these arse puckering moments. The project file setting I am referring to is shown in the image above, I like to set Old Versions To Keep On Save to equal 5 on all Vault project files. Of course, this tactic is of no use to AutoCAD users, but it does have some of it’s own backup treasures which may or may not be useful within any given situation.

This time however, I’m glad he made the mistake, because it prompted me to ponder if some of the new Windows Explorer features in Windows 7 on wards would help out here. The particular feature which inspired me to Google for a solution, was the undo tool. In Windows 7 or 8 if you delete a file in a folder, then press Ctrl + Z, it will undo the delete command and restore the file. In this case the file had been overwritten by an application and not as a result of the user interacting directly with the folder. So I took a punt and searched for:

“Recovering an overwritten file”

The first search return took me to this site. Method 3 of 4 was a particular surprise, I couldn’t believe it, I’d seen this tab in the Windows 7 Property menu before but I’d never realized it’s impact. The command worked perfectly, the 2 days of lost work was returned thanks to this hidden gem. You can even open or copy the previous version to a different location if you aren’t confident it’s the right way to go. Be warned though, this isn’t a fail safe, but this is always worth a check in this situation. The best part though? This is handy for all Windows users, not just Vault users.

Windows 7 Restore Previous Version Tab

Then I went and took a look at Windows 8 to make sure this behaviour still existed, it turns out it doesn’t and this article explains why. Thankfully Microsoft just improved it out right, the only catch is you have to enable it and point it to a non system drive. Take a look at this well written article explaining how to do that. Another bit of good news is Windows 10 has maintained the same system as Windows 8, so we are looking good into the future. If you are the owner of your Autodesk software, then you could re-purpose your Autodesk USB installation media, to leverage this native Windows benefit.

These tools for Windows 7 & 8 are cracking little gems, lurking in the background, rarely used but invaluable all the same just waiting for the opportunity to shine and save your butt. The best part is they can be used on any file stored on your hard drive and not just those your use for CAD. Check them out and if you need to, enable it. With respect to the title of this post, I haven’t really shown you how to prevent it happening in the first place, I will do this in an upcoming post covering dialog and prompt suppression within Vault and it’s application add-ins.

Small Business Design Management Needs

Creativity and CollaborationWe have been reviewing our options for collaborative space and data management needs for business, design, and simulation. I wanted to take a look at how the cloud is enabling the lightweight collaborative design data management needs of some SMBs, and later, try to point out what to watch for in the near future.

Summary of the SMB Design Management Review

SMB Design Management at Autodesk

SMB Design Management Vendors and 2015

Why Collaborative Design Data Management?

Product Lifecycle Management – PLM

Product Design Management – PDM

Enterprise Resource Planning – ERP

Customer Relations Management – CRM

Document Management System – DMS

…and on and on.

The list is endless and quite likely you need some form of most of these in your day to day work. The problem is that the really useful tools are part of very large expensive systems developed by only a handful of vendors, who by virtue of their vast market share, have defined the way we are expected to behave around design data.

New collaborative needs and incredible cost have forced many small businesses to rely on less capable systems, terrible data workflows, and limited features.

Which Features are Important?

That is the crux of the entire issue, and being asked by the wrong people, namely you. In this market it should be the other way around.

Data management software is typically either too vague about how it organizes data, or too specific to one particular industry or another, and all of them require some tuning and programming to get the software to match the way you work.

…and no one wants to do all the customization.

If you are still playing ‘Hansel and Gretel’ data discovery with MS Office and Windows Explorer you are not alone. So why don’t we all just jump out and get some data management?

One important factor is the short period between the emergence and focus on SMB PLM needs, and the sudden upswing in collaborative possibilities. “I need some PLM and PDM, but how do I include collaboration?”

Team Lift, Design, Collaboration

Let’s take a moment and completely jumble everything up. Growing trends in collaboration and market globalization, fueled by accessibility of the internet are pouring in data from all angles and unthought-of workflows. We don’t quite know how to deal with it all yet, and neither do the data management vendors.

I need to catalogue…:

  • Information, instructions, correspondence, and specifications for clients, subcontractors and manufacturers
  • Proposals, agreements, and correspondence
  • Design and non-design data, including iterations, versions, and revisions
  • Industry / company standards and compliance
  • Visualization data
  • The almighty BOM(s)
  • Subcontractor orders, inspections, and correspondence
  • Deliverables
  • Municipal and organizational review comments
  • Supplies
  • Analysis data and reports

 

This scenario represents the least common denominator of many company’s needs, regardless of size. All of this information must be tied together in a project type relevance, but also permitted to associate with other data inherently. This information needs to be discoverable in a myriad of ways, and it needs to be accessible, and easy to use.

The trick is that we also need this data to be compiled between multiple collaborators that are all part of the common design process, on a globally accessible, but relatively light-weight framework.

So, which software serves SMB design firms best? 

Take a look at how Autodesk is changing their management and collaboration software solutions.

We’d love to hear from everyone about what has been going right for you, and what has not. Are there holes in your data management setup, or do you have the magic balance of management and collaboration? Leave a comment and let us know what you’ve discovered.

Image Credit: Norman Lear Center – Flickr

[subscribe2]

Small Business Design Management at Autodesk

The Cloud IronyDid you know that the very same Cloud that was demonized by so many design firms resistant to any change, is the same platform that is making possible the cost effective, flexible management systems that the same SMB firms desperately need? Irony.

* Software as a Service (Saas)

* Platform as a service (PaaS)

* Integration as a Service (IaaS)

The cloud solves many issues including infrastructure and platform at a substantially reduced price. All you really need to do is access the software and make it work for you.

What Software?

There are a few companies that are working hard to fill the void.

These include Autodesk PLM 360, Microsoft Office 365 and Sharepoint, Arena PLM, Aras PLM, Ally PLM, Kenesto, Siemens Solid Edge SP, CADAC Organice, Autodesk 360, GrabCAD, and more.

Almost all of these have one factor in common. They were built for companies in the SMB space to fit a wide array of workflows and needs. All have very interesting strong points, but none fit the small, but broad range of needs. Today I want to review what Autodesk has been doing.

The Fusion Platform

I’d like to mention Autodesk’s Fusion /Sim/CAM 360. The entire data framework was built on PLM 360 platform, enabling a single, true source for all software to interact with. Managed data would no longer require aggregation from multiple design sources. They truly have a really good overall plan to integrate all these collaborative data management needs in a lightweight framework. The raw data is not accessible enough, nor are there instrumental workflow features yet, but I love the concept and wanted to give them an honorable mention here.

Jitterbit

Jitterbit (not affiliated with Autodesk) has a wonderful service that connects you’re a-la-carte datasets in a fluid manner, but at a substantial premium. Each paid connection increases the price and brings us right back to data management costing way too much for small companies. I mentioned them here because they have a great partnership with Autodesk for connecting Vault and PLM 360.

Autodesk PLM 360

Autodesk went after the overall need to manage data, developing a reasonably customizable framework and really did provide a good value and easy-to-adapt data management tool. The problem was that while they included some great design workflows and controls, there are some basic refinements that need to be fulfilled, and Autodesk completely left out the design data part. There is just no realistic method to store and catalogue CAD data on their cloud.

This is understandable as Autodesk already offers CAD PDM, Autodesk Vault, to their customers. Remember SMB data management is now a-la-carte. Jitterbit will gladly connect these two, but at an annual cost, and without any collaborative features. Viewing this from the perspective of a company who has purchased Vault Professional, it does seem weird that Autodesk expects customers used to transferring complex data between their CAD applications for free, to pay a significant annual fee to transfer metadata between their PDM and PLM products.

Autodesk 360 is getting an Overhaul

This product many of you know has been developed as a collaborative storage space. CAD

data is easily accessed by Autodesk CAD software, and people can be invited into the space to collaborate and discuss the design. There are numerous problems from a productive design platform perspective, including the fact that the files are not well discoverable, nor is there any method to catalogue data, and no real management. It’s simply storage and collaboration, and it’s not really comfortable to work in.

I sat in on a meeting with Sheila Wakida, Autodesk’s Sr. product manager for the cloud, who discussed the changes that are taking place in the Autodesk 360 platform. She discussed the timeline for the year and what the company was doing with Autodesk 360.

 The New Plans in Autodesk 360

Better model viewing capabilities, CAD agnostic assembly and dependency detection, and integration with software and services to include things like Dropbox and Autodesk PLM 360.

That’s right. Shortly after Autodesk 360 becomes a premium service this summer, they will integrate PLM 360 in order to merge their capabilities (at this stage the service will only be available in the U.S., U.K., and Germany). That changes the scope of things substantially. Where companies would shun each product because it lacked the other’s capabilities, tying them together opens up a new realm of possibilities for some.

Add in very deep search algorithms, new dashboards for situation awareness and many more features, and Autodesk suddenly becomes much better suited to provide a useful data management solution that is accessible to small design firms.

… and the Battle Begins

Autodesk is not the only game in town. Vendors are diligently pulling together their ideas and solutions in an attempt to answer the question, “Who is providing USEFUL design management tools that meet the flexible needs of today’s small design companies?”. Come see what we found.

Image Credit: Mike King – Flickr & Autodesk

[subscribe2]

Small Business Design Management Vendors and 2015

In recent articles, we’ve been discussing the design data management needs of design firms in the SMB space (Small-to-Medium Sized Businesses). I touched on what Autodesk has been planning as well. Now I’d like to go beyond Autodesk, and look at some other options that we have been reviewing, and how all of the factors I’ve discussed may affect your future.

Management Software Vendors Offer More Flexibility

GrabCAD

GrabCAD started off as a great place to showcase your designs, developed by Hardi Meybaum and Indrek Narusk. It began to change into a collaborative workspace and enabler, ultimately becoming their recent launch of GrabCAD Workbench.

GrabCAD WorkBench Project File Version

The funny thing is that while many have discounted the new service as a novelty, the company is very aggressively developing far more robust capabilities to fill the needs of exactly who we are talking about, the SMB design companies. GrabCAD has already licensed the Parasolid model in order to better develop their viewing and inspection capabilities. Now they are adding useful Bill of Materials (BOM) features, engineering workflows, and much more. Have you checked it out recently? Their CAD viewer is off the hook. It’s worth a look to see just how useful the storage and collaborative space is at this point before all the changes begin to form.

GrabCAD CAD Viewer exploded in section

CADAC Organice

Cadac Group specializes in providing IT solutions to create, manage and share digital design information. That sounds pretty close to what we are talking about.

This team has been aggregating CAD storage and data for some time on SharePoint, and are leveraging that on their hosted SharePoint Cloud. They have vast knowledge and experience in dealing with CAD model data management and have already been involved in Inventor upload add-ins. I am very much hoping for a design and manufacturing specific SharePoint app release for Office 365 Small and Medium business in the near future.

SharePoint and Office 365

SharePoint as part of Office 365 is emerging as a real contender for the small design market. How is that? SharePoint sucks right?

Well, yes and no.

The SharePoint interface itself is clunky, not really design component or process related, and it is still a collection of poorly joined resources, but let’s look at it as a Platform instead.

SharePoint Site Image with Database

Every purchase of Office 365 Small and Medium Business gets you a SharePoint cloud site and a large amount of storage. The current version is 2013 and has been substantially cleaned up which makes it reasonably functional.

* Easy to use and pre-configured collaborative and project management spaces

* Document versioning and control

* Smooth Outlook and Office integration are valuable tools as well

* Pre-configured, streamlined Exchange servers on Microsoft’s Azure server

* Tons of storage with triple redundancy backups

…at no additional cost to your Office licenses. That means that almost every licensed user will have access to a SharePoint cloud site, all their collaboration and records, and their versioned data files in a controlled and secured environment.

Get this: as one Microsoft engineer told me, you can license only the in-house seats you need, but invite the entire world to collaborate with no additional cost. This is hugely significant considering that other services require each invited collaborator to occupy one of your paid seats. Microsoft is pushing collaboration on SharePoint hard.

Also Microsoft is heavily investing in the SharePoint App approach, where companies can develop custom apps that run inside the SharePoint team-site envelope. This means that 3rd-party vendors van develop well-customized data, forms UI, and workflows that can leverage the existing data structures, managed storage, and collaborative spaces, and provide design firms with a powerful well rounded solution.

All the SMB design industry needs is a solid 3rd-3rd party SharePoint application and it’ll be on like Donkey-Kong.

Why is 2015 Significant?

I believe that 2015 will be the baseline for the SMB data management service. Companies are racing to develop useful tools that are reasonably CAD Agnostic, and meets the collaborative, aggregate, storage, discoverability, and accessibility needs that have become so evident in the last few years.

What is more important is that the company that delivers a complete, easy to use, extremely configurable deep-search tool that stores, catalogues, aggregates, and secures design models and data, with customizable form UI, and accessible storage and delivery pipeline by the end of 2015 will set the stage for how small companies will collaborate, and will shape the way we work in the near future.

Will GrabCAD with its beautiful collaborative and viewing interface bring enough management tools to the party? Will Autodesk 360’s integration with Autodesk PLM really tie together all the parts we need in a useful, non-frustrating way? Will one of the fledgling data management vendors put together a comprehensive SharePoint Cloud app that better aggregates data and offers CAD model viewing?

If any of these things occur, D&M will likely be the first company to purchase seats.

Searching, Listing and Filters | Autodesk Vault Professional 2015 – Microsoft SharePoint 2013

SharePoint Searching Listing FilteringSearching

Once we had SharePoint and the Vault database actually on speaking terms, the next step in the process was to configure the Vault Search feature. SharePoint already has the ability to search within its own database for keywords or filenames, etc. What we want now, is a separate search inside SharePoint that looks at Vault results only. This is where we ran into another snag that had me confused for a while.

Following the instructions in the Vault-SharePoint Integration documentation, I got stuck at step #12. Perhaps this would be a good spot to share this procedure, as it is written, so I can better describe the workaround. This one gets a bit confusing.

Configure Vault Search

1.   At the home page for the site, click the Settings > Site Settings.

2.   Select Search Result Sources under Site Collection Administration

3.   Click Result Sources in the Search group.

4.   Click New Result Source.

5.   Fill in the following data

  • Name: VaultSearch
  • Protocol: OpenSearch 1.0/1.1
  • Query Transform: {searchTerms}
  • Source Url: http://<server>/_layouts/Autodesk.Vault.BCSConnect/VaultSearch.aspx?s={searchTerms}&i={startIndex} Replace [server] with the value of your SP site.
  • Credentials: Anonymous

6.   Click Save

7.   Return to the home page for the site and click the Settings > Site Contents.

8.   Click new subsite

  • Title: Vault Search
  • Web Site Address: http://<server>/vaultsearch
  • Select Basic Search Center in the Enterprise Template tab
  • Select Yes for Navigation Inheritance
  • Click the Create button

9.   Go to the newly created site

10.   Click the Settings > Site Settings

11.   Select Result Sources

12.   Select the Vault Search resource created in step 8 and select Set as Default from the drop-down menu.

13.   Return to the site page and perform a search.

I followed this procedure step by step and everything was working just fine until I got to step #12. When I got to the Site Settings for this newly created sub site, the Vault Search resource was not there to select. This had me baffled, as I knew I was following the steps as they were written, and I had been assured by Autodesk people online that the procedure was correct. No matter how many times I did it though, there was no Vault Search there to Set as Default. Returning to the home page and looking at Result Sources there, I was able to select Vault Search and set it as the default. However, doing this overrode the default SharePoint search and replaced it with my Vault search. Now, no one was able to search for anything in SharePoint.

Finally, after scratching my head for a bit and panicking again, it occurred to me that it didn’t really make sense that the search Result Source had been created at the top level, before the Vault Search sub site was created. To me, it made more sense that the sub site should be created first, and then the search Result Source be created under that. Since I was still in the sandbox I decided to do a little creative playing with the order of this procedure.

Configure Vault Search

  1. At the home page for the site, click Settings > Site Contents.
  2. Click new subsite
  • Title: Vault Search
  • Web Site Address: http://<server>/vaultsearch
  • Select Basic Search Center in the Enterprise Template tab
  • Select Yes for Navigation Inheritance
  • Click the Create button
  1. Go to the newly created site
  2. Click Settings > Site Settings
  3. Select Result Sources
  4. Click New Result Source.

Fill in the following data

  • Name: VaultSearch
  • Protocol: OpenSearch 1.0/1.1
  • Query Transform: {searchTerms}
  • Source Url: http://<server>/_layouts/Autodesk.Vault.BCSConnect/VaultSearch.aspx?s={searchTerms}&i={startIndex} Replace [server] with the value of your SP site.
  • Credentials: Anonymous
  1. Click Save
  2. Return to the home page for the Vault Search sub site (http://<server>/vaultsearch), click Settings > Site Settings.
  3. Select Search Result Sources under Site Collection Administration
  4. Click Result Sources in the Search group.
  5. Select the Vault Search resource created in step 7 and select Set as Default from the drop-down menu.
  6. Return to the sub site page and perform a search.

This revised procedure creates a sub site for the Vault Search, and then creates a SharePoint Search Result Source on that sub site. This keeps the main SharePoint search feature separated from the Vault search, ensuring correct results from each. You can then easily create a link to this Vault Search on the SharePoint site home page, if you want. Here are some images of the search Screen and a typical search result.

Powell SharePoint Search FieldPowell SharePoint Search ResultsListing

To create a list of Vault data to be displayed on a page within SharePoint, go to http://<server>/_layouts/15/Autodesk.Vault.BCSConnect/addVaultlist.aspx

Type in a name for the list, and select a list type from the drop down menu. You can create a list for Vault Files, Items or Change Orders. When finished, click Create List. Make a note of the URL that will be created when you add the list. The format will be: http://<server>/Lists/<listname>/AdskVaultFileFinder.aspx (note: for Items this will be AdskVaultItemFinder.aspx, and for change orders AdskVaultChangeOrderFinder.aspx)
Once you have created a list, you still need to add a link to it on whichever page within your SharePoint site you want to view the results. To do this, navigate to the page within SharePoint and select Settings, Site Contents. At the top of the contents page you should see “add an app”.

SharePoint Add Vault ListsSelecting this will open a page with available apps that can be added to your page. Select “Links“, and give the app a name. This is what will appear on your SharePoint page and is what users will see. The app will appear at the bottom of the page, and under the name you will see “new link or edit this list”. This example is from the CAD page on my home site.

Add SharePoint AppEach of the items you see under the links, is a Vault List created using the steps above. When you select “new link” you are prompted for the web address. This will be the web address from the list you created earlier. There is a link to test your web address to make sure it is correct. Click Save once satisfied, and your Vault List will be added as a link on that page.

SharePoint Vault ListsFiltering

Once you have added a list to a page within SharePoint, it will return all results for the List Type you selected during List creation. So, an Item List will return the entire Item Master as the list results. Depending on how large your Vault database is, this will be more results than you probably want or need. Now you need to add some filters, to narrow the results to a specific set of Items or Files. In this way, for example, you can have a List that shows only those drawings associated with a particular project, on the project’s page in SharePoint.

Select a List from the link you just created in the steps above. Depending on the speed of your network and the size of your database, this could take a while. Once it is loaded, look for the toolbar in the upper right of the screen with Browse, Items & List. Select List and then Modify View.

SharePoint Modify ViewA View in SharePoint is simply a filtered version of the list. You can create many different Views from one List, and then specify one to be the default. Selecting Modify View brings up a screen full of options to narrow the results of this list. The first requirement is to give the view a name. In the future users will be able to select from your list of views by selecting Current View, as seen in the above image.

The section for Columns allows you to choose from a list of properties, preloaded from the Business Connectivity Model, for the Vault object type. Adding or removing columns from this list is covered quite well in the integration documentation, and worked very well in my testing, so I will not go over that in this article. The list of properties will be shown in the list results as a chart from left to right, in the order of their position. By selecting or deselecting the Display check-boxes, and manipulating the Position values, you can customize which properties you want to show and in what order.

SharePoint Configure ColumnsThe next section on the page is Sort. This sort allows you to do just that, sort the results by any of the properties in the list of columns. Data Source Filters is a good one for narrowing down the results of a list. You can filter by Category, State, Vault Folder and Limit. For Change Orders, the filter for Category would not be present. Category allows filtering by a Vault Category, State filters by Vault life cycle state, Vault Folder allows for filtering by specifying a folder path in the Vault project explorer. The correct format is $/1st level folder/next level folder. Limit specifies how many objects will be returned for this list from Vault. The default is 100.

SharePoint Data Source FiltersIn the example above I have filtered a list of Files, based only on a specific folder residing inside Vault. For an even deeper level of restriction on list results, you can use the Filter section to narrow the scope based on specific properties.

SharePoint Filter ConfigurationYou can stack up as many of these property filters as needed to narrow the scope of your results, but be careful that you don’t get too carried away. I recommend adding filters a few at a time, and checking the results. With some trial and error, you will eventually get to the results you want for this custom view. Make notes along the way so you can repeat the process on other pages. In my examples above I was able to narrow a list of the entire project explorer down to a much shorter list of only Autocad drawings from one specific folder. This speeds up display time and cuts down on frustration when a user is looking at a list.

There are other settings on this page that will affect the overall appearance of your lists, play around with them as you have time, but these are the main areas for filtering a list to a smaller group of results. Here is an example of a list which has been filtered down.

SharePoint Vault List ResultsSelecting one of these files will bring up a detail page that gives the user information about the file or item as well as any links to the CAD file itself or to the visualization file.

SharePoint Vault File List Result Detail PageConclusion

So… There you have it. Easy as pie, right? Using the installation document that came with the integration package; Autodesk Vault Professional 2014 – Integrating with Microsoft SharePoint 2013, and these helpful (I hope) tips, in no time at all you will have installed the Autodesk Vault Professional 2015 – Microsoft SharePoint 2013 Integration, set up login credentials, created a search function, and then created and filtered lists which can be placed on any page in your SharePoint site. Now anyone in your company, or even from outside if you grant them access, can use SharePoint to take a look into your Vault and download or print your CAD data. Now, if you feel brave enough, it’s time to move this into a production environment. Remember…. backup everything first! Good luck and….. Enjoy!

“Autodesk® screen shots reprinted with the permission of Autodesk, Inc. Autodesk® , AutoCAD® , DWG, the DWG logo, Vault®, Autocad Electrical® and Inventor® are registered trademarks or trademarks of Autodesk, Inc., and/or its subsidiaries and/or affiliates in the USA and other countries.” Programs and programmers’ information used with permission. Thanks guys!

The Journey Continues – Crisis Resolution | Autodesk Vault Professional 2015 – Microsoft SharePoint 2013

SharePoint Crisis Resolution - The National GuardDuring The First Steps into Darkness, I discussed a workaround for missing External Content Types. Once those are set up where they belong, the next section of the setup goes pretty smoothly. You set permissions for each of the three main areas of Vault Professional:

  1. Files
  2. Items
  3. Change Orders.

This makes it possible to create lists in SharePoint for each area of Vault.

The next step in the initial setup, is to configure the Vault login. This is a set of login credentials that will give SharePoint access to the Vault database. First things first, a Vault User must be created and given read only access in the Vault to the areas needed. The best advice is to make this a Vault only user, rather than a Domain user. Give the user access to any groups it may need, to access the appropriate Files and Items. At the very least, give them the Vault Change Order Editor (Level 1), Document Consumer and Item Reviewer Roles.

Once that user has been configured in Vault, follow the documentation instructions for configuring the Vault login. This is the login that gives SharePoint the right to access the Vault. The SharePoint Vault Settings screen should look like this:

vaultsettings

  1. The Server field is the name of your Vault server, or it’s IP Address.
  2. The Database field is the name of the Vault you want access to.
  3. The User field is the username for the user you just created in Vault.

If you are setting the password for the first time, or changing it, select the Update Password checkbox. The pages section should be filled in already, pulling from the previous steps of the integration. At the bottom of the page are checkboxes for visualizations. All three are selected by default, but to maximize your search results I recommend leaving only the top one checked. This is up to your discretion.

I showed you this and described some of the steps found in the documentation, because it’s right here where I hit a massive brick wall. I even started having visions of myself sitting at home in my sweat pants, drinking coffee, unshaven, unwashed and looking through online job listings.

I entered all of the information just as you see it above, with the addition of the password, clicked the Save button and was greeted with the following message:

EXECUTE permission was denied on the object ‘proc_putobjectTVP’,database ‘SharePoint_Config’, schema ‘dbo’

Um,… what? This one went way over my head so I called in my IT support. After a bit of digging and searching, he was able to find an answer on the internet. The one good thing about error messages, is the chances are pretty good someone else has already seen it or something like it, and posted a fix online. This case was no different.

The object was slightly different, but the fix was the same… which was a good thing because we ran into two more of these after the fix was applied to the first one, like dominoes. This is an excerpt from the web article providing the steps to assign the necessary permissions for these objects. This fix is applied to the SharePoint Config database on your SQL Server.

Detailed Steps

In order to resolve the issue, I provided Execute permission to the database role “WSS Content_Application Pools” into the stored procedure “proc_putObject”. I performed the following steps to do this:

  • In the database server, expand SharePoint Config database and navigate to Programmability/Stored Procedures/db0.proc_putObject using SQL Server Management Studio.
  • Right click on the above stored procedure and select Properties.
  • On the popup screen, select Permissions on the left and click Search button.
  • On the new popup screen, click Search, select (WSS Content Application Pools) database role and click OK.
  • Click OK again.
  • On the first popup screen, select the role, check Execute permission and click OK

Once we fixed the first error, we also had to apply the same steps to the following procedures:

proc_putclass and proc_getnewobjects.

So, everything is all fine now, right? Not so fast. After these errors were overcome, a new one popped up that had everyone stumped, including the Vault development staff I spoke to. No one had seen this one before.

SharePoint 2013: Event ID 6398 An update conflict has occurred, and you must re-try this action

I think we stared at this message for about three days, trying everything we could come up with, before we once again found a blog post that was directly related to this error.

“Issue: (from Microsoft) This issue occurs if the contents of the file system cache on the front-end servers are newer than the contents of the configuration database. After you perform a system recovery, you may have to manually clear the file system cache on the local server.”

This fix is performed on the SharePoint server. The file system cache will rebuild itself after it has been cleared, with no damage to anything else within the site. So, since this was still in the test environment we just pulled the trigger and cleared the cache as outlined in the blog post. I re-entered the login credentials… again…. and hit the save button. To an audible sigh of relief the message we received was: Your changes have been saved! We were in. Our SharePoint tenant was now talking to our Vault. Now we just had to decide what we wanted it to say!

Searching, Listing and Filters

Image Credits: Powell Fabrication and Manufacturing inc and The National Guard (Flickr)

[subscribe2]

Join the Community