Upgrade to Ensemble 2016

Question

Question

Manoj Jayaraj · Oct 19, 2016

#Beginner #System Administration #Ensemble

Hi All,

We are Upgrading the Application from Ensemble 2009 to 2016.1. We have imported the user, Roles and Resources.
But the Sql Tables and Sql Procedures are not being visible in Management portal -> Security Management -> User.
Please give me a solution or basics steps for importing those.

Thanks,
Manoj J

Discussion (9)0

Log in or sign up to continue

Tirthankar Bachhar · Oct 20, 2016

One article I would like to refer for you. Please go through it. It was been presented by Kyle Baxter.

https://community.intersystems.com/post/global-summit-2016-painless-sql-upgrades

2 0

score 0 · Answer 1 · 2016-10-19T11:15:34-04:00

Copy Cache.Dat from ensemble 2009 version to a separate location, and try mounting them directly into 2016.1. While copying Cache.Dat, keep the ensemble instance down.

let me know if this works.

score 0 · Answer 2 · 2016-10-19T11:30:50-04:00

Manoj Jayaraj · Oct 19, 2016

Thanks for your response.

We already done that still the same problem exists.

Thanks,
Manoj J

0 0

score 0 · Answer 3 · 2016-10-19T12:44:32-04:00

Does the User you are logging into the portal with have %All?

You could turn on Auditing and enable Privilege violation auditing and see if something shows up there.

did you run $SYSTEM.OBJ.Upgrade() on the namespace?

score 1 · Answer 4 · 2016-10-19T13:31:52-04:00

I also have the same problem.. If I use ℅All it works. But I want to restrict some access to different user roles. In that case I am still getting the same problem. Is there any other way??

score 0 · Answer 5 · 2016-10-19T17:39:05-04:00

It's likely that you didn't actually export the SQL Privileges. You can do that via ^SECURITY -> System parameter setup -> Export All Security settings. This will allow you to specifically export just SQL Privileges records if you answer 'no' to 'Export ALL security records?'

score 0 · Answer 6 · 2016-10-21T05:25:26-04:00

In Ensemble 2009 it doesn't have any separate options to export SQL Privileges like it has in Ensemble 2016. I have done what you said but the SQL privilege error still exists. Please help me out.

score 0 · Answer 7 · 2016-10-21T12:11:50-04:00

Pete Greskoff · Oct 21, 2016

At this point, I suggest opening a WRC issue.

0 0

score 2 · Answer 8 · 2016-10-20T09:55:27-04:00

Kyle Baxter · Oct 20, 2016

I would also like to refer you to that article :-D

2 0