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 .
While executing the above JOB i’m getting the following error:-
Please help me with this issue
Thanks in advance,
DAVID KING J
Hello David,
Please refer to KB Article 1728095 as it gives resolution to this issue.
Kindest regards,
Julie
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.
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
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 .
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
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.
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
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.
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
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.
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