DB errors after deploying SSP
7 views
Skip to first unread message
Santiago Gonzalez Toral
Nov 29, 2017, 4:17:25 PM11/29/17
to Student Success Plan Developer Community
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
Reply all
Reply to author
Forward
0 new messages