DakStats Error USP_COMPETITIONS_EXTRA could not insert new records into COMPETITIONS_EXTRA table

Symptoms

  • DakStats Error USP_COMPETITIONS_EXTRA could not insert new records into COMPETITIONS_EXTRA table.
  • Slow DAO error in DakStats.
  • DakStats USP error.png

Environment

  • DakStats Web Sync

Cause

  • Possible causes are two games with same central ID

Resolution

  1. First you will need to Assign Team Code in Web-Sync. See page 1 and 2 of DakStats Web-Sync Setup Guide, ED-14571.pdf to assign team code.
  2. Next you will need to run Web-Sync to reassign all the games and update tables on server. ( For Baseball or Softball you will get prompted to select a game if you have double headers played. Make sure you select the correct time for each game as shown at the top of the window. ) 
  3. After this you should have a successful sync message.

KB ID: DD3611994


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.