Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Serious Database erros with Vault Professional 2014

21 REPLIES 21
SOLVED
Reply
Message 1 of 22
desidubajic
2471 Views, 21 Replies

Serious Database erros with Vault Professional 2014

A few weeks ago we upgraded from Vault professional 2013 to Vault professional 2014.

 

Since then we have been getting endless errors that end up with a user being locked out from editing claiming the item in question is locked for edit by him. After a timeout period the server releases the item.

 

This is ocurring with Item Cards and ECO's as well. A user could for instance click on an item and attempt to change its state, only to get locked out.

 

I understand in using ECO's that in some cases the ability to edit, update or change the state of something is blocked, the most common error (1387) indicates a Restriction. This is understandable, but why on earth is the item locked out for the next 20 minutes.

 

Since this started, we have upgraded SQL from 2008 to 2008 R2 (sp1). Defragged the database and re-indexed it. This did not help. I have researched and am aware that if something fails during a database transaction the record in question gets locked out. I'm just bewildered as to why mundane tasks such as changing the state of an item, or even editing a Bill of Materials only to fail and get locked out after making several changes.

 

We have had such errors in the past with Vault professional 2013 however nothing like we are having now. We just had three people locked out of the items they have been working with, within 5 minutes of one another.

 

Is anybody else having a similar problem? What might be at the root of this? We recently implemented new virus scanners, but I removed it from one of the machines and rebooted the computer, restarted Vault and still had an error occur while performing a simple manual update to an item card.

21 REPLIES 21
Message 2 of 22
olearya
in reply to: desidubajic

Hi there, 

 

This really does require some further investigation, specifically interrogating the server logs to look for probable causes.  Have you, or are you able to log a case with Autodesk support for this?



Allan
Product Manager
Autodesk, Inc.
Message 3 of 22
VinceBalge
in reply to: desidubajic

We are experiencing the same problem.

 

VP2014 SP1 IV2014 Windows7

 

Vince Balge

ATCOEM

 

 

Message 4 of 22
olearya
in reply to: VinceBalge

HI Vince, 

 

As I mentioned above I would strongly suggest tracking this issue via a support ticket that can investigate your specific issue - unfortunately as there was no response to the original post I am not sure whether there was a successful outcome there, but certainly there could be more than one reason for lags in record locking.



Allan
Product Manager
Autodesk, Inc.
Message 5 of 22
Safeflight
in reply to: desidubajic

I have been experiencing the exact same problem with my Vault Professional 2014. While using 2013 we had a lot of 1384 error messages, these made the items un-editable. I would have to go into the file explorer and manually delete the search index folder before I rebuilt them from the ADMS console. This worked temporarily, months later I began to see the messages more frequently so I decided to upgrade. Oh, I forgot to mention I opened a support case with autodesk for this issue and they were unable to resolve the problem. They had me send over my filestore and all the necessary files in a unsuccessful effort to replicate my working environment. They tried there best, so I recommended upgrading because the problem became unbearable. I'm currently using Vault Professional 2014 and I seldomly get a 1384 error message, but I frequently receive 1387 error messages. These 1387 errors are related to restrictions and it also calls out a "SoapException Detail". Users constantly receive Item lock messages and are unable to update items that are being used by Web Client viewers. We have not been able to work with the API due to SOAP issues. I have a support case currently open for these issues and I'm not getting a lot of traction working with Autodesk. This has been a persistent problem for almost 2 months now. If there is anyone out there who can provide with some insight on these problems I would greatly appreciate it.

 

 

Message 6 of 22
desidubajic
in reply to: desidubajic

Well it's both good and bad that others seem to have similar problems. I wish I could say that Autodesk has a solution for Vault 2014. However I too opened a support case and have sent a backup of my database. They have not been able to replicate my errors.

 

I am at the point of creating a whole new clean install of ADMS and SQL on another server. Since Autodesk seems to be using my data without error, then I am guessing a new install would do the same.

 

One thing I didn't think of was, deleting and rebuilding the search index. You say it helped temporarily. That's better than what we have happening now.

 

Either way, we are going ahead with trying a complete new install.

Message 7 of 22
Safeflight
in reply to: desidubajic

    You may want to re-think that idea about re-installing on a new server. I've been working on this issue with Ron Smith from the Autodesk support team, he's been very helpful. He has done a number of things to help server side and client side. He pretty much investigated my permissions on the local machine, I had remnants of previous installs I had to remove. He also changed a few selections in the Vault System properties from the SQL Manager in regards to the access. However, the fix that directly impacted my issue was the following instructions:

 

Go to C:\Users\<USER>\AppData\Roaming\Autodesk

Remove the:

  • Vault common Folder
  • Productstream folder
  • Autodesk Vault <product version> <Product Release number ie 2014>

 

     I will send Ron the link to this discussion group. He would like to see if he could help anyone else suffering from these painful error messages. I'm still testing this resolve and I have been error message free for almost 2 days. I will keep you updated with our progress.

 

Good Luck,

 

D.Alphonse

CAD Administrator

Message 8 of 22
olearya
in reply to: Safeflight

Hey Demetrius,

 

Thanks for the update on your case, I have asked everyone on this topic for their case details so we can have support follow up on the issue but I have only heard from you thus far.



