Errors in Querying JAMF Pro Data

[mvungos]

Hello everyone,

I am not sure where to post this information and where to get help from so I am hoping someone here can assist me. I reached out to JAMF regarding this issue and they referred me here to Power BI. This is the error messages I get when I try to query data from our JAMF Pro server:

Computer Device Groups

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Computers

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Computers - Applications

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Computers - Extension attributes

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Mobile - Applications

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Mobile Device Groups

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Mobile Devices

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Mobile Devices - ExtensionAttributes

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/34664/subset/software' (502): Bad Gateway. OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/mobiledevices/id/38397' (502): Bad Gateway. The current operation was cancelled because another operation in the transaction failed. '.

Can anyone assist me on how to resolve this issue? Two of the attributes will load, but after a few hours, I will get this message. The representative from JAMF does not have enough experience with Power BI and JAMF to 

[zeroSPace33]

Hello,

I'm seeing this error message as well when connecting to our JAMF gateway:

Web.Contents failed to get contents from 'https://bdjamf.jamfcloud.com//JSSResource/computergroups' (502): Bad Gateway

I'll take a look at the links from @v-henryk-mstf above, but we've been using the same connection from Power BI to the gateway for a couple of years and it just recently started to throw this error message. It feels more like something has changed on the JAMF end of things. If anything changes for me, I'll follow up here.

Thank you!

[mvungos]

Hello @zeroSPace33,

Did your orginization recently update the JAMF Pro instance to 10.42.1? We are not 100% sure, but we think that updating it might have caused some issues so we have a meeting with our JAMF Engineer next Wednesday to futher investigate the issues that occured during the upgrade. 

[zeroSPace33]

Hi @mvungos ,

I checked with out JAMF sysadmin and he reports that we did recently upgrade. Seems like too much of a coincidence to not possibly be the cause of this issue. He has sent a message to our JAMF support as well to see if we can get someone to look into it for us on their end. I'll keep you posted.

Thank you!

[mvungos]

Hey @zeroSPace33,

Just wanted to update you and let you know that we made some changes to JAMF that corrected our distribution point issue by enabling anonymous authentication on our Windows Server 2012 instance. I thought that by fixing this issue, it might have something to do with the issues I am having with Power BI, but that is not the case. I still cannot load a full report in Power BI. Any update on your end? Thank you. 

[zeroSPace33]

Hey @mvungos,

We're still testing. We've sent data to our JAMF engineers. In the mean-time, our JAMF on-site admin has tested connecting to the api using other methods and it seems to be working, but he's been off site all week. We'll be testing it further on Monday when he returns. I'll let you know how that goes.

Thanks for checking in!

[mvungos]

Hey @zeroSPace33 

When your JAMF admin gets back on Monday, can you let me know what other methods he's using to connect to the API? Hopefully we'll be able to figure this out soon. Thanks!

[zeroSPace33]

Hi @mvungos,

I met with our admin. He showed me that he can use shell commands to query jamf data. He has proposed that we create shell (or possibly PoweShell scripts) to extract this jamf data and import it into an Azure Table. It seems like maybe the Power BI jamf connector may be the thing that is malfunctioning here.

[zeroSPace33]

Hi @mvungos,
We had our meeting with the Jamf engineer this morning. In our meeting, I ran a test on the connector again and today it worked. I explained to our admin and the engineer that we would normally see a bad gateway error message. Then our admin explained that they had seen the bad gateway error on the LDAP connector to the Jamf server. The cause of that was that the a server was stuck in a hung state and needed to be rebooted, but it was prohibiting network connectivity to complete the data request. The Jamf server wasn't down and could be accessed and worked with directly, but data connections were blocked. I know I'm missing some details that I wasn't given, but the bottom line is that it's working again and it seems to coincide with the error message with LDAP and restart of this other server. Perhaps you're experiencing a similar blockage on your end, but it seems ours was specific to our environment. Hopefully you find the cause on your side soon! Keep us posted.

Thank you!

[v-henryk-mstf]

Hi @mvungos ,

Check out the following series of blog posts about Power BI and JAMF Pro Datasets to see if they are helpful to you.

Power BI and JAMF Pro Datasets : Part 1 - Connecting - SlingPine

Power BI and JAMF Pro Datasets : Part 2 - Export/Import Dataset - SlingPine

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mvungos]

Hello @v-henryk-mstf 

I can do the first attribute: Device Computer Groups and it loads up, but I am doing the next attribute, "Computers" and its still has not populated any data and its been like this for over an hour.

I watched a video earlier that showed how to connect Power BI to JAMF Pro. It also stated that the custom connector is no longer needed since that issue hs been resolved since 2020 I believe and it has been integrated into Power BI.

What is odd is that when it asks me to type the JAMF Pro Instance URL, this is what I type: https://episdmobilemgt.jamfcloud.com however, when I click LOAD, it then it displays "Waiting for ("url":"https:\/\/episdmobilemgt.jamfcloud.com")

Not sure as to why the slashes are like that. I even tried to omit the slashes but then it tells me that the URL is incorrect when I select one of the attributes to load.

I am using the latest version or Power BI (November 2022) from the MS Store.

[mvungos]

Hello @v-henryk-mstf 

I followed those links but I'm getting these error messages:

Computer Device Groups Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers - Applications Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers - Extension attributes Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile - Applications Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Device Groups Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Devices Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Devices - ExtensionAttributes Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Devices - ExtensionAttributes (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Devices (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile Device Groups (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Mobile - Applications (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers - Extension attributes (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers - Applications (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computers (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '. Computer Device Groups (2) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://episdmobilemgt.jamfcloud.com/JSSResource/computers/id/4415' (502): Bad Gateway. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '.

From what I've been reading, there is no need for a Custom Connector since Power BI has integrated with JAMF. I am also reaching out to our JAMF engineer regarding this issue and they advised me to reach out to the people at Power BI for assistance.