Solved

Yardi Genesis

Posted on 2013-01-31
5
1,752 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

786 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