on 02-28-2013 4:58 PM
Hi,
Notciicng some strange behaviour ata database level being cause by wireportserver.exe proceseses.
What is happening is that sqls are running ran one by one automatically aganist a universe, each object in turn.
No user is initiating theses.
WIReportServer.exe
SELECT DISTINCT sum(case
when RETAILER_TRN_REPORT_TYPE.TYP_SUB_GROUP_NAME = 'ACCEPTED REJECTED RETURN' then RETAILER_TRANSACTION.TRANSACTION_QUANTITY*-1
else 0
end) FROM RETAILER_TRANSACTION, RETAILER_TRN_REPORT_TYPE WHERE ( RETAILER_TRN_REPORT_TYPE.DIMENSION_KEY=RETAILER_TRANSACTION.REPORTING_TRN_TYPE_ID )
These not showing in Instance Manager.
Then gets next object and sess what joined into.
Is ther some option in universe which causes this?
Very bizarre.
Any thoughts/ideas?
Thanks
Terrible default option! My IQ server FULL load long time. all queris like select DISTINCT 'filed' from 'TABLE'
I Disable it:
CMC/Applications/Crawling Frequency/Scheduled crawling - check it
then schedule it in non business time:
CMC/All Filders/Platform Search/Platform Search Scheduling Object
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thank for responses.
Looking at qa server and finding it.
What is purpose of this. If say uncheck the universe from content type - this seesm to be th ebiggest overhead as running select distincts etc.
would this just mean users couldn't search for measures across universes - if that all sounds like we would remove this content type form being in the platform search as cost outweighs the benift for us?
If we simply say stop indexibng is that enough/do we need to even run it on scheduled basis?
Also - if uncheck all the content types, does this have same affect i.e. does nothing?
Also, have checke the production server where we don't see these select distincts etc.
sayas following in red..
Assume this is beacuse the adaptive processuing server which has platform search service as a service within it is currently stopped?
Wonder if we should do same on qa server.
Stop the adaptive procesisng server which runs platform saerch service?
We have other aps's running the other core services.
Thoughts?
Here a nice written article about platform search:
Sounds like Platform Search doing its default job...
You might want to limit its scope in CMC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.