Re: Internal error when trying to get a list of Team Members

AaronGlabman6027 · ‎03-21-2024

Does anyone have an idea how to solve this Internal error?

I am making a call to the CCMP API using the following request body:

POST /ResourceManagement HTTP/1.1

<soap:Envelope xmlns:res="http://www.exony.com/schemas/2009/10/resourcemanagement" xmlns:soap="http://www.w3.org/2003/05/soap-envelope"><soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"><wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><wsse:UsernameToken wsu:id="2N"><wsse:Username>xxxxxxx</wsse:Username><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">xxxxxxx</wsse:Password></wsse:UsernameToken></wsse:Security><wsa:Action>Search</wsa:Action><wsa:MessageID>uuid:6DE21FD7-EEE9-42B7-8525-C3E7CACEFB9F</wsa:MessageID><wsa:To>https://xxxx:8085/ResourceManagement</wsa:To></soap:Header><soap:Body><res:Search><res:queryString>type:MT_AGENT_AGENT_TEAM_MEMBER latest:1 deleted:0 property:PhysicalMember=true sort:DisplayName,ASC max:5000 offset:0</res:queryString><res:excludeFilter></res:excludeFilter></res:Search></soap:Body></soap:Envelope> Sent 1112 bytes in 382.335 mS: <soap:Envelope xmlns:res="http://www.exony.com/schemas/2009/10/resourcemanagement" xmlns:soap="http://www.w3.org/2003/05/soap-envelope"> <soap:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"> <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"> <wsse:UsernameToken wsu:id="2N"> <wsse:Username>2nAdmin</wsse:Username> <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">******</wsse:Password> </wsse:UsernameToken> </wsse:Security> <wsa:Action>Search</wsa:Action> <wsa:MessageID>uuid:6DE21FD7-EEE9-42B7-8525-C3E7CACEFB9F</wsa:MessageID> <wsa:To>https://xxxx:8085/ResourceManagement</wsa:To> </soap:Header> <soap:Body> <res:Search> <res:queryString>type:MT_AGENT_AGENT_TEAM_MEMBER latest:1 deleted:0 property:PhysicalMember=true sort:DisplayName,ASC max:5000 offset:0</res:queryString> <res:excludeFilter> </res:excludeFilter> </res:Search> </soap:Body> </soap:Envelope>

Response Header:

HTTP/1.1 500 Internal Server Error Date: Fri, 05 Jan 2024 01:47:54 GMT Content-Length: 1513 Content-Type: multipart/related; type="application/xop+xml";start="<http://tempuri.org/0>";boundary="uuid:7e866f92-04c2-446d-abca-637cb813e170+id=625";start-info="application/soap+xml" Server: Microsoft-HTTPAPI/2.0 MIME-Version: 1.0

Received 1513 bytes in 0.088 mS:

--uuid:7e866f92-04c2-446d-abca-637cb813e170+id=625 Content-ID: <http://tempuri.org/0>Content-Transfer-Encoding: 8bit Content-Type: application/xop+xml;charset=utf-8;type="application/soap+xml" <s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"> <s:Header> <a:Action s:mustUnderstand="1">http://www.w3.org/2005/08/addressing/soap/fault</a:Action> <a:RelatesTo>uuid:6DE21FD7-EEE9-42B7-8525-C3E7CACEFB9F</a:RelatesTo> <o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"> <u:Timestamp u:Id="_0"> <u:Created>2024-01-05T01:47:54.370Z</u:Created> <u:Expires>2024-01-05T01:52:54.370Z</u:Expires> </u:Timestamp> </o:Security> </s:Header> <s:Body> <s:Fault> <s:Code> <s:Value>s:Receiver</s:Value> <s:Subcode> <s:Value xmlns:a="http://schemas.microsoft.com/2009/WebFault">a:InternalServerError</s:Value> </s:Subcode> </s:Code> <s:Reason> <s:Text xml:lang="en-US">Internal Server Error</s:Text> </s:Reason> <s:Detail> <ResourceFaultDetail xmlns="http://www.exony.com/schemas/2009/10/resourcemanagement" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <ErrorCode>1</ErrorCode> <ErrorType>System</ErrorType> <Message>An internal error has occured. Check the logs for more information.</Message> </ResourceFaultDetail> </s:Detail> </s:Fault> </s:Body> </s:Envelope>--uuid:7e866f92-04c2-446d-abca-637cb813e170+id=625-- An internal error has occured. Check the logs for more information.

I discovered the following error in the most recent Application Server.2024-02-08.0.log:

2024-02-08 20:07:02,239 ERROR [55 ] Application.DataCommand Exception: SearchResourcesCommand( originalQuery = type:MT_AGENT_AGENT_TEAM_MEMBER latest:1 deleted:0 property:PhysicalMember=true sort:DisplayName,ASC max:5000 offset:0 transaction = False) Exception: System.AggregateException

Message: One or more errors occurred.

Source: System.Core

at System.Linq.Parallel.QueryTaskGroupState.QueryEnd(Boolean userInitiatedDispose)

at System.Linq.Parallel.OrderPreservingPipeliningMergeHelper`2.OrderedPipeliningMergeEnumerator.ThrowIfInTearDown()

at System.Linq.Parallel.OrderPreservingPipeliningMergeHelper`2.OrderedPipeliningMergeEnumerator.MoveNext()

