I'm having some trouble getting assets to sync with SCCM 2007. I have a connection set up, however whenever I try to sync assets I get the following error:
Encountered error(s) during synchronization:
Error while getting next asset: java.lang.RuntimeException: Error while querying printers for asset with ResourceID 12189: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'PortName0'.
Does anyone have any ideas? I've tried setting the "Linked Peripherals" option to blank instead of "Printers" with no change.