added 16 characters in body
Source Link
Nickoli Roussakov
  • 18.4k
  • 4
  • 28
  • 62

The stored procedure SP_PUBLICATIONS_FIND_CONFLICTS is actually part of the Audience Manager feature. When we ran the Tridion 2013 SP1 installer, we left it checked. For some reason this stored proc has an invalid object and as a result does not compile. The Tridion Core Service makes a call to this procedure when saving a Publication and since it couldn't compile an error was thrown.

To work around the issue, we have re-ran the Tridion CM installer and unchecked Audience Manager to uninstall it. Once this was completed and the CM server got restarted, new Publications can now be saved.

As to why some of the stored procs in the Audience Manager database could not compile, that's a ticket forwe're reaching out to Support for help here.

The stored procedure SP_PUBLICATIONS_FIND_CONFLICTS is actually part of the Audience Manager feature. When we ran the Tridion 2013 SP1 installer, we left it checked. For some reason this stored proc has an invalid object and as a result does not compile. The Tridion Core Service makes a call to this procedure when saving a Publication and since it couldn't compile an error was thrown.

To work around the issue, we have re-ran the Tridion CM installer and unchecked Audience Manager to uninstall it. Once this was completed and the CM server got restarted, new Publications can now be saved.

As to why some of the stored procs in the Audience Manager database could not compile, that's a ticket for Support.

The stored procedure SP_PUBLICATIONS_FIND_CONFLICTS is actually part of the Audience Manager feature. When we ran the Tridion 2013 SP1 installer, we left it checked. For some reason this stored proc has an invalid object and as a result does not compile. The Tridion Core Service makes a call to this procedure when saving a Publication and since it couldn't compile an error was thrown.

To work around the issue, we have re-ran the Tridion CM installer and unchecked Audience Manager to uninstall it. Once this was completed and the CM server got restarted, new Publications can now be saved.

As to why some of the stored procs in the Audience Manager database could not compile, we're reaching out to Support for help here.

Source Link
Nickoli Roussakov
  • 18.4k
  • 4
  • 28
  • 62

The stored procedure SP_PUBLICATIONS_FIND_CONFLICTS is actually part of the Audience Manager feature. When we ran the Tridion 2013 SP1 installer, we left it checked. For some reason this stored proc has an invalid object and as a result does not compile. The Tridion Core Service makes a call to this procedure when saving a Publication and since it couldn't compile an error was thrown.

To work around the issue, we have re-ran the Tridion CM installer and unchecked Audience Manager to uninstall it. Once this was completed and the CM server got restarted, new Publications can now be saved.

As to why some of the stored procs in the Audience Manager database could not compile, that's a ticket for Support.