IH-ETL Crash after adding table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Hi All,
Trying to use IH-ETL to import a multilevel JSON data into the CMDB, after a couple tables, once I add another table, the whole thing breaks. Though not my first rodeo at ETL, have been stumped in the last couple weeks on this.
Appreciate any help
Here's what the JSON looks like
[
{
"subscription": "subscription1",
"id": "00000000-0000-0000-0000-000000000000",
"resourceGroups": [
{
"resourceGroup": "RESOURCEGROUP1",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP1",
"location": {
"displayName": "Location 1",
"name": "loc1"
},
"storage": [
{
"name": "STORAGE1",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP1/providers/Microsoft.Storage/storageAccounts/STORAGE1",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
},
{
"name": "STORAGE2",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP1/providers/Microsoft.Storage/storageAccounts/STORAGE2",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
}
],
"vaults": [
{
"name": "RECOVERYVAULT1",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP1/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT1",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
},
{
"name": "RECOVERYVAULT2",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP1/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT2",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
}
]
},
{
"resourceGroup": "RESOURCEGROUP2",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP2",
"location": {
"displayName": "Location 2",
"name": "loc2"
},
"storage": [
{
"name": "STORAGE1a",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP2/providers/Microsoft.Storage/storageAccounts/STORAGE1a",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
},
{
"name": "STORAGE2a",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP2/providers/Microsoft.Storage/storageAccounts/STORAGE2a",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
}
],
"vaults": [
{
"name": "RECOVERYVAULT1a",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP2/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT1a",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
},
{
"name": "RECOVERYVAULT2a",
"id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RESOURCEGROUP2/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT2a",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
}
]
}
],
"locations": [
{
"displayName": "Location 1",
"name": "loc1"
},
{
"displayName": "Location 2",
"name": "loc2"
}
]
},
{
"subscription": "subscription2",
"id": "22222222-2222-2222-2222-222222222222",
"resourceGroups": [
{
"resourceGroup": "ALPHA",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/ALPHA",
"location": {
"displayName": "Location 1",
"name": "loc1"
},
"storage": [
{
"name": "STORAGE1c",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/ALPHA/providers/Microsoft.Storage/storageAccounts/STORAGE1c",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
},
{
"name": "STORAGE2c",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/ALPHA/providers/Microsoft.Storage/storageAccounts/STORAGE2c",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
}
],
"vaults": [
{
"name": "RECOVERYVAULT1c",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/ALPHA/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT1c",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
},
{
"name": "RECOVERYVAULT2c",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/ALPHA/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT2c",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
}
]
},
{
"resourceGroup": "BETA",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/BETA",
"location": {
"displayName": "Location 2",
"name": "loc2"
},
"storage": [
{
"name": "STORAGE_BETA",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/BETA/providers/Microsoft.Storage/storageAccounts/STORAGE_BETA",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
},
{
"name": "STORAGE_CHARLIE",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/BETA/providers/Microsoft.Storage/storageAccounts/STORAGE_CHARLIE",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
}
],
"vaults": [
{
"name": "RECOVERYVAULT_BETA",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/BETA/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT_BETA",
"location": {
"displayName": "Location 2",
"name": "loc2"
}
},
{
"name": "RECOVERYVAULT_CHARLIE",
"id": "/subscriptions/22222222-2222-2222-2222-222222222222/resourceGroups/BETA/providers/Microsoft.RecoveryServices/vaults/RECOVERYVAULT_CHARLIE",
"location": {
"displayName": "Location 1",
"name": "loc1"
}
}
]
}
],
"locations": [
{
"displayName": "Location 1",
"name": "loc1"
},
{
"displayName": "Location 2",
"name": "loc2"
}
]
},
]
When I run the import, I get this error if I add the "vaults" section...
java.lang.IllegalArgumentException: Can't set value for path com.glide.path.Path$$Lambda$7062/0x0000000102149580@8b78977
at com.snc.cobject.ComplexObject.setRawValue(ComplexObject.java:246)
at com.snc.cobject.ComplexObject.setRawValue(ComplexObject.java:236)
at com.glide.transform.transformer.OutputMapper.map(OutputMapper.java:57)
at com.glide.transform.transformer.Transformer.transform(Transformer.java:587)
at com.glide.transform.transformer.Transformer.transformBatchWithWildCardRules(Transformer.java:742)
at com.glide.transform.transformer.Transformer.transformInBatch(Transformer.java:641)
at com.glide.robust_transform_engine.TransformerWrapper.transform(TransformerWrapper.java:53)
at com.glide.robust_transform_engine.RobustTransformEngine.transformRteInputs(RobustTransformEngine.java:309)
at com.glide.db.impex.transformer.service.RobustImportSetProcessor.sendToRobustTransformEngine(RobustImportSetProcessor.java:137)
at com.glide.db.impex.transformer.service.RobustImportSetProcessor.processBatch(RobustImportSetProcessor.java:118)
at com.glide.db.impex.transformer.service.RobustImportSetProcessor.transform(RobustImportSetProcessor.java:84)
at com.glide.integration_studio.IntegrationStudioScriptableApi.runImportSet(IntegrationStudioScriptableApi.java:374)
at com.glide.integration_studio.IntegrationStudioScriptableApi.lambda$runImportSetWithRollback$0(IntegrationStudioScriptableApi.java:353)
at com.glide.rollback.recording.RollbackRecorder.execute(RollbackRecorder.java:67)
at com.glide.integration_studio.IntegrationStudioScriptableApi.runImportSetWithRollback(IntegrationStudioScriptableApi.java:353)
at com.glide.integration_studio.IntegrationStudioScriptableApi.jsStaticFunction_preview(IntegrationStudioScriptableApi.java:125)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:232)
at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:692)
at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:621)
at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:3078)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1721)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:907)
at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:137)
at com.glide.caller.gen.sys_ws_operation_4dfc4d667394001024e5aa114df6a757_operation_script.call(Unknown Source)
at com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:135)
at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:3181)
at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:3088)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1721)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:907)
at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:137)
at com.glide.caller.gen.sys_ws_operation_4dfc4d667394001024e5aa114df6a757_operation_script.call(Unknown Source)
at com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:135)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:720)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:4501)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:151)
at com.glide.script.ScriptCompiler.executeAndPublishMetric(ScriptCompiler.java:78)
at com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:468)
at com.glide.script.ScriptEvaluator.evaluate(ScriptEvaluator.java:235)
at com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:384)
at com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:268)
at com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:245)
at com.glide.rest.service.custom.CustomService.runScript(CustomService.java:90)
at com.glide.rest.service.custom.CustomService.execute(CustomService.java:77)
at com.glide.rest.handler.impl.ServiceHandlerImpl.invokeService(ServiceHandlerImpl.java:37)
at com.glide.rest.processors.RESTAPIProcessor.invokeService(RESTAPIProcessor.java:441)
at com.glide.rest.processors.RESTAPIProcessor.processInternal(RESTAPIProcessor.java:427)
at com.glide.rest.processors.RESTAPIProcessor.process(RESTAPIProcessor.java:412)
at com.glide.processors.AProcessor.runProcessor(AProcessor.java:890)
at com.glide.processors.AProcessor.processTransaction(AProcessor.java:345)
at com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:187)
at com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:175)
at com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:58)
at com.glide.sys.Transaction.run(Transaction.java:3000)
at com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:34)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:841)(PS: for the sharp eyes over there, yes, I am trying to redo the Azure SGC manually as we don't expect to have the ITOM license soon)
0 REPLIES 0
