Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Azure Service Graph Connector - Error in SQL Imports

ColtinR
Tera Contributor

Greetings Community!

 

I am facing a challenge with the SQL imports. I keep getting the following error when trying to import our SQL databases:

Transformation failed:

java.lang.IllegalArgumentException: Undefined field family
at com.snc.cobject.ComplexObject.setRawValue(ComplexObject.java:253)
at com.snc.cobject.ComplexObject.setValue(ComplexObject.java:328)
at com.snc.cobject.ComplexObject.setValue(ComplexObject.java:343)
at com.snc.cobject.ComplexObject.setValue(ComplexObject.java:343)
at com.snc.cobject.ComplexObject.setRawValue(ComplexObject.java:245)
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.system_import_set.ImportSetTransformerImpl.doRobustImportSetTransform(ImportSetTransformerImpl.java:166)
at com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:114)
at com.glide.system_import_set.ImportSetTransformer.transformAllMaps(ImportSetTransformer.java:91)
at com.snc.automation.ImportSetTransformerJob.runTransform(ImportSetTransformerJob.java:291)
at com.snc.automation.ImportSetTransformerJob.execute(ImportSetTransformerJob.java:103)
at com.glide.schedule.JobExecutor.lambda$executeJob$1(JobExecutor.java:198)
at com.snc.db.data_replicate.replicator.DataReplicationAdvisors.runInOriginatorContext(DataReplicationAdvisors.java:74)
at com.glide.schedule.JobExecutor.lambda$inDataReplicationContext$3(JobExecutor.java:228)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:201)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:181)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:171)
at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:612)
at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$3(SchedulerWorkerThread.java:404)
at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:404)
at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:180)

 

This started most recently 5 days ago and was working previously.

 

I did notice the family attribute is empty but it's also not mapping to anything in the RTE's

ColtinR_1-1777665374245.png

 

ColtinR_0-1777665285183.png

 

Any help would be appreciated!

 

0 REPLIES 0