Getting import log error while import data from SCCM to servicenow

Siddiqbasha
Tera Contributor

I'm getting below error in import log. Please tell me how to resolve this issue.

 

MID Server reported error: SQLState: S0001
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'TimeKey'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:2021)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:844)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:693)
at com.service_now.monitor.jdbc.JDBCRowSet.query(JDBCRowSet.java:66)
at com.service_now.mid.probe.JDBCProbe.doSelect(JDBCProbe.java:487)
at com.service_now.mid.probe.JDBCProbe.doQuery(JDBCProbe.java:349)
at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:236)
at com.service_now.mid.probe.AProbe.process(AProbe.java:160)
at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:187)
at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
at com.service_now.mid.threadpool.ResourceUserQueue$RunnableProxy.run(ResourceUserQueue.java:643)
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:840)

0 REPLIES 0