iOS Google Apps just wiped out

[Sandy]

Hey anyone,
Today we came in and discovered that ALL the Google iOS apps have the alert that they are no longer in the App Store.
But they are in the App Store, same ID, but our catalog entries have to be recreated to link back up.
There were a few others as well that seem fine but are no longer connected:
DuoLingo, Cloud Library, Flocabulary, Dakota Library
Anyone else seeing this?
Also on a related note, do others have the global app Update turned ON these days? I am wondering if this is version related since I do NOT have that lobal update turned on.

[Sandy]

Huh. well, I understand Google "warned us" about this... but nobody warned me LOL!

[larry_barrett]

Where did you get the "alert"?

[Sandy]

@larry_barrett In my App Catalog, there's a yellow badge next to all the apps that are "No longer in the App Store" .... but they are. Creating a new catalog item recreates the app with the same ID! There were a couple non-google apps also affected.
EDIT: It's also possible this happened because our app versions were older. Maybe if yours are newer they would escape this fate?

[larry_barrett]

@Sandy I forced the updates after seeing your post. No issues here (today). I also didn't have the yellow badge etc.

[St0rMl0rD]

No issues here, haven't updated any Google apps for a few months or so

[thejenbot]

Oh man you scared the crap out of me! I ran to my app catalog and they are all intact for me, so I'm guessing you're running into a really fun Product Issue! PI-005394 - "Apps That Exist on the App Store are Disabled" - basically causes apps that are in the App Store to show as not available in the JSS. Online services can make them good again if you're cloud hosted. I've had this happen a couple of times. It doesn't affect apps on devices, but if they're disabled in your catalog nobody new can get them. SO FUN!

[Sandy]

Sorry, @thejenbot I had not had any issues with that product issue all this time
We jumped versions from 10.13 to 10.17 several weeks ago and this just happened yesterday, and also suddenly had the DEP syncing issue.
TGIF!!

[CSCC-JS]

I noticed that Google Apps now show as Google LLC as company identity.

[thejenbot]

@Sandy it's all good. welcome to the PI party! :) i've been dealing with this one for a full calendar year, so i know it was from before 10.13 - you're lucky you haven't seen it before now...if you haven't, i would definitely open a case referencing that PI to bump it :)

[lehmanp00]

We have had this problem for 2 years now. I check our app list every week. (2k+ apps)
I have 2 SQL DB commands that I have to run to get them back up.

1. Go into the app in the App Catalog. Find the app iTunes idetifier number. Gmail's is this: https://itunes.apple.com/us/app/gmail-email-from-google/id422689480?mt=8&uo=4
2. Login to MySQL (all I have is MYSQL commands). Open the JAMFSOFTWARE DB.
3. Run this command 1st:

   update vpp_mobile_device_app_license_app set available_in_appstore = 1 where adam_id = '422689480';

4. Then this command:

   update mobile_device_apps set available_in_appstore = 1,enabled=1 where deleted=0 and itunes_id ='422689480';

   If you refresh the app page in JSS, it should be active again. Repeat as needed for other disabled apps.

[Sandy]

@lehmanp00 , @thejenbot

Whoa fun Party!
Apps are fixed, thanks for sending those commands!
Got any clues as to the who what why's on this issue?
Sandy

[lehmanp00]

Not a clue. I got these commands from JAMF 2 years ago or more. They knew about this issue back then. To be fair, JAMF Pro 13 did NOT have this issue for me, but it came back when I upgraded to 15.

[thejenbot]

yeah, it's been off and on for me as well. my first issue with it was back in december of 2018 and i didn't see it again until october. sporadic, random, no rhyme or reason that i can see...