community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Collections not found after Server update

Alteryx Partner

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

 

collection.JPG

 

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

page not found.JPG

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

create collection.JPG

 

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

Alteryx
Alteryx

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:

 

database.pngdatabase2.png

Alteryx Partner

@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

Alteryx
Alteryx

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...

Alteryx Partner

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

Highlighted
Atom

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.