Hi,
That may well be, but 11 is not a big number. Can you please try another set
of 11 records, and also 9 records overlapping record id 11 to make sure that
it is not related to a specific record?
Best Regards - Misi, RRR AB, http://rrr.se
> Well, the report runs fine with 11+ records when called through the User Tool,
> so I am thinking it's a mid-tier related issue now. Perhaps hitting a
> memory/cache limit?
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Wednesday, February 10, 2016 11:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Selecting more than 10 records in MT report error
>
> Hi,
>
> My guess would be that it is a specific record that is the problem, rather
> than the number of records. Can you check that out?
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> Okay, here's something I want to see if anyone else has come across.
>> When a user selects 10 records in Mid-Tier, clicks the 'report' button
>> and selects a predefined Crystal Report, the report displays all ten records
>> without issue.
>>
>> When they select 11+, the report, displays with the following error:
>>
>> This field name is not known. Details: errorKind Error in File
>> BillingSiteProfileINSTALLATION111213v2008
>> {80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula
>> Record_Selection:
>> '({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")'
>> This field name is not known. Details: errorKind
>>
>> Any ideas why this happens? I have refreshed the report, verified the DB,
>> etc.
>> Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7.
>>
>> Keith Sinclair
>> Remedy Development
>> ShopperTrak Chicago, USA
>> O 312.676.8289
>> ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> |
>> shoppertrak.com Retail Profitability, Improved.
>>
>>
>> ______________________________________________________________________
>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
> Are, and have been for 20 years"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
