Error fetching select txyrparm 100

Receiving the message Error fetching select_txyrparm. 100 in a property tax billing program. 

• Property Tax Billing 
• Error fetching select_txyrparm. 100 
• Tax Year Settings 

There is no Tax Year Settings setup for the necessary year and category or the Tax Year Setting for the year and category is setup incorrectly. 

1. Many of the tax programs use either the Current Assessment Year or Current Collection Year defined in the Tax Settings program to determine which Tax Year Setting record to select. Determine which Tax Year Setting record the program is failing to select by determining what the Current Assessment Year or Current Collection Year are defined as in the Tax Settings program using the below guides: 
   1. Determine the Current Assessment Year in Tax Settings
   2. Determine the Current Collection Year in Tax Settings
2. If either the Current Assessment Year or Current Collection Year in Tax Settings needs to be updated, please see: 
   1. Change the Current Assessment Year in Tax Settings
   2. Change the Current Collection Year in Tax Settings
3. Once the appropriate year is determined, navigate to the Tax Year Settings program either by searching or using the following path: Property Revenues > Property Tax Billing > Region > State > Assessor Setup > Tax Year Settings
4. Click Search. 
5. Enter the Category and Year for the Tax Year Setting record that is failing to select. 
6. If no records return, copy an older Tax Year Setting record to the Current Assessment or Collection Year as needed or, if no older Tax Year Setting records exist, add a Tax Year Setting record using the guides below. 
   1. Copy or Duplicate a Tax Year Setting
   2. Add Tax Year Setting
7. If a record does return, make sure that it is setup correctly. Some frequent setup errors are outlined below. 

MA Tax:

Real Estate - Category 20: 

1. By design, MA sites only use one Category 20 Tax Year Setting for each year. Because of this, the programs select the Tax Year Setting for the year defined in Tax Settings, Category 20, and Cycle/Com 0. 
2. Navigate to the Tax Year Settings program either by searching or using the following path: Property Revenues > Property Tax Billing > Region > State > Assessor Setup > Tax Year Settings
3. Click Search. 
4. Enter the 20 as the Category and the Year for the Tax Year Setting record that is failing to select. 
5. Make sure there is a Tax Year Setting record for the year, Category 20, and Cycle/Com 0. 
6. If there is no Tax Year Setting record for year, Category 20, and Cycle/Com 0 copy an older Tax Year Setting record to the Current Assessment or Collection Year being sure to set the Cycle/Com to 0 or, if no older Tax Year Setting records exist, add a Tax Year Setting record using the guides below. 
   1. Copy or Duplicate a Tax Year Setting
   2. Add Tax Year Setting
7. If a Tax Year Setting record was created with a Cycle/Com other than 0 for Category 20, it is okay to just leave it in the database. It will not be used. Please be careful when copying Tax Year Settings for the next year to not copy this Tax Year Setting. 

Personal Property - Category 25: 

1. By design, MA sites only use one Category 25 Tax Year Setting for each year. Because of this, the programs select the Tax Year Setting for the year defined in Tax Settings, Category 20, and Cycle/Com 0. 
2. Navigate to the Tax Year Settings program either by searching or using the following path: Property Revenues > Property Tax Billing > Region > State > Assessor Setup > Tax Year Settings
3. Click Search. 
4. Enter the 25 as the Category and the Year for the Tax Year Setting record that is failing to select. 
5. Make sure there is a Tax Year Setting record for the year, Category 25, and Cycle/Com 0. 
6. If there is no Tax Year Setting record for year, Category 25, and Cycle/Com 0 copy an older Tax Year Setting record to the Current Assessment or Collection Year being sure to set the Cycle/Com to 0 or, if no older Tax Year Setting records exist, add a Tax Year Setting record using the guides below. 
   1. Copy or Duplicate a Tax Year Setting
   2. Add Tax Year Setting
7. If a Tax Year Setting record was created with a Cycle/Com other than 0 for Category 25, it is okay to just leave it in the database. It will not be used. Please be careful when copying Tax Year Settings for the next year to not copy this Tax Year Setting. 

If additional assistance is required, please contact tax support for the appropriate region.