I am currently working on the query on the BO through a Java application. Following the sample procedure, I can perform a query to extract data from the built-in Universe [e-fashion] using the JDK-provided web services: QueryService and ReportEngine.
However, I encountered some problems when doing the same thing in a universe that contains million rows of data [let say Unvierse A]. I am not sure how the differences between the 2 universes affect the result.
I have tried several times like setting different query objects and query condition but the results still outputs error. There are some error messages I commonly found when I tried to execute the query from the Universe A.
DataProviderInformation boDataProviderInfo = boQuerySrv.createDataProvider(boUniverseUID, boQuerySpec, boRetProp); DocumentInformation docInfo = objReportEngine.getDocumentInformation(boQueryDocRef, null, actions, null, retBOData); org.apache.axis2.AxisFault: Read timed out org.apache.axis2.AxisFault: Read timed out
When I tried doing the same query job in QaaWS / Webi, the report result looks fine. Am I missing some setting in Java ?
Any help is greatly appreciated.
-
Here are my findings on the Universe Specification:
(com.businessobjects.datasource.DataSourceSpecification)
[e-fashion]
>> getAdvancedConditionSupported() - true
>> getBothOperatorSupported() - true
>> getCombinedQuerySupported() - true
>> getConditionObjectValueSupported() - true
>> getDuplicateRowSupported() - true
>> getEditQueryAllowed() - true
>> getIsNullOperatorSupported() - true
>> getMaxInListNumber() - 999
>> getMaxRetrievalTime() - 300
>> getMaxRowsRetrieved() - 90000
>> getMissingRowSupported() - false
>> getName() - eFashion
>> getNotIsNullOperatorSupported() - true
>> getPercentageRankConditionSupported() - false
>> getRankConditionSupported() - false
>> getSortOnAnyObjectSupported() - true
>> getViewSQLSupported() - true
[Universe A]
>> getAdvancedConditionSupported() - false
>> getBothOperatorSupported() - false
>> getCombinedQuerySupported() - false
>> getConditionObjectValueSupported() - false
>> getDuplicateRowSupported() - false
>> getEditQueryAllowed() - true
>> getIsNullOperatorSupported() - false
>> getMaxInListNumber() - -1
>> getMaxRetrievalTime() - 600
>> getMaxRowsRetrieved() - 5000
>> getMissingRowSupported() - false
>> getNotIsNullOperatorSupported() - false
>> getPercentageRankConditionSupported() - false
>> getRankConditionSupported() - false
>> getSortOnAnyObjectSupported() - true
>> getViewSQLSupported() - false