Rollback of upgrading Private Cloud DevPortal 15.01 to 16.09

[#1]

Hi Team,

A customer asked me about how to restore the broken user id of Drupal. They upgraded from DevPortal 15.01 to 16.09 but made a mistake of configuring it by pointing wrong Edge MS server in DevPortal config.

And the following error is shown on DevPortal when creating a new user:

409:The UserID overlapped.:Specified ID:4946, user
name:toshi.shiba.20170630test data has already been created.

On DevPortal the last uid is 4916 from MySQL DB users table which is different from 4946 in the above message.

So, it seems that the uid counter is broken on DevPortal due to the wrong config of MS url.

Could someone please advise me what are the right steps to restore the DevPortal issue above?
How can they roll it back to 15.01 and re-install it?

Thanks,
Toshi

[#2]

Toshi,

You can change the URL and credentials DevPortal use to connect to Edge form within Drupal Admin menu. You don't need to re-install for that.

[#3 · Accepted solution]

@Toshihiro Shibamoto

the error you added above indicates that there already exists a user with the userid in devportal database. This would very likely occur if the user ran the "Developer sync" from portal, pulling developer information from edge to devportal. You could correct this by changing the devportal configuration by pointing to the correct edge org. And then you can manually remove the unwanted developers from portal. If this is not feasible, then you can revert back to 15.01 install using the database and file system backup taken prior to the upgrade per the steps: http://docs.apigee.com/private-cloud/v4.16.09/upgrading-developer-services-portal . Once you uninstall 4.16.09 , you can install 4.15.01 and follow this article by @gkoli@apigee.com to restore the database and file system backup.

[#4]

@Arun Kumar Thank you so much for the answer.

I'll share this with the customer to follow the steps to restore DevPortal user data or a rollback/reinstallation as you suggested above.