SQL Query to List All Active RCR jobs in Siebel CRM
SELECT
PAR_REQ_ID "Job Id",
rpt_interval||' '||rpt_uom "Frequency",
STATUS,
ACTL_START_DT,
EXEC_SRVR_NAME
FROM
SIEBEL.S_SRM_REQUEST
WHERE
SELECT
PAR_REQ_ID "Job Id",
rpt_interval||' '||rpt_uom "Frequency",
STATUS,
ACTL_START_DT,
EXEC_SRVR_NAME
FROM
SIEBEL.S_SRM_REQUEST
WHERE
clearing Siebel workflow instance monitoring log :
TRUNCATE TABLE S_WFA_INST_LOG;
TRUNCATE TABLE S_WFA_INSTP_LOG;
TRUNCATE TABLE S_WFA_STPRP_LOG
clearing Siebel workflow instance monitoring log :
TRUNCATE TABLE S_WFA_INST_LOG;
TRUNCATE TABLE S_WFA_INSTP_LOG;
TRUNCATE TABLE S_WFA_STPRP_LOG
During configuration and upgrades of a Siebel application, it happens quite often that settings from one Siebel enterprise (the source) must be migrated to another Siebel enterprise (the target).
generate a more detailed log file to assist in troubleshooting any Siebel Object Manager (OM) related behaviors. Increasing the event logging will provide information about the individual processes and steps that are part of that task. This information is especially useful when debugging performance, hang, memory leak, or crash behaviors. NOTE: When you increase the Object Manager event logging levels, the log files will grow larger and require more disk space.
he session can be killed at the Database layer, however the Siebel object manager's DB Connector will automatically perform a session reconnect :
Here is the session from Oracle's v$session table :
The columns are; logon_time, username, sid, serial#, osuser, program, process
02/26/2014 22:29:30 SADMIN 54 173 NT AUTHORITY\SYSTEM siebmtshmw.exe 5496:6032
Kill this session :
SQL> alter system kill session '54,173,@1' immediate;
System altered.
Spell check functionality is not working properly. When invoking the Spell Check, it highlights the wrong text.
ACTUAL BEHAVIOR
-------------------------------
Spell Check is highlighting the wrong text, and we notice a partial highlight.
EXPECTED BEHAVIOR
----------------------------------
If a word with an incorrect spelling is encountered , the spell checker should highlight the complete word.
CAUSE
Spell check functionality changes HTML to jumbled text
The Spell Check is on many pages and if HTML tag are inserted, Spell Check functionality escapes HTML tags.
This has been tested in Message Catalog (Main Menu > PeopleTools > Utilities > Administration > Message Catalog):
If you enter:
Text: Test Message Catalog
Converted to: Test Message Catalog
Siebel CRM After executing a search from within a Screen Home Page view and going back via IE Back button, a script error occurs and siebel screen freezes only way to recover is to log out from siebel and log back in.
Error Message:
Message: Object doesn't support this property or method
By following these steps the issue can be reproduced:
In Siebel version 7.x and higher, saved user preferences such as columns displayed and column size settings are stored by the Siebel application in .spf User Preference files.
For users on Siebel Mobile or Siebel Dedicated Web Clients, User Preference files are saved by default on the local client machine in the SIEBEL_CLIENT_ROOT\bin directory.
For users on Siebel Web Clients, User Preference files are saved in the "userpref" subdirectory of the Siebel File System.