Skip to main content
Question

WHD & JSS

  • November 25, 2013
  • 46 replies
  • 190 views

Forum|alt.badge.img+3

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'

46 replies

bentoms
Forum|alt.badge.img+35
  • Hall of Fame
  • November 25, 2013

Which versions of both products?


Forum|alt.badge.img+3
  • Author
  • New Contributor
  • November 25, 2013

JSS 9.20

WHD 12.0.1


bentoms
Forum|alt.badge.img+35
  • Hall of Fame
  • November 25, 2013

Have you ever had if working under 9? I thought it didn't.


Forum|alt.badge.img+17
  • Honored Contributor
  • November 25, 2013

agree pretty sure at JNUC someone from JAMF said WHD sync is broken with 9 and WHD hadn't fixed to accommodate new tables or using API, etc.. .


Forum|alt.badge.img+18
  • Valued Contributor
  • November 25, 2013

Great. We have been using JSS in conjunction with WHD for years. Just updated JSS to 9.21 yesterday. Hadn't tried reconnecting WHD to the JSS yet. This is not good. Maybe all of us WHD users need to file a ticket to to get it fixed. If not I'll have to find another way to try and sync the data over. @Yousseph.Wehbe did you ever have it working with 9 ? Does it work at all ?


Forum|alt.badge.img+33
  • Hall of Fame
  • November 25, 2013

Web Help Desk connects to the JSS's MySQL database with a read-only connection and JAMF made a lot of database changes for Casper 9.x. Unfortunately, this means that the tables that Web Help Desk referred to in Casper 8.x are now renamed or otherwise not accessible in Casper 9.x.

I'd recommend opening a ticket with SolarWinds to see when this will be fixed: http://www.webhelpdesk.com/support/technical-support/


Forum|alt.badge.img+18
  • Valued Contributor
  • November 25, 2013

I just filed my ticket with SolarWinds. Any others file theirs ? Maybe if they get a number of tickets something will happen.

Anything need to or can be done on the Jamf end to help this ?

Any alternate methods to sync the assets over ?


Forum|alt.badge.img+18
  • Valued Contributor
  • November 25, 2013

My ticket is filed. I have a response :

Update for Case #549219 - "Web Help Desk and Casper Discovery Tool"

Thank you for contacting SolarWinds Technical Support.

The information is right, presently WHD does not support Capser 9.x. The latest version of WHD out there has been tested to work with upto Casper 8.6.

Our development team is aware of this need and are currently working to ge WHD to support it. We don't have an ETA of when this will be ready at the moment.

Kind Regards,
Caroline Musindi
Solarwinds Technical Support
-------------

If this WHD issue affects you please file a ticket so we can get some momentum on this !


Forum|alt.badge.img+18
  • Valued Contributor
  • November 25, 2013

I also noticed a WHD product blog that they are talking about Casper 9 support.

http://thwack.solarwinds.com/community/solarwinds-community/product-blog/blog/2013/10/10/what-were-working-on-for-web-help-desk


bentoms
Forum|alt.badge.img+35
  • Hall of Fame
  • November 25, 2013

Sorry to have been the bearer of bad news!


Forum|alt.badge.img+3
  • Author
  • New Contributor
  • November 25, 2013

It has always been working for us.


Forum|alt.badge.img+8
  • Contributor
  • November 25, 2013

We've been pushing Solarwinds for months on this - Pretty poor form given the 9 betas have been out for almost a year and one of their major selling points is the integration into the Casper Suite (Still says so on their site laughably)


Forum|alt.badge.img+18
  • Valued Contributor
  • November 25, 2013

Please keep pushing Solarwinds @sovereign ! I will start to do so myself. Would be great if this could be resolved.


Forum|alt.badge.img+9
  • Contributor
  • November 26, 2013

I spoke to them a couple of days ago, them being unimpressed / solarwinds.

They are working on it and it should come in the next version of WHD.


Forum|alt.badge.img+3
  • New Contributor
  • November 26, 2013

