cancel
Showing results for 
Search instead for 
Did you mean: 

TREX search for DMS originals

Former Member
0 Kudos

Hello Everyone,

I am trying to configure TREX server with SAP DMS for searching the text within an original in a sandbox.

When i Upload Originals in DMS they are getting stored in a content Repository DMS_C1_ST. Storage type: SAP System Database.

I have done all the necessary configurations which Includes tcodes SRMO, SKPR07,SKPRO6, Assign Relevant MIME types etc.,

I have following Questions:

1) In SKPR07 when i click diagnosis All are green except two rows which appears in red .

a) Language must be defined as a mandatory attribute in SDOKCLPROP

b) NOCATID

2) Do TREX search has the capability to search the documents stored in SAP System Database apart from Content server. Right now there is no Content server in place.


Please let me know your comments or suggestions where i might have forgotten something to configure or suggest me the best way.


Regards

Praveen

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Praveen/Umar,

Please check the below steps i have performed when i had the same issue.I actually have document with screen shots.If required can share the same if the below steps does not work for you.

Goto maintain search server relationship

Create DRFUZZY server if not found and set as default.

  Goto next tab maintain RFC destination properly as configured by basis consultant.

Check with Basis team the RFC destination configured with the TREX server.

   Click connection test ( If found link made) Connection successful.

  Goto SKPR06  t code and index release and classify for DMS and DMS2.

  Run the program in SE38 RSTIRIDX for indexing and schedule the back ground job to run the program for indexing.

        

Test Result:

Result:

  Please check whether you have done these configurations or not.

For text search you have activate TREX Server follow the steps

Set TREX

A:- Transaction: SRMO

Install TREX , and create RFC destination to connect to

B:- Transaction: SKPR06

Check the flag to Document Area "DMS" to utilize this document area for

document search.

For Indexing

A: Transaction: SE38

Run the report program "RSTIRIDX_REINDEX" to create Index.

Also, run the report program "RSTIRIDX" to create Index.

Set mime type for the text search

A: SPRO --

Cross-Application Components > Document Management System > General

Data > Settings for Storage Systems > Create MIME types for full

text search,

Enter MIME type like

"application/msword",

"application/pdf".

Retrive document via Test Search

A: Then, test retrieval document search using

Transaction: SKPR07.

Enter Document Class "DMS_PCD1", Language "EN", Document Class "DMS",

and try "TEST search".

Rgds,

Nayeem.

ufarooq176
Explorer
0 Kudos

Dear Nayeemur Rahman,

Thanks for you reply.

I have already follow these steps but result are 0. As discussed can you share the document. I am very thankful to you. I want to full text search in DMS.

Umar Farooq

ufarooq176@gmail.com

Former Member
0 Kudos

Hi Umar farooq,

Go to skpr07 and select the Document class as DMS_PCD1 and click on Diagnosis. Let me know what error you are getting.

And Go to CV04N and try to search the content and let me know what pop out message you are getting.

Regrds

Ahmed

ufarooq176
Explorer
0 Kudos

Dear Shaik,

Please find the below the screen short which I facing the issue.

Former Member
0 Kudos

Hi Umar farooq,

I got the same issue. and then i have deleted all the index category, step by step in a sequential order.

And then after when i indexed orderly as mentioned earlier, It has worked.

I am not sure but you might be missing some step.

Otherwise try indexing using Search engine Services.( SES_ADMIN ) if possible, and make sure you clean all the index category step by step before using SES_ADMIN.

Hope this will help.

Regards

Ahmed

ufarooq176
Explorer
0 Kudos

Dear Ahmed,

Thanks for you reply,I have done this activity in step by step and now the issue is resolved which I mentioned in my earlear reply.

Now tell me what I am

I have create the mime type(PDF) in configuration.

1. I have created the document info record and also attached pdf file and check-in.

Document No. Test

Document Type. DRW

Original Attachment. “Pakistan.PDF”

2. I have go the t.code SKPR07 and execute reindex. After this process I execute Trigger Process from skpr07.

3.  When I execute test search I found no document found.

4. When I go to the t.code CV04N.  I have search from Text Search with in original field "Pakistan" but system reply the message "No document found with these selection parameter".  Kindly tell me what exactly I should search.

Thanks & Regards

Umar Farooq

ufarooq176
Explorer
0 Kudos

Dear Praveen\Shaik Ahmed,

I am also facing the same problem, which you are mentioned in this thread, Please let me know if you have resolve this issue.

Best Regards,

Umar Farooq

Former Member
0 Kudos

Hi Umar Farooq,

Yes, I have resolved the issue, already. and its working fine. Let me know what exactly the issue you have, so that i can help you.

Regards

Ahmed

ufarooq176
Explorer
0 Kudos

Dear Ahmed,

Thank you very much for your prompt response.

I have run the process as per following steps but no result found. Kindly tell me what i am missing.

·         I have index release in t.code SKPR06.

·         I have created the search server relation in SKPR07.

·         Test the connection to the RFC destination SRMO.

·         I have deleted all the entries (marked document) without an index category.

·         I have executed the back ground job which mentioned the program name RSTIRIDX and and also choose Re-index in SKPR07.

·         The system has not generate the index category when I attached the document in CV01N.

·         Also trigger the Process function on the Index/De-index tab page and re-indexing.

