Tools
Rss Categories

Procedure or function procGet Payees error

Views: 680 Created: 2016-07-21 11:45 Last Updated: 2017-06-09 14:17

SYMPTOM

When opening Yearli one of the following errors is displayed:
"Cannot find stored procedure."
"BirthDate"
“Procedure or function procGet Payees has too many arguments specified”.

CAUSE

This usually occurs after a quarterly update is processed for Yearli. It will appear if the database updates were either not applied or applied incorrectly.

RESOLUTION

Procedure 1 (Reapply Database Updates)

Note: If Yearli is installed as a network, the following steps will need to be taken on the server machine.

  1. Disable any anti-virus or anti-spyware software.
  2. Navigate to C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli or Yearli Server\20XX*, where XX is the year, and locate the file called Versions or Versions.ini.
  3. Open the Versions.ini file in notepad.
  4. Change the line that says “PatchLevel= #” to “PatchLevel=-1”.
  5. Save and close the file.
  6. Open Yearli and apply the available updates. If on a network, double-click the online update icon on the server machine desktop.

*The file directory will differ depending on the version of the program. The file directories associated with each version of the program are:

  • WinFiler: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler or WinFiler Server
  • WinFiler Plus and Yearli 2014: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus or WinFiler Plus Server
  • Yearli: C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli or Yearli Server

APPLIES TO

  • WinFiler 2012 - 2013
  • WinFiler Plus 2013
  • Yearli 2014 - Current