Forum Discussion

FreKac2's avatar
FreKac2
Level 6
14 years ago

EV10 upgrade, missing stored procedure?

Hi all,

 

Just did an upgrade to EV10 and when starting the Storage Service the Migrator Server complained that the uspx_savesetitems stored procedure was missing (event ids 13360 and 6796).

I checked the programmability folder in the database and the stored procedure is there.

Before doing the the EV10 upgrade we ran through the collation change procedures including dropping the stored procedures (as per the tech note) and then re-adding them after the change.

And again the stored procedure is there.

EV states that the VS database and fingerprint database was upgraded successfully and when restarting the storage service there is no error events anymore.

But, is there any way to confirm that everything is as it should since we did get those events after the upgrade?

It's a single server/VS installation.

  • well its there defined in the schema, so maybe it was a caching thing? if you dont get anymore errors I would'nt worry about it.

  • mmm bit odd execute this on *each* of your VS databases.

     

    select *
    from INFORMATION_SCHEMA.ROUTINES
    where ROUTINE_NAME = 'uspx_savesetitems'

  • well its there defined in the schema, so maybe it was a caching thing? if you dont get anymore errors I would'nt worry about it.

  • Thanks Nathan, will check the next couple of days and see if anything pops up.