Posts Tagged ‘Enterprise’

Babysitting SQL

Friday, June 25th, 2010

In the world of SolidWorks Enterprise PDM administration, maintaining the Enterprise systems is really pretty easy. You need to add/remove users (assuming the HR department bothers to tell you when they hire someone) and ensure you have good reliable backups.

But don’t forget Enterprise’s playmate – SQL.

SQL is that one kid who was hard to babysit for. Sure he was good when you were watching him, but if you left him alone for too long you would catch him chewing on the furniture, burning the hair on your sister’s dolls, or using a shovel in your mom’s flower bed.

He’s a good kid, he’ll serve you well, but every once in a while you need to pat him on the head so he knows you are watching him.

Like any Microsoft product, SQL requires some occasional maintenance. Tim Kwong, SolidWorks Sr. Technical Support Engineer, recommends this schedule:

Daily:

  • Preform backups of the SQL database (and log file if using Full Recovery Mode)
  • If using the SQL backup feature, offload the backup from the SQL server

Weekly or Monthly:

  • Rebuild the SQL indexes using SQL Maintenance Plan Wizard
  • Review the MDF and LDF files to make sure they haven’t exceeded the initial sizes
  • Defrag the SQL drives

Quarterly:

  • Check the integrity of the SQL backup by restoring and testing a recent database backup on a test setup

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

HOWTO: Kill SQL

Friday, December 4th, 2009

Looking for a quick way to kill your SQL engine and bring your SolidWorks Enterprise PDM system to a screeching halt?

I just got a support call from an Enterprise customer who was complaining they could not connect to the database. Tried restarting SQL, the service stopped – good…but then I could not start back up again – bad. Rebooted the server, the service still laid there dead. -worser than bad!

killSQL

Next, tried to do a SQL repair install – the repair install failed, telling me “the database engine was bad”. Well no kidding! Had to do a clean uninstall/reinstall of SQL before we could get the service started again.

What happened? Symantec AntiVirus. Symantec started scanning the databases and less than a minute later there was nothing left but the crying. Luckily it didn’t seem to hurt the actual databases – they mounted right back up after the reinstall.

Jeff Sweeney

Jeff Sweeney

Engineering Data Specialist
3DVision Technologies

SQL 2008 PreRelease

Thursday, December 3rd, 2009

Had a little scare yesterday and since misery loves company I thought I would share it with you.

Yesterday I received an email with this image:

SQLVersion

These are the file properties of the Microsoft SQL 2008 install that comes with SolidWorks Enterprise PDM. Look closely, it says that it is a prerelease! Yikes! Using a prerelease for production data?

I’ve done some checking and this SQL build (also known as 10.0.1600.22) is a a RTM build. [Reference] I have no idea why it says prerelease in the version information.  If you are concerned, there is a service pack can be downloaded from the Microsoft web site.

Heart attack averted. As you were.

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

Shun the drawing

Thursday, November 19th, 2009

In the PDM world drawings are always seem to be the after-thought. Are they the parent or the child? Should they be revised if you need to add a missing dimension? Does meta data go in the part or drawing or both? If the meta data does go in both, how do you ensure the data is synchronized?

Even red-headed step children point to 2D drawings and laugh.

During a SolidWorks Enterprise PDM install I did last week, we implemented what I think is a rather unique solution. We didn’t create a datacard for drawings, and the drawings don’t even enter the design workflow, they just sit in a simple “Uncontrolled” state with no transitions going in or out.

DrawingDataCard

I hear some of you gasp: “But Engineering Data Specialist Man how do they find their drawings? What about revision control?!?” It actually is pretty simple. For them, the model is the master, the model is what is revised and searched on. If you want the drawing from a search, do a “Where used” on the model. The drawing’s titleblock information points to the model’s file properties anyway, so what is the point of having a drawing datacard? Designers can check the drawing in and out all day long, adding their missing dimensions, but they cannot modify the model without revising it.

It could be argued that changing a tolerance on a dimension can change the model, thus designers add their tolerance to the model and replicate these tolerances to the drawings. The model is the master, the drawing only annotates the model.

I’ve been to places where they have had the same issues and we have written quite a few little tricks and “work arounds” for these problems where in fact the simplest solution may have been to do nothing at all!

This solution isn’t for everyone, but it is very easy and can solve many data management drawing issues.

Jeff Sweeney

Jeff Sweeney

Engineering Data Specialist
3DVision Technologies

Upgrading to EPDM 2010

Monday, November 16th, 2009

I don’t have the exact numbers, but it surprises me how many of our customers have already upgraded to SolidWorks Enterpise PDM 2010. I am sure the number is close to half -and the release hasn’t even been out a month yet!

So far I haven’t found anyone that had a bad upgrade experience. The upgrade runs just as your 2009 service pack upgrades went except you will need to get  new license file, and you will need to run the “Update.exe” routine to upgrade your database.

Since everyone will be locked out of the vault until you enter the new license file, I recommend getting the license file before you upgrade. Log in to the customer portal, register the product (you’ll need to know your serial number) and the file will be emailed to you automatically.

register

Average upgrade times seem to be about a half hour – depending on hardware speed and the size of your vault.

Why is everyone upgrading so quickly? The new Tasks feature? Toolbox integration? …or are they just excited about SolidWorks 2010 and they know you need to install EPDM 2010 first?

