UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

Excel import issue- getting failed to resolve object container error

Advisor

Excel import issue- getting failed to resolve object container error

Hi all

attached sheet for reference i was trying to import clusterresourcegroup data with nodes but it says failed to resolve object container error.

 

<execution jobId="DS_excel import_Import topology from Excel Workbook" destinationid="befc285bf6ea48a0a6a04d124c0dece8" max_store_sent_results="2147483647">
<destination>
<destinationData name="ip_domain"></destinationData>
<destinationData name="hostId"></destinationData>
<destinationData name="id">befc285bf6ea48a0a6a04d124c0dece8</destinationData>
<destinationData name="ip_address"></destinationData>
</destination>
<params>
<param param_name="integer_list_delimiter" param_value="," />
<param param_name="JOB_ID" param_value="DS_excel import_Import topology from Excel Workbook" />
<param param_name="file_name" param_value="D:\1.xlsx" />
<param param_name="relationship_attr_delimiter" param_value="|" />
<param param_name="defaultOwner" param_value="" />
<param param_name="runInSeparateProcess" param_value="true" />
<param param_name="set_empty_value" param_value="false" />
<param param_name="taskType" param_value="regular" />
<param param_name="maxThreadRuntime" param_value="900000" />
<param param_name="remoteJVMClasspath" param_value="%minimal_classpath%;../lib/dom4j.jar;../runtime/probeManager/discoveryResources/geronimo-stax-api_1.0_spec-1.0.jar;../runtime/probeManager/discoveryResources/poi-3.7-20101029.jar;../runtime/probeManager/discoveryResources/poi-ooxml-3.7-20101029.jar;../runtime/probeManager/discoveryResources/poi-ooxml-schemas-3.7-20101029.jar;../runtime/probeManager/discoveryResources/xmlbeans-2.3.0.jar" />
<param param_name="string_list_delimiter" param_value="," />
</params>
<log start="12:30:56" severity="info">Execution current time:2017/03/22 12:30:56</log>
<log start="12:30:57" severity="debug">Excel file to process:D:\1.xlsx</log>
<log start="12:30:57" severity="debug">file D:\1.xlsx exists</log>
<log start="12:30:57" severity="debug">OXML excel format</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="info"> Process all tabs and create OSH from them; Root containers and links will be created lately</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="debug">Processing worksheet: cluster_resource_group</log>
<log start="12:30:59" severity="debug">Processing worksheet: node</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="info"> Process root containers from early created OSHes</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="debug">Processing references of worksheet: cluster_resource_group</log>
<log start="12:30:59" severity="debug">unable to resolve OSH using None</log>
<log start="12:30:59" severity="debug">unable to resolve OSH using cluster_resource_group 3</log>
<log start="12:30:59" severity="warn">failed to resolve object container</log>
<log start="12:30:59" severity="debug">Processing references of worksheet: node</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="info"> Report OSH to vector</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="debug">reported 2 objects</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="info"> Process relationships</log>
<log start="12:30:59" severity="info"> ------------------------------------------------------------------</log>
<log start="12:30:59" severity="debug"> ------------------------------------------------</log>
<log start="12:30:59" severity="debug"> Worksheet rows: 2 (including header)</log>
<log start="12:30:59" severity="debug"> ------------------------------------------------</log>
<log start="12:30:59" severity="info">Execution current time:2017/03/22 12:30:59</log>
</execution>

 

if anyone help appriciated.

 

thanks

Chethan

//Add this to "OnDomLoad" event