Skip to Content
Author's profile photo david king

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

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

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Julie Oliver
      Julie Oliver

      Hello David,

      Please refer to KB Article 1728095 as it gives resolution to this issue.

      Kindest regards,

      Julie

      Author's profile photo david king
      david king
      Blog 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.

      Author's profile photo Julie Oliver
      Julie Oliver

      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

      Author's profile photo david king
      david king
      Blog 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 .

      Author's profile photo Julie Oliver
      Julie Oliver

      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

      Author's profile photo david king
      david king
      Blog 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.

      Author's profile photo Former Member
      Former Member

      If you receive this message you may be using the wrong driver. For nearly all databases, you must use JDBC drivers with 64-bit machines.

      This information can be found in the documentation:

      http://www.mathworks.com/help/releases/R2011b/toolbox/database/ug/bq89k8o-1.html#bq89k8p-5

      Author's profile photo david king
      david king
      Blog Post Author

      Hi Prasanna ,

           Due to license issues i'm not able to view the documentation.

           can you please mail me the document to kingdavid431@gmail.com.

      Thanks in advance.

      David king.

      Author's profile photo Arun Sasi
      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

      Author's profile photo david king
      david king
      Blog 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.

      Author's profile photo Arun Sasi
      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