API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 26th, 2017
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.74 KB | None | 0 0
raw download clone embed print report
  1. ERROR: relation "up_user" does not exist at character 28
  2. STATEMENT: SELECT COUNT(USER_ID) FROM UP_USER
  3. ERROR: relation "up_dlm_evaluator_paren" does not exist
  4. STATEMENT: alter table UP_DLM_EVALUATOR_PAREN drop constraint FK389B659CF5644C8E
  5. ERROR: relation "up_dlm_evaluator_paren" does not exist
  6. STATEMENT: alter table UP_DLM_EVALUATOR_PAREN drop constraint FK389B659CE342C201
  7. ERROR: relation "up_permission_activity" does not exist
  8. STATEMENT: alter table UP_PERMISSION_ACTIVITY drop constraint FK120337DB4CDEE1
  9. ERROR: relation "up_person_attr" does not exist
  10. STATEMENT: alter table UP_PERSON_ATTR drop constraint FKCB32A0F787E89701
  11. ERROR: relation "up_person_attr_values" does not exist
  12. STATEMENT: alter table UP_PERSON_ATTR_VALUES drop constraint FKC6C4396A9ACCCD25
  13. ERROR: relation "up_portlet_cookies" does not exist
  14. STATEMENT: alter table UP_PORTLET_COOKIES drop constraint FK852CFF66BD9C91A9
  15. ERROR: relation "up_portlet_cookies" does not exist
  16. STATEMENT: alter table UP_PORTLET_COOKIES drop constraint FK852CFF6658E2E71A
  17. ERROR: relation "up_portlet_def" does not exist
  18. STATEMENT: alter table UP_PORTLET_DEF drop constraint FKF564C5CAC8D6888
  19. ERROR: relation "up_portlet_def" does not exist
  20. STATEMENT: alter table UP_PORTLET_DEF drop constraint FKF564C5C91ACC674
  21. ERROR: relation "up_portlet_def_mdata" does not exist
  22. STATEMENT: alter table UP_PORTLET_DEF_MDATA drop constraint FKB9A3F3D46D18AE66
  23. ERROR: relation "up_portlet_def_param" does not exist
  24. STATEMENT: alter table UP_PORTLET_DEF_PARAM drop constraint FKB9CD1ACA58338D50
  25. ERROR: relation "up_portlet_ent" does not exist
  26. STATEMENT: alter table UP_PORTLET_ENT drop constraint FKF5651425D0D9A60
  27. ERROR: relation "up_portlet_ent" does not exist
  28. STATEMENT: alter table UP_PORTLET_ENT drop constraint FKF56514291ACC674
  29. ERROR: relation "up_portlet_ent__states" does not exist
  30. STATEMENT: alter table UP_PORTLET_ENT__STATES drop constraint FKFA7A5524865EEBCA
  31. ERROR: relation "up_portlet_ent__states" does not exist
  32. STATEMENT: alter table UP_PORTLET_ENT__STATES drop constraint FKFA7A5524AC306746
  33. ERROR: relation "up_portlet_pref" does not exist
  34. STATEMENT: alter table UP_PORTLET_PREF drop constraint FKDB78E48C91ACC674
  35. ERROR: relation "up_portlet_pref_values" does not exist
  36. STATEMENT: alter table UP_PORTLET_PREF_VALUES drop constraint FK608BB435807F1BE0
  37. ERROR: relation "up_ss_desc_lay_attr" does not exist
  38. STATEMENT: alter table UP_SS_DESC_LAY_ATTR drop constraint FK46E8FB3F16314E36
  39. ERROR: relation "up_ss_desc_lay_attr_elms" does not exist
  40. STATEMENT: alter table UP_SS_DESC_LAY_ATTR_ELMS drop constraint FK8B58718D50AFA17B
  41. ERROR: relation "up_ss_desc_output_prop" does not exist
  42. STATEMENT: alter table UP_SS_DESC_OUTPUT_PROP drop constraint FKDDC8E38E16314E36
  43. ERROR: relation "up_ss_desc_param" does not exist
  44. STATEMENT: alter table UP_SS_DESC_PARAM drop constraint FKE61949DA16314E36
  45. ERROR: relation "up_ss_user_pref" does not exist
  46. STATEMENT: alter table UP_SS_USER_PREF drop constraint FK15DE561C6874C4FC
  47. ERROR: relation "up_ss_user_pref_lay_attr" does not exist
  48. STATEMENT: alter table UP_SS_USER_PREF_LAY_ATTR drop constraint FKEFD7328FC7EEEE72
  49. ERROR: relation "up_ss_user_pref_lay_attr_val" does not exist
  50. STATEMENT: alter table UP_SS_USER_PREF_LAY_ATTR_VAL drop constraint FKF4F9CD51CA16CFDD
  51. ERROR: relation "up_ss_user_pref_output_prop" does not exist
  52. STATEMENT: alter table UP_SS_USER_PREF_OUTPUT_PROP drop constraint FK7F3FAA3EC7EEEE72
  53. ERROR: relation "up_ss_user_pref_param" does not exist
  54. STATEMENT: alter table UP_SS_USER_PREF_PARAM drop constraint FK7F16D48AC7EEEE72
  55. ERROR: sequence "up_dlm_evaluator_seq" does not exist
  56. STATEMENT: drop sequence UP_DLM_EVALUATOR_SEQ
  57. ERROR: sequence "up_message_seq" does not exist
  58. STATEMENT: drop sequence UP_MESSAGE_SEQ
  59. ERROR: sequence "up_mutex_seq" does not exist
  60. STATEMENT: drop sequence UP_MUTEX_SEQ
  61. ERROR: sequence "up_permission_activity_seq" does not exist
  62. STATEMENT: drop sequence UP_PERMISSION_ACTIVITY_SEQ
  63. ERROR: sequence "up_permission_owner_seq" does not exist
  64. STATEMENT: drop sequence UP_PERMISSION_OWNER_SEQ
  65. ERROR: sequence "up_person_attr_seq" does not exist
  66. STATEMENT: drop sequence UP_PERSON_ATTR_SEQ
  67. ERROR: sequence "up_person_dir_seq" does not exist
  68. STATEMENT: drop sequence UP_PERSON_DIR_SEQ
  69. ERROR: sequence "up_portal_cookies_seq" does not exist
  70. STATEMENT: drop sequence UP_PORTAL_COOKIES_SEQ
  71. ERROR: sequence "up_portlet_cookies_seq" does not exist
  72. STATEMENT: drop sequence UP_PORTLET_COOKIES_SEQ
  73. ERROR: sequence "up_portlet_def_param_seq" does not exist
  74. STATEMENT: drop sequence UP_PORTLET_DEF_PARAM_SEQ
  75. ERROR: sequence "up_portlet_def_seq" does not exist
  76. STATEMENT: drop sequence UP_PORTLET_DEF_SEQ
  77. ERROR: sequence "up_portlet_ent_seq" does not exist
  78. STATEMENT: drop sequence UP_PORTLET_ENT_SEQ
  79. ERROR: sequence "up_portlet_prefs_seq" does not exist
  80. STATEMENT: drop sequence UP_PORTLET_PREFS_SEQ
  81. ERROR: sequence "up_portlet_pref_seq" does not exist
  82. STATEMENT: drop sequence UP_PORTLET_PREF_SEQ
  83. ERROR: sequence "up_portlet_type_seq" does not exist
  84. STATEMENT: drop sequence UP_PORTLET_TYPE_SEQ
  85. ERROR: sequence "up_sso_ticket_seq" does not exist
  86. STATEMENT: drop sequence UP_SSO_TICKET_SEQ
  87. ERROR: sequence "up_ss_desc_lay_attr_seq" does not exist
  88. STATEMENT: drop sequence UP_SS_DESC_LAY_ATTR_SEQ
  89. ERROR: sequence "up_ss_desc_output_prop_seq" does not exist
  90. STATEMENT: drop sequence UP_SS_DESC_OUTPUT_PROP_SEQ
  91. ERROR: sequence "up_ss_desc_param_seq" does not exist
  92. STATEMENT: drop sequence UP_SS_DESC_PARAM_SEQ
  93. ERROR: sequence "up_ss_desc_seq" does not exist
  94. STATEMENT: drop sequence UP_SS_DESC_SEQ
  95. ERROR: sequence "up_ss_user_pref_lay_attr_seq" does not exist
  96. STATEMENT: drop sequence UP_SS_USER_PREF_LAY_ATTR_SEQ
  97. ERROR: sequence "up_ss_user_pref_seq" does not exist
  98. STATEMENT: drop sequence UP_SS_USER_PREF_SEQ
  99. ERROR: sequence "up_user_fragment_sub_seq" does not exist
  100. STATEMENT: drop sequence UP_USER_FRAGMENT_SUB_SEQ
  101. ERROR: sequence "up_version_seq" does not exist
  102. STATEMENT: drop sequence UP_VERSION_SEQ
  103. ERROR: sequence "up_raw_events_seq" does not exist
  104. STATEMENT: drop sequence UP_RAW_EVENTS_SEQ
  105. ERROR: relation "up_concurrent_user_aggr" does not exist
  106. STATEMENT: alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE21C6A7B0CB
  107. ERROR: relation "up_concurrent_user_aggr" does not exist
  108. STATEMENT: alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE218B863C4B
  109. ERROR: relation "up_concurrent_user_aggr" does not exist
  110. STATEMENT: alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE211F78EA22
  111. ERROR: relation "up_concurrent_user_aggr" does not exist
  112. STATEMENT: alter table UP_CONCURRENT_USER_AGGR drop constraint FK5769BE2163D2B8A4
  113. ERROR: relation "up_event_aggr_conf_groups_exc" does not exist
  114. STATEMENT: alter table UP_EVENT_AGGR_CONF_GROUPS_EXC drop constraint FK11F6791B986B33DD
  115. ERROR: relation "up_event_aggr_conf_groups_exc" does not exist
  116. STATEMENT: alter table UP_EVENT_AGGR_CONF_GROUPS_EXC drop constraint FK11F6791B60C93DD1
  117. ERROR: relation "up_event_aggr_conf_groups_inc" does not exist
  118. STATEMENT: alter table UP_EVENT_AGGR_CONF_GROUPS_INC drop constraint FK11F686E9986B33DD
  119. ERROR: relation "up_event_aggr_conf_groups_inc" does not exist
  120. STATEMENT: alter table UP_EVENT_AGGR_CONF_GROUPS_INC drop constraint FK11F686E960C93DD1
  121. ERROR: relation "up_event_aggr_conf_intrvl_exc" does not exist
  122. STATEMENT: alter table UP_EVENT_AGGR_CONF_INTRVL_EXC drop constraint FK1C053D2071843272
  123. ERROR: relation "up_event_aggr_conf_intrvl_inc" does not exist
  124. STATEMENT: alter table UP_EVENT_AGGR_CONF_INTRVL_INC drop constraint FK1C054AEE71843272
  125. ERROR: relation "up_event_session_groups" does not exist
  126. STATEMENT: alter table UP_EVENT_SESSION_GROUPS drop constraint FK43216B46986B33DD
  127. ERROR: relation "up_event_session_groups" does not exist
  128. STATEMENT: alter table UP_EVENT_SESSION_GROUPS drop constraint FK43216B46B5E73C4D
  129. ERROR: relation "up_login_event_aggr" does not exist
  130. STATEMENT: alter table UP_LOGIN_EVENT_AGGR drop constraint FKF2650210C6A7B0CB
  131. ERROR: relation "up_login_event_aggr" does not exist
  132. STATEMENT: alter table UP_LOGIN_EVENT_AGGR drop constraint FKF26502108B863C4B
  133. ERROR: relation "up_login_event_aggr" does not exist
  134. STATEMENT: alter table UP_LOGIN_EVENT_AGGR drop constraint FKF26502101F78EA22
  135. ERROR: relation "up_login_event_aggr" does not exist
  136. STATEMENT: alter table UP_LOGIN_EVENT_AGGR drop constraint FKF265021063D2B8A4
  137. ERROR: relation "up_portlet_exec_aggr" does not exist
  138. STATEMENT: alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B6C6A7B0CB
  139. ERROR: relation "up_portlet_exec_aggr" does not exist
  140. STATEMENT: alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B6B3AE3610
  141. ERROR: relation "up_portlet_exec_aggr" does not exist
  142. STATEMENT: alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B61F78EA22
  143. ERROR: relation "up_portlet_exec_aggr" does not exist
  144. STATEMENT: alter table UP_PORTLET_EXEC_AGGR drop constraint FK9FED29B663D2B8A4
  145. ERROR: relation "up_tab_render_aggr" does not exist
  146. STATEMENT: alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152CC6A7B0CB
  147. ERROR: relation "up_tab_render_aggr" does not exist
  148. STATEMENT: alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C1F78EA22
  149. ERROR: relation "up_tab_render_aggr" does not exist
  150. STATEMENT: alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C993D37F5
  151. ERROR: relation "up_tab_render_aggr" does not exist
  152. STATEMENT: alter table UP_TAB_RENDER_AGGR drop constraint FK7DB5152C63D2B8A4
  153. ERROR: relation "up_unique_str_segment" does not exist
  154. STATEMENT: alter table UP_UNIQUE_STR_SEGMENT drop constraint FKB8D8E79BA702953C
  155. ERROR: relation "up_unique_str_segment__uids" does not exist
  156. STATEMENT: alter table UP_UNIQUE_STR_SEGMENT__UIDS drop constraint FK2534615E5B08F2F1
  157. ERROR: sequence "up_academic_term_detail_seq" does not exist
  158. STATEMENT: drop sequence UP_ACADEMIC_TERM_DETAIL_SEQ
  159. ERROR: sequence "up_aggr_group_mapping_seq" does not exist
  160. STATEMENT: drop sequence UP_AGGR_GROUP_MAPPING_SEQ
  161. ERROR: sequence "up_aggr_portlet_mapping_seq" does not exist
  162. STATEMENT: drop sequence UP_AGGR_PORTLET_MAPPING_SEQ
  163. ERROR: sequence "up_aggr_tab_mapping_seq" does not exist
  164. STATEMENT: drop sequence UP_AGGR_TAB_MAPPING_SEQ
  165. ERROR: sequence "up_concurrent_user_aggr_seq" does not exist
  166. STATEMENT: drop sequence UP_CONCURRENT_USER_AGGR_SEQ
  167. ERROR: sequence "up_date_dimension_seq" does not exist
  168. STATEMENT: drop sequence UP_DATE_DIMENSION_SEQ
  169. ERROR: sequence "up_event_aggr_conf_groups_seq" does not exist
  170. STATEMENT: drop sequence UP_EVENT_AGGR_CONF_GROUPS_SEQ
  171. ERROR: sequence "up_event_aggr_conf_intrvl_seq" does not exist
  172. STATEMENT: drop sequence UP_EVENT_AGGR_CONF_INTRVL_SEQ
  173. ERROR: sequence "up_event_aggr_status_seq" does not exist
  174. STATEMENT: drop sequence UP_EVENT_AGGR_STATUS_SEQ
  175. ERROR: sequence "up_event_session_seq" does not exist
  176. STATEMENT: drop sequence UP_EVENT_SESSION_SEQ
  177. ERROR: sequence "up_login_event_aggr_seq" does not exist
  178. STATEMENT: drop sequence UP_LOGIN_EVENT_AGGR_SEQ
  179. ERROR: sequence "up_portlet_exec_aggr_seq" does not exist
  180. STATEMENT: drop sequence UP_PORTLET_EXEC_AGGR_SEQ
  181. ERROR: sequence "up_quarter_detail_seq" does not exist
  182. STATEMENT: drop sequence UP_QUARTER_DETAIL_SEQ
  183. ERROR: sequence "up_tab_render_aggr_seq" does not exist
  184. STATEMENT: drop sequence UP_TAB_RENDER_AGGR_SEQ
  185. ERROR: sequence "up_time_dimension_seq" does not exist
  186. STATEMENT: drop sequence UP_TIME_DIMENSION_SEQ
  187. ERROR: sequence "up_unique_str_segment_seq" does not exist
  188. STATEMENT: drop sequence UP_UNIQUE_STR_SEGMENT_SEQ
  189. ERROR: sequence "up_unique_str_seq" does not exist
  190. STATEMENT: drop sequence UP_UNIQUE_STR_SEQ
  191. ERROR: syntax error at or near ")" at character 108
  192. 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!