Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Yardi Genesis

Posted on 2013-01-31
5
Medium Priority
?
2,040 Views
Last Modified: 2013-02-26
I have a client that 2 days ago they started to receive the following error when logging into their Yardi database
Login Failed with error 1:
                Couldn’t access the database server “apmyardi\yardipm”. The engine must be installed and running. ADO returned error: 0 – Timeout expires.

Three users do not have this issue but 21 do. Checked if it was an issue with a switch, people who can and cannot log in are on the same switch, moved a computer that could not connect to the data port of one that could and it was fine. After much troubleshooting, if i release and renew the IP address they can log in. Problem is, if they close the program and reopen it, they have to first release and renew the IP. They are on a DHCP server. All users are running Windows XP Pro SP3

Any insight would be great
0
Comment
Question by:debcard
  • 3
5 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 38843479
I would check what netstat says about the connections from the klient.
I would check the FW on the XP to make sure it's not dropping any packages

If this doesn't give me all the info I need I would install the netmon tool and sniff the traffic to see whats happening.

To learn about netmon look at:
http://blogs.technet.com/netmon
http://msdn.microsoft.com/en-us/library/windows/desktop/bb648688(v=vs.85).aspx
http://support.microsoft.com/kb/812953
http://blogs.technet.com/b/netmon/
http://blogs.technet.com/b/netmon/p/usagevideos.aspx
http://technet.microsoft.com/en-us/library/cc782726(v=ws.10).aspx

Regards Marten
0
 
LVL 35

Expert Comment

by:David Todd
ID: 38845356
Hi,

To go back half a step, can these three clients ping the server? You indicated that for one or more there was an issue with the ip address, or maybe the dns entry.

You could try for these three putting an entry into the hosts file.

Check them for virus and other malware which may be getting into the dns thing and not resolving ip addresses properly.

HTH
  David
0
 

Author Comment

by:debcard
ID: 38845772
Actually this afternoon we checked the server which is a DHCP server and found issues there, I believe the issue is resolved

Thank you

Will repost if still an issue
0
 

Accepted Solution

by:
debcard earned 0 total points
ID: 38916011
issue is resolved
0
 

Author Closing Comment

by:debcard
ID: 38929183
found the DHCp was turned on the router so the server and router were both giving out addresses
1

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
Steps to fix “Unable to mount database. (hr=0x80004005, ec=1108)”.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

885 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