This document was generated from CDN thread
Created by: Igor Zatsarevnyy on 02-11-2010 03:55:09 PM
Hi all,
We encounter the following issue with Reporting Server.
While starting the CVP server we are getting in a CVP log file the following error message
3: 10.81.6.214: Nov 02 2010 16:59:22.984 +0200: %CVP_7_0_RPT-3-REPORTING_INTERNAL_ERROR: Can't initialize the JDBC Connectionjava.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (cvp_db_cvpnbu) failed. [id:4003]
I followed Cisco recommendations and attempted to change a password for a database user, but got the error message "Insufficient privileges to execute the operation" while doing this operation. Please note I log on to the CVP Operations Console as Administrator with the Super User role.
So currently we do not have any data in the Informix database, i.e. this database is empty.
What is wrong? Any ideas?
Please note we are working with a non-standalone CVP 7.0(2) without ICM integrated.
Thanks.
Igor
Subject: RE: Reporting Server unable to connect to Informix database
Replied by: Igor Zatsarevnyy on 02-11-2010 05:08:09 PM
Matthew,
Thanks for your response.
Below is what is in an ORM error log file:
2: 10.81.6.214: Nov 02 2010 16:59:22.656 +0200: %CVP_7_0_MessagingLayer-1-PLUGIN_INITIALIZATION_SUCCESS: Client Side Plugin: SYS_ORM has been started Plugin initialization and configuration succeeded [id:10]
75: 10.81.6.214: Nov 02 2010 16:59:22.828 +0200: %CVP_7_0_ORM-1-ORM_ALERT_SERVICE_START_NOTIFY: Resource Manager service alert, Service started successfully and is ready to respond [id:8002]
3: 10.81.6.214: Nov 02 2010 16:59:25.718 +0200: %CVP_7_0_MessagingLayer-1-PLUGIN_INITIALIZATION_SUCCESS: SYS_ORM Connection Successful: host=Socket QoS Level set to: 0 Plugin initialization and configuration succeeded [id:10]
6: 10.81.6.214: Nov 02 2010 16:59:25.765 +0200: %CVP_7_0_MessagingLayer-1-PLUGIN_INITIALIZATION_SUCCESS: Received an ACK from the server. Plugin initialization and configuration succeeded [id:10]
388: 10.81.6.214: Nov 02 2010 17:47:35.578 +0200: %CVP_7_0_ORM-3-ORM_ERROR_GENERAL: Script changePWD execution failed, reason=5
com.cisco.cvp.oamp.ocom.mbean.ScriptException: Script execution failed:C:\Cisco\CVP\bin\cvp4dbBackend
at com.cisco.cvp.oamp.orm.utility.ScriptUtil.executeScript(ScriptUtil.java:185)
at com.cisco.cvp.oamp.orm.mbean.pc.impl.SubsystemReportingImpl.executeDBOperation(SubsystemReportingImpl.java:1827)
at com.cisco.cvp.oamp.orm.mbean.pc.impl.SubsystemReportingImpl.changeUserPassword(SubsystemReportingImpl.java:1985)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
at javax.management.StandardMBean.invoke(StandardMBean.java:323)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1410)
at javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81)
at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1247)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1343)
at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:784)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
[id:8001]
What is the next step?
Thanks.
Igor
Subject: RE: Reporting Server unable to connect to Informix database
Replied by: Richard Parker on 02-11-2010 05:10:41 PM
We saw this recently, the issue turned out to be a setup issue on the userid itself (domain?). I've asked around to refresh my memory.
Regards,
Jack parker
Subject: RE: Reporting Server unable to connect to Informix database
Replied by: Matthew Reiter on 02-11-2010 04:03:09 PM
Check the ORM logs on your reporting server for errors; it's possible that it doesn't have permissions to change the user's password.
Subject: RE: Reporting Server unable to connect to Informix database
Replied by: Matthew Reiter on 02-11-2010 05:59:18 PM
388: 10.81.6.214: Nov 02 2010 17:47:35.578 +0200: %CVP_7_0_ORM-3-ORM_ERROR_GENERAL: Script changePWD execution failed, reason=5
Error code 5 means ERROR_ACCESS_DENIED (The user does not have access to the requested information), so it's likely that the account that ORM runs as (local system by default) does not have permission to change the password of the reporting users (informix, cvp_dbadmin and cvp_dbuser). This could occur if these users are domain accounts rather than local users, which I believe can happen in certain situations if the computer is on a domain at the time the reporting server is installed.
Subject: RE: Reporting Server unable to connect to Informix database
Replied by: Igor Zatsarevnyy on 04-11-2010 12:47:27 PM
Solved!
The reason was lack of the Datafeed logger in our CVP Call Studio app. So be patient if you want to make Reporting Server working. For this it is mandatory to have such a logger in your CVP apps.
Thank you all for assistance.
Igor
