org.apache.openjpa.persistence.PersistenceException: Unknown column 't7.allowRecording' in 'field list' {prepstmnt 1773392968 SELECT t0.recording_id, t0.comment_field, t0.deleted, t0.duration, t0.name, t1.user_id, t1.activatehash, t2.adresses_id, t2.additionalname, t2.comment_field, t2.deleted, t2.email, t2.fax, t2.phone, t2.starttime, t3.state_id, t3.deleted, t3.name, t3.starttime, t3.updatetime, t2.street, t2.town, t2.updatetime, t2.zip, t1.age, t1.availible, t1.deleted, t1.externalUserId, t1.externalUserType, t1.firstname, t1.forceTimeZoneCheck, t1.language_id, t1.lastlogin, t1.lastname, t1.lasttrans, t1.level_id, t1.login, t4.om_timezone_id, t4.ical, t4.inserted, t4.jname, t4.label, t4.order_id, t1.password, t1.pictureuri, t1.regdate, t1.resethash, t1.show_contact_data, t1.show_contact_data_to_contacts, t1.starttime, t1.status, t1.title_id, t1.updatetime, t1.user_offers, t1.user_searchs, t5.user_sip_data_id, t5.authId, t5.inserted, t5.updated, t5.username, t5.userpass, t6.roomrecording_id, t6.comment_field, t6.conferencetype, t6.endtime, t7.roomclient_id, t7.allowRecording, t7.avsettings, t7.broadcast_id, t7.canDraw, t7.canGiveAudio, t7.canRemote, t7.canShare, t7.chat_user_room_id, t7.connected_since, t7.externalUserId, t7.externalUserType, t7.firstname, t7.flvRecordingId, t7.flvRecordingMetaDataId, t7.formated_date, t7.interviewPodId, t7.isBroadcasting, t7.is_chat_notification, t7.is_mod, t7.is_recording, t7.isScreenClient, t7.is_super_mod, t7.language, t7.last_login, t7.lastname, t7.mail, t7.micMuted, t7.official_code, t7.organization_id, t7.picture_uri, t7.public_sid, t7.room_enter, t7.room_recording_name, t7.room_id, t7.scope, t7.screenPublishStarted, t7.startRecording, t7.startStreaming, t7.streamPublishName, t7.streamid, t7.swfurl, t7.user_id, t7.usercolor, t7.userip, t7.username, t7.userport, t7.userpos, t7.vHeight, t7.vWidth, t7.vX, t7.vY, t7.zombieCheckFlag, t6.initwhiteboardvars_in_xml, t6.recordingname, t6.recordname, t6.roomrecordingstablestring, t8.rooms_id, t8.allow_recording, t8.allow_user_questions, t8.appointMent, t8.comment_field, t8.conference_pin, t8.deleted, t8.demo_time, t8.externalRoomId, t8.externalRoomType, t8.hide_top_bar, t8.is_audio_only, t8.is_closed, t8.isdemoroom, t8.ismoderatedroom, t8.ispublic, t8.name, t8.numberOfPartizipants, t8.owner_id, t8.redirect_url, t9.roomtypes_id, t9.deleted, t9.name, t9.starttime, t9.updatetime, t8.sip_number, t8.starttime, t8.updatetime, t8.wait_for_recording, t10.roomclient_id, t10.allowRecording, t10.avsettings, t10.broadcast_id, t10.canDraw, t10.canGiveAudio, t10.canRemote, t10.canShare, t10.chat_user_room_id, t10.connected_since, t10.externalUserId, t10.externalUserType, t10.firstname, t10.flvRecordingId, t10.flvRecordingMetaDataId, t10.formated_date, t10.interviewPodId, t10.isBroadcasting, t10.is_chat_notification, t10.is_mod, t10.is_recording, t10.isScreenClient, t10.is_super_mod, t10.language, t10.last_login, t10.lastname, t10.mail, t10.micMuted, t10.official_code, t10.organization_id, t10.picture_uri, t10.public_sid, t10.room_enter, t10.room_recording_name, t10.room_id, t10.scope, t10.screenPublishStarted, t10.startRecording, t10.startStreaming, t10.streamPublishName, t10.streamid, t10.swfurl, t10.user_id, t10.usercolor, t10.userip, t10.username, t10.userport, t10.userpos, t10.vHeight, t10.vWidth, t10.vX, t10.vY, t10.zombieCheckFlag, t6.starttime, t11.rooms_id, t11.allow_recording, t11.allow_user_questions, t11.appointMent, t11.comment_field, t11.conference_pin, t11.deleted, t11.demo_time, t11.externalRoomId, t11.externalRoomType, t11.hide_top_bar, t11.is_audio_only, t11.is_closed, t11.isdemoroom, t11.ismoderatedroom, t11.ispublic, t11.name, t11.numberOfPartizipants, t11.owner_id, t11.redirect_url, t11.roomtypes_id, t11.sip_number, t11.starttime, t11.updatetime, t11.wait_for_recording, t0.starttime, t0.updatetime, t0.whiteboardconverted, t0.xmlString FROM recording t0 LEFT OUTER JOIN users t1 ON t0.recordedby = t1.user_id LEFT OUTER JOIN roomrecording t6 ON t0.roomrecordingId = t6.roomrecording_id LEFT OUTER JOIN rooms t11 ON t0.rooms = t11.rooms_id LEFT OUTER JOIN adresses t2 ON t1.adresses_id = t2.adresses_id LEFT OUTER JOIN om_timezone t4 ON t1.omtimezoneId = t4.om_timezone_id LEFT OUTER JOIN user_sip_data t5 ON t1.userSipDataId = t5.user_sip_data_id LEFT OUTER JOIN roomclient t7 ON t6.enduser_roomclient_id = t7.roomclient_id LEFT OUTER JOIN rooms t8 ON t6.room_setup = t8.rooms_id LEFT OUTER JOIN roomclient t10 ON t6.startedby_roomclient_id = t10.roomclient_id LEFT OUTER JOIN states t3 ON t2.state_id = t3.state_id LEFT OUTER JOIN roomtypes t9 ON t8.roomtypes_id = t9.roomtypes_id WHERE (t0.whiteboardconverted = ? AND t0.deleted <> ?) [params=?, ?]} [code=1054, state=42S22]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Lee Daniel, 1 year ago
Unknown column 't7.allowRecording' in 'field list' {prepstmnt 1773392968 SELECT t0.recording_id, t0.comment_field, t0.deleted, t0.duration, t0.name, t1.user_id, t1.activatehash, t2.adresses_id, t2.additionalname, t2.comment_field, t2.deleted, t2
via Stack Overflow by veote
, 2 years ago
DSRA9500E: Negative values are not allowed for fetch size. FailedObject: SELECT u FROM user_table u WHERE lower(u.username) = lower(:name) [java.lang.String]
via Stack Overflow by Vishal Nadikudi
, 2 years ago
The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 32 seconds BEA1-00003CA049AA50DAD185]'. No further JDBC access is allowed within this transaction.
via nabble.com by Unknown author, 2 years ago
ORA-00936: missing expression {prepstmnt 328799129 SELECT t0.ID, t1.EXPORT_ORDER_ID, t1.VM_ID, t2.ID, t2.NAME     FROM INFOP_SYSTEM.EXPORT_ORDER t0,         INFOP_SYSTEM.EXPORT_ORDER_VM t1,         INFOP_SYSTEM.EXPORT_ORDER t2     WHERE (t0.ID
via openjpa-users by Angelo K. Huang, 6 months ago
Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0
via openjpa-users by Trenton D. Adams, 6 months ago
Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time
org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown column 't7.allowRecording' in 'field list' {prepstmnt 1773392968 SELECT t0.recording_id, t0.comment_field, t0.deleted, t0.duration, t0.name, t1.user_id, t1.activatehash, t2.adresses_id, t2.additionalname, t2.comment_field, t2.deleted, t2.email, t2.fax, t2.phone, t2.starttime, t3.state_id, t3.deleted, t3.name, t3.starttime, t3.updatetime, t2.street, t2.town, t2.updatetime, t2.zip, t1.age, t1.availible, t1.deleted, t1.externalUserId, t1.externalUserType, t1.firstname, t1.forceTimeZoneCheck, t1.language_id, t1.lastlogin, t1.lastname, t1.lasttrans, t1.level_id, t1.login, t4.om_timezone_id, t4.ical, t4.inserted, t4.jname, t4.label, t4.order_id, t1.password, t1.pictureuri, t1.regdate, t1.resethash, t1.show_contact_data, t1.show_contact_data_to_contacts, t1.starttime, t1.status, t1.title_id, t1.updatetime, t1.user_offers, t1.user_searchs, t5.user_sip_data_id, t5.authId, t5.inserted, t5.updated, t5.username, t5.userpass, t6.roomrecording_id, t6.comment_field, t6.conferencetype, t6.endtime, t7.roomclient_id, t7.allowRecording, t7.avsettings, t7.broadcast_id, t7.canDraw, t7.canGiveAudio, t7.canRemote, t7.canShare, t7.chat_user_room_id, t7.connected_since, t7.externalUserId, t7.externalUserType, t7.firstname, t7.flvRecordingId, t7.flvRecordingMetaDataId, t7.formated_date, t7.interviewPodId, t7.isBroadcasting, t7.is_chat_notification, t7.is_mod, t7.is_recording, t7.isScreenClient, t7.is_super_mod, t7.language, t7.last_login, t7.lastname, t7.mail, t7.micMuted, t7.official_code, t7.organization_id, t7.picture_uri, t7.public_sid, t7.room_enter, t7.room_recording_name, t7.room_id, t7.scope, t7.screenPublishStarted, t7.startRecording, t7.startStreaming, t7.streamPublishName, t7.streamid, t7.swfurl, t7.user_id, t7.usercolor, t7.userip, t7.username, t7.userport, t7.userpos, t7.vHeight, t7.vWidth, t7.vX, t7.vY, t7.zombieCheckFlag, t6.initwhiteboardvars_in_xml, t6.recordingname, t6.recordname, t6.roomrecordingstablestring, t8.rooms_id, t8.allow_recording, t8.allow_user_questions, t8.appointMent, t8.comment_field, t8.conference_pin, t8.deleted, t8.demo_time, t8.externalRoomId, t8.externalRoomType, t8.hide_top_bar, t8.is_audio_only, t8.is_closed, t8.isdemoroom, t8.ismoderatedroom, t8.ispublic, t8.name, t8.numberOfPartizipants, t8.owner_id, t8.redirect_url, t9.roomtypes_id, t9.deleted, t9.name, t9.starttime, t9.updatetime, t8.sip_number, t8.starttime, t8.updatetime, t8.wait_for_recording, t10.roomclient_id, t10.allowRecording, t10.avsettings, t10.broadcast_id, t10.canDraw, t10.canGiveAudio, t10.canRemote, t10.canShare, t10.chat_user_room_id, t10.connected_since, t10.externalUserId, t10.externalUserType, t10.firstname, t10.flvRecordingId, t10.flvRecordingMetaDataId, t10.formated_date, t10.interviewPodId, t10.isBroadcasting, t10.is_chat_notification, t10.is_mod, t10.is_recording, t10.isScreenClient, t10.is_super_mod, t10.language, t10.last_login, t10.lastname, t10.mail, t10.micMuted, t10.official_code, t10.organization_id, t10.picture_uri, t10.public_sid, t10.room_enter, t10.room_recording_name, t10.room_id, t10.scope, t10.screenPublishStarted, t10.startRecording, t10.startStreaming, t10.streamPublishName, t10.streamid, t10.swfurl, t10.user_id, t10.usercolor, t10.userip, t10.username, t10.userport, t10.userpos, t10.vHeight, t10.vWidth, t10.vX, t10.vY, t10.zombieCheckFlag, t6.starttime, t11.rooms_id, t11.allow_recording, t11.allow_user_questions, t11.appointMent, t11.comment_field, t11.conference_pin, t11.deleted, t11.demo_time, t11.externalRoomId, t11.externalRoomType, t11.hide_top_bar, t11.is_audio_only, t11.is_closed, t11.isdemoroom, t11.ismoderatedroom, t11.ispublic, t11.name, t11.numberOfPartizipants, t11.owner_id, t11.redirect_url, t11.roomtypes_id, t11.sip_number, t11.starttime, t11.updatetime, t11.wait_for_recording, t0.starttime, t0.updatetime, t0.whiteboardconverted, t0.xmlString FROM recording t0 LEFT OUTER JOIN users t1 ON t0.recordedby = t1.user_id LEFT OUTER JOIN roomrecording t6 ON t0.roomrecordingId = t6.roomrecording_id LEFT OUTER JOIN rooms t11 ON t0.rooms = t11.rooms_id LEFT OUTER JOIN adresses t2 ON t1.adresses_id = t2.adresses_id LEFT OUTER JOIN om_timezone t4 ON t1.omtimezoneId = t4.om_timezone_id LEFT OUTER JOIN user_sip_data t5 ON t1.userSipDataId = t5.user_sip_data_id LEFT OUTER JOIN roomclient t7 ON t6.enduser_roomclient_id = t7.roomclient_id LEFT OUTER JOIN rooms t8 ON t6.room_setup = t8.rooms_id LEFT OUTER JOIN roomclient t10 ON t6.startedby_roomclient_id = t10.roomclient_id LEFT OUTER JOIN states t3 ON t2.state_id = t3.state_id LEFT OUTER JOIN roomtypes t9 ON t8.roomtypes_id = t9.roomtypes_id WHERE (t0.whiteboardconverted = ? AND t0.deleted <> ?) [params=?, ?]} [code=1054, state=42S22]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1183)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:284)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1785)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:274)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:391)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
at org.apache.openjpa.datacache.QueryCacheStoreQuery$CachingResultObjectProvider.open(QueryCacheStoreQuery.java:644)
at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:34)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:305)
at org.openmeetings.app.data.record.dao.RecordingDaoImpl.getRecordingWhiteboardToConvert(RecordingDaoImpl.java:95)
at org.openmeetings.app.data.record.dao.RecordingDaoImpl$$FastClassByCGLIB$$156bc05.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.openmeetings.app.data.record.dao.RecordingDaoImpl$$EnhancerByCGLIB$$8930733.getRecordingWhiteboardToConvert()
at org.openmeetings.app.data.record.WhiteboardConvertionJobManager.initJobs(WhiteboardConvertionJobManager.java:86)
at org.openmeetings.app.quartz.scheduler.RecordingJob.doIt(RecordingJob.java:18)
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:597)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)

Users with the same issue

60 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.