Friday, August 7, 2015

[SAP][ODBC Driver]Non-space text found after ending quote


I have encountered below error during data import into HANA Dynamic Tiering

* 403: internal error: [SAP][ODBC Driver]Non-space text found after ending quote
-- (dblib/db_RecScanner.cxx 2657) SQLSTATE: HY000


I found that data has quotes (“) which is causing the issue. But didn’t find any forum/link related to this error in HANA DT or solution.

At this situation SLT can help, I have used SLT to load the data and was able to load successfully.

During research I found that few users encountered same issue during the data import into SYBASE
They propose below recommendations

- Remove quotes from all values in data file
- TURN OFF the QUOTES as QUOTES ON is default.

Refer below link for more info for SYBASE error
https://scn.sap.com/thread/3638327

Other possible errors you may encounter:

* 403: internal error: [SAP][ODBC Driver]Cannot convert PatKey to a integer(10) (column EMPLOYEE_ID) SQLSTATE: HY00

Possible solution: Please choose appropriate data type.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com 

18 comments:

  1. The oracle information was very excellent and more technical skills improve after refer that post.I impressed after seeing seeing that post really so nice.
    php training in chennai

    ReplyDelete


  2. Mobility| Austere Technologies

    REALLY VERY EXCELLENT INFORMATION. THIS BLOG IMFORMATION VERY GOOD AND WE ALSO PROVIDING BEST SERVICES.

    ReplyDelete
  3. Tripura 7th Class Syllabus
    Students who are Eagerly Searching for the Tripura 6th, 7th, 8th, 9th, 10th Class Revised Syllabus 2023 can Stay on this web page. Complete Subject wise TBSE 6th, 7th, 8th, 9th, 10th Class Syllabus 2023 Pdf Format are Attached in the Following Sections for Free of Cost, Tripura 7th Class Syllabus Therefore, All the Students who are Going to Appear for the Examination can make use of the Information Provided here and Accordingly practice Complete Tripura 6th, 7th, 8th, 9th, 10th Class Syllabus 2023 given in order to give their best in the Examination

    ReplyDelete