Templates have disappeared

Carolyn Vincent

unread,

Nov 7, 2011, 1:50:18 PM11/7/11

to dot...@googlegroups.com

It seems that my templates have disappeared in a 1.9.3.1 enterprise install. We had 1.9.2.1 and just recently upgraded to 1.9.3.2. When I go to an existing page and look at the template for that page, it will list the template that was used to create the page, but nothing appears when I use the drop down. I can’t even find the folder that the templates originally were in.

1. Can someone tell me what folder the templates are in for 1.9?

2. I have checked the permissions and they seem fine. The error log gives this message:

3. [07/11/11 18:26:46:108 UTC] WARN dwrp.BaseCallMarshaller: --Erroring: batchId[4] message[com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

4. ]

5. [07/11/11 18:26:47:478 UTC] ERROR ajax.TemplateAjax: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

6.

7. com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

8.

9. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:226)

10. at com.dotmarketing.common.db.DotConnect.loadResults(DotConnect.java:325)

11. at com.dotmarketing.business.PermissionedWebAssetUtil.queryForAssetIds(PermissionedWebAssetUtil.java:294)

12. at com.dotmarketing.business.PermissionedWebAssetUtil.findTemplatesForLimitedUser(PermissionedWebAssetUtil.java:103)

13. at com.dotmarketing.portlets.templates.business.TemplateFactoryImpl.findTemplatesUserCanUse(TemplateFactoryImpl.java:74)

14. at com.dotmarketing.portlets.templates.business.TemplateAPIImpl.findTemplatesUserCanUse(TemplateAPIImpl.java:90)

15. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:77)

16. at sun.reflect.GeneratedMethodAccessor898.invoke(Unknown Source)

17. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

18. at java.lang.reflect.Method.invoke(Method.java:597)

19. at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)

20. at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)

21. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)

22. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)

23. at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)

24. at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)

25. at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)

26. at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

27. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

28. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

29. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

30. at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:137)

31. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

32. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

33. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

34. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

35. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

36. at com.dotmarketing.filters.CacheImagesFilter.doFilter(CacheImagesFilter.java:47)

37. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

38. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

39. at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:313)

40. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

41. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

42. at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:140)

43. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

44. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

45. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

46. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

47. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

48. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

49. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

50. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

51. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

52. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

53. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

54. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

55. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

56. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

57. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

58. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

59. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

60. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

61. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

62. at java.lang.Thread.run(Thread.java:662)

63. Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

64.

65. at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

66. at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

67. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

68. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

69. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

70. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

71. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

72. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)

73. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)

74. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

75. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)

76. at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)

77. at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

78. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:562)

79. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:461)

80. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:224)

81. ... 53 more

82. [07/11/11 18:26:47:478 UTC] WARN impl.DefaultRemoter: Method execution failed:

83. com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

84.

85. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:98)

86. at sun.reflect.GeneratedMethodAccessor898.invoke(Unknown Source)

87. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

88. at java.lang.reflect.Method.invoke(Method.java:597)

89. at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)

90. at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)

91. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)

92. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)

93. at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)

94. at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)

95. at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)

96. at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

97. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

98. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

99. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

100. at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:137)

101. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

102. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

103. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

104. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

105. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

106. at com.dotmarketing.filters.CacheImagesFilter.doFilter(CacheImagesFilter.java:47)

107. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

108. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

109. at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:313)

110. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

111. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

112. at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:140)

113. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

114. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

115. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

116. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

117. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

118. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

119. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

120. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

121. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

122. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

123. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

124. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

125. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

126. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

127. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

128. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

129. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

130. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

131. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

132. at java.lang.Thread.run(Thread.java:662)

133. Caused by: com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

134.

135. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:226)

136. at com.dotmarketing.common.db.DotConnect.loadResults(DotConnect.java:325)

137. at com.dotmarketing.business.PermissionedWebAssetUtil.queryForAssetIds(PermissionedWebAssetUtil.java:294)

138. at com.dotmarketing.business.PermissionedWebAssetUtil.findTemplatesForLimitedUser(PermissionedWebAssetUtil.java:103)

139. at com.dotmarketing.portlets.templates.business.TemplateFactoryImpl.findTemplatesUserCanUse(TemplateFactoryImpl.java:74)

140. at com.dotmarketing.portlets.templates.business.TemplateAPIImpl.findTemplatesUserCanUse(TemplateAPIImpl.java:90)

141. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:77)

142. ... 47 more

143. Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

144.

145. at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

146. at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

147. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

148. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

149. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

150. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

151. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

152. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)

153. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)

154. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

155. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)

156. at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)

157. at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

158. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:562)

159. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:461)

160. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:224)

161. ... 53 more

162. [07/11/11 18:26:47:478 UTC] WARN dwrp.BaseCallMarshaller: --Erroring: batchId[5] message[com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

163. ]

164. [07/11/11 18:26:47:478 UTC] WARN db.DbConnectionFactory: ---------- DBConnectionFactory: error closing the db dbconnection: jdbc/dotCMSPool ---------------

165. java.sql.SQLException: Already closed.

166. at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84)

167. at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)

168. at com.dotmarketing.db.DbConnectionFactory.closeConnection(DbConnectionFactory.java:200)

169. at com.dotmarketing.listeners.HibernateSessionsListener.requestDestroyed(HibernateSessionsListener.java:19)

170. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:204)

171. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

172. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

173. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

174. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

175. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

176. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

177. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

178. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

179. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

180. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

181. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

182. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

183. at java.lang.Thread.run(Thread.java:662)

184. [07/11/11 18:26:52:504 UTC] ERROR ajax.TemplateAjax: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

185.

186. com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

187.

188. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:226)

189. at com.dotmarketing.common.db.DotConnect.loadResults(DotConnect.java:325)

190. at com.dotmarketing.business.PermissionedWebAssetUtil.queryForAssetIds(PermissionedWebAssetUtil.java:294)

191. at com.dotmarketing.business.PermissionedWebAssetUtil.findTemplatesForLimitedUser(PermissionedWebAssetUtil.java:103)

192. at com.dotmarketing.portlets.templates.business.TemplateFactoryImpl.findTemplatesUserCanUse(TemplateFactoryImpl.java:74)

193. at com.dotmarketing.portlets.templates.business.TemplateAPIImpl.findTemplatesUserCanUse(TemplateAPIImpl.java:90)

194. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:77)

195. at sun.reflect.GeneratedMethodAccessor898.invoke(Unknown Source)

196. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

197. at java.lang.reflect.Method.invoke(Method.java:597)

198. at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)

199. at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)

200. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)

201. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)

202. at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)

203. at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)

204. at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)

205. at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

206. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

207. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

208. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

209. at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:137)

210. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

211. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

212. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

213. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

214. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

215. at com.dotmarketing.filters.CacheImagesFilter.doFilter(CacheImagesFilter.java:47)

216. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

217. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

218. at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:313)

219. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

220. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

221. at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:140)

222. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

223. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

224. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

225. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

226. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

227. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

228. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

229. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

230. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

231. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

232. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

233. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

234. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

235. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

236. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

237. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

238. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

239. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

240. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

241. at java.lang.Thread.run(Thread.java:662)

242. Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

243.

244. at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

245. at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

246. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

247. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

248. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

249. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

250. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

251. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)

252. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)

253. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

254. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)

255. at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)

256. at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

257. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:562)

258. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:461)

259. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:224)

260. ... 53 more

261. [07/11/11 18:26:52:504 UTC] WARN impl.DefaultRemoter: Method execution failed:

262. com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

263.

264. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:98)

265. at sun.reflect.GeneratedMethodAccessor898.invoke(Unknown Source)

266. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

267. at java.lang.reflect.Method.invoke(Method.java:597)

268. at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)

269. at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)

270. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)

271. at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)

272. at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)

273. at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)

274. at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)

275. at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

276. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

277. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

278. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

279. at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:137)

280. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

281. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

282. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

283. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

284. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

285. at com.dotmarketing.filters.CacheImagesFilter.doFilter(CacheImagesFilter.java:47)

286. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

287. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

288. at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:313)

289. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

290. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

291. at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:140)

292. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

293. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

294. at com.memexonline.plugins.authentication.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:72)

295. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

296. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

297. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

298. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

299. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

300. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

301. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

302. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

303. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

304. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

305. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

306. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

307. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

308. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

309. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

310. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

311. at java.lang.Thread.run(Thread.java:662)

312. Caused by: com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

313.

314. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:226)

315. at com.dotmarketing.common.db.DotConnect.loadResults(DotConnect.java:325)

316. at com.dotmarketing.business.PermissionedWebAssetUtil.queryForAssetIds(PermissionedWebAssetUtil.java:294)

317. at com.dotmarketing.business.PermissionedWebAssetUtil.findTemplatesForLimitedUser(PermissionedWebAssetUtil.java:103)

318. at com.dotmarketing.portlets.templates.business.TemplateFactoryImpl.findTemplatesUserCanUse(TemplateFactoryImpl.java:74)

