Uploaded image for project: 'Gateway'
  1. Gateway
  2. GTWY-948

Viewing a dataset is triggering an incorrect update on the resource table.

XMLWordPrintable

    • Icon: Defect Defect
    • Resolution: Done
    • Icon: Blocker Blocker
    • 1.0.0-ALPHA
    • 1.0.0-M2
    • Domain Model
    • None

      Not sure if it is related but it is showing up after the clickstream insert.

      Queries perfomed during a view dataset operation:

      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select useragent0_.id as id65_, useragent0_.version as version65_, useragent0_.name as name65_, useragent0_.ignore as ignore65_, useragent0_.user_agent_type_id as user5_65_ from metrics.user_agent useragent0_ where useragent0_.name=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select datasetimp0_.id as id52_10_, datasetimp0_1_.version as version52_10_, datasetimp0_1_.name as name52_10_, datasetimp0_1_.description as descript4_52_10_, datasetimp0_1_.date_created as date5_52_10_, datasetimp0_1_.date_updated as date6_52_10_, datasetimp0_1_.type_id as type7_52_10_, datasetimp0_.parent_gateway_id as parent2_92_10_, datasetimp0_.parent_dataset_id as parent3_92_10_, datasetimp0_.parent_display_order as parent4_92_10_, datasetimp0_.dataset_state_id as dataset5_92_10_, datasetimp0_.model_component_id as model6_92_10_, datasetimp0_.license_id as license7_92_10_, datasetimp0_.metadata_profile_id as metadata8_92_10_, (SELECT count(metadata.dataset.id) from metadata.dataset where metadata.dataset.parent_dataset_id = datasetimp0_.id ) as formula1_10_, (SELECT count(metadata.logical_file.id) from metadata.logical_file where metadata.logical_file.dataset_id = datasetimp0_.id) as formula2_10_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, gatewayimp1_.administrator_personal as adminis13_0_0_, gatewayimp1_.administrator_email as adminis14_0_0_, gatewayimp1_.myproxy_endpoint as myproxy15_0_0_, gatewayimp1_.idp_endpoint as idp16_0_0_, gatewayimp1_.metadata_profile_id as metadata17_0_0_, metadatapr2_.id as id50_1_, metadatapr2_.version as version50_1_, metadatapr2_.profile_name as profile3_50_1_, descriptiv3_.id as id35_2_, descriptiv3_.language as language35_2_, descriptiv3_.data_product_type_id as data3_35_2_, descriptiv3_.data_type_id as data4_35_2_, descriptiv3_.physical_domain_id as physical5_35_2_, descriptiv3_.resolution_type_id as resolution6_35_2_, descriptiv3_.dataset_progress_id as dataset7_35_2_, descriptiv3_.time_frequency_id as time8_35_2_, descriptiv3_1_.cadis_metadata_profile_name as cadis2_108_2_, descriptiv3_1_.cadis_metadata_profile_version as cadis3_108_2_, descriptiv3_1_.cadis_metadata_profile_creation_date as cadis4_108_2_, descriptiv3_1_.cadis_metadata_profile_revision_date as cadis5_108_2_, descriptiv3_1_.cadis_resolution_type_id as cadis6_108_2_, descriptiv3_1_.idn_node as idn7_108_2_, descriptiv3_1_.grant_number as grant8_108_2_, descriptiv3_1_.spatial_resolution as spatial9_108_2_, descriptiv3_1_.read_me_file as read10_108_2_, case when descriptiv3_1_.id is not null then 1 when descriptiv3_.id is not null then 0 end as clazz_2_, dataproduc4_.id as id32_3_, dataproduc4_.version as version32_3_, dataproduc4_.name as name32_3_, dataproduc4_.description as descript4_32_3_, physicaldo5_.id as id51_4_, physicaldo5_.version as version51_4_, physicaldo5_.name as name51_4_, timefreque6_.id as id59_5_, timefreque6_.version as version59_5_, timefreque6_.name as name59_5_, timefreque6_.description as descript4_59_5_, geophysica7_.id as id40_6_, geophysica7_.grid_id as grid2_40_6_, gridimpl8_.id as id43_7_, gridimpl8_.version as version43_7_, gridimpl8_.name as name43_7_, gridimpl8_.description as descript4_43_7_, softwarepr9_.id as id55_8_, softwarepr9_.software_version as software2_55_8_, metadatapr10_.id as id50_9_, metadatapr10_.version as version50_9_, metadatapr10_.profile_name as profile3_50_9_ from metadata.dataset datasetimp0_ inner join metadata.resource datasetimp0_1_ on datasetimp0_.id=datasetimp0_1_.id left outer join metadata.gateway gatewayimp1_ on datasetimp0_.parent_gateway_id=gatewayimp1_.id left outer join metadata.metadata_profile metadatapr2_ on gatewayimp1_.metadata_profile_id=metadatapr2_.id inner join metadata.descriptive_metadata descriptiv3_ on datasetimp0_.id=descriptiv3_.id left outer join metadata.cadis_descriptive_metadata descriptiv3_1_ on descriptiv3_.id=descriptiv3_1_.id left outer join metadata.data_product_type dataproduc4_ on descriptiv3_.data_product_type_id=dataproduc4_.id left outer join metadata.physical_domain physicaldo5_ on descriptiv3_.physical_domain_id=physicaldo5_.id left outer join metadata.time_frequency timefreque6_ on descriptiv3_.time_frequency_id=timefreque6_.id left outer join metadata.geophysical_properties geophysica7_ on datasetimp0_.id=geophysica7_.id left outer join metadata.grid gridimpl8_ on geophysica7_.grid_id=gridimpl8_.id left outer join metadata.software_properties softwarepr9_ on datasetimp0_.id=softwarepr9_.id left outer join metadata.metadata_profile metadatapr10_ on datasetimp0_.metadata_profile_id=metadatapr10_.id where datasetimp0_.id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select dataformat0_.dataset_id as dataset1_1_, dataformat0_.data_format_id as data2_1_, dataformat1_.id as id31_0_, dataformat1_.version as version31_0_, dataformat1_.name as name31_0_, dataformat1_.description as descript4_31_0_ from metadata.dataset_data_format_xref dataformat0_ left outer join metadata.data_format dataformat1_ on dataformat0_.data_format_id=dataformat1_.id where dataformat0_.dataset_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select topicsrefe0_.dataset_id as dataset2_1_, topicsrefe0_.topic_id as topic1_1_, topicimpl1_.id as id60_0_, topicimpl1_.version as version60_0_, topicimpl1_.name as name60_0_, topicimpl1_.taxonomy_id as taxonomy4_60_0_ from metadata.dataset_topic_xref topicsrefe0_ left outer join metadata.topic topicimpl1_ on topicsrefe0_.topic_id=topicimpl1_.id where topicsrefe0_.dataset_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select typedconta0_.dataset_id as dataset1_0_, typedconta0_.contact_id as contact2_0_, typedconta0_.contact_type_id as contact3_0_, typedconta0_.idx_order as idx4_0_ from metadata.dataset_typed_contact typedconta0_ where typedconta0_.dataset_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select identifier0_.resource_id as resource1_0_, identifier0_.type_id as type2_0_, identifier0_.identifier as identifier0_, identifier0_.type_id as formula3_0_ from metadata.persistent_identifier identifier0_ where identifier0_.resource_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select notes0_.resource_ref as resource1_0_, notes0_.text as text0_ from metadata.note notes0_ where notes0_.resource_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select relatedlin0_.descriptive_metadata_id as descript1_0_, relatedlin0_.text as text0_, relatedlin0_.uri as uri0_, relatedlin0_.link_type_id as link4_0_, relatedlin0_.idx_order as idx5_0_ from metadata.descriptive_metadata_link relatedlin0_ where relatedlin0_.descriptive_metadata_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select count(id) from metadata.dataset_access_point where dataset_id =?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select activities0_.dataset_id as dataset2_1_, activities0_.activity_id as activity1_1_, (select distinct metadata.activity.activity_type_id from metadata.activity left outer join metadata.dataset_activity_xref on (dataset_activity_xref.activity_id = activity.id) where metadata.dataset_activity_xref.activity_id= activities0_.activity_id) as formula4_1_, activityim1_.id as id1_0_, activityim1_.version as version1_0_, activityim1_.date_created as date3_1_0_, activityim1_.date_updated as date4_1_0_, activityim1_.name as name1_0_, activityim1_.description as descript6_1_0_, activityim1_.rdf_identifier as rdf7_1_0_, activityim1_.activity_type_id as activity8_1_0_, activityim1_4_.project_url as project2_10_0_, case when activityim1_1_.id is not null then 1 when activityim1_2_.id is not null then 2 when activityim1_3_.id is not null then 3 when activityim1_4_.id is not null then 4 when activityim1_.id is not null then 0 end as clazz_0_ from metadata.dataset_activity_xref activities0_ left outer join metadata.activity activityim1_ on activities0_.activity_id=activityim1_.id left outer join metadata.ensemble activityim1_1_ on activityim1_.id=activityim1_1_.id left outer join metadata.experiment activityim1_2_ on activityim1_.id=activityim1_2_.id left outer join metadata.campaign activityim1_3_ on activityim1_.id=activityim1_3_.id left outer join metadata.project activityim1_4_ on activityim1_.id=activityim1_4_.id where activities0_.dataset_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select modelcompo0_.id as id52_1_, modelcompo0_1_.version as version52_1_, modelcompo0_1_.name as name52_1_, modelcompo0_1_.description as descript4_52_1_, modelcompo0_1_.date_created as date5_52_1_, modelcompo0_1_.date_updated as date6_52_1_, modelcompo0_1_.type_id as type7_52_1_, modelcompo0_.physical_domain_ref as physical2_95_1_, modelcompo0_.software_version as software3_95_1_, modelcompo0_.configured as configured95_1_, modelcompo0_.unconfigured_model_component_id as unconfig5_95_1_, case when modelcompo0_2_.id is not null then 5 when modelcompo0_.id is not null then 4 end as clazz_1_, physicaldo1_.id as id51_0_, physicaldo1_.version as version51_0_, physicaldo1_.name as name51_0_ from curator.model_component modelcompo0_ inner join metadata.resource modelcompo0_1_ on modelcompo0_.id=modelcompo0_1_.id left outer join curator.model modelcompo0_2_ on modelcompo0_.id=modelcompo0_2_.id left outer join metadata.physical_domain physicaldo1_ on modelcompo0_.physical_domain_ref=physicaldo1_.id where modelcompo0_.id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select children0_.parent_model_component_ref as parent1_2_, children0_.child_model_component_ref as child2_2_, modelcompo1_.id as id52_0_, modelcompo1_1_.version as version52_0_, modelcompo1_1_.name as name52_0_, modelcompo1_1_.description as descript4_52_0_, modelcompo1_1_.date_created as date5_52_0_, modelcompo1_1_.date_updated as date6_52_0_, modelcompo1_1_.type_id as type7_52_0_, modelcompo1_.physical_domain_ref as physical2_95_0_, modelcompo1_.software_version as software3_95_0_, modelcompo1_.configured as configured95_0_, modelcompo1_.unconfigured_model_component_id as unconfig5_95_0_, case when modelcompo1_2_.id is not null then 5 when modelcompo1_.id is not null then 4 end as clazz_0_, physicaldo2_.id as id51_1_, physicaldo2_.version as version51_1_, physicaldo2_.name as name51_1_ from curator.model_component_child_xref children0_ left outer join curator.model_component modelcompo1_ on children0_.child_model_component_ref=modelcompo1_.id left outer join metadata.resource modelcompo1_1_ on modelcompo1_.id=modelcompo1_1_.id left outer join curator.model modelcompo1_2_ on modelcompo1_.id=modelcompo1_2_.id left outer join metadata.physical_domain physicaldo2_ on modelcompo1_.physical_domain_ref=physicaldo2_.id where children0_.parent_model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select modelcompo0_.model_component_ref as model6_2_, modelcompo0_.id as id2_, modelcompo0_.id as id16_1_, modelcompo0_.name as name16_1_, modelcompo0_.description as descript3_16_1_, modelcompo0_.import as import16_1_, modelcompo0_.export as export16_1_, modelcompo0_.model_component_ref as model6_16_1_, modelcompo0_.units_ref as units7_16_1_, unitimpl1_.id as id45_0_, unitimpl1_.version as version45_0_, unitimpl1_.symbol as symbol45_0_, unitimpl1_.name as name45_0_, unitimpl1_.quantity as quantity45_0_ from curator.model_component_variable modelcompo0_ left outer join metadata.unit unitimpl1_ on modelcompo0_.units_ref=unitimpl1_.id where modelcompo0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select agencies0_.model_component_ref as model1_1_, agencies0_.agency_ref as agency2_1_, agency1_.id as id13_0_, agency1_.name as name13_0_, agency1_.home_page as home3_13_0_ from curator.model_component_agency_xref agencies0_ left outer join curator.agency agency1_ on agencies0_.agency_ref=agency1_.id where agencies0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select institutio0_.model_component_ref as model1_1_, institutio0_.institution_ref as institut2_1_, institutio1_.id as id15_0_, institutio1_.name as name15_0_ from curator.model_component_institution_xref institutio0_ left outer join curator.institution institutio1_ on institutio0_.institution_ref=institutio1_.id where institutio0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select computinge0_.model_component_ref as model1_1_, computinge0_.computing_environment_ref as computing2_1_, computinge1_.id as id14_0_, computinge1_.platform_ref as platform2_14_0_, computinge1_.processor_ref as processor3_14_0_, computinge1_.operating_system_ref as operating4_14_0_, computinge1_.language_compiler_ref as language5_14_0_ from curator.model_component_computing_environment_xref computinge0_ left outer join curator.computing_environment computinge1_ on computinge0_.computing_environment_ref=computinge1_.id where computinge0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select frameworks0_.model_component_ref as model1_1_, frameworks0_.model_component_framework_ref as model2_1_, modelcompo1_.id as id52_0_, modelcompo1_1_.version as version52_0_, modelcompo1_1_.name as name52_0_, modelcompo1_1_.description as descript4_52_0_, modelcompo1_1_.date_created as date5_52_0_, modelcompo1_1_.date_updated as date6_52_0_, modelcompo1_1_.type_id as type7_52_0_ from curator.model_component_model_component_framework_xref frameworks0_ left outer join curator.model_component_framework modelcompo1_ on frameworks0_.model_component_framework_ref=modelcompo1_.id left outer join metadata.resource modelcompo1_1_ on modelcompo1_.id=modelcompo1_1_.id where frameworks0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select properties0_.model_component_ref as model1_1_, properties0_.property_ref as property2_1_, properties0_.property_value_ref as property3_1_, propertypr1_.property_ref as property1_20_0_, propertypr1_.property_value_ref as property2_20_0_ from curator.model_component_property_value_xref properties0_ left outer join curator.property_property_value_xref propertypr1_ on properties0_.property_ref=propertypr1_.property_ref and properties0_.property_value_ref=propertypr1_.property_value_ref where properties0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select grids0_.model_component_ref as model1_1_, grids0_.grid_ref as grid2_1_, gridimpl1_.id as id43_0_, gridimpl1_.version as version43_0_, gridimpl1_.name as name43_0_, gridimpl1_.description as descript4_43_0_ from curator.model_component_grid_xref grids0_ left outer join metadata.grid gridimpl1_ on grids0_.grid_ref=gridimpl1_.id where grids0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select experiment0_.model_component_ref as model1_1_, experiment0_.experiment_ref as experiment2_1_, experiment1_.id as id1_0_, experiment1_1_.version as version1_0_, experiment1_1_.date_created as date3_1_0_, experiment1_1_.date_updated as date4_1_0_, experiment1_1_.name as name1_0_, experiment1_1_.description as descript6_1_0_, experiment1_1_.rdf_identifier as rdf7_1_0_, experiment1_1_.activity_type_id as activity8_1_0_ from curator.model_component_experiment_xref experiment0_ left outer join metadata.experiment experiment1_ on experiment0_.experiment_ref=experiment1_.id left outer join metadata.activity experiment1_1_ on experiment1_.id=experiment1_1_.id where experiment0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select forcings0_.model_component_ref as model1_1_, forcings0_.forcing_ref as forcing2_1_, forcingimp1_.id as id6_0_, forcingimp1_.version as version6_0_, forcingimp1_.name as name6_0_, forcingimp1_.value as value6_0_, forcingimp1_.description as descript5_6_0_, forcingimp1_.type as type6_0_ from curator.model_component_forcing_xref forcings0_ left outer join metadata.forcing forcingimp1_ on forcings0_.forcing_ref=forcingimp1_.id where forcings0_.model_component_ref=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select identifier0_.resource_id as resource1_0_, identifier0_.type_id as type2_0_, identifier0_.identifier as identifier0_, identifier0_.type_id as formula3_0_ from metadata.persistent_identifier identifier0_ where identifier0_.resource_id=?
      [WARN] org.hibernate.engine.StatefulPersistenceContext: Narrowing proxy to class eske.model.metadata.curator.Model - this operation breaks ==
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select nesteddata0_.parent_dataset_id as parent3_11_, nesteddata0_.id as id11_, nesteddata0_.parent_display_order as parent4_11_, nesteddata0_.id as id52_10_, nesteddata0_1_.version as version52_10_, nesteddata0_1_.name as name52_10_, nesteddata0_1_.description as descript4_52_10_, nesteddata0_1_.date_created as date5_52_10_, nesteddata0_1_.date_updated as date6_52_10_, nesteddata0_1_.type_id as type7_52_10_, nesteddata0_.parent_gateway_id as parent2_92_10_, nesteddata0_.parent_dataset_id as parent3_92_10_, nesteddata0_.parent_display_order as parent4_92_10_, nesteddata0_.dataset_state_id as dataset5_92_10_, nesteddata0_.model_component_id as model6_92_10_, nesteddata0_.license_id as license7_92_10_, nesteddata0_.metadata_profile_id as metadata8_92_10_, (SELECT count(metadata.dataset.id) from metadata.dataset where metadata.dataset.parent_dataset_id = nesteddata0_.id ) as formula1_10_, (SELECT count(metadata.logical_file.id) from metadata.logical_file where metadata.logical_file.dataset_id = nesteddata0_.id) as formula2_10_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, gatewayimp1_.administrator_personal as adminis13_0_0_, gatewayimp1_.administrator_email as adminis14_0_0_, gatewayimp1_.myproxy_endpoint as myproxy15_0_0_, gatewayimp1_.idp_endpoint as idp16_0_0_, gatewayimp1_.metadata_profile_id as metadata17_0_0_, metadatapr2_.id as id50_1_, metadatapr2_.version as version50_1_, metadatapr2_.profile_name as profile3_50_1_, descriptiv3_.id as id35_2_, descriptiv3_.language as language35_2_, descriptiv3_.data_product_type_id as data3_35_2_, descriptiv3_.data_type_id as data4_35_2_, descriptiv3_.physical_domain_id as physical5_35_2_, descriptiv3_.resolution_type_id as resolution6_35_2_, descriptiv3_.dataset_progress_id as dataset7_35_2_, descriptiv3_.time_frequency_id as time8_35_2_, descriptiv3_1_.cadis_metadata_profile_name as cadis2_108_2_, descriptiv3_1_.cadis_metadata_profile_version as cadis3_108_2_, descriptiv3_1_.cadis_metadata_profile_creation_date as cadis4_108_2_, descriptiv3_1_.cadis_metadata_profile_revision_date as cadis5_108_2_, descriptiv3_1_.cadis_resolution_type_id as cadis6_108_2_, descriptiv3_1_.idn_node as idn7_108_2_, descriptiv3_1_.grant_number as grant8_108_2_, descriptiv3_1_.spatial_resolution as spatial9_108_2_, descriptiv3_1_.read_me_file as read10_108_2_, case when descriptiv3_1_.id is not null then 1 when descriptiv3_.id is not null then 0 end as clazz_2_, dataproduc4_.id as id32_3_, dataproduc4_.version as version32_3_, dataproduc4_.name as name32_3_, dataproduc4_.description as descript4_32_3_, physicaldo5_.id as id51_4_, physicaldo5_.version as version51_4_, physicaldo5_.name as name51_4_, timefreque6_.id as id59_5_, timefreque6_.version as version59_5_, timefreque6_.name as name59_5_, timefreque6_.description as descript4_59_5_, geophysica7_.id as id40_6_, geophysica7_.grid_id as grid2_40_6_, gridimpl8_.id as id43_7_, gridimpl8_.version as version43_7_, gridimpl8_.name as name43_7_, gridimpl8_.description as descript4_43_7_, softwarepr9_.id as id55_8_, softwarepr9_.software_version as software2_55_8_, metadatapr10_.id as id50_9_, metadatapr10_.version as version50_9_, metadatapr10_.profile_name as profile3_50_9_ from metadata.dataset nesteddata0_ inner join metadata.resource nesteddata0_1_ on nesteddata0_.id=nesteddata0_1_.id left outer join metadata.gateway gatewayimp1_ on nesteddata0_.parent_gateway_id=gatewayimp1_.id left outer join metadata.metadata_profile metadatapr2_ on gatewayimp1_.metadata_profile_id=metadatapr2_.id inner join metadata.descriptive_metadata descriptiv3_ on nesteddata0_.id=descriptiv3_.id left outer join metadata.cadis_descriptive_metadata descriptiv3_1_ on descriptiv3_.id=descriptiv3_1_.id left outer join metadata.data_product_type dataproduc4_ on descriptiv3_.data_product_type_id=dataproduc4_.id left outer join metadata.physical_domain physicaldo5_ on descriptiv3_.physical_domain_id=physicaldo5_.id left outer join metadata.time_frequency timefreque6_ on descriptiv3_.time_frequency_id=timefreque6_.id left outer join metadata.geophysical_properties geophysica7_ on nesteddata0_.id=geophysica7_.id left outer join metadata.grid gridimpl8_ on geophysica7_.grid_id=gridimpl8_.id left outer join metadata.software_properties softwarepr9_ on nesteddata0_.id=softwarepr9_.id left outer join metadata.metadata_profile metadatapr10_ on nesteddata0_.metadata_profile_id=metadatapr10_.id where nesteddata0_.parent_dataset_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select permission0_.resource_id as resource3_1_, permission0_.id as id1_, permission0_.id as id75_0_, permission0_.version as version75_0_, permission0_.resource_id as resource3_75_0_, permission0_.principal_id as principal4_75_0_, permission0_.operation_id as operation5_75_0_ from security.permission permission0_ where permission0_.resource_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select principal0_.id as id76_5_, principal0_.version as version76_5_, principal0_.gateway_id as gateway3_76_5_, principal0_.date_created as date4_76_5_, principal0_1_.firstName as firstName79_5_, principal0_1_.middleName as middleName79_5_, principal0_1_.lastName as lastName79_5_, principal0_1_.email as email79_5_, principal0_1_.userName as userName79_5_, principal0_1_.password as password79_5_, principal0_1_.loginType as loginType79_5_, principal0_1_.organization as organiza9_79_5_, principal0_1_.organization_type as organiz10_79_5_, principal0_1_.city as city79_5_, principal0_1_.state as state79_5_, principal0_1_.country as country79_5_, principal0_1_.openid as openid79_5_, principal0_1_.dn as dn79_5_, principal0_2_.name as name110_5_, principal0_2_.description as descript3_110_5_, principal0_2_.visible as visible110_5_, principal0_2_.automatic_approval as automatic5_110_5_, case when principal0_1_.id is not null then 1 when principal0_2_.id is not null then 2 when principal0_.id is not null then 0 end as clazz_5_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, gatewayimp1_.administrator_personal as adminis13_0_0_, gatewayimp1_.administrator_email as adminis14_0_0_, gatewayimp1_.myproxy_endpoint as myproxy15_0_0_, gatewayimp1_.idp_endpoint as idp16_0_0_, gatewayimp1_.metadata_profile_id as metadata17_0_0_, metadatapr2_.id as id50_1_, metadatapr2_.version as version50_1_, metadatapr2_.profile_name as profile3_50_1_, workspaces3_.principal_id as principal4_7_, workspaces3_.id as id7_, workspaces3_.gateway_id as gateway3_7_, workspaces3_.id as id87_2_, workspaces3_.version as version87_2_, workspaces3_.gateway_id as gateway3_87_2_, workspaces3_.principal_id as principal4_87_2_, gatewayimp4_.id as id0_3_, gatewayimp4_.version as version0_3_, gatewayimp4_.name as name0_3_, gatewayimp4_.description as descript4_0_3_, gatewayimp4_.system_message as system5_0_3_, gatewayimp4_.base_url as base6_0_3_, gatewayimp4_.base_secure_url as base7_0_3_, gatewayimp4_.attributes_service_url as attributes8_0_3_, gatewayimp4_.oai_repository_url as oai9_0_3_, gatewayimp4_.project_view_handler_name as project10_0_3_, gatewayimp4_.collection_view_handler_name as collection11_0_3_, gatewayimp4_.identity as identity0_3_, gatewayimp4_.administrator_personal as adminis13_0_3_, gatewayimp4_.administrator_email as adminis14_0_3_, gatewayimp4_.myproxy_endpoint as myproxy15_0_3_, gatewayimp4_.idp_endpoint as idp16_0_3_, gatewayimp4_.metadata_profile_id as metadata17_0_3_, searchcrit5_.id as id84_4_, searchcrit5_.version as version84_4_, searchcrit5_.workspace_id as workspace3_84_4_, searchcrit5_.name as name84_4_, searchcrit5_.date_inserted as date5_84_4_, searchcrit5_.product as product84_4_ from security.principal principal0_ left outer join security.user principal0_1_ on principal0_.id=principal0_1_.id left outer join security.group principal0_2_ on principal0_.id=principal0_2_.id left outer join metadata.gateway gatewayimp1_ on principal0_.gateway_id=gatewayimp1_.id left outer join metadata.metadata_profile metadatapr2_ on gatewayimp1_.metadata_profile_id=metadatapr2_.id left outer join workspace.workspace workspaces3_ on principal0_.id=workspaces3_.principal_id left outer join metadata.gateway gatewayimp4_ on workspaces3_.gateway_id=gatewayimp4_.id left outer join workspace.search_criteria searchcrit5_ on workspaces3_.id=searchcrit5_.workspace_id where principal0_.id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id77_0_, role1_.name as name77_0_, role1_.description as descript3_77_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select operations0_.role_id as role1_0_, operations0_.operation_id as operation2_0_ from security.role_operation_xref operations0_ where operations0_.role_id=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select clickstrea_.eske_session_id, clickstrea_.date_created, clickstrea_.remote_port, clickstrea_.container_session_id as container4_63_, clickstrea_.users_id as users5_63_, clickstrea_.user_agent_id as user6_63_, clickstrea_.remote_address as remote7_63_, clickstrea_.protocol as protocol63_, clickstrea_.server_name as server9_63_, clickstrea_.server_port as server10_63_, clickstrea_.request_uri as request11_63_, clickstrea_.query_string as query12_63_, clickstrea_.referrer as referrer63_, clickstrea_.request_time as request14_63_ from metrics.clickstream clickstrea_ where clickstrea_.eske_session_id=? and clickstrea_.date_created=? and clickstrea_.remote_port=?
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: insert into metrics.clickstream (container_session_id, users_id, user_agent_id, remote_address, protocol, server_name, server_port, request_uri, query_string, referrer, request_time, eske_session_id, date_created, remote_port) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      [DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: update metadata.resource set version=?, name=?, description=?, type_id=? where id=? and version=?

              wilhelmi Nathan Wilhelmi (Inactive)
              wilhelmi Nathan Wilhelmi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: