locked
Deleting 5000 PubMed fields from Zentity. Exception. RRS feed

  • Question

    1. I fetched 5000 fileds.
    2. Added them to Zentity.

    When I decided to go to the next step I found that I can't get, I can't delete data.

    ************** Exception Text **************
    System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
       --- End of inner exception stack trace ---
       at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
       at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
       at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Objects.DataClasses.EntityCollection`1.Load(List`1 collection, MergeOption mergeOption)
       at ZentityDataImport.BaseForm.ButtonDeleteData_Click(Object sender, EventArgs e) in C:\Program Files (x86)\Zentity\Samples\ZentityDataImport\BaseForm.cs:line 283
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     

    Tuesday, November 1, 2011 8:51 AM

Answers

  • This (Server Error in '/WebUI' Application) one seems to be a bug in the Zentity 2.1. Actually, I am currently looking into this issue. Update you once a proper fix is found.

    -Thanks

    • Marked as answer by ItSurfer Friday, November 4, 2011 11:44 AM
    Friday, November 4, 2011 11:13 AM

All replies

  • What is the best way to fix it?

    Tuesday, November 1, 2011 8:52 AM
  • I guess the data might be in use when you are trying to delete. 5000 entities will take time to get processed and create deep zoom images.

    Please let us know if you are still facing this issue.

    Wednesday, November 2, 2011 9:29 AM
  • It works fine. I just have to wait some time 5-8 mins.

    But I still don't understand why I can't surf throw all shells of data.

    F.e. DashBoard PersonA -> Explorer NewTxt -> Any PersonB. And so on.

     

    When I start doing it there is an item which doesn't have a result in Explorer just "Not found message". 

    Do I do everything in a proper way?

    Wednesday, November 2, 2011 4:59 PM
  • This (F.e. DashBoard PersonA -> Explorer NewTxt -> Any PersonB. And so on) should be working. If it is not can you provide us the error message you are getting.

    One more thing, On your local installation go the web.congig file of all websites (Run inetmgr -> Zentity 2.0 -> right click the website(for example, visual explorer) -> Explore.

    In the respective web.config file for the website change the custom error mode to off as shown below.

    <customErrors defaultRedirect="Error.htm" mode="Off">
    			<error statusCode="404" redirect="Error.aspx?Error=PageNotFound"/>
    			<error statusCode="408" redirect="Error.aspx?Error=Timeout"/>
    		</customErrors>
    

    This will help you to get the exact error and details which would be much helpful to track the bug. Also, start the service "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" if it is not started. To start it run -> services.msc, choose the above sql full text launcher and start.

     

    Please let us know if the error exists with the error details.

    Thursday, November 3, 2011 12:32 PM
  • This (F.e. DashBoard PersonA -> Explorer NewTxt -> Any PersonB. And so on) should be working. If it is not can you provide us the error message you are getting.

    One more thing, On your local installation go the web.congig file of all websites (Run inetmgr -> Zentity 2.0 -> right click the website(for example, visual explorer) -> Explore.

    In the respective web.config file for the website change the custom error mode to off as shown below.

    <customErrors defaultRedirect="Error.htm" mode="Off">
    			<error statusCode="404" redirect="Error.aspx?Error=PageNotFound"/>
    			<error statusCode="408" redirect="Error.aspx?Error=Timeout"/>
    		</customErrors>
    

    This will help you to get the exact error and details which would be much helpful to track the bug. Also, start the service "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" if it is not started. To start it run -> services.msc, choose the above sql full text launcher and start.

     

    Please let us know if the error exists with the error details.

    Server Error in '/WebUI' Application.

    Value cannot be null.
    Parameter name: typeName

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.ArgumentNullException: Value cannot be null.
    Parameter name: typeName

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [ArgumentNullException: Value cannot be null.
    Parameter name: typeName]
       System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +9633470
       System.Type.GetType(String typeName, Boolean throwOnError) +59
       Zentity.Security.AuthenticationProvider.AuthenticationFactory.CreateInstance(String name) +122
    
    [ConfigurationErrorsException: Invalid configuration for key ZentityUser in config file.]
       Zentity.Security.AuthenticationProvider.AuthenticationFactory.CreateInstance(String name) +212
       Zentity.Security.AuthenticationProvider.ZentityAuthenticationProvider.Authenticate(SecurityToken credentialToken) +153
       Zentity.Web.UI.ResourceDataAccess.Authenticate(String userName, String password) +75
       Zentity.Web.UI.Global.Application_Start(Object sender, EventArgs e) +84
    
    [HttpException (0x80004005): Invalid configuration for key ZentityUser in config file.]
       System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +9090793
       System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +131
       System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +194
       System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +339
       System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +253
    
    [HttpException (0x80004005): Invalid configuration for key ZentityUser in config file.]
       System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9011212
       System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +97
       System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +256
    
    Thursday, November 3, 2011 1:45 PM
  • This (Server Error in '/WebUI' Application) one seems to be a bug in the Zentity 2.1. Actually, I am currently looking into this issue. Update you once a proper fix is found.

    -Thanks

    • Marked as answer by ItSurfer Friday, November 4, 2011 11:44 AM
    Friday, November 4, 2011 11:13 AM
  • No fix yet? I have the same issue in /WebUI
    Monday, January 23, 2012 10:10 PM
  • No, It has not been fixed. I am currently looking into it and update you on a fix which you can apply at your end.

     

    Tuesday, January 24, 2012 1:24 PM
  • I have the same error with webui, im waiting a fix


    Wednesday, January 25, 2012 3:05 AM
  • To fix this issue please follow the steps given below:-

    1)      Open the web.config file for the WebUI in visual studio or any xml editor. Path to the file is C:\Program Files (x86)\Zentity\ZentityWebSite\WebUI \web.config

    2)  Add the following keys in the <appSettings> config section.

     

    <appSettings>

                 

                 

        <add key="ZentityUser"
             
    value="Zentity.Security.AuthenticationProvider.CustomZentityUser,
                    Zentity.Security.AuthenticationProvider
    " />

     

        <add key="ZentityUserProfile"
            
    value="Zentity.Security.AuthenticationProvider.CustomZentityUserProfile,
                    Zentity.Security.AuthenticationProvider
    " />

                 

    </appSettings>

     

    3)      Place the file SecurityConfiguration.xml in the C:\Program Files (x86)\Zentity\ZentityWebSite\WebUI \bin folder. (below is the content of SecurityConfiguration.xml file)


    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
      <SecurityConfigSettings>
        <Predicates>
          <SecurityPredicates>
            <add Name="Create"
                 Priority="0"
                 Uri="urn:zentity/module/zentity-authorization/predicate/has-create-access"
                 InversePredicateUri="urn:zentity/module/zentity-authorization/predicate/deny-create-access"/>
            <add Name="Read"
                 Priority="4"
                 Uri="urn:zentity/module/zentity-authorization/predicate/has-read-access"
                 InversePredicateUri="urn:zentity/module/zentity-authorization/predicate/deny-read-access"/>
            <add Name="Update"
                 Priority="3"
                 Uri="urn:zentity/module/zentity-authorization/predicate/has-update-access"
                 InversePredicateUri="urn:zentity/module/zentity-authorization/predicate/deny-update-access"/>
            <add Name="Delete"
                 Priority="2"
                 Uri="urn:zentity/module/zentity-authorization/predicate/has-delete-access"
                 InversePredicateUri="urn:zentity/module/zentity-authorization/predicate/deny-delete-access"/>
            <add Name="Owner"
                 Priority="1"
                 Uri="urn:zentity/module/zentity-authorization/predicate/is-owner-of"
                 InversePredicateUri="urn:zentity/module/zentity-authorization/predicate/deny-ownership-of"/>
          </SecurityPredicates>
        </Predicates>
        <appSettings>
          <add key="AdminGroupName" value="Administrators"/>
          <add key="AdminUserName" value="Administrator"/>
          <add key="GuestUserName" value="Guest"/>
          <add key="AllUsersGroupName" value="AllUsers"/>
          <add key="MemberOfUri" value="urn:zentity/module/zentity-authorization/association/identity-belongs-to-groups"/>
        </appSettings>
      </SecurityConfigSettings>
    </configuration>

    • Edited by Kalnemi Wednesday, January 25, 2012 8:18 AM
    • Proposed as answer by Kalnemi Wednesday, January 25, 2012 8:26 AM
    Wednesday, January 25, 2012 8:15 AM
  • Thank you, It works. You should put this in an independent post.

    Now, there's another related issue: I cannot change the password. Maybe the SecurityConfiguration.xml has some restrictions, or there's a missing parameter in web.config <appSettings> section:

     

    [ArgumentNullException: Value cannot be null.
    Parameter name: typeName]
       System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +9634274
       System.Type.GetType(String typeName, Boolean throwOnError) +59
       Zentity.Security.AuthenticationProvider.AuthenticationFactory.CreateInstance(String name) +122
    
    [ConfigurationErrorsException: Invalid configuration for key ZentityUserManager in config file.]
       Zentity.Security.AuthenticationProvider.AuthenticationFactory.CreateInstance(String name) +212
       Zentity.Security.AuthenticationProvider.ZentityUserManager.CreateInstance() +30
       Zentity.Security.AuthenticationProvider.ZentityUserManager..cctor() +5
    
    [TypeInitializationException: The type initializer for 'Zentity.Security.AuthenticationProvider.ZentityUserManager' threw an exception.]
       Zentity.Security.AuthenticationProvider.ZentityUserManager.ChangePassword(String logOnName, String currentPassword, String newPassword) +0
       Security_ChangePassword.ChangePasswordButton_Click(Object sender, EventArgs e) +107
       System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

     



    Wednesday, January 25, 2012 9:09 PM
  • GRANDE Kalnemi, lo escribo en español por que no se la traducción exacta en ingles y ademas no se ingles pero debe ser algo como esto:  ....

     

    BIGGEST Mr Kaleni....It worked perfect....Only i need add all permis to user guest or to everyone in C:\Windows\Microsoft.NET\Framework

    Thursday, January 26, 2012 3:51 AM
  • I am currently working on this fix. It may get some more time. I currenly recommend you to use Zentity Resource Manager for account/access related work.

    -Regards

    Friday, January 27, 2012 12:38 PM
  • Apologies for the delayed response.

    Please add these  additional keys in the <appSettings> config section

    <appSettings>

    <add key="AuthenticationProvider" value="ZentityAuthenticationProvider"/>

    <add key="ZentityUserManager" value="Zentity.Security.AuthenticationProvider.CustomZentityUserManager, Zentity.Security.AuthenticationProvider"/>

    <add key="ZentityUserAdmin" value="Zentity.Security.AuthenticationProvider.CustomZentityUserAdmin, Zentity.Security.AuthenticationProvider"/>

    </appSettings>

    This will hopefully resolve all the problems related to account.

    -Regards 

     


    • Edited by Kalnemi Thursday, February 2, 2012 11:06 AM Formatting
    Thursday, February 2, 2012 10:59 AM