Reg: Max transcations in transcations page

Ramanjaneyulu_Borusu · March 29, 2018, 3:19pm

Hello Experts,

We are working with wM912, under that we need all transactions should come under the transaction page in MWS.

We are unable to see the transactions and getting the error stated below:

9999:wm.tn.portal.queries:getQueryResults encountered execution error. Error encountered while fetching search results, page 3 requested is not found for queryId=TNPortalQueryResults_50022q00c9ot5p6n0000000r. Contact your administrator to optimize the configuration of the TNQueryResults cache.

Also,
we have specified two properties :

tn.db.fetchMaxRows=0 . It will fetch max number of records from DB and
tn.query.maxrows=-1 .

After these changes still, we are facing the issue and the error is " Read Timed Out error".
Thanks in advance.

Thanks,
Ram.

system · March 30, 2018, 4:49am

Please increase the Max elements in memory:

IS admin page → Settings → Caching → SoftwareAG.IS.TN —>TNQueryResults → Max elements in memory

Ramanjaneyulu_Borusu · March 30, 2018, 2:02pm

@Shahbaz Khan

Thank you for the suggestion I have done same what you have suggested.

Still getting the same error along with that Document types not showing after few pages in MWS.
Is there any property need to set for showing all docs or is it the problem with fetching documents from DB.

info: Sometimes It is showing all documents and sometimes getting the error like as “No results”
please suggest on this.

Attached the error image.

Thanks in advance.

Thanks,
ram.

Mahesh_K_Sreenivas · April 1, 2018, 1:50am

The suggested solution should fix your issue reported earlier. Try applying the latest fixes on TN Servers.

Ramanjaneyulu_Borusu · April 2, 2018, 11:01am

@Mahesh thank you for your suggestion.

we have applied latest fixes on TN i.e TNS_9.12_Fix7 9.12.0.0007-0054 previously.

Thanks,
Ram.