Solid Edge Error while adding parts 'ExecuteNonQuery requires an open and available connection'

2024-04-01T06:53:20Z
APPLICATION

Summary


Details

Error while adding parts 'ExecuteNonQuery requires an open and available connection. The connections's current state is closed'

Solution

This may happen when there are corrupted LocalDB instances. The corrupt one must be stopped, deleted and recreated.

The recommended workflow is this:

1) Open the Command Prompt window (cmd.exe)


2) Type in “SqlLocalDB i” to get a list of currently existing instances on your machine:


As you can see, here result is:

MSSQLLocalDB

ST

ST14

ST15

Note: LocalDB instances created for Standard Parts are only the ones starting with “ST..”

3) Delete all the ST.. instances (ST, ST14, ST15 here in this case) by these steps:

    a) Stop the instance ST15 by “SqlLocalDB stop st15” and press Enter

    b) Then delete the instance ST15 by “SqlLocalDB delete st15” and press Enter:


4) When all ST instances are stopped and deleted, try the Add from Libraries command again.

KB Article ID# PL8777296

Contents

SummaryDetails

Associated Components

APPLICATION: STANDARD_PARTS