Allan
Product Manager
Autodesk, Inc.
Message 9 of 22
VinceBalge
in reply to: Safeflight

I have tried your suggestion and removed the folders listed on 3 of our systems & it didn't fix the problem.

 

Vince B

Message 10 of 22
Safeflight
in reply to: VinceBalge

Hello,

      That's unfortunate your still dealing with these error messages. I haven't had any issues regarding 1384 & 1387 error messages since I did the fix. You should have someone from Autodesk look into this for you. The rep I dealt with made other changes to my system on the server side also. I think it was a combination of things he did to fix my issues.

 

Thanks 

Message 11 of 22
VinceBalge
in reply to: Safeflight

I've got my Reseller involved & they've opened a ticket with Autodesk support.

Vince B
Message 12 of 22
Safeflight
in reply to: Safeflight

My Vault back-ups will not complete. When I manually try to start a Back-up I get a filestore error. I have been working with Autodesk through my reseller and I was told to change the permissions of the folders in the filestore to read-only. This change has not produced a valid back-up. I also have users being locked out of new items while adding them to the Vault. The locking items have been going for a while, these messages are usually accompanied by a 1387 or 1384 message. Typically you would wait about 15 minutes and then you would be able edit the locked item, but that has not been the case lately. This is a huge problem because production views released documents through our web-client; the production floor is looking for updated information that's unavailable. This is affecting our business in a major way; our parts are on 2/3 of the world’s aircrafts. Units cannot and will not be assembled based off of items with incorrect revisions. Management is beginning to question the investment we have made with this product. I have been experiencing issues since release 2013. I really need some positive insight on these errors that I'm receiving.

 

P.S.

I started a support case prior to posting this and all they did was ask for my back-up logs. I just sent these to my reseller to send to Autodesk Friday. This tells me that I will end up in the same place I started. SMH

Message 13 of 22
TBJV
in reply to: Safeflight

Safeflight, I sympathize with your dilemna. Our company also has been paralyzed by Item Master issues in the past and specifically since upgrading to 2014, we have had the same exact issues as what you have been seeing: Locked items... items that apparently exist but are not visible or searchable... when assigning items we get the message "no newer file versions available for update"...errors 1384, 1362, 155 etc, etc, etc.. We have super tight deadlines that cannot be compromised and unfortunately we seem to hit a roadblock every time we have to deal with these issues. We don't feel like we get the support from Autodesk that we deserve... Our management is also questioning why we keep having Vault issues and started doubting the decision to invest in Vault.
Message 14 of 22
gbarone
in reply to: Safeflight

Hello Safeflight,

 

Have you gotten anywhere with the supoort case since you sent your files into Autodesk?  I am curious if they were able to resolve this. We currently have a case with the exact same issue.

Message 15 of 22
VinceBalge
in reply to: Safeflight

I had several online sessions with my Reseller and Autodesk. The initial suggestions of deleting roaming profiles didn't solve my problem.
In Autodesk's opinion it was related to our VM setup.
I ran a test server on different hardware and wasn't able to produce the error. I then created a new VM with a new install of SQL & ADMS on the same hardware and wasn't able to produce the same errors.

I'm just coming back online this morning after migrating the Vault to the new server I did my testing on.
It's too early to tell if everything is OK. Initial testing this morning is good.

Autodesk & my reseller were very good through the whole process.

Vince Balge
Senior Specialist - CAD Systems
ATCO Emissions Management
260 Holiday Inn Dr. Unit #1 Cambridge, ON N3C 4E8

T: 519-220-0600 Ext 239
E-mail: vince.balge@atcoem.com
www.atcoem.com

The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use or the taking of any action in reliance upon this information is prohibited. If you receive this in error, please contact the sender and delete or destroy this message and any copies.
Message 16 of 22
VinceBalge
in reply to: VinceBalge

Before the end of the first day we are still seeing the same errors

 

Vince Balge

Message 17 of 22
Maxim-CADman77
in reply to: VinceBalge

We are another company paralized with Items in the Vault Pro 2014.
I wonder ... have anybody fought self-locking Item issue?
Message 18 of 22
Maxim-CADman77
in reply to: VinceBalge

Hi, Safeflight, the thread is marked as solved ...

1. Could you accept that initial roblem is solved for you?

2. If no than was it you who put the "Solved" mark?

3. Who is Ron (haven't found any posts from somebody named Ron in the thread)?

Message 19 of 22

 

Greetings, Experts

 

We have the same problem with ECOs and ITEMs, and sometimes with cad files (inside Inventor). Even the administrator can't edit or delete these objects.

I don't know if is convenient for my customer to start the using of ITEM feature. What is your advice?

Is there other quick way to unlock these objects (ecos and items) after the lock error?.

 

Thanks for your help.

Message 20 of 22

We got reccomendation:

... you can let this process running multiple times by adding the key LockVacuumTime multiple times in a row in the web.config.

For example:

<!-- time of day to clear entity locks. -->
<add key="LockVacuumTime" value="3:0:0" />
<add key="LockVacuumTime" value="10:0:0" />
<add key="LockVacuumTime" value="15:0:0" />
"
But it haven't helped us

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report