Skip to Content

Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA

February 20, 2015 | 218 Views |
Follow

Hello all ,

Below is the datastore and data flow of my scenario where data is to be transferred from Microsoft SQL Server 2008 to SAP HANA using SQL transform .

/wp-content/uploads/2015/02/err_41_649550.png

err_1.PNG

/wp-content/uploads/2015/02/dav_1_649536.png

While executing the above JOB i’m getting the following error:-

err_3.PNG

Please help me with this issue

Thanks in advance,

DAVID KING J

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

    1. Former Member Post author

      Hi Julie ,

      Couldn’t able to open the link you have provided , may be the webpage is unavailable . Please provide alternate way to find the solution.

      (0) 
      1. Former Member

        Hi David,

        Are you being prompted for a s-user id? This is because KB articles are only accessible for clients with a valid SAP Maintenance contract.

        Please explain what you mean by “couldn’t open the link you have provided”.

        Thanks!
        Julie

        (0) 
        1. Former Member Post author

          Hi Julie ,

          I have read the KB article . My problem is not with HANA connection . Its with fetching data from Microsoft SQL server 2008 . Mean while i tried a sample job of the same above mentioned scenario from Microsoft SQL server 2008 to Flat file and i got this error shown below.

          atul.PNG

          So now i think that problem might be with the datastore . If so provide me the datastore configuration for Microsoft SQL server 2008.

          Please do the needful.

          Thanks in advance,

          David king .

          (0) 
          1. Former Member

            Hello David,

            In your new example, the error indicates an issue with your repository database, not a datastore connection. A repository database is something completely different from a datastore connection.

            If you have concern about your connection to your MS SQL datastore, import a single table from the same datastore, make it a source, connect it to a Query transform, then view it by clicking on the magnifying glass. Do you see your data? If so, you don’t have a connection isssue to your MS SQL 2008 datastore.

            You can also review Extra Requirements for MS SQL Sever via the DS Installation Guide, page 24:

            http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_install_win_en.pdf

            Beyond this, please log into the SAP Support Portal and create a SAP Support Incident.

            Thank you,
            Julie

            (0) 
            1. Former Member Post author

              Hi Julie,

                   Thankyou for your reply.

                   I’m able to view the data from the datastore . You have mentioned that it seems like an issue  with repository database . Can you please elaborate on the same.

              Thanks,

              David king.

              (0) 
  2. Arun Sasi

    Hi David,

    Looks like a 32 bit DSN is trying to contact a 64 bit application.

    Can you please check if the ODBC DSN is created from the following 64 bit location

    C:\Windows\SysWOW64\odbcad32.exe…

    If it is created from the odbad32.exe application under System32 folder under Windows then it can cause an issue

    Regards

    Arun Sasi

    (0) 
  3. Former Member Post author

    Hi all ,

    Sorry for updating this answer very late.

    seems like its a bug in BODS 4.1 . My job server is Linux so cannot use the database type as SQL SERVER 2008 instead use ODBC .

    Thanks,

    David king.

    (0) 
    1. Arun Sasi

      You can still use SQL Server 2008 R2 as database datastore as SQL Server Authentication is supported with Data Services on Linux Platform

      Regards

      Arun Sasi

      (0) 

Leave a Reply