Product(s):	Promis.e, Bentley Substation
	Version(s):	through 08.11.13.140
	Environment:	N\A
	Area:	Installation_Configuration
	Subarea:	N\A

Error or Warning Message

At startup, the following or similar error message is displayed and catalog items such as symbols cannot be inserted.

Internal Error
UI Error Message: ExecuteSQL error. create PROCEDURE BlkInfo AS select
blkName,anum,blkDesc,desc_id,type,date_modify,category,0 AS FileInfo_id,blkSymXML from sym0
The Microsoft Jet database engine cannot find the input table or query 'sym0'. Make sure it exists and that its name is spelled correctly.
TargetSite: Void ExecuteSQL(Int32, System.String)
DeclaringType: MDBProxy.LocalTools
Attributes: public
MemberType: Method...

Explanation

This message can indicate a problem with the Device.mdb file. In one case it occurred after incorrectly trying to [[Rename a catalog|rename a catalog]].

How to Avoid

1. Refer to the following articles for the path to Device.mdb and a link to a fresh copy of this file.
   [[Device.mdb - Promis.e]]
   [[Device.mdb - Substation]]

2. Rename or delete the suspect Device.mdb.

3. Replace the Device.mdb with the known good copy of Device.mdb.

Original Author:

Matt_P

Keywords: sym1, sym2, dev0, dev1, dev2, mac0, mac1, mac2, tit0, tit1, tit2