Table name:sys_rte_eb_operation is not a valid RTE Entity Based Operation

[Nikita28]

My PDI is on the Utah version. I am trying to import data using Robust Transform Engine and every time I run it throws the below error:

java.lang.RuntimeException: Table name:sys_rte_eb_operation is not a valid RTE Entity Based Operation
at com.glide.robust_transform_engine.definition_provider.dao.RteEntityOperationDao.buildOperation(RteEntityOperationDao.java:126)
at com.glide.robust_transform_engine.definition_provider.dao.RteEntityOperationDao.getAll(RteEntityOperationDao.java:47)
at com.glide.robust_transform_engine.definition_provider.RteMetadataLoader.load(RteMetadataLoader.java:48)
at com.glide.db.impex.transformer.etl.compiler.ETLDefinitionProvider.getRobustTransformEngineDefinition(ETLDefinitionProvider.java:50)
at com.glide.robust_transform_engine.RobustTransformEngineDefinitionLoader.getRobustTransformDefinition(RobustTransformEngineDefinitionLoader.java:42)
at com.glide.robust_transform_engine.RobustTransformEngine.getRTEDefinition(RobustTransformEngine.java:435)
at com.glide.robust_transform_engine.RobustTransformEngine.<init>(RobustTransformEngine.java:93)
at com.glide.robust_transform_engine.RobustTransformEngine$Builder.build(RobustTransformEngine.java:156)
at com.glide.db.impex.transformer.service.RobustImportSetProcessor.init(RobustImportSetProcessor.java:63)
at com.glide.db.impex.transformer.service.RobustImportSetProcessor.<init>(RobustImportSetProcessor.java:54)
at com.glide.system_import_set.ImportSetTransformerImpl.doRobustImportSetTransform(ImportSetTransformerImpl.java:164)
at com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:114)
at com.glide.system_import_set.ImportSetTransformerWorker.startWork(ImportSetTransformerWorker.java:40)
at com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126)
at com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52)
at com.glide.worker.BackgroundProgressJob.execute(BackgroundProgressJob.java:59)
at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:140)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:143)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:127)
at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:338)
at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:225)
at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:225)
at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:101)

Any help would be appreciated.

[Vinay2509]

@Nikita28 

If you have one to one source -  target feilds use Transform map capability.

If you have One source - Multi target fields, Use Integration HUB Import capability.

Note: Do not use RTE for importing data separately. Use Integration HUB Import, which is combined solution of RTE and Transform Maps.

Hit Like if solution works!

Thanks

Vinay

[Nikita28]

Hi @Vinay2509 ,
Thank you for your response. 

My use case is to bring third-party data using API to the database instance table, an entry in the server table and create its relationship in cmdb_rel_ci.  
From your suggestion, I have to use IntegrationHub import.
do you have other documents/article links apart from ServiceNow documentation to understand this?

[Vinay2509]

@Nikita28 

Many YT Demo videos available on Integration Hub import, which supports both excel and XML imports. helps in integration as well.

Please make R&D for other documentations apart from ServiceNow.

Thanks

Vinay

[Nikita28]

Hi @Vinay2509,
thank you for your responses. I have figured out a way to integrate with third-party APIs.