03-21-2024 06:00 AM - edited 03-21-2024 06:23 AM
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,
03-21-2024 06:12 AM
I would probably raise a TAC case for this. Your call looks fine and shouldn't cause the server to return a 500.
03-21-2024 06:45 AM
If you are trying to get a list, that sounds list this should be an HTTP GET instead of an HTTP POST.
03-21-2024 07:03 AM
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?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide