Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query from a huge data source

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

Not what you were looking for? View more on this topic or Ask a question