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

Follow RSS feed Like

0 Likes 1,084 View 11 Comments

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 .

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

Please help me with this issue

Thanks in advance,

DAVID KING J

Alert Moderator

11 Comments

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

Julie Oliver

February 20, 2015 at 1:57 pm

Hello David,

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

Kindest regards,

Julie
- Like(0)
- david king Post author
  
  February 23, 2015 at 5:37 am
  
  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.
  - Like(0)
  - Julie Oliver
    
    February 23, 2015 at 4:56 pm
    
    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
    Like(0)
    - david king Post author
      
      February 25, 2015 at 9:21 am
      
      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.
      
      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 .
      
      Like(0)
      /
      - Julie Oliver
        
        February 25, 2015 at 2:13 pm
        
        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
        
        Like(0)
      - david king Post author
        
        February 26, 2015 at 7:10 am
        
        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.
        
        Like(0)
      - Former Member
        
        February 27, 2015 at 4:43 am
        
        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
        
        Like(0)
      - david king Post author
        
        March 4, 2015 at 6:42 am
        
        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.
        
        Like(0)
Arun Sasi

March 4, 2015 at 1:24 pm

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
- Like(0)
david king Post author

June 7, 2016 at 9:55 am

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.
- Like(0)
- Arun Sasi
  
  June 7, 2016 at 2:05 pm
  
  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
  - Like(0)