Synopsis of Knowledge Article
Problem/Symptom(s)
Problem
An exception such as the following may be encountered in the Bladelogic Application Server log:
Caused by: com.bladelogic.app.db.DBException: An error occurred while attempting to access the database:
Message : No entry in mapping files for query with ID SELECT_PROPERTY_SET_CLASS_DEFAULT_VALUE_MAP_BY_PROPERTY_SET_CLASS_KEY SQLState: null ErrorCode: 0
Message : No entry in mapping files for query with ID SELECT_PROPERTY_SET_CLASS_DEFAULT_VALUE_MAP_BY_PROPERTY_SET_CLASS_KEY SQLState: null ErrorCode: 0
at com.bladelogic.app.db.DBStatementImpl.executeSelect(DBStatementImpl.java:202)
at com.bladelogic.model.property.PropertySetClassServiceImpl.findChildrenForClass(PropertySetClassServiceImpl.java:1941)
at com.bladelogic.model.property.LazyPropertySetClassImpl.loadChildren(LazyPropertySetClassImpl.java:324)
at com.bladelogic.model.property.LazyPropertySetClassImpl.getPropertiesInternal(LazyPropertySetClassImpl.java:1068)
... 17 more
Caused by: java.sql.SQLException: No entry in mapping files for query with ID SELECT_PROPERTY_SET_CLASS_DEFAULT_VALUE_MAP_BY_PROPERTY_SET_CLASS_KEY
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:722)
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:655)
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:484)
at com.bladelogic.app.db.DBStatementImpl.executeSelect(DBStatementImpl.java:185)
at com.bladelogic.model.property.PropertySetClassServiceImpl.findChildrenForClass(PropertySetClassServiceImpl.java:1941)
at com.bladelogic.model.property.LazyPropertySetClassImpl.loadChildren(LazyPropertySetClassImpl.java:324)
at com.bladelogic.model.property.LazyPropertySetClassImpl.getPropertiesInternal(LazyPropertySetClassImpl.java:1068)
... 17 more
Caused by: java.sql.SQLException: No entry in mapping files for query with ID SELECT_PROPERTY_SET_CLASS_DEFAULT_VALUE_MAP_BY_PROPERTY_SET_CLASS_KEY
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:722)
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:655)
at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:484)
at com.bladelogic.app.db.DBStatementImpl.executeSelect(DBStatementImpl.java:185)
In this case the offending query ID is "SELECT_PROPERTY_SET_CLASS_DEFAULT_VALUE_MAP_BY_PROPERTY_SET_CLASS_KEY" but that may vary depending on the version of the product or the operation being attempted by the user.
Applicable to
This Knowledge Article is known to apply to:
- BMC BladeLogic Server Automation Suite
- BMC BladeLogic Server Automation Suite
Show Me
For the full article see: KA313238 [Requires Support Login]
To search for other articles, product documentation and web resources; go to the BMC Support Knowledge Base [Requires Support Login]
Comments