Subquery returned more than 1 value

Subquery returned more than 1 value


Problem

When you attempt to run the Income Form Reports wizard, you get a long error message that starts with the following:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.


Solution

This error occurs because you have processed income forms for students that have multiple records in your RocketScan Student Database, but they all have the same student number. For example:



In this example a student appears in the student lookup table twice, but has different grade levels.


This problem must be corrected at the source before it can be fixed in RocketScan. First, remove the extraneous records from wherever your RocketScan is obtaining student information (usually a Point of Sale software) and then Refresh the RocketScan Student Database.


If the problem persists, contact Image One software support; additional steps may be required.


Image one software support will need access to your RocketScan server to troubleshoot this issue.




    • Related Articles

    • RocketScan Income Form Guide

      Welcome Welcome to RocketScan’s Income Form add-on! Image One’s RocketScan software has been a reliable scanning solution for processing family meal applications for almost 20 years. With our add-on, you may utilize RocketScan’s capabilities to ...

    • Considerations for utilizing collected income form data directly from RocketScan's database

      INFO: The application type discussed in this article is the Income Form, but it is also known as "LCFF form", "income survey", "alternative income form", "Community Eligibility Provision (CEP) form", "student education benefit form", "school benefit ...

    • Prerequisites for early collection of Income Surveys in RocketSCAN

      Introduction RocketSCAN by Image One is of the few – if not the only – data collection systems that allows for the collection of Income Form data prior to the release of the USDA’s National School Lunch Program Eligibility Guidelines. However: The ...

    • How to obtain your Income Form Report

      For more information on RocketScan’s Income Form add-on and its features, please see the RocketScan Income Form Guide. 1. Log in to RocketScan and launch the Admin module. 2. Click on the “Refresh Student Database” button and wait for it to complete ...

    • New in RocketSCAN 4.14

      New features and changes released in update packages for RocketSCAN version 4.14 are listed below. New Features Accelerated Validation for online forms There is a new User Preference option in Validation that reduces the tasks to only the student ...