319. at com.dotmarketing.portlets.templates.business.TemplateAPIImpl.findTemplatesUserCanUse(TemplateAPIImpl.java:90)

320. at com.dotmarketing.portlets.templates.ajax.TemplateAjax.fetchTemplates(TemplateAjax.java:77)

321. ... 47 more

322. Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

323.

324. at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

325. at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

326. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

327. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

328. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

329. at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

330. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

331. at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)

332. at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)

333. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

334. at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)

335. at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)

336. at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

337. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:562)

338. at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:461)

339. at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:224)

340. ... 53 more

341. [07/11/11 18:26:52:504 UTC] WARN dwrp.BaseCallMarshaller: --Erroring: batchId[6] message[com.dotmarketing.exception.DotDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

342. ]

343. [07/11/11 18:26:52:504 UTC] WARN db.DbConnectionFactory: ---------- DBConnectionFactory: error closing the db dbconnection: jdbc/dotCMSPool ---------------

344. java.sql.SQLException: Already closed.

345. at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84)

346. at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)

347. at com.dotmarketing.db.DbConnectionFactory.closeConnection(DbConnectionFactory.java:200)

348. at com.dotmarketing.listeners.HibernateSessionsListener.requestDestroyed(HibernateSessionsListener.java:19)

349. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:204)

350. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)

351. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

352. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

353. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

354. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

355. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

356. at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

357. at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

358. at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

359. at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

360. at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

361. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

362. at java.lang.Thread.run(Thread.java:662)

363. [07/11/11 18:27:32:955 UTC] INFO cache.VirtualLinksCache: mapping: /cmsHomePage -> /home/index.dot

364. [07/11/11 18:28:33:019 UTC] ERROR viewtools.DotCMSMacroWebAPI: getTagsCount

365. [07/11/11 18:28:33:020 UTC] ERROR viewtools.DotCMSMacroWebAPI: sortAlpha

366. [07/11/11 18:28:33:047 UTC] INFO viewtools.CategoriesWebAPI: The logged in user cannot access the categories with key : event

367.

368.

----------------------------------

Carolyn

Carolyn Vincent

AIT Project Manager

410-312-7272 Ext 315

410-741-3218 (fax)

image001.gif

Jason Tesser

unread,

Nov 7, 2011, 1:59:38 PM11/7/11

to dot...@googlegroups.com

There is no folder this stuff is all data driven.

There appears to be an error in Oracle.

Do you have any plugins overriding any template code? TemplateAJAX. Maybe an old hotfix. Also check to make sure you do NOT have an old dotcms jar in WEB-INF/lib

Thanks,
Jason Tesser
dotCMS Director, Support Services
1-305-858-1422

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To post to this group, send email to dot...@googlegroups.com.
To unsubscribe from this group, send email to dotcms+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/dotcms?hl=en.

image001.gif

Nadeem Jawaid

unread,

Nov 7, 2011, 2:16:13 PM11/7/11

to dot...@googlegroups.com

I have checked the plugin folder. It has only those plugins , which we use to have from day one.

I have also checked WEBINF/lib folder , it has dotcms_1.9.3.2.jar file. Which is suppose to be the latest file.

So what do you suggest now.

--- On Mon, 11/7/11, Jason Tesser <jason...@gmail.com> wrote:

image001.gif

Jason Tesser

unread,

Nov 7, 2011, 2:36:54 PM11/7/11

to dot...@googlegroups.com

Capture the error and put in a support ticket

Thanks,
Jason Tesser
dotCMS Director, Support Services
1-305-858-1422

image001.gif

Jason Tesser

unread,

May 1, 2012, 1:12:02 PM5/1/12

to dot...@googlegroups.com

I know this post is old but for anyone who runs into the issue this is an issue with Oracle. Their is a patch for it in 11G but you can work around it using the following workaround

Add a database trigger to the Role and Policy Modeler Oracle database to set the Oracle parameter "_replace_virtual_columns=false". Run the following from a SQL*Plus session connected to the Role and Policy Modeler Oracle database with administrative privilege (that is, as SYSTEM or SYS):

-- BEGIN

CREATE OR REPLACE TRIGGER WORKAROUNDORA9965278 AFTER

LOGON ON DATABASE BEGIN

EXECUTE IMMEDIATE 'ALTER SESSION SET "_replace_virtual_columns"=false';

END;

/

-- END

Thanks,
Jason Tesser
dotCMS Director, Support Services
1-305-858-1422

image001.gif

Reply all

Reply to author

Forward