Links:
Sites About Me
Excellence
-
http://excellence.bergren.net
Pics -
http://picasaweb.google.com/rnbergren
Bibles - Family Bibles
Polk City - www.polkcity.org
Church - www.ridgelife.org
Need a PDF Form -
www.bergren.net/pdf
DMACC - wwww.dmacc.edu
http://rnbergren.stumbleupon.com/
twitter
Linked In
Having fun being a father and a web geek.
Hello, my name is
Rod Bergren
Who am Who am I? I am a
geek/programmer/webmaster/manager for the bestest company.
I write applications for Web Services and Windows. I also do on the side
contract programming as my time allows (which is not very much).
Thursday, January 9, 2020
SharePoint Grant-SPProjectAdminstratorAccess Error.
"Grant-SPProjectAdministratorAccess : Cannot insert the value NULL into column 'WRES_GUID', table 'ProjectWebApp_EPM.pub.MSP_WEB_SECURITY_GROUP_MEMBERS'; column does not allow nulls. INSERT fails. Table 'MSP_WEB_SECURITY_GROUP"
Yes, this big ol error.
Turns out we had moved from one primary domain to another. You know company changes hands or changes names or someone decides that they don't like the Domain name for some reason. Most of the users we had in the Domain moved just fine except for 2 Admins. Of course it always has to be the admin ID's.
There was absolutely nothing in the Googlina that was worth looking at. Yay! I was just about to call Microsoft and pay the fee to have someone tell me how to fix it.
Since it was actually a Development system that was erroring out. I decided to try making it worse before calling and begging.
Opened up the Manage Users page for the PWA instance. /PWA/Admin/ManageUsers.aspx
Search for the user. Well paged down and paged down and paged down. (search didn't work)
Edit user(Click User Name). Reattach the userid to the correct email address with the correct domain. john.doe@RightDomain.com
Then the Powershell command worked. and the Admin has access to DEV to do DEV work.
YAY!
Monday, September 16, 2019
Caught a bee in flight
Went driving in SW Iowa this weekend. Caught a bee in flight in my window of my truck. The background was pretty as well.
Thursday, June 27, 2019
So David went on a Mission Trip and Mom and Dad went on Vacation.
David headed out of town for 10 days on a mission trip with this bunch of yaahoos.
So Mom and I decided it was time for a much needed vacation. Those who know us know we rarely get this option. So here Helene was trying to speak but I don't think she had enough Vacation or sleep to be able to actually speak.
But then we settled into just relaxing and reading. And then we started driving and seeing the sights.
Like Bob and Steve's Convenience store. This actually caused us to take a wrong turn in the middle of Wisconsin. Seriously off track for about half and hour.
But we did take note of some stunning scenery as well. Like the the North Shore of Lake Michigan.
Eventually we stopped looking at the scenery which is awesome on the UP and we did get to our Hotel on Lake Huron. Which was also awesome.
Then we ran around in Mackinaw City and toured an Ice Breaker. The Mackinaw. She is a big boat"Ship" I was called out on calling it a boat. Sorry those of you who actually know the difference.
And toured the Michillimackinac Fort. Which was probably my favorite part of the whole trip. They had guns dude! and fresh baked bread.
We left Mackinaw City and ran up to the Soo. Sault Saint Marie. We did the Locks tour thingy. They are interesting. The Ships are huge! Things dont' happen quickly here though. Also we hung out with Bigfoot for awhile. He was a pretty kewl dude.
On the way back home we stopped at Kitch-iti-kipi springs in Michigan. There is a rainbow trout in one of those pictures. You can even see the rainbow on him. Just glowing away.
Last stop was Oshkosh. This was Helene's favorite stop. We got to fly in Vintage Bi-Planes. On a bright sun shinny day with just a few clouds in the sky.
Finally it is time to get home. Drove over the Bridge over the Mississippi and thru some pretty farm land. That is Iowa don't ya know. Stopped in Tama for supper and had some Ice Cream.
Saturday, January 26, 2019
Old recipe (joke)
Found this recipe in an old cook book. Obviously a joke by someone. But the fact that the ladies that were publishing this cookbook left it in there.
My giggle for you today.
Enjoy
Monday, January 14, 2019
Magnify the flag and shine some light on it.
Notice something really kewl with a magnifying glass and the lighting in my study today. So, I took a picture. Pretty much unedited except for the edges where I wanted to get rid of some background that was distracting.
Enjoy
Wednesday, January 9, 2019
Cold walk for the doggos
Went for a walk. it was cold and windy. The dogs didn't seem to mind. Me, I was distracted by the sunset. Imagine that.
Wednesday, January 9, 2019
The Start Button/Task Bar
So, Why do we all just leave the start button bar on the bottom left of our screen? ?If we do that. We end up with a bar that has icons and well if left as the default takes up a significant amount of real estate on the screen on a screen that is wider than it is tall.
I end up with something along the lines of this.
And that is all well fine and dandy. But I cannot tell what is up on which screen. I don't know which SQL file I might be editing, I don't know which webpage I might be on in IE/ or chrome. or the folder in Explorer. And lastly I have to "know" what each icon means.
Many years ago, I switched this to being on the right hand side of my monitor and I have never went back. This offers me many advantages over the default.
Here is a screen shot.
It is an easy switch. Just right click and unlock the task bar.
Then select the bar where no icons are present and drag to where you want it. Top, left, right. 
More
pictures are here.
From Ariea
Other stuff of interest to people possibly.
Trip to Tahiti.
Belize
is nice as well
Pics - http://picasaweb.google.com/rnbergren
Bibles - Family Bibles
Polk City - www.polkcity.org
Church - www.ridgelife.org
Need a PDF Form - www.bergren.net/pdf
http://rnbergren.stumbleupon.com/
Linked In
Having fun being a father and a web geek.
Hello, my name is
Rod Bergren
Who am Who am I? I am a geek/programmer/webmaster/manager for the bestest company. I write applications for Web Services and Windows. I also do on the side contract programming as my time allows (which is not very much).
| Thursday, January 9, 2020 SharePoint Grant-SPProjectAdminstratorAccess Error. "Grant-SPProjectAdministratorAccess : Cannot insert the value NULL into column 'WRES_GUID', table 'ProjectWebApp_EPM.pub.MSP_WEB_SECURITY_GROUP_MEMBERS'; column does not allow nulls. INSERT fails. Table 'MSP_WEB_SECURITY_GROUP" Yes, this big ol error. Turns out we had moved from one primary domain to another. You know company changes hands or changes names or someone decides that they don't like the Domain name for some reason. Most of the users we had in the Domain moved just fine except for 2 Admins. Of course it always has to be the admin ID's. There was absolutely nothing in the Googlina that was worth looking at. Yay! I was just about to call Microsoft and pay the fee to have someone tell me how to fix it. Since it was actually a Development system that was erroring out. I decided to try making it worse before calling and begging. Opened up the Manage Users page for the PWA instance. /PWA/Admin/ManageUsers.aspx Search for the user. Well paged down and paged down and paged down. (search didn't work) Edit user(Click User Name). Reattach the userid to the correct email address with the correct domain. john.doe@RightDomain.com Then the Powershell command worked. and the Admin has access to DEV to do DEV work. YAY! |
| Monday, September 16, 2019 Caught a bee in flight Went driving in SW Iowa this weekend. Caught a bee in flight in my window of my truck. The background was pretty as well.  |
| Thursday, June 27, 2019 So David went on a Mission Trip and Mom and Dad went on Vacation. David headed out of town for 10 days on a mission trip with this bunch of yaahoos.  So Mom and I decided it was time for a much needed vacation. Those who know us know we rarely get this option. So here Helene was trying to speak but I don't think she had enough Vacation or sleep to be able to actually speak. But then we settled into just relaxing and reading. And then we started driving and seeing the sights.  Like Bob and Steve's Convenience store. This actually caused us to take a wrong turn in the middle of Wisconsin. Seriously off track for about half and hour.  But we did take note of some stunning scenery as well. Like the the North Shore of Lake Michigan.    Eventually we stopped looking at the scenery which is awesome on the UP and we did get to our Hotel on Lake Huron. Which was also awesome. Then we ran around in Mackinaw City and toured an Ice Breaker. The Mackinaw. She is a big boat"Ship" I was called out on calling it a boat. Sorry those of you who actually know the difference.  And toured the Michillimackinac Fort. Which was probably my favorite part of the whole trip. They had guns dude! and fresh baked bread.  We left Mackinaw City and ran up to the Soo. Sault Saint Marie. We did the Locks tour thingy. They are interesting. The Ships are huge! Things dont' happen quickly here though. Also we hung out with Bigfoot for awhile. He was a pretty kewl dude.     On the way back home we stopped at Kitch-iti-kipi springs in Michigan. There is a rainbow trout in one of those pictures. You can even see the rainbow on him. Just glowing away.   Last stop was Oshkosh. This was Helene's favorite stop. We got to fly in Vintage Bi-Planes. On a bright sun shinny day with just a few clouds in the sky.       |
| Saturday, January 26, 2019 Old recipe (joke) Found this recipe in an old cook book. Obviously a joke by someone. But the fact that the ladies that were publishing this cookbook left it in there. My giggle for you today. Enjoy  |
| Monday, January 14, 2019 Magnify the flag and shine some light on it. Notice something really kewl with a magnifying glass and the lighting in my study today. So, I took a picture. Pretty much unedited except for the edges where I wanted to get rid of some background that was distracting. Enjoy  |
| Wednesday, January 9, 2019 Cold walk for the doggos Went for a walk. it was cold and windy. The dogs didn't seem to mind. Me, I was distracted by the sunset. Imagine that.    |
| Wednesday, January 9, 2019 The Start Button/Task Bar So, Why do we all just leave the start button bar on the bottom left of our screen? ?If we do that. We end up with a bar that has icons and well if left as the default takes up a significant amount of real estate on the screen on a screen that is wider than it is tall. I end up with something along the lines of this.  And that is all well fine and dandy. But I cannot tell what is up on which screen. I don't know which SQL file I might be editing, I don't know which webpage I might be on in IE/ or chrome. or the folder in Explorer. And lastly I have to "know" what each icon means. Many years ago, I switched this to being on the right hand side of my monitor and I have never went back. This offers me many advantages over the default. 1. I have at least an inkling of what I have open in each application/browser 2. It takes up space on my screen from the width rather than the height. We have more width to spare. 3. if I am Terminal serviced in somewhere ( I leave my TS screen at the bottom) I have a quick indicator telling me I am not on my own computer 4. I can have alot more windows open before things begin to stack like the Internet Explorer icons above. Here is a screen shot. As you can see. I can see what is up on each page/application. It is out of the way being on the right hand side. and it just seems clearer. Maybe not cleaner. But certainly the information is more clearly available to me. It is an easy switch. Just right click and unlock the task bar. Then select the bar where no icons are present and drag to where you want it. Top, left, right. |
More pictures are here.
|
| |
| From Ariea |
Other stuff of interest to people possibly.
Trip to Tahiti.
Belize is nice as well