Jeff Sweeney

Jeff Sweeney

Engineering Data Specialist
3DVision Technologies

Capone tracked documents world-wide

Monday, October 26th, 2009

ABC has canceled our mini-series, Mr. Rivera has left in a huff saying that he had not been disrespected so much since Hugh Downs kept thinking he was an intern and always sent him out to get coffee.

Geraldo left with this item screen shot on his screen:
localization
Since Al had a world wide business, it would be logical that he was using SolidWorks Enterprise PDM for its multi-site capabilities. Though he quickly learned each business unit had different manufacturing capabilities. For an example: some groups could not get ANSI steel or perhaps some of their ERP system had part number limitations that other did not. Thus it appears Capone created an item card for his parts that were created in other countries. If a designer wanted to use a part that was already in the system but wanted a localized part number or material, he didn’t have to bump the revision of the file to had his local information, he simply updated the item card.

I’m going to miss working with Geraldo, I though we had a good thing going there. Perhaps I can do a mini-series with Celine Dion soon.

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

Capone used Enterprise to track his stockroom

Friday, October 23rd, 2009

Geraldo continues…

“Welcome back from our break. Today we find ourselves in Al Capone’s server room across the street from where the Lexington Hotel once stood, examining Al Capone’s Enterprise Vault, seen Tuesdays on ABC 9:00 Eastern, 8:00 Central. It appears Al had an item card created especially for his stocked items as well, here is their item card.”

stockroomcard

“I am sure it was very helpful to his designers to know what was available on hand. Though I notice there are many versions of each of these items, this must be due to the fact that the users had to check in/out the card every time the stock room quantities changed.  Seems a little bit wasteful doesn’t it Engineering Datra Specialist man?”

Yeah Geraldo, it would be nice if we had a special control that could be modified without checking the item in and out over and over…like a control directly connected to a database value. This is an enhancement request I have sent in several times now. However, since items are only a record in a database, checking the item in and out over and over is a small price to pay considering Al was able to get control over his stock room with a tool he already owned because it was included in his PDM system.

Geraldo? Where did you go? There is one more tab on this item card… Geraldo?!

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

Al Capone’s manufacturing process

Thursday, October 22nd, 2009

After looking at how Capone tracked his training documents you have to wonder if even the mob was afraid of ISO?!

Come on Geraldo, it is getting cold in here in Al Capone’s server room. (Kept at a cool 50 degrees Fahrenheit for maximum chip performance.)  Go to the SolidWorks models that Capone used to retrofit his famous bullet proof Cadillac. Can you find any?

“Can I find any? With Enterprise’s search features, is that a joke Engineering Data Specialist man? Yes, it appears all of Capone’s parts marked for manufacturer have an item card that looks like this:
routingslips

It appears he set up the card to track not only where the parts were in his shop, but how long there were at each station. Since items can go through workflows just as any other document, Capone was able to streamline his manufacturing process with SolidWorks Enterprise PDM workflows! This show is going to win me another Emmy!”

It might Geraldo, I think this series may win a Bloggie too…anything else in Al Capone’s vault?

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

Rivera learns of training in Capone’s Enterprise Vault

Wednesday, October 21st, 2009

My original plan was to have Geraldo Rivera take over today’s blog, but he claims he can no longer type since his nose was broken, so I’ll continue with the narration.

Okay Geraldo, what does the next tab look like in Capone’s item master?

“Well Engineering Data Specialist Man, it appears Capone had an extensive training program. Many of his training documents have an item card associated with them to track who has actually reviewed each document. In the past, I’ve seen some elaborate workflows created to accomplish the same thing but I have to remark using the item master to track this information certainly simplifies the process.”

signoffcard
Clever indeed Geraldo, what else can we find in Al Capone’s Enterprise Vault? …

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies

The mystery of Al Capone’s Enterprise Vault

Tuesday, October 20th, 2009

Today Geraldo Rivera and I will explore the mysterious SolidWorks Enteprise Vault owned by Al Capone. I wanted this to be a short little blog entry of how Al Capone used the Item Master inside of Enterprise, but Geraldo wants to make this a five part mini-series to air on ABC during sweeps week.

Item Centric PDM ability was introduced in Enterprise 2009 service pack two. Since that time there has been nothing but mystery around it. “What good is it?” People have been asking. Now, here in Capone’s server room we can see just how the Item Master could be used in industry!

The best way to think of what an item is is to imagine a datacard with no corresponding file. This item can [optionally] be linked to a file and thus be used to further describe properties of the file. What is nice is that an item can be checked in and out of the vault independently of the file, allowing you to update information about the file without changing its revision.

Geraldo has the cameras grouped around him, it appears he has found Capone’s item card. It looks just like a datacard. This one has several tabs across the top, one of them is marked “Vendor Information”

vendorcard

Geraldo explains: “As you can see here Al Capone was able to track his vendor information with this customizable item card right within Enterprise, now he could store pricing information in Enterprise and not have to change the revision of a part if the vendor’s price changed. Hey, is that Michelle Malkin in that picture?”

Take it easy there Geraldo, that is not a picture of Michelle. Let’s see what other tabs Capone has on his item card…

Jeff Sweeney

Jeff Sweeney
Engineering Data Specialist
3DVision Technologies