CUCM 7.1.5 DRS restore errors.

[ccieid10t]

Everything restores fine.  Only when it gets to CCMDB where it errors.  Bunch of java errors.

----> BEGIN Standard Error
Fri May 13 12:06:50 MST 2011:main:General SQL failure:
Fri May 13 12:06:50 MST 2011:main:java.sql.SQLException: Failed to get Connection.Connector(NOT CONNECTED: Driver=com.informix.jdbc.IfxDriver;)
at com.cisco.ccm.dbl.Connector.getConn(Connector.java:698)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:588)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:530)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:757)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:744)
at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:921)
at com.cisco.ccm.dbl.idbl.executeSelect(idbl.java:672)
at com.cisco.ccm.dbl.idbl.executeSQL(idbl.java:1251)
at com.cisco.ccm.dbl.idbl.run(idbl.java:1404)
at com.cisco.ccm.dbl.idbl.main(idbl.java:1470)

Fri May 13 12:14:38 MST 2011:main:connect() SQLException
Fri May 13 12:14:38 MST 2011:main:java.sql.SQLException: Can't load driver java.lang.reflect.InvocationTargetException
at com.informix.util.IfxErrMsg.getLocSQLException(IfxErrMsg.java:494)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:271)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at com.cisco.ccm.dbl.Connector.getConn(Connector.java:671)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:588)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:530)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:757)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:744)
at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:921)
at com.cisco.ccm.dbl.util.ProcessNodeId.setProcessNodeId(ProcessNodeId.java:108)
at com.cisco.ccm.dbl.util.ProcessNodeId.(ProcessNodeId.java:64)
at com.cisco.ccm.dbl.util.ReplHelper.run(ReplHelper.java:144)
at com.cisco.ccm.dbl.util.ReplHelper.main(ReplHelper.java:290)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
... 12 more

[mudmathu]

Hi

Can you please let us know if the CEF service is running in the CUCM Publisher ??

If yes, then stop the CEF service -> Restart the A Cisco DB on all the nodes and then try to restore again.

Try this workaround, if it still fails, then attach the "ccm.log" from the Publisher.

Thanks

Mudit

[ccieid10t]

Work around didn't work.  Here's the logs attached.

[mudmathu]

The file you attached is DRS log file. Can you please provide me the ccm.log. Also I see the the connection to the informix database mainccmp_ccm7_1_5_10000_12 has failed. I think this is the Publisher. Restart the Tomcat service and try to take the manual backup again and then try to restore it.

If it fails , give me the logs for analysis.

Thanks

Mudit

[ccieid10t]

Mudit,

Tried it with another backup and it still fails.  We have tried with another CCM backup with a different hostname and that was able to restore correctly.

[mudmathu]

from the CCM logs I see that the CDR backup is failing ::

1:16:34  CDR SQLHOSTS file has a problem with (g=) or (i=) option for server mainccmp_ccm7_1_5_10000_12.
11:16:49  Verbose error trapping set, errno = 661, session_id = -1
11:16:55  Booting Language from module <>
11:16:55  Loading Module

options: q=quit, n=next, p=prev, b=begin, e=end (lines 5901 - 5920 of 7778) :
11:16:55  CDR GC: operation drop table cdr_deltab_000001 failed (error -206).
11:16:55  CDR operation continued : Table previously dropped or was never created
11:16:55  CDR GC: operation drop table cdr_deltab_000002 failed (error -206).

Can you check if the CDR files are there or not ?

Also let me know if you changed the IP or Hostname of the server ?

Did you added another node in the cluster ?

Thanks

Mudit

[ccieid10t]

Thanks Mudit.  Even though the last restore failed, we were able to filled up the database with phones, route patterns, etc.  We're making a copy of the customer's production environment so we can start utilizing our tools to populate it.

[mudmathu]

If the backup is incomplete or corrupted, you will see that the restore will also show errors.

where are you trying to take the backup and which sftp client is used to take the backup.

I have seen instances where the error occurs due to the ftp client as well. Try using a freeware "freeftpd" and try to take a manual backup locally on your machine, and let me know if you seek any difference.

PS.. Rate if useful..!! :-)

[ccieid10t]

Hey Mudit.  The hostname was change sometime in between March and May that we're not aware of since we're just replicating the customer's environment in order to use our tool.  I'm giving you rating because you did assist regardless of the result.

[mudmathu]

Hey ..

Thanks a lot ..!!

I guess the problem lies with the hostname entry with CDR records.

Did you took the backup for the CDR files after you changed the hostname ?