Invalid Column Name

[KenSimmons]

I have a user in a group that tries to create a report and keeps getting an "Invalid Column Name" error. Other users in the same group are not getting this error and she is set up exactly the same. Any ideas?

Thanks,
Ken

 

[skrandel]

You must have her middleware set up differently. She either doesn't have all the right database privileges or is pointing to a different database.

Without knowing which database you are using......

Try using a different BO id from her machine.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[KenSimmons]

I am using Webi. I used her login from my machine and got the same error. The universe is inherited from the group, so all users should have the same results right?

 

[skrandel]

You need to check her universe security in supervisor. She could either have a row restriction turned on or a table mapping.

What version of WebI. If 6.x, then you should compare the SQL code that is being run.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[nimmy99]

Then the privillage and rights of her id. See whether that table is restricted