Kindly need your urgent help in this regards.

Umar Farooq

Former Member
0 Kudos

Make sure that you have gone through the following steps...!

• CV04N – Find Document Selection Criteria Screen

• Where Text search is not active. As kpro settings has to been done to activate Text search.

Execute Transaction: SKPR06:

• Check the Required Index Release according to the Document Area. In our case It is DMS, DMS2.

-----------------------

• After SKPR06 settings:

• Now create a Communication User using SU01 transaction which has a Role “SAP_BC_TREX_ADMIN”.

• Select the “Address” tab and fill the details.

• Then Select the “Logon data” tab and Give the initial password.

• TREX User creation

-----------------

 

• Now After creating a user with trex_admin role, execute TREXAdmin.exe.

• \usr\sap\TRX\TRX01\TREXAdmin.exe.

-----------------------------------

 

  Search Server Relation Monitor

• Execute Tx:SRMO.

• Click on “Create SSR”.

• Type the Search server ID and click on Create SSR.

• Click on Save.

• Select the RFC Destination Tab and Test the connection.

---------------------------------------------------

           KPRO IMS: Monitoring

• Select the Document Class In our case DMS_PCD1-( DMS_PCD1 DMS: Physical object for main originals).

• Select the Language EN, Uncheck “Limited to Selected Language”.

• Click on “Trigger Process”.

• Click on the “Diagnosis” Button to check the indexability.

• Run the report “RSTIRIDX” In SE38. For Indexing Checked in Documents.

-------------------------------------

  TREX Administration.

• Execute the Transaction: TREXADMIN. on SAP Application screen. 

• Select the RFC Destination and execute (f8).

• You can now monitor the Trex services, Index, Queues…etc.

you can ignore the language error.

Let me know if you still have the issue.

Regrds

Ahmed

Former Member
0 Kudos

And also you might not have deleted the entries properly in SRMO.


If you have deleted the entries from SKPR07 then i think you have to clean the index category (i am not sure but it worked for me).


And also please do the diagnosis for Document Class DMS_PCD1.


ufarooq176
Explorer
0 Kudos

Dear Ahmed,

Thanks for you response.

I have follow all the steps as per your guidance, and also create the communicate user and assign the role “SAP_BC_TREX_ADMIN". I have tried to search TREXAdmin.exe but not found.

I have also clean the entries from skpr07. Please find below the screen short.

Your usual co-operation will be appreciated.

Thanks & Regards,

Umar Farooq

Former Member
0 Kudos

Hi,

1) Login to the Application server where TREX is installed. Look for the path /usr/sap/<TREX SID>/TREXAdmin.exe.

-----------------

2) Even after you clean up the entries from SKPR07. you still have the entries in tables, which need to be cleaned up.

As you said you have run the report in background RSTIRIDX. Please stop the report and start up the cleaning process again.

Follow this cleanup process and try to index it again through SKPR07. I am sure it will work.

  • Execute TREXAdmin.exe in \usr\sap\<TREX Installed Dir>\TRX<Instance no>.
  • Clear and Delete the Queues by selecting Queue Admin in TREXAdmin tool.
  • Select the Index Landscape and Clear the index and Delete.


  • If Indexing has been done using SES_ADMIN, then execute the Transaction.
  • Select the indexed business object and Deactivate/Delete.


  • Though if you have deleted Indexed Documents, Index Category will remains.
  • Clear the Index category. SRMO àààà
  • Cleanup the Table entries in SKPR07.
    • Make sure to run the clean up report in the SKPR07 already.
    • Check if you still have any entries in the tables:
    • SRETIDCAT
    • SRETIDCATT
    • SRETIDCTAT
    • SRETIDATTR
      if yes, Delete the entries related to DMS_PCD1 using SE11.

  • Cleanup the buffers from the System using /$sync (Not in PRD Server).

And also Run this report

  • RSTIRIDX_CONSISTENCY
  • RSTIRIDX_CLEAR_IDX_DOCUSPACE


After this start configuring SSR, Defining Category... again.

Let me know if this is useful.

Regards

Ahmed.

ufarooq176
Explorer
0 Kudos

Dear Ahmed,

I am very thankful to you for your immediate response. I have also search again this TREXadmin.exe file but not found. I have found this file from my file server. "F:\usr\sap\TRX\TRX50\TrexAdmin.bat"

Deleted all index categories from the mentioned table.

I have execute the “clean up table entries” on t.code SKPR07.

I would like to inform you that we are not using the content server. I am not sure is it necessary or not.

Waiting for your response.

Thanks & Regards,

Umar Farooq.

ufarooq176@gmail.com

Former Member
0 Kudos

Hi Praveen,

I am in the same situation as you are.

we dont have a content server, and I dont knw if it is necessary.

Please let me knw if you have solve the problem already.

Thanks and Regards

christoph_hopf
Advisor
Advisor
0 Kudos

Hi Praveen,

regarding your question I hope that the information at Full Text Search for Original Application Files - Document Management - SAP Library

could help to answer your questions.

Best regards,

Christoph

Former Member
0 Kudos

Hi Christoph,

The link you have shared is valuable and I have done all the necessary configurations mentioned.

But still the issue is unresolved.


Please help if you knw how to resolve the issue.


Thanks and regards