Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
celalettin.pisg1
New Member.
282 views

Custom CP Build Problem

Hello Guys, We have installed OBR 10.22 with HF1 we are trying to create a simple content pack in order to report data from another database. So we have a table for dimension and this table name is BVDDimension and it has 2 columns named KANAL(Varchar) and KANALPK(Number). We have another table for Fact named BVDData and this table has 3 columns. “TARIH” (TimeStamp),”KANAL”(Number), “Data”(Long). But when we are trying to create content pack, it fails. Do you have any idea? 2018-07-03 15:15:58,470 INFO, com.hp.bto.shr.cde.bo.univ.UniversePropertiesCreator.main , CDE property file updated successfully. 2018-07-03 15:16:03,678 INFO, com.hp.bto.shr.cde.createcp.CreateCP.Parser , subpackage name is not specified. subpackage name will default to package name BVDData 2018-07-03 15:16:08,494 INFO, com.hp.bto.shr.cde.createcp.CreateCP.Parser , Content pack folder structure for BVDData was created successfully 2018-07-03 15:16:16,528 INFO, com.hp.bto.shr.cde.generatecpartifacts.CreateMappingFile.main , ##############################Creating Mapping Document Csv file for the provided data sources at the following location/opt/HP/BSM/PMDB/../CDE/workspace/BVDData##################### 2018-07-03 15:16:16,531 INFO, com.hp.bto.shr.cde.generatecpartifacts.CreateMappingFile.main , *********Mapping Document lists the source columns from the given data source against which required target columns of schema can be mapped*********** 2018-07-03 15:16:17,680 ERROR, com.hp.bto.shr.cde.generatecpartifacts.utils.ProcessXML.validateXMLAgaintXSD , org.xml.sax.SAXParseException; cvc-complex-type.2.4.b: The content of element 'sourcesql' is not complete. One of '{"SHRSQLNamespace":csvfile, "SHRSQLNamespace":statement}' is expected. 2018-07-03 15:16:17,682 ERROR, com.hp.bto.shr.cde.generatecpartifacts.mappingfile.GenerateMapFileFromDBQuery.getXMLSchemaObject , XML Validation Failed:cvc-complex-type.2.4.b: The content of element 'sourcesql' is not complete. One of '{"SHRSQLNamespace":csvfile, "SHRSQLNamespace":statement}' is expected.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.