Siebel Search Administration Guide > Troubleshooting the Setup of Siebel Search >

SQL Troubleshooting

This topic lists frequently asked questions on the SQL generated by the Siebel Object Manager.

Is it possible to see the SQL sent to the Fulcrum search engine from the Siebel Search Center?

From Siebel 7.0.5 and 7.5.3 onward, it is possible to see the SQL generated by the Siebel Object Manager to be sent to the Fulcrum Search Engine by setting the 'Generic Log' event parameter. This can be set either using the srvrmgr command line or the Administration - Server Configuration screen.

To use the srvrmgr command line

• change evtloglvl genericlog=4 for comp <Comp_Alias_Name>

To use the Server Administration screen

1. Navigate to Administration - Server Configuration.
2. Select the object manager and set the 'Generic Log' event parameter to equal 4.

   There is no requirement to restart the Siebel server in order to have the change in the event parameters picked up, the user must simply start a new session connecting to the object manager. The log file where this SQL will be generated to is the object manager log file in the Siebel server log directory. For an example, see Example of SQL generated in the object manager log file.

Example of SQL generated in the object manager log file

GenericLog GenericDetail 4 2003-12-12 12:36:49 Siebel Search: Executing search. The select statement is

SELECT

ROW_ID,SUMMARY,FILE_NAME,FT_DNAME,REVNUM,VIS_ID, TEXT_READER,FT_TEXT_STATUS,TABLENAME(),Relevance(),
FT_ORIGINAL_SIZE,
FULLNAME(),VIS_INFO,DESCRIPTION,PRIVATE_FLG, TITLE, VERSION
FROM "FUL_LIT"

WHERE

(FUL_LIT.VIS_ID IN ('0-3P1KT') AND

(FUL_LIT.SALES_TOOL_TYPE <> 'Component') AND

(FUL_LIT.SUMMARY CONTAINS ~ 'null' OR

FUL_LIT.EXTERNAL_TEXT CONTAINS ~ 'null' ))

ORDER BY 10 DESC