Special characters can cause errors during model compilation

Symptom

Models are compiled to XML files. Do not use the following characters in model names or in model group, property, or rule names:: "&", "/". "@", "!", and the quote characters " and '.

For example, if your model name contains a forward slash symbol "/" you will get the exception listed below under error tab while trying to assign the model to a product.

In the method com.comergent.api.appservices.productService.util.ProdMgrUtils.getModelKeyFromNa me() the forward slash is used as a logical parent/child break in a model path.
Therefore, the forward slash in a model name does not get encoded and the query fails.

If model names contain a forward slash and the model is assigned to a product in the product admin, the following exception will occur:

============start===========
2009.07.28 00:28:29:432 Env/http-8080-1:DEBUG:Operation Executing SQL: SELECT CMGT_MODELS.MODEL_KEY, CMGT_MODELS.NAME, CMGT_MODELS.DESCRIPTION, CMGT_MODELS.PARENT_KEY, CMGT_MODELS.MODEL_TYPE, CMGT_MODELS.XMLFILEPATH FROM CMGT_MODELS WHERE CMGT_MODELS.ACTIVE_FLAG = 'Y' AND (CMGT_MODELS.XMLFILEPATH = 'ABC/123' ) AND (CMGT_MODELS.MODEL_TYPE=1)
2009.07.28 00:28:29:432 Env/http-8080-1:DEBUG:Operation Executing SQL: SELECT CMGT_MODELS.MODEL_EY, CMGT_MODELS.NAME, CMGT_MODELS.DESCRIPTION, CMGT_MODELS.PARENT_KEY, CMGT_MODELS.MODEL_TYPE, CMGT_MODELS.XMLFILEPATH FROM CMGT_MODELS WHERE CMGT_MODELS.ACTIVE_FLAG = 'Y' AND (CMGT_MODELS.XMLFILEPATH = ?) AND (CMGT_MODELS.MODEL_TYPE=1)
2009.07.28 00:28:29:432 Env/http-8080-1:DEBUG:JDBCService > JDBCService.executeQuery Model
2009.07.28 00:28:29:438 Env/http-8080-1:DEBUG:JDBCService < JDBCService.executeQuery Model
2009.07.28 00:28:29:439 Env/http-8080-1:DEBUG:DataSourceInfo Pool Size: 3
2009.07.28 00:28:29:439 Env/http-8080-1:DEBUG:DataSourceInfo Number of free connections in the pool: 2
2009.07.28 00:28:29:439 Env/http-8080-1:ERROR:DispatchServlet com.comergent.api.dataservices.NoDataFoundException: [CMGT_E_NO_DATA_FOUND] error: "No data was found for the specified selection criteria."
com.comergent.api.dataservices.NoDataFoundException: [CMGT_E_NO_DATA_FOUND] error: "No data was found for the specified selection criteria."
at com.comergent.dataservices.SqlDataObject.processResults(SqlDataObject.java:3308 )
at com.comergent.dataservices.SqlDataObject.restore(SqlDataObject.java:370)
at com.comergent.dataservices.DataBean.restore(DataBean.java:407)
at com.comergent.appservices.productService.ProdServBeanRoot.restore(ProdServBeanR oot.java:246)
at com.comergent.api.appservices.productService.util.ProdMgrUtils.getModelKeyFromN ame(ProdMgrUtils.java:135)
at com.comergent.reference.apps.productMgr.controller.ProdMgrProdGenController.set CommonProperties(ProdMgrProdGenController.java:347)
at com.comergent.reference.apps.productMgr.controller.ProdMgrProdGenController.upd ateProduct(ProdMgrProdGenController.java:729)
at com.comergent.reference.apps.productMgr.controller.ProdMgrProdGenController.exe cute(ProdMgrProdGenController.java:130)
============end============