Micro Focus Expert
Micro Focus Expert

Error while importing data from excel to uCMDB 9.04 content pack 10



I am trying to import data from excel sheet in uCMDB and using xls import adapter. But operation is getting failed with below error in the mam.autodiscovery.log file: -


<2012-01-11 17:10:47,131> ERROR  - Error processing results, on job [DS_NodeFromXls_Import topology from Excel Workbook], on trigger CI [fca90aad0bb4be5421828f336f1d99f9] [Process Results Thread-DS_NodeFromXls_Import topology from Excel Workbook]
com.mercury.jdbc.sqlserverbase.BaseBatchUpdateException: [mercury][SQLServer JDBC Driver][SQLServer]Invalid column name 'job_id'.


excel file is step properly to reflect correct field names. Any idea what could be causing this.


I can attach complete log file and excel sheet if required.


2 Replies
Micro Focus Expert
Micro Focus Expert



It would be helpful if you included the complete log file and the excel spreadsheet as well as a screenshot of the properties tab for the job.  Just at a glance, it appears the excel spreadsheet isn't formatted correctly.



Hope this helps,
Keith Paschal
UCMDB Worldwide Support Lead
Micro Focus Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'
Absent Member.. Absent Member..
Absent Member..

from the error it seems like you have a column in the excel file named: job_id

which does not match to a defined attribute on the class that you are trying to import the data into. Please make sure that the spreadsheet name matches the name of the CI not the display-name. For example: for node class it should be node not Node. And all the columns specified on the spreadsheet match the attributes defined on the CI Type, again with name of the attribute not the display-name.


Hope this helps



HP Software values your thoughts and ideas regarding your overall Software Support experiences. Please contact us at software.satisfaction@hp.com to share your comments or contact my manager directly at zubin.ghai@hp.com
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.