Very frequent ado errors
Very frequent ado errors
(OP)
The issue I'm having is constant ado errors in the event log of the Goldmine server. Everything seems to be running nomrally, but these errors persist.
About our environment:
We used to have two pe2950's. One was a Citrix server and the other ran all of our applications including Goldmine. Late last year we upgraded to a single server that runs all of our applications in their own vm's. We'd had these same ado errors with our old server and we have them now as well.
We have about 10 remote users that all log on to our RDS server which then launch Goldmine from a shared drive where Goldmine is installed.
About Goldmine support:
I've called Frontrange about this twice. The first guy said this was "normal". The second guy said that this was a networking issue and they couldn't help me. This very well may be true, but I don't have a whole lot to go on and Google hasn't been very helpful.
This is the event in the event log I get over and over sometimes as often as 3 times per minute.
About our environment:
We used to have two pe2950's. One was a Citrix server and the other ran all of our applications including Goldmine. Late last year we upgraded to a single server that runs all of our applications in their own vm's. We'd had these same ado errors with our old server and we have them now as well.
We have about 10 remote users that all log on to our RDS server which then launch Goldmine from a shared drive where Goldmine is installed.
About Goldmine support:
I've called Frontrange about this twice. The first guy said this was "normal". The second guy said that this was a networking issue and they couldn't help me. This very well may be true, but I don't have a whole lot to go on and Google hasn't been very helpful.
This is the event in the event log I get over and over sometimes as often as 3 times per minute.
Talk To Other Members
RE: Very frequent ado errors
The description for Event ID 0 from source GoldMine cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
GM version: 2014.1.0.503 R Thread ID 12304:
ADO Error in AdoConnection::open failed to open ADO connection
Com Error IDispatch error #3149
HRESULT : -2147217843
Description: Login failed for user 'sa'.
the message resource is present but the message is not found in the string/message table
RE: Very frequent ado errors
RE: Very frequent ado errors
(OP)
30 Mar 15 15:14
One final piece of inromation is that this error I'm getting shows up on all of our clients. On the Goldmine server I get a matching "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 192.168.1.xxx]."
This sounds like an intermittent connectivity issue and/or an actual credentials error. Make certain that the user has a login for the Server as well as a login for SQL Server. The same holds true for the Passwords for each.
DJ Hunt
Phone: (978)2-3333
WebSite: http://www.DJHunt.US
- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )
http://www.DJHunt.US
RE: Very frequent ado errors
RE: Very frequent ado errors
I would make sure that I ran the Client Configuration Tool on each desktop, and confirm that Named Pipes & TCP/IP are both enabled in the Protocol section. I would then Order the Named Pipes as position 2, and TCP/IP as position 3.
On the SQL Server I would make sure that the Service SQL Browsing has been Started.
Beyond that, I'm at a loss.
DJ Hunt
Phone: (978)2-3333
WebSite: http://www.DJHunt.US
- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )
http://www.DJHunt.US
RE: Very frequent ado errors
Doug Castell
Castell Computers
www.castellcomputers.com
RE: Very frequent ado errors
RE: Very frequent ado errors
As a side note, I think what you're seeing with those errors is relatively innocuous. It's just GoldMine going through its SQL login fall back progression.
When a user logs into GoldMine, the SQL login used is in any of a number of places:
1. their user properties
2. the database properties (tools|databases|open databases|properties of each)
3. the Alias properties (tools|databases|alias manager|properties of each)
It will try to use the one closest to the user and fall back, as necessary, through the progression as it finds them empty/wrong.
Doug Castell
Castell Computers
www.castellcomputers.com
RE: Very frequent ado errors