10 Replies Latest reply: Apr 4, 2012 12:16 AM by Srinath Menon-Oracle RSS

    java component - ora-01013 error when calling ws.createResultSetSQL

    klee
      Running Content Server 11.1.1.5 on WLS 10.3.5 in 64bit Linux environment. Same component/code runs great in dev environment, but consistently get this error in production. In production, query runs against view in same schema as system database. I can run the same query in either SQL Developer or SQLPlus and the results return nearly immediate - about 1 second.

      The query in the Java component times-out nearly every single time, even when very little load on the system (late at night).

      getMessage() returns "!csDbUnableToCreateResultSet

      I have already set the default query timeout in config.cfg to 120 seconds.


      Any suggestions? Really perplexed on this one!

      Thank you, Ken


      Here is an example of the Java code used in the call.

      {code}package com.example;
      import intradoc.common.ExecutionContext;
      import intradoc.common.ServiceException;
      import intradoc.common.SystemUtils;
      import intradoc.data.DataBinder;
      import intradoc.data.DataException;
      import intradoc.data.DataResultSet;
      import intradoc.data.ResultSet;
      import intradoc.data.Workspace;
      import intradoc.provider.Provider;
      import intradoc.provider.Providers;
      import intradoc.shared.FilterImplementor;
      import intradoc.util.IdcMessage;

      public class Test implements FilterImplementor {
      public int doFilter(Workspace ws, DataBinder binder, ExecutionContext cxt) throws DataException, ServiceException {
      String value = "-1";
      String xEMP_NUM ="";
      String SQL = "";
      String ResultSetName = "XEMPNUMCOUNT";
      int rowcount = 0;
      DataResultSet result = null;
      DataException error = null;
      ResultSet temp = null;
      Workspace wsTemp = null;
      SystemUtils.trace("filterdebug", "Starting doFilter for Test");
      xEMP_NUM = binder.getLocal("xEMP_NUM");
      xEMP_NUM = (xEMP_NUM == null) ? null : xEMP_NUM.trim();
      SystemUtils.trace("filterdebug", "xEMP_NUM=" + xEMP_NUM);
      if (xEMP_NUM != null && !xEMP_NUM.equalsIgnoreCase("0") && xEMP_NUM.length() > 0) {
      SQL = "select emp_num, emp_lname, emp_mname, emp_fname from emps where emp_num = " + xEMP_NUM.trim();
      SystemUtils.trace("filterdebug", "SQL=" + SQL);
      if (ws == null) {
      SystemUtils.trace("filterdebug", "ws is null, getting ws from call to getSystemWorkspace()");
      ws = getSystemWorkspace();
      }
      SystemUtils.trace("filterdebug", "try-catch block to get ResultSet from SQL");
      try {
      SystemUtils.trace("filterdebug", "start: temp = ws.createResultSetSQL(SQL)");
      temp = ws.createResultSetSQL(SQL);
      SystemUtils.trace("filterdebug", "end: temp = ws.createResultSetSQL(SQL)");
      result = new DataResultSet();
      result.copy(temp);
      rowcount = result.getNumRows();
      SystemUtils.trace("filterdebug","rowCount=" + rowcount);
      } catch (DataException de) {
      error = de;
      SystemUtils.trace("filterdebug", "de.getMessage()=" + de.getMessage());
      } finally {
      // ws.releaseConnection();
      }
      if (rowcount > 0){
      try {
      int fieldCnt = result.getNumFields();
      SystemUtils.trace("filterdebug", "fieldCnt=" + fieldCnt);
      result.first();
      xEMP_NUM = result.getStringValue(0);
      binder.putLocal("xEMP_NUM",xEMP_NUM);
      String xEMP_LNAME = result.getStringValue(1);
      binder.putLocal("xEMP_LNAME",xEMP_LNAME);
      String xEMP_MNAME = result.getStringValue(2);
      binder.putLocal("xEMP_MNAME",xEMP_MNAME);
      String xEMP_FNAME = result.getStringValue(3);
      binder.putLocal("xEMP_FNAME",xEMP_FNAME);
      } catch (NumberFormatException nfe) {
      SystemUtils.trace("filterdebug", "nfe.getMessage()=" + nfe.getMessage());
      }
      } else {
      SystemUtils.trace("filterdebug", "Throw error since xEMP_NUM is not in the ems table");
      throw new ServiceException("Invalid Employee Number provided!");
      }
      if (error != null) {
      SystemUtils.trace("filterdebug", "Throw error since error condition exists.");
      throw error;
      }
      }
      SystemUtils.trace("filterdebug", "Ending doFilter for Temp");
      return CONTINUE;
      }

      public Workspace getSystemWorkspace() {
      Workspace workspace = null;
      Provider wsProvider = Providers.getProvider("SystemDatabase");
      if (wsProvider != null) {
      workspace = (Workspace)wsProvider.getProvider();
      }
      return workspace;
      }
      }
      {code}
        • 1. Re: java component - ora-01013 error when calling ws.createResultSetSQL
          Srinath Menon-Oracle
          Hi ,

          Can you please post the entire error stack trace that comes along with "!csDbUnableToCreateResultSet ?

          Thanks
          Srinath
          • 2. Re: java component - ora-01013 error when calling ws.createResultSetSQL
            klee
            From Console Output in the server
            >filterdebug/6     01.24 21:42:46.004     IdcServer-6201     Starting doFilter for DCSDEmployeeCheckinValidation
            
            filterdebug/6     01.24 21:42:46.005     IdcServer-6201     xEMP_NUM=2003076
            filterdebug/6     01.24 21:42:46.005     IdcServer-6201     SQL=select emp_num, emp_lname, emp_mname, emp_fname, emp_natl_id, emp_stat_cd from dcsdemployees where emp_num = 2003076
            filterdebug/6     01.24 21:42:46.005     IdcServer-6201     try-catch block to get ResultSet from SQL
            filterdebug/6     01.24 21:42:46.006     IdcServer-6201     start: temp = ws.createResultSetSQL(SQL)
            filterdebug/6     01.24 21:44:46.232     IdcServer-6201     de.getMessage()=!csDbUnableToCreateResultSet,select emp_num\, emp_lname\, emp_mname\, emp_fname\, emp_natl_id\, emp_stat_cd from dcsdemployees where emp_num = 2003076!$ORA-01013: user requested cancel of current operation
            filterdebug/6     01.24 21:44:46.232     IdcServer-6201     Throw error since xEMP_NUM is not in the dcsdstudents table
            services/3     01.24 21:44:46.239     IdcServer-6201     !csUserEventMessage,weblogic,ucmprod.dcsdk12.org!$ intradoc.common.ServiceException: Invalid Employee Number provided!
            services/3     01.24 21:44:46.239     IdcServer-6201     *ScriptStack CHECKIN_NEW_SUB services/3     01.24 21:44:46.239     IdcServer-6201     3:doScriptableAction,dDocName=3:doSubService,dDocName=CHECKIN_NEW_SUB,dDocName=3:validateStandard,dDocName=DCS866569 services/3     01.24 21:44:46.239     IdcServer-6201             at org.dcsdk12.ucm.DCSDEmployeeCheckinValidation.doFilter(DCSDEmployeeCheckinValidation.java:112) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.shared.PluginFilters.filterWithAction(PluginFilters.java:114) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.shared.PluginFilters.filter(PluginFilters.java:68) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.DocServiceHandler.validateStandard(DocServiceHandler.java:1167) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) services/3     01.24 21:44:46.239     IdcServer-6201             at java.lang.reflect.Method.invoke(Method.java:597) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCodeEx(Service.java:533) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCode(Service.java:505) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doAction(Service.java:477) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doActions(Service.java:472) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1322) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.executeSubServiceCode(Service.java:3866) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1200) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.executeServiceEx(Service.java:3861) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.executeService(Service.java:3845) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doSubService(Service.java:3760) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.GeneratedMethodAccessor411.invoke(Unknown Source) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) services/3     01.24 21:44:46.239     IdcServer-6201             at java.lang.reflect.Method.invoke(Method.java:597) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCodeEx(Service.java:550) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCode(Service.java:505) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doAction(Service.java:477) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doScriptableAction(Service.java:3807) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) services/3     01.24 21:44:46.239     IdcServer-6201             at java.lang.reflect.Method.invoke(Method.java:597) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCodeEx(Service.java:550) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doCode(Service.java:505) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doAction(Service.java:477) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doActions(Service.java:472) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.executeActions(Service.java:458) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.Service.doRequest(Service.java:1890) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715) services/3     01.24 21:44:46.239     IdcServer-6201             at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222) services/3     01.24 21:44:46.239     IdcServer-6201             at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source) services/3     01.24 21:44:46.239     IdcServer-6201             ... 35 more
            (internal)/6     01.24 21:44:46.286     IdcServer-6201     File to be removed: /cms/ecm/vault/~temp/1897335874.txt
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
            • 3. Re: java component - ora-01013 error when calling ws.createResultSetSQL
              Srinath Menon-Oracle
              Hi ,

              ORA-01013: user requested cancel of current operation

              This is the core error being returned in UCM logs which is causing the result set issue .

              Can you check to see if the DB connection to UCM is losing out .

              Maybe one way to check this would be restart DB completely which will clear out the dead / hung processes from db side and then try running the same query to see what is happening .

              Thanks
              Srinath
              • 4. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                klee
                I had the DBA drop all of the active sessions tied to the system database. There was one that was problematic, and once cleared, the system started to work as expected. Thank you for your help!

                Ken
                • 5. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                  klee
                  This problem continues to be problematic.

                  The following is data from our database showing what is locked when the java component is being called:

                  >
                  UCMP3 sid 711 is session SID 62 on FINP3 (connection via DBLINK on March 19, performing SELECT).
                  The reason for the hang is ROW EXCLUSIVE LOCK on CONTRIB_ADMIN.REVCLASSES )
                  Is weblogic doing a select for UPDATE??

                  Solution: Terminate 711.


                  More details on the session:

                  HV Line SQL Statement
                  ---------- ------ -----------------------------------------------------------------
                  962371944 0 SELECT p.employee_number EMP_NUM, p.last_name EMP_LNAME, p.middl
                  962371944 1 e_names EMP_MNAME, p.first_name EMP_FNAME, p.national_identifier
                  962371944 2 EMP_NATL_ID, pt.user_person_type EMP_STAT_CD FROM per_all_peop
                  962371944 3 le_f@apps_link p, per_person_types@apps_link pt, per_person_type
                  962371944 4 usagesf@apps_link ptu WHERE :"SYS_B_0"=:"SYS_B_1" AND p.person
                  962371944 5 id          = ptu.personid AND ptu.person_type_id = pt.per
                  962371944 6 son_type_id AND pt.system_person_type IN (:"SYS_B_2", :"SYS_B_3"
                  962371944 7 ) AND p.effective_start_date BETWEEN ptu.effective_start_date AN
                  962371944 8 D ptu.effective_end_date AND p.effective_end_date = to_date(:"SY
                  962371944 9 S_B_4",:"SYS_B_5") AND p.first_name IS NOT NULL AND p.emp
                  962371944 10 loyee_number = :"SYS_B_6"


                  Select VIA database link APPS_LINK to three tables:

                  OWNER..............................: PUBLIC
                  DB_LINK............................: APPS_LINK
                  USERNAME...........................: APPS
                  HOST...............................: FINP
                  CREATED............................: 22-JAN-12

                  per_all_people_f
                  per_person_types
                  per_person_type_usages_f


                  USERNAME KILL TAB loc req
                  -------------- ------------ ---------------------------------------- -------------- --------------
                  CONTRIB_ADMIN 711,63 CONTRIB_ADMIN.REVCLASSES Row Exclusive


                  Other sessions accessing the table:

                  SID OWNER OBJECT TYPE
                  ------ ---------------- -------------------------------------------------- ---------------
                  12 CONTRIB_ADMIN REVCLASSES TABLE
                  707 CONTRIB_ADMIN REVCLASSES TABLE
                  471 CONTRIB_ADMIN REVCLASSES TABLE
                  244 CONTRIB_ADMIN REVCLASSES TABLE
                  590 CONTRIB_ADMIN REVCLASSES TABLE
                  240 CONTRIB_ADMIN REVCLASSES TABLE
                  242 CONTRIB_ADMIN REVCLASSES TABLE
                  357 CONTRIB_ADMIN REVCLASSES TABLE
                  9 CONTRIB_ADMIN REVCLASSES TABLE
                  591 CONTRIB_ADMIN REVCLASSES TABLE
                  711 CONTRIB_ADMIN REVCLASSES TABLE
                  354 CONTRIB_ADMIN REVCLASSES TABLE
                  588 CONTRIB_ADMIN REVCLASSES TABLE
                  594 CONTRIB_ADMIN REVCLASSES TABLE
                  >

                  My question is:
                  When I run the java component, what is causing the ROW EXCLUSIVE LOCK on CONTRIB_ADMIN.REVCLASSES?

                  Thank you,

                  Ken
                  • 6. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                    klee
                    The previous "correct" answer was a quick one time fix, and was not the root cause of the issue. I am still trying to find a permanent fix to this issue.
                    • 7. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                      Srinath Menon-Oracle
                      Hi ,

                      I believe that the session parameters being used by UCM (OOTB) need to be set on SQL Developer and then the query executed to see how it performs , then capture the db tracings .

                      By default, UCM attempts to optimize connections using the following session parameters. In some cases, these may not work as effectively as default session parameters. One method of testing the query that UCM is running is to set these session parameters in SQL Developer or SQL Plus and then run the explain plan on the query to see what is different between an unchanged session and a session that mimics UCM's use of these session parameters.


                      ALTER SESSION SET optimizer_mode = 'FIRST_ROWS_100'
                      ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR'
                      ALTER SESSION SET NLS_SORT = 'BINARY'
                      ALTER SESSION SET NLS_COMP = 'BINARY'
                      ALTER SESSION SET CURSOR_SHARING = 'FORCE'


                      Please refer to Note : 1270549.1 on MoS portal for checking further details on this .

                      Thanks
                      Srinath
                      • 8. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                        klee
                        Srinath,

                        In MOS, the knowledge search wasn't working, so I will check the mentioned note in the AM. I appreciate the reference. I will also run the query in SQL Developer with the settings you reference and see what explain plan has to offer.

                        I have run the query previously in SQL Developer, and it runs amazingly quick. I have not had any problems previously, but as you said, I need to run the query with the parameters set as they are in UCM. When the query is run in UCM, we do get ROW EXCLUSIVE LOCK on REVCLASSES. At this point, the component stops working until the session for the stuck thread is deleted. The component times out when called. Where can I find more information on how REVCLASSES and their dependencies work in regards to Java components in UCM, specifically when accessing remote data sources as I am in my code? Do you have any thoughts on whether this may be key to solving this issue?

                        Thank you,

                        Ken
                        • 9. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                          klee
                          Srinath,
                          Please refer to Note : 1270549.1 on MoS portal for checking further details on this .
                          A search on all sources on 1270549.1 returns "No results found". Is there another location in MoS or a different number to search on?

                          Thanks,

                          Ken
                          • 10. Re: java component - ora-01013 error when calling ws.createResultSetSQL
                            Srinath Menon-Oracle
                            Hi Ken ,

                            My bad ,the document is a internal only one .

                            From the note :
                            ---------------------

                            The following config settings can be altered to manipulate the session parameters that UCM uses when creating database connections.

                            To change optimizer_mode parameter, use the following config setting. This example sets the parameter to use the default value of ALL_ROWS:

                            QVOrclQueryOptimizerMode=ALL_ROWS

                            To change cursor_sharing parameter, use the following config setting. This example sets the parameter to use the default value of EXACT:

                            QVOrclCursorSharing=EXACT

                            To change NLS_COMP parameter:

                            QVOrclCompType=BINARY

                            To change NLS_SORT parameter:

                            QVOrclCompSortOrder=BINARY

                            To change NLS_LENGTH_SEMANTICS parameter:

                            QVOrclLengthSemantics=CHAR


                            Thanks
                            Srinath