Ambiguous Error/Missing columns

Question

I recently configured a few databases today in addition to the canned innovator solutions db. Throughout the process I needed to delete a database and reconfigure the exact database with a user id change. I deleted the wrong database, then deleted the correct one. After attempting to reconfigure the required db's, setting the tag in the config file, and attempting to login I get the following error:

Cannot find either column "protected" or the user-defined function or aggregate "protected.getProtectionToken", or the name is ambiguous.

It is my hope that Mr Gills doesn't tell me to read the book, although I would certainly be appreciative.

Thanks for reading.

Cannot find either column "protected" or the user-defined function or aggregate "protected.getProtectionToken", or the name is ambiguous.

It is my hope that Mr Gills doesn't&nbsp;tell me to read the book, although I would certainly be appreciative.
&nbsp;
Thanks for reading.

former_member · Answer

Sounds like a permissions issue.&nbsp; Maybe the install was done with a profile that isn't admin.&nbsp; I know when my organization yanks my permissions from the server I generally have all kinds of issues managing aras.

Im glad this post has been useful.&nbsp; Thanks to all that replied and especially Mr. Gillis.&nbsp;&nbsp;

former_member · Answer

Like magic I was able to get into the DB's without re-configuring aras.&nbsp; Do not know what the issue was.&nbsp; Perhaps the server took off early for the weekend, who knows.

christopher_gillis · Answer

Hi Rob,
I don't think this one is covered in our documents. :)&nbsp;
If I had to take a guess based on the description of the problem and the sudden resolution, I'd say this was probably a caching issue.&nbsp;When you were configuring the new databases, was one of them restored with the same name as a database that was previously deleted?
Chris

former_member · Answer

The method we have found best for adding and deleting databases is to:
Run Installer&gt;select add database and all its features&gt;Configure database via aras Installer&gt;cancel installation of aras&gt;Edit config tag with appropriate information: ie, copy and paste most of the connection tag with the credentials being different. Log in.
My Actions:&nbsp; At first I assumed I needed a different users for each different db in aras, so I started with innovator1, innovator2 ect as a user.&nbsp; I didn't not make it to innovator2, I found this to be a needless step.&nbsp; So I deleted the database I&nbsp;built with innovator1, rebuilt the database via aras MSI naming it the exact same database, which as I type I realize the cache explanation make a ton of sense.&nbsp; Anyway after naming the two databases I deleted the exact name as they were before, setting the tag in the config file and attempting to login prompted that error.

Mr. Gillis, as always I am very grateful.&nbsp;&nbsp;I hope I was clear and helpful.&nbsp;

christopher_gillis · Answer

Happy to help Rob. :)
As a note, it sounds like you might benefit from checking out our blog post on managing databases. The last section,&nbsp;How to restore a database from a backup, goes over the steps we use internally to set up multiple databases. After the database is restored using those steps, you'd just need to add a tag to the config file like you already do, and you should be able to log into the database.
I'm mentioning this method of restoring databases only because I've found it's faster than the method you're currently using. This method would likely also run into the caching issue when restoring a database with the same name.&nbsp;
Chris

Forum Discussion

Ambiguous Error/Missing columns

10 Replies

Recent Discussions

Workflow Continues after Lifecycle is Cancelled

Installation issue : ODBC Driver 18 SSL Provider error

Train and onboard a team on Aras Innovator

Changing File Type Column Width in Relationship Grid

Noob question...