none
Exception while Querying Siebel with LOB Adapter RRS feed

  • Question

  •  

    Hi,

     

    We are using BTS 2006 R2 along with BizTalk 2006 R2 Enterprise LOB Adapters for connecting to a Siebel 7.5.3 system. While trying to create a Service Request (Siebel Business Object), its working fine and we are getting the row id as the response.

     

    But while trying to query to query Siebel for the existing SR's information, the adapter is throwing the following exception

     

    System defined exception
    Call to
    QueryEx@Siebel://Business Objects/Service Request/Service Request
        Implementation = Siebel://Business Objects/Service Request/Service Request

            Source: Siebel
            Error Code: 27730 (0x6c52)
            Cause: Siebel://exception=SBLException (Unique ID <none>)
       
    E-SBL0030: Call to  failed; Siebel error msg- An error has occurred executing a Sql statement.Please continue or ask your
    systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)Execute Query failed, for component Service Request with search criteria : [Row Status]="Y".  Contact Siebel Administrator. ; Siebel error code-

    27730

        Exception data:
            struct SBLExceptionType =
                StringType SBLErrorMessage = "An error has occurred executing a Sql statement.

    Please continue or ask your systems administrator to check your application configuration if the problem

    persists.(SBL-DBC-00105)Execute Query failed, for component Service Request with search criteria : [Row Status]="Y".  Contact

    Siebel Administrator. "
                Signed32 SBLErrorCode = 27730
                Signed32 SBLRecordIndex = -2


    While if we give a invalid field name in the search expression, the system is throwing an exception clearly stating that the field is invalid.


    System defined exception
    Call to
    QueryEx@Siebel://Business Objects/Service Request/Service Request
        Implementation = Siebel://Business Objects/Service Request/Service Request

            Source: Siebel
            Error Code: 27749 (0x6c65)
            Cause: Siebel://exception=SBLException (Unique ID <none>)
        E-SBL0030: Call to  failed; Siebel error msg- No field matches identifier 'ID'. Please ask your systems administrator to check your application configuration.(SBL-DAT-00416)Execute Query failed, for component Service Request with search criteria : [ID] like "1*".  Contact Siebel Administrator. ; Siebel error code- 27749

        Exception data:
            struct SBLExceptionType =
                StringType SBLErrorMessage = "No field matches identifier 'ID'.

    Please ask your systems administrator to check your application configuration.(SBL-DAT-00416)Execute Query failed, for

    component Service Request with search criteria : [ID] like "1*".  Contact Siebel Administrator. "
                Signed32 SBLErrorCode = 27749
                Signed32 SBLRecordIndex = -2

     

    This cleary shows that Siebel is receiving the search expression and also able to identify whether the fields are valid. However when we give a valid search expression the system is unable to execute the Sql statement.

     

    Please suggest the possible cause and resolution for this ??

     

    Regards,

     

    Aditya

    Thursday, March 13, 2008 8:18 PM

Answers

  • I've asked to install 7.5.3.13 as you have mentioned that you are working with 7.5.3 server earlier in the thread. Even I too donot know the location to download that patch.

     

    But, I checked the scenario on the 7.5.3.18 version without doing any changes to the built-in BO and I'm successful in getting the response.

     

    As you'd mentioned that you made some changes to the BO. If you can provide the details of the modifications you have done, I can try the same.

     

    Regards,

    Venu.

     

    Monday, March 24, 2008 12:04 PM

