This discussion is archived
4 Replies Latest reply: Aug 18, 2011 1:36 AM by 792262 RSS

how many optional allowed in the query?

792262 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points