topic Re: Collections not found after Server update in Alteryx Server Discussions

Collections not found after Server update

RsRoel — Mon, 01 Jul 2019 15:44:43 GMT

After updating Alteryx Server from 2018.2 to 2019.2 we lost access to our Collections:

When click on one of them we get a 'page not found' message:

I also cannot remove and re-add them again, nor create new Collections:

The workflows do still exist in the Private Studio and those workflows that were publish Gallery-wide are also still there.

Anyone experienced this as well and managed to resolve it?

Regards,

Ruben

Re: Collections not found after Server update

MichaelSu — Tue, 02 Jul 2019 01:05:22 GMT

Hi @RsRoel,

Sounds like the DB is corrupt. This may require some help from support. However, a quick fix is to create a new Data Folder. When you are running through System Settings for Server, point to that new data folder. This should resolve the collections error you are having. The only catch is that you will have to re-upload your collections. See screen shots below:

Re: Collections not found after Server update

RsRoel — Tue, 02 Jul 2019 13:12:51 GMT

@MichaelSu thanks, it seems indeed to be an issue with the DB :)When creating a new one the Collection error is resolved.

The drawback however is that we also lose all our user settings, permissions, collections, workflows/apps, schedules, shared data connections and subscriptions..

Are you aware of a method to at least safe some of that (especially the shared data connections) from the old DB? As this is also not corrupted at the moment.

Thanks,

Ruben

Re: Collections not found after Server update

MichaelSu — Tue, 02 Jul 2019 16:54:30 GMT

You can look at the Server log files to get a better understanding of what's going on - see link below.

The best bet would be to reach out to Alteryx Customer Support (support@alteryx.com) and they should be able to help you out.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/The-Lumbermill-App-Obtain-Server-Logs-the-easy-way/ta-p/302943

Re: Collections not found after Server update

RsRoel — Thu, 04 Jul 2019 13:26:33 GMT

Thanks @MichaelSu for the help. Have contacted support who hopefully finds a solution 🙂

Re: Collections not found after Server update

pjarrard — Mon, 15 Jul 2019 21:50:49 GMT

I was having (what appeared to be) the same issue.

The solution was to clear the browser history. Collections came back (they never really went anywhere).

Your mileage may vary - but try that first.

Re: Collections not found after Server update

John_Doe101 — Thu, 24 Oct 2019 15:51:48 GMT

@RsRoel Did you ever find a solution for this? We ran into the same issue and haven't got any luck solving it. We don't want to lose all the settings as you mentioned you did. Please let me know how did it go.

Thanks

Re: Collections not found after Server update

DanM — Thu, 24 Oct 2019 18:09:38 GMT

@John_Doe101,

I would suggest reaching out to our Support team for assistance. This issue can be environmentally specific and they should be able to assist you.

DanM

Re: Collections not found after Server update

marisoltimm — Sun, 15 Nov 2020 00:15:17 GMT

@pjarrard Clearing browse history did the trick for me. Thanks!