I don't know... It seems to come from the WebService-call.
I apparently missed to attached the plugin-log to the first email, and
only attached the API/SQL/FLTR-log...
I have now attached both logs.
Thank you for the help so far.
Best Regards - Misi, RRR AB, http://rrr.se
> Two instances where I have seen that message before is with row level
> security (they lose permissions right after a save) and doing a get record
> where the status history record is missing.
>
> I just looked at your log and it seems that theory two seems very likely.
> Notice there is a query to the H table right before the error. The newer
> versions handle missing status history data better than older ones
> (probably
> because it is now optional). In older versions (pre 7.1/7.5? Basically
> before SH was optional) the client would throw the error you are seeing
> and
> the record would be inaccessible.
>
> Jason
> On Oct 30, 2010 3:47 AM, "Misi Mladoniczky" <[email protected]> wrote:
>> Hi,
>>
>> Well, if you make a query that does not return anything, you should get
>> an
>> ARWARN 1200 (no matching request), not an ARERR 302, which would
>> indicate
>> that the system expects a record that is not there...
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> Hi Misi,
>>>
>>> I am not really sure about version incompatibility, so if that's true
> then
>>> you can ignore my below reply. :)
>>>
>>> This error message corresponds to "No matching request found" as what
>>> we
>>> see on User tool when a certain qualification does not return any
> records.
>>>
>>> So, I think, 2 things are possible here
>>> a) Web-service client is passing a qualification for which there are no
>>> records returned.
>>> b) The Set Fields actions #1 is using a qualification in its "Set
>>> Fields"
>>> that is not returning any records back (What is value set for "No
> requests
>>> match:- Set fields to $NULL$ or "Display no match error"?). If its set
>>> to
>>> "Display No Match" error then there is a possibility of ARERR 302 being
>>> thrown to client.
>>>
>>> Thanks
>>> Chintan.
>>>
>>> --- On Fri, 10/29/10, Misi Mladoniczky <[email protected]> wrote:
>>>
>>> From: Misi Mladoniczky <[email protected]>
>>> Subject: ARServer to ARServer WebService
>>> To: [email protected]
>>> Date: Friday, October 29, 2010, 6:13 AM
>>>
>>> Hi,
>>>
>>> One of my customers gets the following error when calling a WebService
>>> from ARServer 7.0.1 patch patch005/patch011 to an 7.1.0 patch???
>>>
>>> ARERR [9130] An exception occurred from the WebService class : ERROR
>>> (302): Entry does not exist in database;
>>>
>>> I recall to have seen something similar before, and that it had to do
> with
>>> version incompatibility in the ARSystem...
>>>
>>> Can anyone shed any light on this, or give suggestions?
>>>
>>> I have attached a small API/FLTR/ECSL-log as well as the Plugin-log.
>>>
>>> So which entry are we talking about here???
>>>
>>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>>
>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>>> logs.
>>> Find these products, and many free tools and utilities, at
>>> http://rrr.se.
>>>
>>>
> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>
>>>
>>>
>>>
> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>
>>
>>
> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<PLGN> <...> /* to sep 30 2010 11:50:35.7575 */+CALL ARFilterApiCall -- filter API ARSYS.ARF.WEBSERVICE
<PLGN> <...> /* to sep 30 2010 11:50:35.7699 */<> <FINE> soapService = WS_tabascoService
<PLGN> <...> /* to sep 30 2010 11:50:35.7700 */<> <FINE> soapMethod = GetList
<PLGN> <...> /* to sep 30 2010 11:50:35.7701 */<> <FINE> soapURL = http://itsm7up/arsys/services/ARService?server=itsm7app&webService=WS_tabasco
<PLGN> <...> /* to sep 30 2010 11:50:35.7702 */<> <FINE> soapNamespace = urn:WS_tabasco
<PLGN> <...> /* to sep 30 2010 11:50:35.7710 */<> <FINE> soapInputDocument = <ns0:ROOT xmlns:ns0="urn:WS_tabascoService" xmlns:ns1="urn:WS_tabasco" xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<ns0:SOAPHeader>
<ns1:AuthenticationInfo>
<ns1:userName>WS_TABASCO</ns1:userName>
<ns1:password>****</ns1:password>
<ns1:authentication/>
<ns1:locale/>
<ns1:timeZone/>
</ns1:AuthenticationInfo>
</ns0:SOAPHeader>
<ns1:Region>Nordic</ns1:Region>
</ns0:ROOT>
<PLGN> <...> /* to sep 30 2010 11:50:35.7712 */<> <FINE> soapOperationDoc = <?xml version="1.0" encoding="windows-1252"?>
<operation name="GetList" type="create" useStyle="literal" bindingStyle="document" soapActionURI="urn:WS_tabasco/GetList">
<inputMapping name="GetList" topLevelElement="GetList"/><Client-RPC: 390695> /* to sep 30 2010 11:50:36.1136 */<> <FINE> ERROR (302): Entry
does not exist in database;
<PLGN> <...> /* to sep 30 2010 11:50:36.1198 */-CALL FAIL
<API > <...> /* to sep 30 2010 11:50:35.7406 */+SE ARSetEntry -- schema ITSM7:INVOICE:Main entryId 000000000000092 from Remedy User (protocol 12) at IP address 151.156.16.143
<FLTR> <...> /* to sep 30 2010 11:50:35.7409 */Start filter processing -- Operation - SET
<FLTR> <...> ITSM7:INVOICE:Main - 000000000000092
<FLTR> <...> Checking ITSM7:INVOICE:MAIN:500:Get Data (500)
<SQL > <...> /* to sep 30 2010 11:50:35.7410 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0 FROM T494 WHERE C1 = '000000000000092'
<SQL > <...> /* to sep 30 2010 11:50:35.7426 */OK
<SQL > <...> /* to sep 30 2010 11:50:35.7427 */SELECT entryId,T0,U0,T1,U1,T2,U2 FROM H494 WHERE entryId = '000000000000092'
<SQL > <...> /* to sep 30 2010 11:50:35.7436 */OK
<FLTR> <...> --> Passed -- perform actions
<FLTR> <...> 0: Set Fields
<FLTR> <...> Region (536871186) = Nordic
<FLTR> <...> WS Login (536871187) = WS_TABASCO
<FLTR> <...> WS Password (536871188) = WS_TABASCO
<FLTR> <...> 1: Set Fields
<SQL > <...> /* to sep 30 2010 11:50:35.7517 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0 FROM T494 WHERE C1 = '000000000000092'
<SQL > <...> /* to sep 30 2010 11:50:35.7527 */OK
<SQL > <...> /* to sep 30 2010 11:50:35.7528 */SELECT entryId,T0,U0,T1,U1,T2,U2 FROM H494 WHERE entryId = '000000000000092'
<SQL > <...> /* to sep 30 2010 11:50:35.7536 */OK
<FLTR> <...> An exception occurred from the WebService class
<FLTR> <...> ERROR (302): Entry does not exist in database;
<FLTR> <...> **** Error while performing filter action
<FLTR> <...> /* to sep 30 2010 11:50:36.1201 */ End of filter processing (phase 1)
<SQL > <...> /* to sep 30 2010 11:50:36.1201 */COMMIT WORK
<API > <...> /* to sep 30 2010 11:50:36.1207 */-SE FAIL
