cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Search returns empty after reindex

0 Likes
869

Hi,

I have just done a migration of a TREX server, done the export and the import and after I issue a reindex inside as per the procedure below, the search returns no data.

Prodecure: http://wiki.scn.sap.com/wiki/display/TechTSG/SAP+E-recruiting+search+-+KPRO+reindexing

I really can't figure what is going on.

Also, sometimes it returns wrong data, like if I search for "Amanda" it will return all Amandas and some more differente names.

Do you guys have any guess of waht is going worg?

Another question I have is if is there way to selecth wich fields(or message inside a field), I want the search to return?

Best regards,

Gabriel

Accepted Solutions (1)

Accepted Solutions (1)

NicoleGeischnek
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Gabriel,

The search at transaction TREXADMIN alread doesn't work?

Regards,

Nicole

0 Likes

Hi Nicole,

Thank you for answering.

The search works from both sides, from TREXADMIN transaction and from the TREXAdmin panel.

But when I apply some filter before search, at my search panel, it returns empty. I was Reading some documentation and it might be that my templates has some fields missing.

That should be one of the explanations, right?

Regards,

Gabriel

NicoleGeischnek
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Gabriel,

Which release do you use? We have a search customizing report since EhP4 which you could use to check that.

Regards,

Nicole

0 Likes

Hi Nicole,

We're on EhP6.

Which report?

I really can't understand. Is there any Guide for building Templates?

Best regards,

Gabriel

NicoleGeischnek
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Gabriel,

It's RCF_CHECK_SEARCH_SETTINGS -> Report RCF_CHECK_SEARCH_SETTINGS - ERP Human Capital Management - SCN Wiki

Regards,

Nicole

0 Likes

Hi Nicole,

Thank you for reply!

But I still can't figure why my Search on EP is not working, not bringing any result.

Is there any log/transaction file I could look?

Regards,

Gabriel

NicoleGeischnek
Product and Topic Expert
Product and Topic Expert
0 Likes

You can try transaction SLG1.

former_member217429
Active Contributor
0 Likes

Hi Gabriel,

the search in the tc. TREXADMIN is usually very different than the search from the application .
You can record the python trace (note 1533891) for RFCServer and search calls , so that you
can see the "filters" / exact stucture  of the search query query  . This is the way we usually take
when need to investigate the issues with the incorrect search results . based on the recorded trace
we could execute different query parts separately and find out which of the query parts doesn't return
hits. You can also create an OSS incident for this case if you need help from us.

Thanks and best regards,
Mikhail

0 Likes

I can't get any log on SLG1, also my search is not workin on R3 side, I'm getting RC=2007.

The report  RCF_CHECK_SEARCH_SETTINGS has some red lights, I'm trying to fix it.

0 Likes

Thank you!

I was able to check that my search wasn't returning many results, but maybe it is my index that might be corrupt.

Also I want to create a new index.

former_member217429
Active Contributor
0 Likes

Hi Gabriel,

the index isn't corrupt. It's just missing . The error code 2007 means that the requested index doesn't exist . Could you please recreate this.

Best regards,
Mikhail

0 Likes

Mikhail,

Thank you so much!

I'm kinda new on E-REcruit, is there any guide to recreate it?

Regards,

GAbriel

former_member217429
Active Contributor
0 Likes

Hi Gabriel,

could you please check if the document "SAP E-Recruiting Search - Good to Know" attached on the note 817145 is suitable for you. If you use the SES instead of KPRO you can recreate the index
from SES_ADMIN instead of SKPR07.

Best regards,
Mikhail

0 Likes

Hi, thank you Mikhail,

Well, I was able to get the traces as you told me, but I'm didn't get the relation yet, the search is based on my templates, so when I start a search the query generated in the log reflects my configuration. But how can I figure what is missing between template and quary?

