+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / CMS DB Invalids

CMS DB Invalids

10 posts, 0 answered
  1. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    03 Dec 2010
    Link to this post
    Hi

    We are getting few invalids in the CMS database when we moved the db to differnt server. Does this db procedures suppose to create empty tables why?

    Owner                     Object Name                     Object Type

    .

    CMSCORP           SF_ACTIONSTRACKER_UPD                       PROCEDURE

    CMSCORP                 SF_LOC_ITEM_UPD                       PROCEDURE

    CMSCORP    SF_NOTIF_GROUPNEWSLETTER_UPD                       PROCEDURE

    CMSCORP     SF_NOTIF_RECIPIENTGROUP_UPD                       PROCEDURE

    CMSCORP      SF_NOTIF_RECIPIENTROLE_UPD                       PROCEDURE

    CMSCORP             SF_READCOMMENTS_UPD                       PROCEDURE

    CMSCORP        TELERIK_USERSINROLES_UPD                       PROCEDURE

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    03 Dec 2010
    Link to this post
    Hi VIJAIANAND,

    These stored procedures are created by our datalayer and tables like UsersInRoles cannot have empty data, because you have at least one user in one role and this is the "admin" user.

    Regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    03 Dec 2010
    Link to this post
    But we use Activedirectory for login and don't use CMS. In that case being empty is ok right?

    Vijai
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    03 Dec 2010
    Link to this post
    Hi VIJAIANAND,

    If you use AD these tables are not used, because Sitefinity is just an acceptor of AD. The other tables are related to newsletters module and workflow.

    Regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    03 Dec 2010
    Link to this post
    ok. if we don't use these funcationalities at this point and the tables are created with empty skeleton throwing error as invalid. Any suggestion or can we just populate with some empty values?
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    03 Dec 2010
    Link to this post
    Hello VIJAIANAND,

    When you create a new project the tables are also empty, so I am not sure why you get this error. Probably you have made some other changes. Also the database tables should not be touched.  As I mentioned  I am not sure how you got an error for empty data when UsersInRoles could not have empty data. There should be a record for the admin user.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  7. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    03 Dec 2010
    Link to this post
    Ivan,

    Its not the table which is creating problems. These Storoed procedures are tagged by oracle 10g as invalids because they don't have anything in the body. They only have create statement with begin and end and because of that reason its tagging them as invalids. Is it expected by oracle or can be fixed by just putting null inthe body.

    Vijai
  8. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    03 Dec 2010
    Link to this post
    Ivan,

    This one of the stopping block for us to move on to testing and getting approved by management to purchase the product. Please reply with your answer asap.

    Vijai
  9. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    07 Dec 2010
    Link to this post
    Hello VIJAIANAND,


    Database procedures are created by the ORM which we use for database access - Nolics.NET. The ORM creates stored procedures of all CRUD operations for each table. The procedures which are failing to recompile are empty - they do nothing and are never called. Those procedures are created for tables which describe many to many relationships. I am afraid that there is not much that can be done in the case. You can edit the stored procedures - put some SQL which does nothing and recompile them. However next time you upgrade your website the stored procedures will be rewritten by the ORM to match the latest version.

    All the best,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  10. Vijaianand
    Vijaianand avatar
    94 posts
    Registered:
    09 Jul 2012
    07 Dec 2010
    Link to this post
    That makes sense. I will let my dba team know about it and make the changes if neccessary.
Register for webinar
10 posts, 0 answered