error message

what you mean this message "error message - NO records matched the selection criteria"

"error message - NO records matched the selection criteria"

If its from Enquiry- Data inputting for selection is improper or records not available with the specified data(inputted)
If any routines attached check the coding once,within IF ELSE,LOOP conditions.

This error message (No records matched the selection criteria)appears if no records matched for Single File enquiry, however no-file enquiry (source code based), if no records fetched the system will show "NO RECORDS RETURNED BY ROUTINE BASED SELECTION"

also error in jsh "SSELECT: No such file or directory"

If i want choose any application like 'customer' or 'account' in t24 application
show messagae 'error message - NO records matched the selection criteria'
automatic also show messagae in jsh "No such file or directory"

Please i need solve for this problem

thnk

Altefish2000, copy output or attach screenprint of what you're attempting to perform and error message returned.

Hi I am having a nofile enquiry for Cash Balance Report, I also created an Enquiry Report record and attached that enquiry there.

When I run that Enquiry report directly through browser I am getting proper input but when the same is executed through EOD Batch process, a flat file is being created but it shows " No records returned from Routine based selection".

I understand that we get this error when the selection values are not passed properly but in my case, I am not sure where it goes wrong.

Please help with some ideas for me to pass through this error and to see actual enquiry report output data.

Thanks in Advance!

Hi
post here all relevant records: ENQUIRY.REPORT, ENQUIRY (first page); BATCH. Also - is it possible that at the time of COB the selection of your table is empty?

VK

P.S. Probably it was better to create a new topic than proceed with necroposting... :))

Vinoth wrote:

Hi I am having a nofile enquiry for Cash Balance Report, I also created an Enquiry Report record and attached that enquiry there.

When I run that Enquiry report directly through browser I am getting proper input but when the same is executed through EOD Batch process, a flat file is being created but it shows " No records returned from Routine based selection".

I understand that we get this error when the selection values are not passed properly but in my case, I am not sure where it goes wrong.

Please help with some ideas for me to pass through this error and to see actual enquiry report output data.

Thanks in Advance!

Possible cause was
1. Date was already changed 
2. File was already cleared 

There are live file (E.g TELLER and FUNDS.TRANSFER)  that was being cleared during cob in various stages.

Solution
1. Change the Batch stage of your report to A005
2. Change the source to ACCT.ENT.LWORK.DAY which contains entries from ACCT.ENT.TODAY and filter the application based on STMT Entries (E.g TT)

COB Stages:
A - Application
S - System Wide
R - Reporting
D - End of Day
O - Online

Ref:  t24ALL - ACCT.ENT.TODAY and ACCT.ENT.LWORK.DAY - Discussions
t24ALL - Clarify all stages in COB.MONITOR - Discussions