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.
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.
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'
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