All replies

  • The error might be beacause of the query statement referring to deleted or inactive fields.

     

    Try querying with this string  -- > [Id] like "copy the row id from insert response file here" .

     

    Hope this works

     

    Cheers,

    Venu.

    Friday, March 14, 2008 12:34 PM
  •  

    Hi Venu,

     

    We did try the queries as suggested ( [Id] like "1*", [Id] = "1-2Q5" ), but receiving the same exception. Is there anything that needs to be done at Siebel Server end ??

     

    Regards,

     

    Aditya

    Friday, March 14, 2008 1:47 PM
  • Hi Aditya,

     

    Usually this error is thrown due to configuration problems on the Siebel Objects.

     

    Can you provide the below information ?

     

    The Input file you have used and the Query file.

     

    Also, have you done any changes on the ‘Service Request’ BC or the underlying table OR just using the Siebel provided default objects without any modifications.

     

    Regards,

    Venu.

     

    Tuesday, March 18, 2008 5:12 AM
  •  

    Hi Venu,

     

    Thanks for the timely support. I havent used any seperate input file for building the query. I was sending the query schema instance file itself to the orchestration. Following are few of the query files I have used.

     

    <ns0:Query xmlns:ns0="http://schemas.microsoft.com/[Siebel://Business Objects/Service Request/Service Request]">
      <ns0Tongue TiedearchExpression>[Id] like "1*"</ns0Tongue TiedearchExpression>
      <ns0Tongue TiedortExpression></ns0Tongue TiedortExpression>
    </ns0:Query>
     
    <ns0:QueryEx xmlns:ns0="http://schemas.microsoft.com/[Siebel://Business Objects/Service Request/Service Request]" xmlns:exposed="http://schemas.microsoft.com" xmlns:Business_Objects="http://schemas.microsoft.com/Business_Objects">
     <ns0Tongue TiedearchExpression>[Activity Id] like "1*"</ns0Tongue TiedearchExpression>
     <ns0Tongue TiedortExpression></ns0Tongue TiedortExpression>
     <ns0:viewMode></ns0:viewMode>
    </ns0:QueryEx>
     
    <ns0:QueryEx xmlns:ns0="http://schemas.microsoft.com/[Siebel://Business Objects/Service Request/Service Request]" xmlns:exposed="http://schemas.microsoft.com" xmlns:Business_Objects="http://schemas.microsoft.com/Business_Objects">
     <ns0Tongue TiedearchExpression>[Id] == "1-2G5"</ns0Tongue TiedearchExpression>
     <ns0Tongue TiedortExpression></ns0Tongue TiedortExpression>
     <ns0:viewMode></ns0:viewMode>
    </ns0:QueryEx>
     
    <ns0:QueryEx xmlns:ns0="http://schemas.microsoft.com/[Siebel://Business Objects/Service Request/Service Request]" xmlns:exposed="http://schemas.microsoft.com" xmlns:Business_Objects="http://schemas.microsoft.com/Business_Objects">
     <ns0Tongue TiedearchExpression>[Id] = "1-2G5"</ns0Tongue TiedearchExpression>
     <ns0Tongue TiedortExpression></ns0Tongue TiedortExpression>
     <ns0:viewMode></ns0:viewMode>
    </ns0:QueryEx>
     
     
    I have also tried with queries like [Id] = '1-2G5' , [Activity Id] like '1*', [Status] = "Open", [Status] == "Open", Status = "Open" etc and sometimes with viewMode = 3.
     
    I have tried these queries with Query, QueryEx and QueryEx2 methods.
     
    Also to update you on the progress, we have installed BizTalk Adapter Pack 1.0 and even with the Siebel WCF Adapter we are facing the same error.
     
    The Siebel srf being used is not the vanialla srf. Many custom fields have been added to the "Service Request" BC and complied properly. The new changes are being reflected in the Siebel Thin client without any error. I verified all the screens and views, and there are no errors.
     
    We are in the middle of project development and completely stuck up with this issue. Your suggestions in this regards would be greatly helpful. Shall wait to hear from your end.
     
    Please do suggest if we can communicate on mails in order to make the communication faster.
    Tuesday, March 18, 2008 7:01 AM
  •  

    Hi Venu,

     

    Apart from the Sql error, we are facing one more issue also. Newly added BC fields or business services are not getting reflected while trying to re-generate the schema using BAP 1.0 / 2006 R2 LOB adapters. Seems like both these errors are relative. Please suggest.

     

    Regards,

     

    Aditya

    Tuesday, March 18, 2008 9:46 AM
  • Hi Aditya,

     

    I tried to repro the scenario against Siebel 7.7 and 7.5.3.18 Version. But, we are getting the response without any problem.

    In some blog I have seen that this issue is addressed in 7.5.3.13 Version of siebel. Can you try installing that patch and verify.

     

    http://siebel.ittoolbox.com/groups/technical-functional/siebel-admin-l/error-sbldbc00105-an-error-has-occurred-executing-a-sql-statement-1424569

     

    Regards,

    Venu.

    Tuesday, March 18, 2008 2:29 PM
  •  

    Hi Venu,

     

    We have Siebel  7.5.3.15 version here. Since 7.5.3.15 is a higher version than 7.5.3.13, do you still feel that we need install the patch ?? Also can you please suggest me from where can I download this patch.

     

    Regards,

     

    Aditya

    Tuesday, March 18, 2008 4:09 PM
  • I've asked to install 7.5.3.13 as you have mentioned that you are working with 7.5.3 server earlier in the thread. Even I too donot know the location to download that patch.

     

    But, I checked the scenario on the 7.5.3.18 version without doing any changes to the built-in BO and I'm successful in getting the response.

     

    As you'd mentioned that you made some changes to the BO. If you can provide the details of the modifications you have done, I can try the same.

     

    Regards,

    Venu.

     

    Monday, March 24, 2008 12:04 PM