cancel
Showing results for 
Search instead for 
Did you mean: 

BO4 - WIReportServer.exe scanning all objects in a universe one by one in order

former_member272336
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

former_member272336
Participant
0 Kudos

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?

Former Member
0 Kudos

Here a nice written article about platform search:

http://evtechnologies.com/ghosts-in-the-database/

former_member272336
Participant
0 Kudos

Hi,

Thanks for response.

Answers (1)

Answers (1)

denis_konovalov
Active Contributor
0 Kudos

Sounds like Platform Search doing its default job...

You might want to limit its scope in CMC.