Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Error: Invalid column name 'TimeKey' while running SCCM second time

learn nv
Tera Contributor

Hi All,

I am facing below error when i ran SCCM second time and my SCCM version is 3.6.0

 

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)

 

I got a below link as a work around, but unfortunately I don't have access

 

https://support.servicenow.com/kb?id=kb_article_view&sys_kb_id=0d66ef9a47879a5077748d01426d43a5

 

Could some one please post the content from this link.

 

Thank you

 

 

2 REPLIES 2

SiddiqB
Tera Contributor

Did you resolved the issue?

HeyMarkWarmack
Tera Expert

@learn nv 

Here is the exact error KB match to my problem which is what I think is yours too.

KB1724482 - SG-SCCM Computer Identity Data source Fails with SQL error: S0001 | Invalid column name 'TimeKey'
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1724482

 

This matches my CHG update for Service Graph Connector for Microsoft SCCM v3.8.0 to v3.8.1

I am on MID buildstamp: yokohama-12-18-2024__patch10-hotfix1-12-23-2025_12-24-2025_1252

 

I applied it today and will know tomorrow if the error clears.

 

update 2/19/26 - I am still seeing errors on this one job within SG-SCCM v3.8.1.  I am putting in a SN Case.

HeyMarkWarmack_0-1771521590811.png