Design and Manufacturing solutions through Digital Prototyping and Interoperability

Category Archives: Management

Design Highlights for August

NASA Develops Multi-Alloy 3D Printing Process – RT.com

August 3rd, 2014. image Researchers at NASA’s Pasadena based Jet Propulsion Lab are actively working with a process that 3D prints an object composed of more than one metal alloy. The team has been working on the project since 2010, after being inspired by wanting to improve on methods of combining parts made from different materials. The team has developed a method of changing the metal powder at will, and using a customized laser sintering process that adds layers tangentially on a rotating shaft. The article noted gradient alloy objects have been developed in the past, but not with definitive separate parts in a single mass. Some possible uses were proposed such as an object with different melting temperatures, densities and even magnetic properties.

Edit:

A far more detailed review was found at Design Engineering.com, discussing the linear process that has been developed, some drawbacks with brittleness and their workarounds. Additionally, Design Engineering pointed to the full scientific report on the radial deposit process.

The Diverging State of PDM – Lifecycle Insights

By Chad Jackson on Friday, March 28th, 2014. image I enjoyed reading Chad Jackson’s take on the changes that are taking place in the data management space especially after we did our look to 2015. Chad noted how the Product Data Management (PDM) across the industry began to more towards the cloud in a similar path, but sometimes different methodologies. The thing that was significant to all is that everyone was moving together in a common direction. However since 2013 things have begun to fragment, and Chad discusses specific examples of how this is starting to occur, and what the strategies are behind these diverging methodologies. I liked Chad’s statement here:

“This stands as the antithesis of Autodesk’s and Dassault Systèmes approach, which is the automate the manage and tracking of changes as much as possible. GrabCAD’s approach is to give the market what they want. The approach for Autodesk’s and Dassault Systèmes is to be more visionary. [SIC]“

Siemens CAE & Test Symposium 2014 – Siemens

“Smarter Decisions, Better Products” image Siemens has announced their CAE & Test Symposium that is planned for October 22-23, 2014 on a boat of all things – Queen Mary in Long Beach, California. This is the former NX CAE Symposium. Siemens has rebranded the symposium to reflect their expanded capabilities especially after the purchase of LMS International NV in 2012. This should represent the entire lineup of testing and simulation software under their roof. LMS, by the way, was a strategic acquisition and gave Siemens some well-regarded capabilities. Here is a quote from the Siemens 2012 press release: “Siemens will become the first product lifecycle management (PLM) software company to provide a closed-loop systems-driven product development solution extending all the way to integrated test management.” I’d really like to attend this symposium to see how they intent on moving forward with all the luggage they are now carrying.

The One True Part Number System – GrabCAD

By Ed Lopategui on August 5th, 2014. imageEd did a great job on this somewhat humorous write-up, looking at the differences between people’s (often heated) arguments over structured vs. non-structured part numbers. There is significant truth in both arguments, but Ed called for a balance and flexibility that allowed for things to work together. Some items he suggested are:

  • A temporary pool of simple numbers in early-stage design
  • Easy re-identification
  • Gaps in numbering to permit grouping
  • Numbers evolve as the design matures
  • Include only the minimum information, and decide how much that will be.

What is interesting is that these might be considered what GrabCAD has in the works for their Workbench service, which is rapidly evolving as we speak, and has a lot of eyes on it (including my own).

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


 

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


 

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)