Migrate-SPProjectDatabase : Error encountered while migrating project data in Content database. The INSERT permission was denied on the object ‘MSP_RESOURCES’, database ‘PWA_Content’, schema ‘pjpub’.

I’m running a migration test from Project Server 2013 to Project Server 2016 and ran into a problem of my own making, so I wanted to share in the event this can help others. My upgrade command is this: Migrate-SPProjectDatabase -DatabaseName PWA_ProjectWebApp -SiteCollection “http://vm1/pwa” “[A] Yes to All” got me this: Migrate-SPProjectDatabase : Error encountered…

0

GeneralActionCanceledBecauseServerEventServiceProblem (22002) Action cancelled because of a problem with the Project Server Event Service.

Today I was working on why a customer seems to be unable to delete nodes from their RBS table in Project Server 2013 on premises (there’s a timeout they are hitting, because I can delete just fine).  I clicked Save after I had removed all the nodes in the lookup table and received an error in…

0

After February 2017, no more support for Project 2013 with Project Online

***** Update Jan 26 2017 The deadline has been extended. Using Project Online? Time to be sure you upgrade the client software *****   Starting in February 2017, Microsoft will no longer support Project 2013 (through Office 365 or MSI) connecting to Project Online. Customers who need to connect to Project Online will need to…

2

SharePoint 2016 – Joining Farm failed. The exception is One or more types failed to load.

Problem My customer was setting up her first SharePoint 2016 server in a test farm and ran into a problem creating the SharePoint configuration database using PowerShell. Her Powershell input and the output looked like this: $ConfigDatabaseName = “SharePoint_Config” $SQLServer = “sptest16sql.contoso.com” $CADatabaseName = “SP2016_AdminContent” $CAPort = 2016 $CAAuth = “NTLM” $PassPhrase = “ILovePizza!1” $LocalServerRole…

0

Actual hours can move in a plan

I have been working on actual work hours mismatches between timesheets and project plans. Kate Simpson, Senior Support Escalation Engineer, and I came across a situation where Project Online will move actual hours a resource has already entered and submitted, if the same resource moves the Start of the task after the original task update has been approved…

0

Periodic Tasks for Project Managers

Periodic Tasks for Project Managers     Daily  Check the queue for Failed and Blocking jobs related to your plan in Server Settings > My Queued Jobs.  Review the errors related to failed and blocking jobs to troubleshoot.  Cancel Failed and Blocking jobs and/or re-submit them if required.  Check email notifications for the resources for undue…

0

Tell the Product Group what you want to see!

The Product Group wants to know how Microsoft can improve SharePoint Server, SharePoint Online, Project Desktop, Project Server, and Project Online. You can lend your voice to the SharePoint and Project Server product group’s choices for functionality!   Here are the links to provide feedback at UserVoice.com: For Project: https://microsoftproject.uservoice.com/ For SharePoint: http://sharepoint.uservoice.com/    …

0

403 error in IE when accessing the Project Online OData feed URL

This morning, I fired up my Microsoft Edge browser to connect to my demo tenant for Project Online and access the OData feed URL. After a few minutes ensuring I had the correct URL (and turning off my Insert key) for the odata feed, I was still unable to get the output in the browser…

0