Cannot send email Cognos 8.2

[jfischer]

I am having a very strange problem.  We are currently using ReportNet and are starting a migration to Cognos 8.2.   We have setup the notification section within Cognos Configuration, but cannot send email.  When using the Test option within Cognos Configuration, I do receive an email, but when I run a report, I get nothing.  I am currently working with support, but they have not been able to figure out what the problem is.  They had be rename the ipfSDSClientConfig.xml file to ipfclientconfig.xml and retry to send an email.  That produced crnclient.log file which contained an error:

CNC-SDS-0216 Unable to create a new ID.java.lang.IllegalStateException: CNC-SDS-0216 Unable to create a new ID.   at com.cognos.jsmcommon.objectid.JDBCIdGenerator.getIdFromDatabase(JDBCIdGenerator.java:127)   at com.cognos.jsmcommon.objectid.JDBCIdGenerator.getNewId(JDBCIdGenerator.java:75)   at com.cognos.jsmcommon.objectid.LongIdCreatorImpl.createNew(LongIdCreatorImpl.java:31)   at com.cognos.jsmcommon.objectid.NCObjectId.createNew(NCObjectId.java:40)   at com.cognos.jsmcommon.jms.provider.PersistedJMSQueue.persistMessage(PersistedJMSQueue.java:429)   at com.cognos.jsmcommon.jms.provider.PersistedJMSQueue.add(PersistedJMSQueue.java:308)   at com.cognos.jsmcommon.jms.provider.NCJMSDatabaseQueue.add(NCJMSDatabaseQueue.java:66)   at com.cognos.jsmcommon.jms.provider.Target.add(Target.java:57)   at com.cognos.jsmcommon.jms.provider.DestinationManager.addMessage(DestinationManager.java:113)   at com.cognos.jsmcommon.jms.provider.NCJMSSession.send(NCJMSSession.java:371)   at com.cognos.jsmcommon.jms.provider.NCJMSQueueSender.send(NCJMSQueueSender.java:168)   at com.cognos.jsmcommon.jms.provider.NCJMSQueueSender.send(NCJMSQueueSender.java:113)   at com.cognos.jsmcommon.jms.client.JMSConnection.sendMessage(JMSConnection.java:153)   at com.cognos.dls.smtp.SMTPDeliveryService.queueDeliverable(SMTPDeliveryService.java:114)   at com.cognos.dls.smtp.SMTPDeliveryService.emailDelivery(SMTPDeliveryService.java:87)   at com.cognos.dls.smtp.DeliveryOptionsRunnable.run(DeliveryOptionsRunnable.java:67)   at com.cognos.dls.api.DeliveryServiceHandler.run(DeliveryServiceHandler.java:342)   at com.cognos.dls.api.DeliveryServiceImpl.run(DeliveryServiceImpl.java:80)   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)   at java.lang.reflect.Method.invoke(Unknown Source)   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)   at com.cognos.jsmcommon.soap.service.SDSSoapService.process(SDSSoapService.java:189)   at com.cognos.jsmcommon.soap.service.AxisServiceHandler.execute(AxisServiceHandler.java:266)   at com.cognos.dls.service.DLSHandler.invokeImpl(DLSHandler.java:176)   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)   at com.cognos.jsmcommon.soap.service.AsyncServiceImpl.invoke(AsyncServiceImpl.java:96)   at com.cognos.pogo.async.impl.AsyncContextImpl.runRequest(AsyncContextImpl.java:169)   at com.cognos.pogo.async.impl.AsyncRequestThread.run(AsyncRequestThread.java:45)

Support is starting to think that there is a problem with the content store running Oracle 10.2.0.2.0.  Any thoughts? 

[larsonr]

Please verify the following:

Did you do a clean install of 8.2 or did you try migrating from ReportNet to Cognos 82.  Factors to look into:

1) Version of JRE.  Make sure that if you have JAVA_HOME environment variable it is pointing to either java jre 1.4.2 or 1.5.0.  If it is the out of the box install, then it is by default point to 1.4.2 which is perfect.

2) Are you using ojdbc14.jar?  Old installs of Cognos stated to use classes12.jar.  This is actual the wrong driver when dealing with JRE 1.4.2 or higher with Oracle 9i or Oracle 10g. If it helps, rather than pulling the file from your oracle home directory, head out to Oracle's website and grab an updated version of the file.

3)Oracle 10.2 offers up new functionality, if you're still in development mode,  it may be worth a shot to run it in 9i compatibility mode just to see if that may make a difference.  I know its not a good solution long term but it is a starting point. 

If anything else comes to mind, I will then post more.  We will be moving the content store to 10.2 ourselves around November.