Getting import log error while import data from SCCM to servicenow

Siddiqbasha
Tera Contributor

‎10-29-2025 04:29 AM

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 Helpfuls
  • 279 Views
1 REPLY 1

Matthew_13
Kilo Sage

3 weeks ago

Hi!

The error you’re seeing:

Invalid column name 'TimeKey'

…means that the SQL query your MID Server is running is trying to access a column called TimeKey that doesn’t exist in the target database table.

How to resolve:

  1. Verify the table schema

    • Connect to your SQL Server and check the table used in the import. Confirm whether TimeKey exists.

  2. Update the import source or query

    • If the column was renamed or removed, update your Import Set or JDBC Data Source query to match the correct column names.

  3. Check field mappings in ServiceNow

    • Make sure your Transform Map is pointing to valid source fields.

  4. Retry the import

    • After fixing the column reference, run the import again.

If TimeKey was supposed to exist (e.g., part of a view), verify that your SQL user has access to the correct table or view.

This usually fixes the “Invalid column name” SQL errors in MID Server imports.

 

@Siddiqbasha - Please mark Solution Accepted and Thumbs up if you find helpful my friend!
0 Helpfuls