4 Replies Latest reply: Aug 18, 2011 3:36 AM by 792262 RSS

    how many optional allowed in the query?

    792262
      Hi,

      Data base is getting disconnected while running the below sparql query (Query with 9 optional conditions).

      I tested the query with 5 optional its working fine but, its not working for more than 5 optional.

      How many optional allowed in the query?

      Please advice me to solve this problem.

      Error Detail: ORA-03113: end-of-file on communication channel

      SELECT bi, OWNER,name,usage,notes,icto,app,ssd,ssdname,ssdid,sdname,sdarchitect,schedule
      FROM TABLE (sem_match('{
      ?bi rdf:type di:Bulk_Interface .
      ?bi di:hasBulkInterfaceItOwner ?OWNER .
      ?bi di:hasBulkInterfaceName ?name .
      ?bi di:hasBulkInterfaceRecipientApplicationArea ?usage .
      ?bi di:hasBulkInterfaceRecipientFeederType ?notes .
      ?bi di:hasBulkInterfaceSupplierApplicationId ?icto .
      ?app ds:hasConceptualSourceApplicationIctoId ?icto .
      ?ssd ds:hasConceptualSourceApplication ?app .
      ?ssd ds:hasConceptualSourceSubdomainName ?ssdname .
      ?ssd ds:hasConceptualSourceSubdomainIctoId ?ssdid .
      ?sd ds:hasConceptualSourceSubdomain ?ssd .
      ?sd ds:hasConceptualSourceDomainName ?sdname .
      ?sd ds:hasConceptualSourceDomainArchitect ?sdarchitect .
      ?bi di:hasBulkInterfaceDeliverySchedule ?schedule
      optional {?bi di:hasBulkInterfaceRecSet1AverageStorageRequirements ?avgsize}
      optional {?bi di:hasBulkInterfaceWorstStorageRequirements ?maxsize}
      optional {?bi di:hasBulkInterfaceRecSet1AverageNumberOfRecords ?avgrec}
      optional {?bi di:hasBulkInterfaceAverageNumberOfRecords ?avgrec}
      optional {?bi di:hasBulkInterfaceRecSet1WorstNumberOfRecords ?maxrec}
      optional {?bi di:hasBulkInterfaceWorstNumberOfRecords ?maxrec}
      optional {?bi di:hasBulkInterfaceTransferMethodJob ?job}
      optional {?bi di:hasBulkInterfaceDataFileAvailability ?post}
      optional {?bi di:hasBulkInterfaceBusinessDescription ?descr}
      }
      ',
      sem_models ('IFM_CURR', 'SRC_CURR'),
      SEM_Rulebases('OWLPRIME'),
      sem_aliases(SEM_ALIAS('di','http://www.cse.com/sbip/dwh/mdm/data_interface#'),
      SEM_ALIAS('ds','http://www.cse.com/sbip/dwh/mdm/data_sources#'))
      , NULL));


      Let me know if you need any other details.

      Regards,
      Kavitha.

      Edited by: 789259 on Aug 3, 2011 2:01 AM