DB errors after deploying SSP

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

DB errors after deploying SSP

Santiago Gonzalez Toral
Hello,

I'm able to deploy SSP for the first time but for some reason it is not working. After I logged in using credentials admin/admin, I cannot do anything in the platform. When I do click any menu item (e.g. Manager Users, Reports, MyGPS), it just redirects me to the login screen. One thing I noticed when deploying the platform was that the postgres logs were printing statement execution errors like the following.

ERROR:  relation "up_user" does not exist at character 28
STATEMENT:  SELECT COUNT(USER_ID) FROM UP_USER
ERROR:  relation "up_dlm_evaluator_paren" does not exist
STATEMENT:  alter table UP_DLM_EVALUATOR_PAREN drop constraint FK389B659CF5644C8E
ERROR:  relation "up_dlm_evaluator_paren" does not exist
STATEMENT:  alter table UP_DLM_EVALUATOR_PAREN drop constraint FK389B659CE342C201
ERROR:  relation "up_permission_activity" does not exist
STATEMENT:  alter table UP_PERMISSION_ACTIVITY drop constraint FK120337DB4CDEE1
ERROR:  relation "up_person_attr" does not exist
STATEMENT:  alter table UP_PERSON_ATTR drop constraint FKCB32A0F787E89701
ERROR:  relation "up_person_attr_values" does not exist
STATEMENT:  alter table UP_PERSON_ATTR_VALUES drop constraint FKC6C4396A9ACCCD25
ERROR:  relation "up_portlet_cookies" does not exist
STATEMENT:  alter table UP_PORTLET_COOKIES drop constraint FK852CFF66BD9C91A9
ERROR:  relation "up_portlet_cookies" does not exist
STATEMENT:  alter table UP_PORTLET_COOKIES drop constraint FK852CFF6658E2E71A
ERROR:  relation "up_portlet_def" does not exist
STATEMENT:  alter table UP_PORTLET_DEF drop constraint FKF564C5CAC8D6888
ERROR:  relation "up_portlet_def" does not exist
STATEMENT:  alter table UP_PORTLET_DEF drop constraint FKF564C5C91ACC674
ERROR:  relation "up_portlet_def_mdata" does not exist
STATEMENT:  alter table UP_PORTLET_DEF_MDATA drop constraint FKB9A3F3D46D18AE66
ERROR:  relation "up_portlet_def_param" does not exist
STATEMENT:  alter table UP_PORTLET_DEF_PARAM drop constraint FKB9CD1ACA58338D50
ERROR:  relation "up_portlet_ent" does not exist
STATEMENT:  alter table UP_PORTLET_ENT drop constraint FKF5651425D0D9A60
ERROR:  relation "up_portlet_ent" does not exist
STATEMENT:  alter table UP_PORTLET_ENT drop constraint FKF56514291ACC674
ERROR:  relation "up_portlet_ent__states" does not exist
STATEMENT:  alter table UP_PORTLET_ENT__STATES drop constraint FKFA7A5524865EEBCA
ERROR:  relation "up_portlet_ent__states" does not exist
STATEMENT:  alter table UP_PORTLET_ENT__STATES drop constraint FKFA7A5524AC306746
ERROR:  relation "up_portlet_pref" does not exist
STATEMENT:  alter table UP_PORTLET_PREF drop constraint FKDB78E48C91ACC674
ERROR:  relation "up_portlet_pref_values" does not exist
STATEMENT:  alter table UP_PORTLET_PREF_VALUES drop constraint FK608BB435807F1BE0
ERROR:  relation "up_ss_desc_lay_attr" does not exist
STATEMENT:  alter table UP_SS_DESC_LAY_ATTR drop constraint FK46E8FB3F16314E36
ERROR:  relation "up_ss_desc_lay_attr_elms" does not exist
STATEMENT:  alter table UP_SS_DESC_LAY_ATTR_ELMS drop constraint FK8B58718D50AFA17B
ERROR:  relation "up_ss_desc_output_prop" does not exist
STATEMENT:  alter table UP_SS_DESC_OUTPUT_PROP drop constraint FKDDC8E38E16314E36
ERROR:  relation "up_ss_desc_param" does not exist
STATEMENT:  alter table UP_SS_DESC_PARAM drop constraint FKE61949DA16314E36
ERROR:  relation "up_ss_user_pref" does not exist
STATEMENT:  alter table UP_SS_USER_PREF drop constraint FK15DE561C6874C4FC
ERROR:  relation "up_ss_user_pref_lay_attr" does not exist
STATEMENT:  alter table UP_SS_USER_PREF_LAY_ATTR drop constraint FKEFD7328FC7EEEE72
ERROR:  relation "up_ss_user_pref_lay_attr_val" does not exist
STATEMENT:  alter table UP_SS_USER_PREF_LAY_ATTR_VAL drop constraint FKF4F9CD51CA16CFDD
ERROR:  relation "up_ss_user_pref_output_prop" does not exist
STATEMENT:  alter table UP_SS_USER_PREF_OUTPUT_PROP drop constraint FK7F3FAA3EC7EEEE72
ERROR:  relation "up_ss_user_pref_param" does not exist
STATEMENT:  alter table UP_SS_USER_PREF_PARAM drop constraint FK7F16D48AC7EEEE72
ERROR:  sequence "up_dlm_evaluator_seq" does not exist
STATEMENT:  drop sequence UP_DLM_EVALUATOR_SEQ
ERROR:  sequence "up_message_seq" does not exist
STATEMENT:  drop sequence UP_MESSAGE_SEQ
ERROR:  sequence "up_mutex_seq" does not exist
STATEMENT:  drop sequence UP_MUTEX_SEQ
ERROR:  sequence "up_permission_activity_seq" does not exist
STATEMENT:  drop sequence UP_PERMISSION_ACTIVITY_SEQ
ERROR:  sequence "up_permission_owner_seq" does not exist
STATEMENT:  drop sequence UP_PERMISSION_OWNER_SEQ
ERROR:  sequence "up_person_attr_seq" does not exist
STATEMENT:  drop sequence UP_PERSON_ATTR_SEQ
ERROR:  sequence "up_person_dir_seq" does not exist
STATEMENT:  drop sequence UP_PERSON_DIR_SEQ
ERROR:  sequence "up_portal_cookies_seq" does not exist
STATEMENT:  drop sequence UP_PORTAL_COOKIES_SEQ
ERROR:  sequence "up_portlet_cookies_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_COOKIES_SEQ
ERROR:  sequence "up_portlet_def_param_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_DEF_PARAM_SEQ
ERROR:  sequence "up_portlet_def_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_DEF_SEQ
ERROR:  sequence "up_portlet_ent_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_ENT_SEQ
ERROR:  sequence "up_portlet_prefs_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_PREFS_SEQ
ERROR:  sequence "up_portlet_pref_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_PREF_SEQ
ERROR:  sequence "up_portlet_type_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_TYPE_SEQ
ERROR:  sequence "up_sso_ticket_seq" does not exist
STATEMENT:  drop sequence UP_SSO_TICKET_SEQ
ERROR:  sequence "up_ss_desc_lay_attr_seq" does not exist
STATEMENT:  drop sequence UP_SS_DESC_LAY_ATTR_SEQ
ERROR:  sequence "up_ss_desc_output_prop_seq" does not exist
STATEMENT:  drop sequence UP_SS_DESC_OUTPUT_PROP_SEQ
ERROR:  sequence "up_ss_desc_param_seq" does not exist
STATEMENT:  drop sequence UP_SS_DESC_PARAM_SEQ
ERROR:  sequence "up_ss_desc_seq" does not exist
STATEMENT:  drop sequence UP_SS_DESC_SEQ
ERROR:  sequence "up_ss_user_pref_lay_attr_seq" does not exist
STATEMENT:  drop sequence UP_SS_USER_PREF_LAY_ATTR_SEQ
ERROR:  sequence "up_ss_user_pref_seq" does not exist
STATEMENT:  drop sequence UP_SS_USER_PREF_SEQ
ERROR:  sequence "up_user_fragment_sub_seq" does not exist
STATEMENT:  drop sequence UP_USER_FRAGMENT_SUB_SEQ
ERROR:  sequence "up_version_seq" does not exist
STATEMENT:  drop sequence UP_VERSION_SEQ
ERROR:  sequence "up_raw_events_seq" does not exist
STATEMENT:  drop sequence UP_RAW_EVENTS_SEQ
ERROR:  relation "up_concurrent_user_aggr" does not exist
STATEMENT:  alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE21C6A7B0CB
ERROR:  relation "up_concurrent_user_aggr" does not exist
STATEMENT:  alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE218B863C4B
ERROR:  relation "up_concurrent_user_aggr" does not exist
STATEMENT:  alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE211F78EA22
ERROR:  relation "up_concurrent_user_aggr" does not exist
STATEMENT:  alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE2163D2B8A4
ERROR:  relation "up_event_aggr_conf_groups_exc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_GROUPS_EXC drop constraint FK11F6791B986B33DD
ERROR:  relation "up_event_aggr_conf_groups_exc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_GROUPS_EXC drop constraint FK11F6791B60C93DD1
ERROR:  relation "up_event_aggr_conf_groups_inc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_GROUPS_INC drop constraint FK11F686E9986B33DD
ERROR:  relation "up_event_aggr_conf_groups_inc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_GROUPS_INC drop constraint FK11F686E960C93DD1
ERROR:  relation "up_event_aggr_conf_intrvl_exc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_INTRVL_EXC drop constraint FK1C053D2071843272
ERROR:  relation "up_event_aggr_conf_intrvl_inc" does not exist
STATEMENT:  alter table UP_EVENT_AGGR_CONF_INTRVL_INC drop constraint FK1C054AEE71843272
ERROR:  relation "up_event_session_groups" does not exist
STATEMENT:  alter table UP_EVENT_SESSION_GROUPS drop constraint FK43216B46986B33DD
ERROR:  relation "up_event_session_groups" does not exist
STATEMENT:  alter table UP_EVENT_SESSION_GROUPS drop constraint FK43216B46B5E73C4D
ERROR:  relation "up_login_event_aggr" does not exist
STATEMENT:  alter table UP_LOGIN_EVENT_AGGR drop constraint FKF2650210C6A7B0CB
ERROR:  relation "up_login_event_aggr" does not exist
STATEMENT:  alter table UP_LOGIN_EVENT_AGGR drop constraint FKF26502108B863C4B
ERROR:  relation "up_login_event_aggr" does not exist
STATEMENT:  alter table UP_LOGIN_EVENT_AGGR drop constraint FKF26502101F78EA22
ERROR:  relation "up_login_event_aggr" does not exist
STATEMENT:  alter table UP_LOGIN_EVENT_AGGR drop constraint FKF265021063D2B8A4
ERROR:  relation "up_portlet_exec_aggr" does not exist
STATEMENT:  alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B6C6A7B0CB
ERROR:  relation "up_portlet_exec_aggr" does not exist
STATEMENT:  alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B6B3AE3610
ERROR:  relation "up_portlet_exec_aggr" does not exist
STATEMENT:  alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B61F78EA22
ERROR:  relation "up_portlet_exec_aggr" does not exist
STATEMENT:  alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B663D2B8A4
ERROR:  relation "up_tab_render_aggr" does not exist
STATEMENT:  alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152CC6A7B0CB
ERROR:  relation "up_tab_render_aggr" does not exist
STATEMENT:  alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C1F78EA22
ERROR:  relation "up_tab_render_aggr" does not exist
STATEMENT:  alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C993D37F5
ERROR:  relation "up_tab_render_aggr" does not exist
STATEMENT:  alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C63D2B8A4
ERROR:  relation "up_unique_str_segment" does not exist
STATEMENT:  alter table UP_UNIQUE_STR_SEGMENT drop constraint FKB8D8E79BA702953C
ERROR:  relation "up_unique_str_segment__uids" does not exist
STATEMENT:  alter table UP_UNIQUE_STR_SEGMENT__UIDS drop constraint FK2534615E5B08F2F1
ERROR:  sequence "up_academic_term_detail_seq" does not exist
STATEMENT:  drop sequence UP_ACADEMIC_TERM_DETAIL_SEQ
ERROR:  sequence "up_aggr_group_mapping_seq" does not exist
STATEMENT:  drop sequence UP_AGGR_GROUP_MAPPING_SEQ
ERROR:  sequence "up_aggr_portlet_mapping_seq" does not exist
STATEMENT:  drop sequence UP_AGGR_PORTLET_MAPPING_SEQ
ERROR:  sequence "up_aggr_tab_mapping_seq" does not exist
STATEMENT:  drop sequence UP_AGGR_TAB_MAPPING_SEQ
ERROR:  sequence "up_concurrent_user_aggr_seq" does not exist
STATEMENT:  drop sequence UP_CONCURRENT_USER_AGGR_SEQ
ERROR:  sequence "up_date_dimension_seq" does not exist
STATEMENT:  drop sequence UP_DATE_DIMENSION_SEQ
ERROR:  sequence "up_event_aggr_conf_groups_seq" does not exist
STATEMENT:  drop sequence UP_EVENT_AGGR_CONF_GROUPS_SEQ
ERROR:  sequence "up_event_aggr_conf_intrvl_seq" does not exist
STATEMENT:  drop sequence UP_EVENT_AGGR_CONF_INTRVL_SEQ
ERROR:  sequence "up_event_aggr_status_seq" does not exist
STATEMENT:  drop sequence UP_EVENT_AGGR_STATUS_SEQ
ERROR:  sequence "up_event_session_seq" does not exist
STATEMENT:  drop sequence UP_EVENT_SESSION_SEQ
ERROR:  sequence "up_login_event_aggr_seq" does not exist
STATEMENT:  drop sequence UP_LOGIN_EVENT_AGGR_SEQ
ERROR:  sequence "up_portlet_exec_aggr_seq" does not exist
STATEMENT:  drop sequence UP_PORTLET_EXEC_AGGR_SEQ
ERROR:  sequence "up_quarter_detail_seq" does not exist
STATEMENT:  drop sequence UP_QUARTER_DETAIL_SEQ
ERROR:  sequence "up_tab_render_aggr_seq" does not exist
STATEMENT:  drop sequence UP_TAB_RENDER_AGGR_SEQ
ERROR:  sequence "up_time_dimension_seq" does not exist
STATEMENT:  drop sequence UP_TIME_DIMENSION_SEQ
ERROR:  sequence "up_unique_str_segment_seq" does not exist
STATEMENT:  drop sequence UP_UNIQUE_STR_SEGMENT_SEQ
ERROR:  sequence "up_unique_str_seq" does not exist
STATEMENT:  drop sequence UP_UNIQUE_STR_SEQ
ERROR:  syntax error at or near ")" at character 108
STATEMENT:  SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0

I'm using SSP release v2.8, and I'm obtaining this output either running initdb+deploy-ear or initportal targets.

Hope anyone can give me any suggestions of how to solve this issue.

Regards,
Santiago

--
You received this message because you are subscribed to the Google Groups "Student Success Plan Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/ssp-dev/.