- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2025 08:54 AM
Hi Team,
SGC-SCCM works perfect when the Last run datetime is empty. However when that gets filled in after the 1st run it fails with import log as below.
MID Server reported error: SQLState: S0001
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'TimeKey'.
TimeKey is standard SCCM column, nothing customized. This worked cool during dev phase, while we deployed this to prod, we see this behavior with error out.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 09:48 AM - edited 01-21-2025 09:49 AM
Hello - it will get fixed on the next upgrade 4.0. But please see the work around below that fixed it. Thanks
https://support.servicenow.com/kb?id=kb_article_view&sys_kb_id=0d66ef9a47879a5077748d01426d43a5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 05:09 AM
we are getting the exact same issue. when the last run datetime is empty it works fine but after the 1st run it fails with the same error mentioned by the TS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 07:14 AM
There are some change in the SQL statement which messed up. Dev is on older version- 3.4.2 and Prod is on 3.6.0. The latest version messed out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 07:35 AM
did you fix the issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 08:00 AM
Created HI Case.