Highlighted
Absent Member.
Absent Member.
245 views

DataWarehouse

Hi, I'm getting this error every hour:

OV_dataWareHouseMaintError

Data Warehouse maintenance program () exited with

ovdwevent
ovcoldelsql
ovdweventa non-zero returnm code and the following message's are being logged to the Event Browser:

1034821841 1 Thu Oct 17 03:30:41 2002 ldn-smuk-nms a ovdwevent connected to pmd;1 17.1.0.59179056 0
1034821841 6 Thu Oct 17 03:30:41 2002 ldn-smuk-nms a Data warehouse maintenance program (ovdwevent) exited with a non-zero return code of 1 and the following message: \nODBC Error Occurred while connecting to DB: SQLSTATE = HY000\nNATIVE ERROR = 21306\nMSG = SOLID Communication Error 21306: Server 'tcpip 2690' not found, connection failed\n\n;1 17.1.0.59181002 0
1034821841 1 Thu Oct 17 03:30:41 2002 ldn-smuk-nms a ovdwevent disconnected from pmd;1 17.1.0.59179057 0
1034825465 1 Thu Oct 17 04:31:05 2002 ldn-smuk-nms a ovdwevent connected to pmd;1 17.1.0.59179056 0
1034825465 6 Thu Oct 17 04:31:05 2002 ldn-smuk-nms a Data warehouse maintenance program (ovdwevent) exited with a non-zero return code of 1 and the following message: \nODBC Error Occurred while connecting to DB: SQLSTATE = HY000\nNATIVE ERROR = 21306\nMSG = SOLID Communication Error 21306: Server 'tcpip 2690' not found, connection failed\n\n;1 17.1.0.59181002 0
1034825465 1 Thu Oct 17 04:31:05 2002 ldn-smuk-nms a ovdwevent disconnected from pmd;1 17.1.0.59179057 0
1034829057 1 Thu Oct 17 05:30:57 2002 ldn-smuk-nms a ovdwevent connected to pmd;1 17.1.0.59179056 0
1034829057 6 Thu Oct 17 05:30:57 2002 ldn-smuk-nms a Data warehouse maintenance program (ovdwevent) exited with a non-zero return code of 1 and the following message: \nODBC Error Occurred while connecting to DB: SQLSTATE = HY000\nNATIVE ERROR = 21306\nMSG = SOLID Communication Error 21306: Server 'tcpip 2690' not found, connection failed\n\n;1 17.1.0.59181002 0
1034829057 1 Thu Oct 17 05:30:57 2002 ldn-smuk-nms a ovdwevent disconnected from pmd;1 17.1.0.59179057 0
1034832658 1 Thu Oct 17 06:30:58 2002 ldn-smuk-nms a ovdwevent connected to pmd;1 17.1.0.59179056 0
1034832658 6 Thu Oct 17 06:30:58 2002 ldn-smuk-nms a Data warehouse maintenance program (ovdwevent) exited with a non-zero return code of 1 and the following message: \nODBC Error Occurred while connecting to DB: SQLSTATE = HY000\nNATIVE ERROR = 21306\nMSG = SOLID Communication Error 21306: Server 'tcpip 2690' not found, connection failed\n\n;1 17.1.0.59181002 0
1034832658 1 Thu Oct 17 06:30:58 2002 ldn-smuk-nms a ovdwevent disconnected from pmd;1 17.1.0.59179057 0

If I run an ovstatus I the following processes have failed:

object manager name: ovdbcheck
state: NOT_RUNNING
PID: -
last message: Data Warehouse unaccessible.
exit status: Exit(1)

It does start with an ovstart ovdbcheck:

object manager name: ovdbcheck
state: RUNNING
PID: 649
last message: Connected to embedded database.
exit status: -

The box is patched upto PSOV_03208, 09052002

SunOS 5.7
2 Processors
2GB RAM


Any Ideas ?
0 Likes
7 Replies
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

The ovdwtrend.log file contains more information regarding the ovcoltosql error in the following message.


ERROR: ovcoltosql: /var/opt/OV/share/databases/snmpCollect/ must have 777 permission.


To fix this error, simply change the permissions on the snmpCollect directory or file folder to read, write, and execute for all users.


Hope this helps.
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

Cheers Ian, I'll give that a shot and let you know how I get on !

Many Thanks

J
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

Hi,
The permissions are already set to 777 for the snmpcollect directory.

drwxrwxrwx 72 root other 50688 Oct 20 00:26 snmpCollect

However looking at the ovdwtrend.log file - it complains about an ODBC failure to the database. This error is a regular entry in the log.



# tail /var/opt/OV/share/log/ovdwtrend.log
ovcoltosql: Hour alignment is enabled; in order to prevent
partial records, only reduced records up to 10/21/02 08:59:59 will be exported
10/21/02 09:57:55
Connection to database failed, check DB status.
ODBC Error Occurred during connection:
SQLSTATE = HY000
NATIVE ERROR = 21306
MSG = SOLID Communication Error 21306: Server 'tcpip 2690' not found, connection
failed

Any Ideas ?

Regards

J
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

Hi, we are having the same problems as you. However, it occurs only once every night. Did you find out how to fix ovdbcheck dies because of
"Connection to database 'tcpip 2690' failed: port not available"?

Thanks in advance.

-Chu
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

no ideas
I dont believe in miracles, i trust in them
0 Likes
New Member.

Re: DataWarehouse

I'm having the same issue. Just started recently and I have no idea how to resolve it.

It's as if it cannot connect to it's embedded solid DB on port 2690, but the port is there and available. Nothing changed.

Does anyone have any ideas on this?
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: DataWarehouse

Hi All,

Earlier I have also faced this problem. After redo the solid DB problems gone.

Thanks,
Gobinathan.S
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.