How to apply Oracle hint in query via Siebel Configuration?

Our team was facing one performance issue in our application in which navigation to a view was taking hell lot of time. As every Siebel developer does, we also spooled the query which is running in the background and found the culprit query for the issue. SQL query seems to be very simple:SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY,T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID,

תגובות

הוסף רשומת תגובה

פוסטים פופולריים מהבלוג הזה

Profile Attributes and Open UI

תמונה
Yes, Profile Attributes! As the ever attentive, up-to-date Siebel CRM expert that you are when you read this, you know that in Siebel Open UI (since version 15), it is no longer allowed/supported to  set  Profile Attributes from browser-side script. But  getting  them is not a problem, since the  GetProfileAttr  function works perfectly fine. Recently I found a few vanilla Profile Attributes that came quite handy in my work in Open UI JavaScript: Navigation Type : stores the navigation type such as "NAVIGATION_TAB" ActiveViewName : does what it says on the tin IsOpenUI : returns "1" when the application runs in Open UI Is SUI Theme : when "TRUE", the application theme is Synergy (aka SUI) Position:  returns the currently active position Primary Responsibility Name : guess what this one is… Profile Image : returns the URL of the user's profile image Org.Name : returns the name of the user's organization Here's a sample line of ...
המשך לקרוא

SBL-EAI-04120: Error Base64-decoding binary attachment with ContentId: '%1'

<H2 class=km>Applies to: </H2> Siebel System Software - Version: 7.5.2.214 [16066]<max_ver> and later&nbsp;&nbsp;&nbsp;[Release: V7 and later ]</rel><BR>z*OBSOLETE: Microsoft Windows 2000<br> Product Release: V7 (Enterprise)<br> Version: 7.5.2.214 [16066]<br> Database: Microsoft SQL Server 2000 SP 2<br> Application Server OS: Microsoft Windows 2000 Server SP 2<br> Database Server OS: Microsoft Windows 2000 Server SP 2<br> <br> This document was previously published as Siebel SR 38-1111862111.<br> ***Checked for relevance on 18-Nov-2010*** <H2 class=km><A NAME="SYMPTOM"></A>Symptoms</H2> While trying to create an activity record and add an attachment to that activity using the EAI Siebel Adapter, the activity and attachment records were created successfully but the contents of the attachment file that is not “.txt” extension such as .htm or .doc was not showed prop...
המשך לקרוא

SBL-EAI-05003: Call to JNI_CreateJavaVM failed.

תמונה
Applies to: Siebel Financial Services CRM - Version: 8.1.1 SIA [21111] - Release: V8 Information in this document applies to any platform. Symptoms Environment: ------------------- Product type: Siebel Financial Services CRM Version: 8.1.1 SIA [21111] DB: Oracle Server - Enterprise Edition OS platform: IBM AIX on POWER Systems (64-bit) Env type: dev Statement of Issue: ----------------------------- A java business service (JBS) works correctly when executed on a local development environment. When it is called within an application object manager task running on the server it fails with an error. Error: ------- (javabsvc.cpp (181)) SBL-EAI-05003: Echec de l'appel de JNI_CreateJavaVM. In English: (javabsvc.cpp (181)) SBL-EAI-05003: Call to JNI_CreateJavaVM failed. Business Impact: ------------------------- The JBS cannot be executed on the server. Cause VMOPTIONS is set to the following in the JAVA JMSSubsys: -Xrs –Djava.compiler=NONE -Djms.log=/siebint/crmint1/siebsrvr/enterpr...
המשך לקרוא