(It wasn't me who did this configuration and have no documentation, thats bad!)

# tracing search call (thread 5220) at 2015-07-28 11:00:00.487

# ccms user 'UTRECRUTA1'

# Passport:transId='55B764D206B50BD0E10080000AC18129', userId='UTRECRUTA1, peerName='10.193.129.55:52758'

so = fuzzypy.Search()

so.setCommunicationMethod(0)

so.addIndexId('4f9bd5855f320df0e10080000ac18129r3d222', 'DRFUZZY', '')

so.addRequestedAttribute2('loio_id_kpro')

so.addRequestedAttribute2('lo_class_kpro')

so.addRequestedAttribute2('phio_id_kpro')

so.addRequestedAttribute2('ph_class_kpro')

so.setResultFromTo(1, 750)

so.setMaxResults(750)

qo = fuzzypy.QueryEntry()

qo.setValue('BO', '', 'EQ')

qo.setXmlQueryString('BO')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BO', '', 'EQ')

qo.setXmlQueryString('BO')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('ONOT', '', 'EQ')

qo.setXmlQueryString('ONOT')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('TamandaNL5

000', '', 'EQ') qo.setXmlQueryString('TamandaNL5000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BC', '', 'EQ')

qo.setXmlQueryString('BC')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BC', '', 'EQ')

qo.setXmlQueryString('BC')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OAND', '', 'EQ')

qo.setXmlQueryString('OAND')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BO', '', 'EQ')

qo.setXmlQueryString('BO')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BO', '', 'EQ')

qo.setXmlQueryString('BO')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_ATTRIBUTE10001A1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_ATTRIBUTE10001A1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OOR', '', 'EQ')

qo.setXmlQueryString('OOR')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_ATTRIBUTE10002A1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_ATTRIBUTE10002A1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OOR', '', 'EQ')

qo.setXmlQueryString('OOR')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_ATTRIBUTE10011A1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_ATTRIBUTE10011A1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OOR', '', 'EQ')

qo.setXmlQueryString('OOR')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_ATTRIBUTE10012A1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_ATTRIBUTE10012A1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OOR', '', 'EQ')

qo.setXmlQueryString('OOR')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_ATTRIBUTE1SPACEA1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_ATTRIBUTE1SPACEA1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BC', '', 'EQ')

qo.setXmlQueryString('BC')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('OAND', '', 'EQ')

qo.setXmlQueryString('OAND')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('AHR_DOC_IDATTACHMENTA1B2C3E4D5EQ10000', '', 'EQ')

qo.setXmlQueryString('AHR_DOC_IDATTACHMENTA1B2C3E4D5EQ10000')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

qo = fuzzypy.QueryEntry()

qo.setValue('BC', '', 'EQ')

qo.setXmlQueryString('BC')

qo.setRowType('EXPRESSION')

qo.addContentType(fuzzypy.CT_UNDEFINED)

so.addQueryEntry(qo)

so.search() # tracing search result (thread 5220) at 2015-07-28 11:00:00.487 # found 8 of 8 documents after 0ms (0ms)

Best regards,

Gabriel

former_member217429
Active Contributor
0 Likes


Hi Gabriel,

either you didn't copy/paste the python trace here correctly  , or we have some problems on the
application side . In the trace you can see entries like
qo.setValue('OAND', '', 'EQ')
qo.setValue('AHR_DOC_IDATTACHMENTA1B2C3E4D5EQ10000', '', 'EQ')
....
these are definitely wrong. Could you please double check if you see the same in trace on the TREX side and if it's the case please open OSS incident for this issue.

Thanks and best regards,
Mikhail

0 Likes

Hi Mikhail,

Now I have a OSS open. Thank you for your help. Let's check what is going on!


Best Regards,

Gabriel

former_member217429
Active Contributor
0 Likes

Hi Gabriel,

could you please share the OSS incident number with me.

Thanks ,
Mikhail

0 Likes

Hi Mikhail,

Thank you for helping me.

Here is te OSS 639069 / 2015

Regards,

Gabriel

Answers (1)

Answers (1)

0 Likes

Dear experts,

Still need some help in here!

Anyone can guess what is going on?

I can index it and search it on SKPR07, its working.
But When I use the portal search mechanism, I got no results, but the python trace shows some results in back ground, the same I was searching before.

NOTE: I am NOT using SES,

Regards,

Gabriel