Hi Justin,

In the Patch 6 notes there is mention of recreating some stored procedures. This may have come in with the Hotfix for Patch 5. so maybe was a missed step in the Hotfix, or not in its documentation. Or, it could have just been missed in the non-prop environment. The details are:

Content Manager stored procedures
You must install the following stored procedures as part of the patch upgrade process:
Order of stored procedure to be installed:
1. tsAclOthersCheck
2. tsAclRTAndFPCheck
3. tsAclRecordCheck
4. tsAclWorkflowCheck
5. tsAclCheck
6. tsAclStoreCheck
To manually install the stored procedure, perform the following steps:
1. In the Content Manager Enterprise Studio, right-click on the dataset where you want to install the
stored procedure.
2. Navigate to Schema > Manage. The Schema Manager dialog is displayed.
3. In the left pane, expand Procedures and scroll down.
4. Select the tsAclOthersCheck stored procedures, right-click > Check and then Recreate.
5. Repeat step 4 for all the stored procedures mentioned above.
6. Once all the stored procedures are recreated, click Close to exit out of Schema Manager

Cheers,

Mike.

Thanks for the reply Mike Leydon , this does seem to be the issue.  I ran a check on those procedures and they produce an error stating they don't exist.

When going into the Schema Manager, it states that all activity needs to be halted before proceeding.  We have 3 environments.  We also have 2 servers (Workgroup and Event Processing).  Do I need to stop anything before recreating these?

I generally don't bother shutting anything down, when you go into the Schema manager, it will mark the database as unavailable for the duration. Just make sure you don't run it on the PROD dataset as users may get upset...

Each dataset has its own set of stored procedures, they are not shared between all datasets.

Cheers

Awesome, thanks Mike Leydon .  I recreated those procedures and was able to successfully register a record!