SGC-SCCM Integration failing on second run

jobikunjumon
Tera Contributor

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.

1 ACCEPTED SOLUTION

vhiinnz1
Tera Expert

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

View solution in original post

12 REPLIES 12

vhiinnz1
Tera Expert

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. 

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. 

did you fix the issue?

Created HI Case.