Deleting 5000 PubMed fields from Zentity. Exception.

Dienstag, 1. November 2011 08:51

0
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)
- Antworten
- Zitieren

Alle Antworten

Dienstag, 1. November 2011 08:52

0

What is the best way to fix it?
- Antworten
- Zitieren
Mittwoch, 2. November 2011 09:29

1

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.
- Antworten
- Zitieren
Mittwoch, 2. November 2011 16:59

0

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?
- Antworten
- Zitieren
Donnerstag, 3. November 2011 12:32

1
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.
- Antworten
- Zitieren

Donnerstag, 3. November 2011 13:45

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

Freitag, 4. November 2011 11:13

1
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
- Als Antwort markiert ItSurfer Freitag, 4. November 2011 11:44
- Antworten
- Zitieren
Montag, 23. Januar 2012 22:10

0
No fix yet? I have the same issue in /WebUI
- Bearbeitet Leonardo Vargas Bernal Montag, 23. Januar 2012 22:12
- Antworten
- Zitieren
Dienstag, 24. Januar 2012 13:24

0

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.
- Antworten
- Zitieren
Mittwoch, 25. Januar 2012 03:05

0

I have the same error with webui, im waiting a fix
- Antworten
- Zitieren

Mittwoch, 25. Januar 2012 08:15

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>

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>

Bearbeitet Kalnemi Mittwoch, 25. Januar 2012 08:18
Als Antwort vorgeschlagen Kalnemi Mittwoch, 25. Januar 2012 08:26

Mittwoch, 25. Januar 2012 21:09

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

Bearbeitet Leonardo Vargas Bernal Donnerstag, 26. Januar 2012 16:33
Bearbeitet Leonardo Vargas Bernal Donnerstag, 26. Januar 2012 16:34

Donnerstag, 26. Januar 2012 03:51

1

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
- Antworten
- Zitieren
Freitag, 27. Januar 2012 12:38

1

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
- Antworten
- Zitieren
Donnerstag, 2. Februar 2012 10:59

1
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　
- Bearbeitet Kalnemi Donnerstag, 2. Februar 2012 11:03 formatting
- Bearbeitet Kalnemi Donnerstag, 2. Februar 2012 11:06 Formatting
- Antworten
- Zitieren

Deleting 5000 PubMed fields from Zentity. Exception.

Alle Antworten

Server Error in '/WebUI' Application.

Value cannot be null. Parameter name: typeName

Value cannot be null.
Parameter name: typeName