Posted on 11-25-2013 05:01 AM
Hey Guys,
WE are getting the following error with the syncing of JSS AND WHD Asset discovery.
Has anyone seen the below?
Encountered error(s) during synchronization:
Error while getting next asset: com.mysql.jdbc.exceptions.jdbc4. MySQLSyntaxErrorException: Unknown column 'h.model' in 'field list'
Posted on 12-12-2013 01:32 AM
Hey guys,
reason Database Name is missing is that we don't now connect to DB, but we are using Casper API, so you have to use some Casper user to connect, not database user. Please check the tooltips in the UI of Asset Connection configuration.
Hope that helps,
Peter
Posted on 12-12-2013 07:31 AM
@peter.kruty][/url Glazed over what was right in front of me. Staring at screen too long. Got it connected and syncing. I prefer using the API hook. The expanded tool tips are a nice feature as is the question mark quick link to documentation.
Thank you!
Posted on 12-13-2013 02:24 PM
12.1 seems to be working for me for Casper 9 Computers, however it doesn't seem to sync Casper 9 mobile devices. I don't think that worked with Casper 8 either but I guess I was hopeful it would now with Casper 9.
Posted on 01-10-2014 05:18 AM
Hi guys,
we have just released WHD 12.1 RC2, with
You can find the new bits on Solarwinds customer portal under RELEASE CANDIDATES section.
http://customerportal.solarwinds.com
I would love to get your feedback! Feel free to comment on RC forum:
http://thwack.solarwinds.com/groups/solarwinds-web-help-desk
or contact me personally on [peter.kruty@solarwinds.com](peter.kruty@solarwinds.com).
Thanks in advance,
Peter, WHD Product Manager
Posted on 01-16-2014 07:51 AM
Wanted to chime in. Peter replied directly to my email plea for help and we've gotten asset syncing straightened out. Happy to report that JSS 9.22 and WHD 12.1.0RC2 are playing well together again. Assets are syncing cleanly and properly. Good work, Peter!
(the solution for me was that I had neglected to select the new "Casper 9" discovery tool and was still trying to use the older "Casper" discovery tool in my WHD asset discovery settings. Also, check your attribute mappings to make sure they are all set the way you want before syncing).
Posted on 01-16-2014 08:26 AM
Glad it works! :)
Posted on 01-16-2014 10:18 AM
Damien are you finding the RC2 pretty stable in a production environment ?
Peter do you see 12.1 going to a final release soon ?
Posted on 02-12-2014 09:11 AM
We have just updated to the 12.1 release version of Web Help Desk. I'm going to set the Casper 9 discovery tool up later today. I take it that I just need to create a user in Casper that has access to the inventory records. Does the Attribute Mapping need to be tweaked ? Or do the stock settings come up fine ?