I have also been pushing Solarwinds on this. They are reluctant to say when the integration will be fixed, but it's worth adding to the pressure. Solarwinds tech support helpfully suggested that I could resolve the problem by reverting to Casper 8.6!


thomasC
Forum|alt.badge.img+10
  • Contributor
  • November 26, 2013

I have a ticket open as well. We are holding off on Casper 9 for our production JSS, which we were going to rev in a few weeks. @makander][/url did Solarwinds support say next version or point revision?


Forum|alt.badge.img+18
  • Valued Contributor
  • November 26, 2013

Indeed the product and support did seem better before Solarwinds took over. Please keep up the pressure and hopefully they will make this happen. I really can't see it being that hard. They probably just have to take the existing tool and change a few database field names.

My latest reply I got today from Solarwinds.

Update for Case #549219 - "Web Help Desk and Casper Discovery Tool"

Roger,
I understand, we certainly got a lot of requests for the support. Because this is a feature request and not a bug, I cannot leave the ticket open. What I will do is submit a feature request on your behalf and when we have the feature in place, you will be contacted as a beta tester for the RC version, this way you'll know it's out or about to be rolled out. Does that work for you?

Kind Regards,
Caroline Musindi
Solarwinds Technical Support


Forum|alt.badge.img+18
  • Valued Contributor
  • November 26, 2013

I also found out they have another way to file feature requests. I am going to file one. If any one sees it they might want to comment on it that it is an important thing to them.

You may also post your request to the Thwack forum for the SolarWinds product you wish to see improved. Thwack Feature Request forums are here: http://thwack.solarwinds.com/community/feature-request_tht. Create a post titled “FEATURE REQUEST - Name of the Feature Request” and detail your request including case number. These forums are monitored by our Product Managers. This will allow other customers to voice their opinions as to whether they would find the feature useful.

My feature request is now filed. Looks like you can vote on it. Lets get in a bunch of votes !

http://thwack.solarwinds.com/ideas/3080


thomasC
Forum|alt.badge.img+10
  • Contributor
  • November 26, 2013

@rcorbin][/url Thanks for the info. Voted up your feature request.


Forum|alt.badge.img+18
  • Valued Contributor
  • November 26, 2013

Thanks for the vote up @thomasC ! I noticed many of the other feature requests have about 30 votes or more so we are going to need to get that number up. Also please comment on mine and note how important feature is to you. To me this seems like a real easy one for them to keep a few customers happy ? How hard can it be ? The tool already talked to the database. It just now has query a few different field names instead. Maybe I'm over simplifying it, but I don't think it's going to be that hard for them.


Forum|alt.badge.img+17
  • Honored Contributor
  • November 26, 2013

Not defending them, but you may be over simplifying. At JNUC they had exact numbers, but the database drastically cut down on the number of tables in the db, so it's not like a find/replace kind of thing. At the talk where this was brought up, I think the comment from JAMF was WHD hadn't yet decided if they're going to continue to try to talk directly to db or start using the API.


Forum|alt.badge.img+9
  • Contributor
  • November 27, 2013

@thomasC][/url

They told me next release and to keep checking this page:

http://thwack.solarwinds.com/community/solarwinds-community/product-blog/blog/2013/10/10/what-were-working-on-for-web-help-desk


damienbarrett
Forum|alt.badge.img+19
  • Honored Contributor
  • December 3, 2013

Ugh, wish I'd known of this incompatibility before upgrading to Casper 9 this morning. This is going to be a huge problem for us. Keeping assets synced between WHD tickets and JSS is incredibly important.

Does anyone know of a helpdesk ticketing system that *does* work with Casper 9? My school is more than willing to deep-six WHD for a working ticket system that has asset discovery and sync.


Forum|alt.badge.img+9
  • Contributor
  • December 4, 2013

You can't downgrade to 8.73 then?


Forum|alt.badge.img+8
  • Contributor
  • December 4, 2013

I just submitted a support request to SolarWinds about this to add to their list. Was told they are working on it but don't have an ETA. The support rep offered to open a feature request on our behalf. Wait and see at this point I guess.