on ‎2015 Jul 23 3:15 PM
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
Request clarification before answering.
Hi Gabriel,
The search at transaction TREXADMIN alread doesn't work?
Regards,
Nicole
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Gabriel,
It's RCF_CHECK_SEARCH_SETTINGS -> Report RCF_CHECK_SEARCH_SETTINGS - ERP Human Capital Management - SCN Wiki
Regards,
Nicole
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.