xwikisas / application-meeting

Application to handle meetings
0 stars 7 forks source link

Error when editing a meeting on Oracle Database #22

Open ilieandriuta opened 6 years ago

ilieandriuta commented 6 years ago

STEPS TO REPRODUCE

Preconditions: An user is already created (e.g. U1).

  1. Login with Admin
  2. Go to Meeting App from Apps Panel
  3. Click on 'Create'
  4. Type a name for the new meeting event
  5. Select 'Meeting' page type
  6. Click 'Create'
  7. Pick a leader (e.g. Admin), at least one participating member (e.g. U1) and a participating group (e.g. XWikiAllGroup)
  8. Click 'Save & View'
  9. Click 'Edit'

EXPECTED RESULTS

The meeting's page enters in edit mode and the members and groups names are displayed properly.

ACTUAL RESULTS

When entered in edit mode, the members and the groups names have 'XWiki.' prefix and the following error is displayed in console:

2018-08-07 15:44:35,942 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/Meeting.Code.MeetingClass/properties/participants/values?fp=XWiki.U1&limit=10] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
2018-08-07 15:44:35,942 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/Meeting.Code.MeetingClass/properties/participants/values?fp=XWiki.U1&limit=10] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB

2018-08-07 15:44:35,953 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/Meeting.Code.MeetingClass/properties/groups/values?fp=XWiki.XWikiAllGroup&limit=10] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
2018-08-07 15:44:35,953 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/Meeting.Code.MeetingClass/properties/groups/values?fp=XWiki.XWikiAllGroup&limit=10] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB

Meeting create screenshot: meetings_pro_oracle_create_screen

Meeting edit screenshot: meetings_pro_oracle_edit_screen

Please also see: https://jira.xwiki.org/browse/XWIKI-14634