Solved

Lotus Notes Database clocks and hangs when trying to open

Posted on 2014-07-30
4
460 Views
Last Modified: 2014-08-05
Every time I go to open a lotus notes database,  One that I use all the time and am the designer for, it just sits and clocks and hangs notes.  I have to hit the stop button a few times, then it says operation stopped at my request.  Then when I try it again right away, it opens perfectly.
Any Ideas ???
0
Comment
Question by:pratigan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40230056
Turn on debugging, then open the database. Step through the code to find the problem.

What code runs in the database-level events? Can you debug it?

Ditto for the default view.

If you right-click > Goto > select a view that you don't use much > does the problem go away? If so, then perhaps the Initialize event for the view has a bug in it.
0
 
LVL 4

Author Comment

by:pratigan
ID: 40234229
appears to be network issues.  The default views and other views are inside the database and by then the response time is fine.  It only happens when I try to open the database.  I'm still checking some optimization tweaks.  I did try the debugging.  When I turn it open, the database opens fine every time... lol strange.
0
 
LVL 14

Accepted Solution

by:
ThomasMcA2 earned 500 total points
ID: 40234644
Sometimes it helps to create your own process that logs (and times) each step. Then you don't need to babysit the process, or enable debug. Exactly how you do it depends on how fancy you want to get with this feature. Here's some pseudocode for one method:
strLog = strLog & Date & Time & "about to do X"
x

strLog = strLog & Date & Time & "about to do y"
y

strLog = strLog & Date & Time & "about to do z"
z

Open in new window

Then create a Notes document that contains strLog, or send strLog to a mail-in database.

Once you have some logs saved, review the logs after you've seen performance problems, and you should be able to see which step caused the bad performance.

If you want to get fancy, save the date, time, and message about the current step into individual Notes documents (one for each step). You can then show the dates and times in a view, which would allow you to analyze trends.
0
 
LVL 4

Author Comment

by:pratigan
ID: 40241223
I was able to perform some optimization tweaks in the database properties that have stabilized the performance of the database.
Right click on the database icons in your workspace and the last tab is for performance optimization features.
Thank You for your input.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus Notes 41 238
Domino Application - View Refresh on Subform 15 101
Lotus Domino 9.0 install on same pc with 8.5.3 9 142
Problem setting value in rich text field with action 11 64
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question