1 Reply Latest reply: Nov 14, 2008 4:48 PM by 599764 RSS

    Problem in Creating New position in Siebel CRM 7.8 using java program

    670502
      Hi
      We have Siebel CRM with Business Object and Business Component as Position.

      Position Business Component has a manadatory pick list Division.

      When we try to create a new Position by picking the Divison then we are getting the below error


      Logged in OK!
      picking the list
      in the pick() method before
      <Exception>
      <Major No.>256</Major No.><Minor No.>21944</Minor No.><Message>An error has occurred picking the current row.

      Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)</Message><DetailedMessage>Unknown<DetailedMessage>
      <Exception>
      <com.siebel.om.sisnapi.i>
      <Major No.>256</Major No.><Minor No.>21944</Minor No.><Message>An error has occurred picking the current row.
      <Error><ErrorCode>21944</ErrorCode> <ErrMsg>An error has occurred picking the current row.


      Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)</Message><DetailedMessage>Unknown<DetailedMessage>
      Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)</ErrMsg></Error>
      <com.siebel.om.sisnapi.i>
      <Error><ErrorCode>21735</ErrorCode> <ErrMsg>Siebel eScript runtime error occurred in procedure 'BusComp_SetFieldValue' of BusComp [Position]:
      <Error><ErrorCode>21944</ErrorCode> <ErrMsg>An error has occurred picking the current row.


      ConversionError 1616: Undefined and Null types cannot be converted to an object.
      Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)</ErrMsg></Error>
      (SBL-SCR-00141)</ErrMsg></Error>
      <Error><ErrorCode>21735</ErrorCode> <ErrMsg>Siebel eScript runtime error occurred in procedure 'BusComp_SetFieldValue' of BusComp [Position]:
      <Error><ErrorCode>21735</ErrorCode> <ErrMsg>Stack trace:

      BusComp [Position].BusComp_SetFieldValue(), Line: 1110</ErrMsg></Error>
      ConversionError 1616: Undefined and Null types cannot be converted to an object.
      </com.siebel.om.sisnapi.i></Exception>
      (SBL-SCR-00141)</ErrMsg></Error>
      <Error><ErrorCode>21735</ErrorCode> <ErrMsg>Stack trace:
      BusComp [Position].BusComp_SetFieldValue(), Line: 1110</ErrMsg></Error>
      </com.siebel.om.sisnapi.i></Exception>
      at com.siebel.data.SiebelBusComp.pick(SiebelBusComp.java:241)
      at siebelconn.main(siebelconn.java:44)


      Java program
      --------------------
      import com.siebel.data.*;
      import com.siebel.data.SiebelException;

      class siebelconn {


      public static void main (String args [])
      {
      SiebelDataBean m_dataBean = null;
      SiebelBusObject m_busObject = null;
      SiebelBusComp m_busComp = null;
      SiebelBusComp picklistBC = null;
           try{
      m_dataBean = new SiebelDataBean(); //Create Siebel JDB instance
      m_dataBean.login("XXXX", "XXX", "XXX");
           System.out.println("Logged in OK!");
      m_busObject = m_dataBean.getBusObject("Position");
      m_busComp = m_busObject.getBusComp("Position");
      m_busComp.newRecord(false);

      picklistBC = m_busComp.getPicklistBusComp("Division");
      picklistBC.clearToQuery();
      picklistBC.setViewMode(3);
      picklistBC.setSearchSpec("Name", "idmtest");
      //picklistBC.executeQuery(true);
      picklistBC.executeQuery2(true,true);
      if(picklistBC.firstRecord())
      {
      System.out.println("picking the list");
      picklistBC.pick();
      System.out.println("records are there");
      m_busComp.setFieldValue("Name","Access GE HQ 11");
      m_busComp.writeRecord();
      }//if



           if(m_busObject!=null)
      m_busObject.release();
      if(m_busComp!=null)
      m_busComp.release();
      if(picklistBC!=null)
      picklistBC.release();
      if(m_dataBean!=null)
      m_dataBean.logoff();

           }
      catch(Exception e)
      {
      System.out.println(e);e.printStackTrace();

      if(m_busObject!=null)
      m_busObject.release();
      if(m_busComp!=null)
      m_busComp.release();
      if(picklistBC!=null)
      picklistBC.release();
      try
      {
      if(m_dataBean!=null)
      m_dataBean.logoff();
      }catch(Exception e1){System.out.println(e1);}
      }
      }
      }


      Can any body please help us.

      Thanks