at System.Linq.Parallel.QueryOpeningEnumerator`1.MoveNext()

at System.Linq.Buffer`1..ctor(IEnumerable`1 source)

at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__1.MoveNext()

at System.Linq.Enumerable.<TakeIterator>d__25`1.MoveNext()

at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

at System.Linq.Buffer`1..ctor(IEnumerable`1 source)

at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)

at Exony.Reporting.Application.Management.Commands.SearchResourcesCommand.ExecuteSearchQuery() in T:\Streams\C12_6_1\App\Exony.Reporting.Application.ResourceManagement\Commands\SearchResourcesCommand.cs:line 143

at Exony.Reporting.Application.Management.Commands.SearchResourcesCommand.ExecuteSearchCommand() in T:\Streams\C12_6_1\App\Exony.Reporting.Application.ResourceManagement\Commands\SearchResourcesCommand.cs:line 115

at Exony.Reporting.Application.Search.SearchDataCommand.ExecuteCommand() in T:\Streams\C12_6_1\App\Exony.Reporting.Application\Search\SearchDataCommand.cs:line 98

at Exony.Reporting.Application.DataCommand.ExecuteMethodWithRetries(DatabaseMethod method, Boolean allowTransaction, Exception& exception) in T:\Streams\C12_6_1\App\Exony.Reporting.Application\DataCommandExecution.cs:line 149

Nested Exception

Exception: System.Exception

Message: Failed to locate resource: Agent Team, -1

Source: Exony.Data.Search

at Exony.Data.Search.Resources.Security.BaseResourceSecurity.FindResource(ResourceType resourceType, Object id, IResourceSecurityContext context) in T:\Streams\C12_6_1\App\Caching\SearchRuntime\Resources\Security\BaseResourceSecurity.cs:line 331

at Exony.Data.Search.Resources.Security.MemberResourceSecurity.GetLatestParentResource(Resource member, IResourceSecurityContext context) in T:\Streams\C12_6_1\App\Caching\SearchRuntime\Resources\Security\MemberResourceSecurity.cs:line 168

at Exony.Data.Search.Resources.Security.MemberResourceSecurity.CheckParentAccess(Resource& parent, Resource member, ResourceSecurityAccessType accessType, IResourceSecurityContext context) in T:\Streams\C12_6_1\App\Caching\SearchRuntime\Resources\Security\MemberResourceSecurity.cs:line 205

at Exony.Data.Search.Resources.Security.Types.AgentAgentTeamMemberSecurity.CanViewInternal(Resource resource, IResourceSecurityContext context) in T:\Streams\C12_6_1\App\Caching\SearchRuntime\Resources\Security\Types\AgentAgentTeamMemberSecurity.g.cs:line 160

at Exony.Data.Search.Security.GatekeeperSearchSecurity.<>c__DisplayClass10_0.<FilterVisibleResources>b__0(CacheEntry resource) in T:\Streams\C12_6_1\App\Caching\SearchRuntime\Security\GatekeeperSearchSecurity.cs:line 85

at System.Linq.Parallel.SelectQueryOperator`2.SelectQueryOperatorEnumerator`1.MoveNext(TOutput& currentElement, TKey& currentKey)

at System.Linq.Parallel.WhereQueryOperator`1.WhereQueryOperatorEnumerator`1.MoveNext(TInputOutput& currentElement, TKey& currentKey)

at System.Linq.Parallel.SelectQueryOperator`2.SelectQueryOperatorEnumerator`1.MoveNext(TOutput& currentElement, TKey& currentKey)

at System.Linq.Parallel.OrderPreservingPipeliningSpoolingTask`2.SpoolingWork()

at System.Linq.Parallel.SpoolingTaskBase.Work()

at System.Linq.Parallel.QueryTask.BaseWork(Object unused)

at System.Threading.Tasks.Task.Execute()

I have been trying to determine which Agent Member is referencing a Team Id = -1 and am not finding anything.

Any help of suggestions are welcomed.

Thank you,

Torbjørn · ‎03-21-2024

I would probably raise a TAC case for this. Your call looks fine and shouldn't cause the server to return a 500.

Happy to help! Please mark as helpful/solution if applicable.
Get in touch: https://torbjorn.dev

Elliot Dierksen · ‎03-21-2024

If you are trying to get a list, that sounds list this should be an HTTP GET instead of an HTTP POST.

AaronGlabman6027 · ‎03-21-2024

The call works in most test cases. Something unknown happened in this specific environment to cause this error. DB Integrity appears the most likely, but it is unclear. For example, if the table AGENT_AGENT_TEAM_MEMBER contains a PARENT_ITEM_BIZ_URN that does not exist in AGENT_TEAM.

The error Failed to locate resource: Agent Team, -1 leads me to believe that a value of -1 in the field PARENT_ITEM_BIZ_URN in the AGENT_AGENT_TEAM_MEMBER table does not exist in the ITEM_URN field of the AGENT_TEAM table.

I do see some default entries that contain a URN = -1, but nothing to lead me to believe this would be a problem as they are consistent in both source tables and the aggregate relation table.

Does anyone have a contact for the team that wrote CCMP? Does exony still exist? A forum where I can find more information on the error Failed to locate resource: Agent Team, -1?