The stored procedure 'EDA_TRUSTEES_GETTRUSTEETOKEN_X' doesn't exist

Question

After restoring the Content Manager database of our SDL Web 8.5 CME I get the following error:

The stored procedure 'EDA_TRUSTEES_GETTRUSTEETOKEN_82' doesn't exist.

I added the user to the TRUSTEE table but I am still getting this error.

Any suggestions on how to fix this error?

I installed: Hofix CM_8.5.0.10663, but still getting the same error.

Peter - sounds like you’re missing a hitfix perhaps.? Have you checked? — Dylan .. Mark Saunders, Commented Mar 22, 2019 at 19:54
Hi @Dylan..MarkSaunders, I will check. Do you have any advice to which HotFix this might be related? — Peter van der Lugt, Commented Mar 25, 2019 at 7:23
_82 - seems it's introduced in version 8.2, How come this missed for you in your 8.5 DB, either your upgrade script something went wrong during your upgrade, I would recommend raising this to SDL support? — Velmurugan, Commented Mar 25, 2019 at 10:27
@Velmurugan, we upgraded from SDL 2013 SP1 to SDL Web 8.5. I also raised a ticket at SDL. — Peter van der Lugt, Commented Mar 25, 2019 at 10:57

Peter van der Lugt · Accepted Answer · 2019-03-25 15:12:16Z

1

We requested a copy of the Content Management DB, but our hosting supplier delivered a copy of the old 2013 SP1 installation.

So this error happens when you restore a 2013 SP1 database in your SDL Web 8.5 CME...

answered Mar 25, 2019 at 15:12

1,3238 silver badges18 bronze badges

We got the same error after running the upgrade script (also from 2013 SP1 to 8.5) with integrated security. As a result, schema of the created stored procedures wasn't 'dbo' but user which ran the scripts and that's why stored procedures were reported to be missing. I'm still not sure whether this was caused by a bug in the script of insufficient db permissions.
– lajavko
Commented Jun 10, 2019 at 12:20

Add a comment |

1 Answer 1