This document was generated from CDN thread
Created by: Ben Sunderland on 18-07-2012 11:20:43 PM
I have a fresh build of webexsocial with SR1 (3.0.1.09011.163).
Initially I thought I was able to create posts (but now am doubting if I ever could) , but now cant , and cant create any content at all (blogs docs etc).
Anyideas on how I trouble shoot (other than rebuild from scratch). Director topology says all is OK.
In the quad logs I get :
"0:34 awq2qwa01.alphawest.com.au quad[]: ERROR [hibernate.util.JDBCExceptionReporter] - [TP-Processor39] - - [A42404DE2804889DFC7247E5CD3D6E40.awq2qwa01.alphawest.com.aujvm]: ORA-00904: "MBMESSAGEI0_"."ORIGINALMESSAGEID": invalid identifier#012
Jul 19 03:00:34 awq2qwa01.alphawest.com.au quad[]: ERROR [service.impl.GroupLocalServiceImpl] - [TP-Processor39] - - [A42404DE2804889DFC7247E5CD3D6E40.awq2qwa01.alphawest.com.aujvm]: Unble to import layouts for group: 1314410004
Jul 19 03:00:34 awq2qwa01.alphawest.com.au com.liferay.portal.SystemExcepti com.liferay.portal.lar.PortletDataException: com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portlet.messageboards.model.impl.MBMessageImpl#0]
Jul 19 03:00:34 awq2qwa01.alphawest.com.au at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:483)"
and this in rdbms collectd.log
"Jul 19 03:08:51 awq2rdb01 collectd[2358]: oracle plugin: o_read_database: OCILogon failed: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Jul 19 03:09:06 awq2rdb01 collectd[2358]: oracle plugin: o_read_database: OCILogon failed: ORA-12514: TNS:listener does not currently know of service request"
and the rdbms alert log (/opt/oracle/app/oracle/diag/tnslsnr/awq2rdb01/listener/alert/log.xml) I get this constantly looping:
"<msg time='2012-07-19T03:13:36.805+00:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='awq2rdb01.alphawest.com.au'
host_addr='10.122.23.32'>
<txt>19-JUL-2012 03:13:36 * (CONNECT_DATA=(SERVICE_NAME=quad.awq2rdb01.alphawest.com.au)(CID=(PROGRAM=collectd)(HOST=awq2rdb01.alphawest.com.au)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=53323)) * establish * quad.awq2rdb01.alphawest.com.au * 12514
</txt>
</msg>
<msg time='2012-07-19T03:13:36.805+00:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='awq2rdb01.alphawest.com.au'
host_addr='10.122.23.32'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
Subject: RE: Cant create posts / communities
Replied by: Manuel Michel on 19-07-2012 10:45:21 AM
- Maybe the TNS listener has a problem on the RDBMS store, is the dbora service running on the RDBMS? try a puppet service debug
- can you disable / enable the app server AND worker node and monitor the catalina.out of the app server?
