We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

SO WEB 8.0x crashes the

Hello,

I have an issue where a customer has to login to superoffice, many times a day, after the w3wp.exe process has crashed. 

The log file gives me a somewhat generic error.

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="ASP.NET 4.0.30319.0" /> 
  <EventID Qualifiers="49152">1325</EventID> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Keywords>0x80000000000000</Keywords> 
  <TimeCreated SystemTime="2018-05-09T11:22:39.000000000Z" /> 
  <EventRecordID>181803</EventRecordID> 
  <Channel>Application</Channel> 
  <Computer>PDKSRV01</Computer> 
  <Security /> 
  </System>
- <EventData>
  <Data>An unhandled exception occurred and the process was terminated. Application ID: /LM/W3SVC/1/ROOT/SuperOffice Process ID: 3504 Exception: System.NullReferenceException Message: Object reference not set to an instance of an object. StackTrace: at SuperOffice.Data.SoDataReader.Finalize()</Data> 
  </EventData>
  </Event>

 

But the Netserver log is more informative. And it looks like it's a dynamic selection which is causing the error.

See this excerpt from the netserver log
https://docs.google.com/document/d/1ShZTXQR18zxd6vFw0SPkHE6SjvRUCGZe7C52z7-j3_g/edit?usp=sharing

Problem is, that I cannot reproduce the error by browsing the link in the log nor get any error running the sql directly against the database.

So any good idea on how to debug further is greatly appreciated :)

Cheers Søren

RE: SO WEB 8.0x crashes the

Hi Søren, seems like selection_id=1328 is causing a timeout in SQL. It is being used in the minicard here.

I'd start by looking into if it is always the same selection causing timeout.

How does it behave if you open the same selection in Win client?

You should also look at the performance of the SQL server. Is it under heavy CPU load?

Av: Frode Lillerud 9. mai 2018

RE: SO WEB 8.0x crashes the

I suspect  selectionmember count is high, like a static selection with 10.000+ selectionmembers

Av: Margrethe Romnes 9. mai 2018

RE: SO WEB 8.0x crashes the

Thank you for the feedback, and sorry for the late reply. 

To answer your questions:

1. It looked a lot like it was the same selection causing the error. And once the customer was aware of what selection, the error hasn't occured since the 9th May .. Until today 3 times. But now it looks like different selections that time out.

2. I can open one of the selections in the win client

3. The selections are all very small - about 100 units (but running the SQL command takes 15 seconds for 100 records)

4. The computer is almost dorment, and has little to no activity on the CPU.

I can not recreate the error with the user I log in as. I will try to alter the creds of one of the users in question, and see if I can trigger an error. 

Cheers Søren

Av: Søren Lund 23. mai 2018

RE: SO WEB 8.0x crashes the

Try removing columns for the user(s) that are experiencing this.
From the log, it looks like the selection in question is a dynamic selection of contacts.
Remove all columns but 1, e.g. company name. See what happens. If this helped, then add columns..
If this did not help then try removing criteria as a process of ellimination.

Note: In win 8.0 up to 8.2, the selection of contacts archive control is still hybrid. The Netserver provider is used as a data provider but Win defines the available columns and does the needed mapping. Win will not have as many coilumns to choose from.

In 8.3, this is changed. Selection of Company&Contacts as well as both Company & Contact Relations are now netsver based archives. More columns to choose from, externder columns will be available but on the whole a much inferior live-update.

Conrad

Av: Conrad Weyns 23. mai 2018