Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in

View / Stored Procedures / Functions - Could not be parsed message.

Last post 07-02-2009, 4:50 PM by admin. 1 replies.
Sort Posts: Previous Next
  •  07-02-2009, 4:17 PM 1257

    View / Stored Procedures / Functions - Could not be parsed message.

    Hello,

     When I do a reverse engineering on a SQL Server 2008 DB, I have a bunch of Views/Sprocs/Functions that I get a warning about not being able to parse.  (I've pasted below).  What does that mean and is there a way I can get rid of them?

    Warning: View dbo.Answers could not be parsed.
    Warning: View dbo.vAdEntcore could not be parsed.
    Warning: View dbo.vStringsMain could not be parsed.
    Warning: View dbo.vForumThreadPostInfo could not be parsed.
    Warning: View dbo.vDownloadEntities could not be parsed.
    Warning: View dbo.vStrings could not be parsed.
    Warning: View dbo.Field_Answer could not be parsed.
    Warning: View dbo.Entcore could not be parsed.
    Warning: Procedure dbo.spReadMessages could not be parsed.
    Warning: Procedure dbo.spDeleteMessages could not be parsed.
    Warning: Procedure dbo.spLoadEntities could not be parsed.
    Warning: Procedure dbo.sp_helpdiagrams could not be parsed.
    Warning: Procedure dbo.sp_helpdiagramdefinition could not be parsed.
    Warning: Procedure dbo.sp_creatediagram could not be parsed.
    Warning: Procedure dbo.sp_alterdiagram could not be parsed.
    Warning: Procedure dbo.uspDeleteEntities could not be parsed.
    Warning: Procedure dbo.spDeleteContacts could not be parsed.
    Warning: Procedure dbo.uspAdSearch could not be parsed.
    Warning: Procedure dbo.spAdvancedSearch4 could not be parsed.
    Warning: Procedure dbo.spNewMessage could not be parsed.
    Warning: Procedure dbo.spAdvancedSearch3 could not be parsed.
    Warning: Procedure dbo.usp_SaveEntityAnswersFlat could not be parsed.
    Warning: Function dbo.udf_AdSmartTagSearch could not be parsed.
    Warning: Function dbo.udf_AdTargetedSearch could not be parsed.
    Warning: Function dbo.udfSplitString could not be parsed.
    Warning: Function dbo.udf_GetTagId_FromString could not be parsed.

    Thank you,

     Bill

  •  07-02-2009, 4:50 PM 1259 in reply to 1257

    Re: View / Stored Procedures / Functions - Could not be parsed message.

    That is a relatively minor issue.  It just means that either we could not parse the view or we could not represent it (if it has a join clause - we will post a post 3.5 build with better join clause support).  The view will still be represented in the model, but with not as much structure.  i.e. it is basically a block of text.  MR will still generate and compare it though.  If you can send us the views, etc... we can give you a more specific answer.
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742