SOLVED

New PWA site metadata error

%3CLINGO-SUB%20id%3D%22lingo-sub-1101847%22%20slang%3D%22en-US%22%3ENew%20PWA%20site%20metadata%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EWhen%20trying%20to%20use%20the%20PowerBi%20data%20pack%20for%20PWA%20I%20received%20the%20following%20error%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CBR%20%2F%3E%3CSTRONG%3EOData%3A%20The%20feed's%20metadata%20document%20appears%20to%20be%20invalid.%20Error%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CBR%20%2F%3EI%20then%26nbsp%3B%20tried%20to%20verify%20if%20the%20metadata%20for%20the%20PWA%20site%20was%20actually%20good%2C%20but%20when%20I%20entered%20the%20URL%20%5B%2F%2Fhttps%3A%2F%2F%3CMY%20site%3D%22%22%3E%2F%3CPWA%3E%2F_api%2FProjectData%2F%24metadata%5D%20it%20doesn't%20return%20any%20information%20and%20gives%20the%20following%20error%20message%3A%3C%2FPWA%3E%3C%2FMY%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CBR%20%2F%3E%3CSTRONG%3EAn%20IEdmModel%20instance%20was%20found%20that%20failed%20validation%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CBR%20%2F%3EAnybody%20knows%20what%20is%20the%20problem%20and%20how%20I%20can%20fix%20it%3F%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1103753%22%20slang%3D%22en-US%22%3ERe%3A%20New%20PWA%20site%20metadata%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1103753%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491868%22%20target%3D%22_blank%22%3E%40mhugo%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EAs%20the%20metadata%20is%20view%20is%20failing%20it%20could%20be%20a%20configuration%20issue%20-%20potentially%20a%20duplicate%20property%20as%20described%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fproject-support-blog%2Fproject-online-and-odata-amp-8211-reserved-words%2Fba-p%2F361765%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fproject-support-blog%2Fproject-online-and-odata-amp-8211-reserved-words%2Fba-p%2F361765%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EDo%20you%20know%20which%20endpoint%20is%20failing%20in%20the%20Power%20BI%20report%20pack%3F%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1107407%22%20slang%3D%22en-US%22%3ERe%3A%20New%20PWA%20site%20metadata%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1107407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491868%22%20target%3D%22_blank%22%3E%40mhugo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22js-vote-count%20grid--cell%20fc-black-500%20fs-title%20grid%20fd-column%20ai-center%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22post-text%22%3E%3CP%3EI%20am%20using%20a%20workflow%20to%20create%20a%20project%20in%20project%20server%202013.%20This%20seems%20like%20a%20fairly%20common%20operation%2C%20but%20I%20need%20to%20set%20a%20few%20pieces%20of%20information%20when%20I%20create%20the%20project%20that%20are%20not%20available%20in%20the%20constructor.%3C%2FP%3E%3CH2%20id%3D%22toc-hId--1416428679%22%20id%3D%22toc-hId--1416428679%22%20id%3D%22toc-hId--1416428679%22%20id%3D%22toc-hId--1416428679%22%3EProcess%20Outline%3C%2FH2%3E%3CP%3Efor%20my%20own%20purposes%20I%20am%20using%20Chrome%20app%20DHC%20for%20creating%20these%20requests.%3C%2FP%3E%3CP%3EI%20use%20headers%3A%3C%2FP%3E%3CPRE%3E%20%20%3CSPAN%20class%3D%22typ%22%3EAccept%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E%20%20%20%20%20%20%20application%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Ejson%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Eodata%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Everbose%0A%20%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EContent%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E-%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EType%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E%20application%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Ejson%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Eodata%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Everbose%3C%2FSPAN%3E%3C%2FPRE%3E%3COL%3E%3CLI%3E%3CP%3Eget%20the%20Context%20(X-RequestDigest)%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3Edev1projects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPWA%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E_api%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Econtextinfo%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPOST%20empty%20body%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5D%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLI%3E%3CLI%3E%3CP%3EPick%20a%20Project%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3Edev1projects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPWA%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E_api%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjectServer%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E%24Top%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22lit%22%3E1%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22pun%22%3E%5B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EGET%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5D%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLI%3E%3CLI%3E%3CP%3ECheck%20out%20the%20project%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3Edev1projects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPWA%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E_api%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjectServer%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E'theguidi-just-pick-from-theprojectabove'%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E)%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EcheckOut%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E()%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22com%22%3E%2F%2FAdd%20Header%20X-RequestDigest%3A0xTheStringFromTheContextQuery(d%2FGetContextWebInformation%2FFormDigestValue)%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22pun%22%3E%5B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPOST%20empty%20body%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5D%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLI%3E%3CLI%3E%3CP%3EUpdate%20the%20Draft%20item%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3Edev1projects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPWA%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E_api%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjectServer%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E'projectid'%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E)%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EDraft%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3Eupdate%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E()%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22com%22%3E%2F%2FAdd%20Header%20X-RequestDigest%3A0xTheStringFromTheContextQuery(d%2FGetContextWebInformation%2FFormDigestValue)%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22pun%22%3E%5B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPOST%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5D%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22pun%22%3E%7B%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E%22__metadata%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%7B%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E%22type%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E%22PS.DraftProject%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%7D%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E%22Name%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E%22Test%20679%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%7D%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLI%3E%3CLI%3E%3CP%3ECheck%20In%20the%20Draft%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3Edev1projects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPWA%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E_api%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjectServer%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EProjects%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22str%22%3E'theguidi-just-pick-from-theprojectabove'%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E)%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22typ%22%3EDraft%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%2F%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EcheckIn%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E()%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22com%22%3E%2F%2FAdd%20Header%20X-RequestDigest%3A0xTheStringFromTheContextQuery(d%2FGetContextWebInformation%2FFormDigestValue)%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22pun%22%3E%5B%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3EPOST%20empty%20body%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%5D%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1107579%22%20slang%3D%22en-US%22%3ERe%3A%20New%20PWA%20site%20metadata%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1107579%22%20slang%3D%22en-US%22%3EThanks%20Paul!%20After%20a%20lot%20of%20troubleshooting%2C%20I%20found%20that%20we%20had%20a%20custom%20field%20called%20%22Project%23%22%20-%20when%20I%20changed%20that%20to%20%22Project%20Number%22%20it%20resolved%20the%20issue!%3CBR%20%2F%3E%3CBR%20%2F%3EMuch%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1108022%22%20slang%3D%22en-US%22%3ERe%3A%20New%20PWA%20site%20metadata%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1108022%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20to%20hear%20that%20you%20have%20this%20sorted%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491868%22%20target%3D%22_blank%22%3E%40mhugo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When trying to use the PowerBi data pack for PWA I received the following error:


