101 views

Description

Using JDBC data Source if we load data source using the "Load all data"  related link displays: GlideRecord not a SYS_ATTACHMENT record.

 

 

The localhost logs include the following entries:

com.glide.db.impex.JDBCProbeLoader: java.lang.IllegalArgumentException: GlideRecord not a SYS_ATTACHMENT record: com.glide.ui.SysAttachmentInputStream.<init>(SysAttachmentInputStream.java:89)
com.glide.ui.SysAttachment.getAsStream(SysAttachment.java:2474)

Release or Environment

All

Cause

We receive the payload from the MID server and stores in the sys_attachment table. ServiceNow platform expects these files to be named "payload.txt", if we change the name to something like payload_11_21_26.txt it will cause the issue. The payload file should be with the name: "payload.txt".

You can find below errors in the system logs :

com.glide.db.impex.JDBCProbeLoader: java.lang.IllegalArgumentException: GlideRecord not a SYS_ATTACHMENT record: com.glide.ui.SysAttachmentInputStream.<init>(SysAttachmentInputStream.java:89)
com.glide.ui.SysAttachment.getAsStream(SysAttachment.java:2474)
com.glide.db.impex.JDBCProbeLoader.getPayloadXMLStream(JDBCProbeLoader.java:318)
com.glide.db.impex.JDBCProbeLoader.getECCQueueByQuery(JDBCProbeLoader.java:311)
com.glide.db.impex.JDBCProbeLoader.getECCQueue(JDBCProbeLoader.java:286)
com.glide.db.impex.JDBCProbeLoader.nextBatch(JDBCProbeLoader.java:91)
com.glide.db.impex.JDBCProbeLoader.getAttributesFromFirstRecord(JDBCProbeLoader.java:403)
com.glide.db.impex.JDBCProbeLoader.getAttributes(JDBCProbeLoader.java:278)
com.glide.db.impex.AbstractLoader.createColumnAttributes(AbstractLoader.java:479)
com.glide.db.impex.AbstractLoader.createTableAndMap(AbstractLoader.java:243)
com.glide.db.impex.AbstractLoader.createTableForImport(AbstractLoader.java:215)
com.glide.db.impex.AbstractLoader.load(AbstractLoader.java:160)
com.glide.db.impex.AbstractLoader.startWork(AbstractLoader.java:143)
com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126)
com.glide.worker.HierarchicalProgressWorker.startAndWait(HierarchicalProgressWorker.java:35)
com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:101)
com.glide.system_import_set.ImportSetLoader.startWorker(ImportSetLoader.java:119)
com.glide.system_import_set.ImportSetLoader.startLoader(ImportSetLoader.java:108)
com.glide.system_import_set.ImportSetLoader.loadImportSetTable(ImportSetLoader.java:62)
com.glide.system_import_set.ImportSetLoader.loadImportSetTable(ImportSetLoader.java:38)
com.snc.automation.ScheduledImportSetJob.runImport(ScheduledImportSetJob.java:107)
com.snc.automation.ScheduledImportSetJob.runNextImport(ScheduledImportSetJob.java:62)
com.snc.automation.ScheduledImportSetJob.runNextImport(ScheduledImportSetJob.java:74)
com.snc.automation.ScheduledImportSetJob.runNextImport(ScheduledImportSetJob.java:74)
com.snc.automation.ScheduledImportSetJob.runImport(ScheduledImportSetJob.java:50)
com.snc.automation.ScheduledImportJob.execute(ScheduledImportJob.java:45)
com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:108)
com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:111)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:95)
com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:329)
com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:192)
com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:192)
com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:100)

Resolution

We should not change the payload.txt file to something else, cross-check and make sure we have a correct file created in the sys_attachment with the name "payload.txt"

Additional Information

If payload file has the correct name in sys_attachment table, still the same issue check this KB for file size-related issues KB0623372

Article Information

Last Updated:2020-03-08 08:24:15
Published:2020-02-22