OData: The feed's metadata document appears to be invalid. Error


I then  tried to verify if the metadata for the PWA site was actually good, but when I entered the URL [//https://<My Site>/<PWA>/_api/ProjectData/$metadata] it doesn't return any information and gives the following error message:


An IEdmModel instance was found that failed validation


Anybody knows what is the problem and how I can fix it?

4 Replies
Highlighted
Solution

Hello @mhugo ,

As the metadata is view is failing it could be a configuration issue - potentially a duplicate property as described here: https://techcommunity.microsoft.com/t5/project-support-blog/project-online-and-odata-amp-8211-reserv...

Do you know which endpoint is failing in the Power BI report pack?

Paul

Highlighted

@mhugo 

 

I am using a workflow to create a project in project server 2013. This seems like a fairly common operation, but I need to set a few pieces of information when I create the project that are not available in the constructor.

Process Outline

for my own purposes I am using Chrome app DHC for creating these requests.

I use headers:

  Accept:       application/json;odata=verbose
  Content-Type: application/json;odata=verbose
  1. get the Context (X-RequestDigest):

    dev1projects/PWA/_api/contextinfo [POST empty body]
  2. Pick a Project:

    dev1projects/PWA/_api/ProjectServer/Projects?$Top=1
    [GET]
  3. Check out the project:

    dev1projects/PWA/_api/ProjectServer/Projects('theguidi-just-pick-from-theprojectabove')/checkOut()
    //Add Header X-RequestDigest:0xTheStringFromTheContextQuery(d/GetContextWebInformation/FormDigestValue)
    [POST empty body]
  4. Update the Draft item:

    dev1projects/PWA/_api/ProjectServer/Projects('projectid')/Draft/update()
    //Add Header X-RequestDigest:0xTheStringFromTheContextQuery(d/GetContextWebInformation/FormDigestValue)
    [POST]
    {"__metadata":{"type":"PS.DraftProject"},"Name":"Test 679"}
  5. Check In the Draft:

    dev1projects/PWA/_api/ProjectServer/Projects('theguidi-just-pick-from-theprojectabove')/Draft/checkIn()
    //Add Header X-RequestDigest:0xTheStringFromTheContextQuery(d/GetContextWebInformation/FormDigestValue)
    [POST empty body]
Highlighted
Thanks Paul! After a lot of troubleshooting, I found that we had a custom field called "Project#" - when I changed that to "Project Number" it resolved the issue!

Much appreciated.
Highlighted

Great to hear that you have this sorted @mhugo