Skip to Content

HANA DB 1.00 Build 20 - Error import COPA Data with HANA STUDIO 1.00...

Hi,

Has anyone tried loading data records to HANA DB 1.00 Build 20 from the CTL files provided in https://wiki.wdf.sap.corp/wiki/display/HANADemoenvironment/HowtoloadCOPAdata ?

It was work on HANA DB 1.00 Build 15 but not with New Build...

The procedure was exactly the same

The creation of Tables is done but i have this error with import data with each csv files:

Command with HANA Studio (Build 20):

load from '/tmp/export/TCURT.ctl' threads 4 batch 1000;

Error:

Could not execute 'load from '/tmp/export/TCURT.ctl' threads 4 batch 1000'

SAP DBTech JDBC: [257]: sql syntax error: line 1 (at pos 3643214585)

I tried also: load from '/tmp/export/TCURT.ctl' -> same error...

We have all privileges on the tmp folder and files 😊

I tried also to copy new data from source...

Do you have an idea?

Thanks for advance for help .

Best regards,

Eric MG

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Nov 15, 2011 at 09:58 PM

    Hello,

    LOAD TABLE command was not public - full syntax was never mentioned in any SAP guide on help.sap.com or Market Place (except SAP HANA Pocketbook-DRAFT). Therefore it is SAP internal syntax that can be changed anytime. And I guess this is what happened. Command is either deprecated or having different syntax.

    If you need to import CVS file I would suggest to use official way - either IMPORT command (which was also not very public before but since SP03 it is mentioned in SQL Script Guide) or best using SAP HANA Studio import functionality (just be sure you use CVS as type of file).

    You can find explanation of both ways in this blog:

    SAP HANA - Modeling Content Migration - part 2: Import, Post-migration Activities

    Tomas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2011 at 03:22 AM

    it works for me HANA 1.0 SP2 R18 but R20 means SP3 😊

    I don't have access for that SP3 right now, by the way did you installed SAP Client tools also Build 20? in Server and Studio also.

    thanks

    rao

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2011 at 08:18 AM

    Hi Eric

    I was able to reproduce the error in a 1.00.20.355749 (DB + Studio) environment. Syntax error for LOAD FROM. Furthermore, when I try to import the CSV via File->Import->SAP HANA Studio->Tables, the column for "Format" (in former builds you could choose between binary and csv) is empty and not editable now.

    I have follow up with the development to find out if this is a bug or a (removed) feature. I'll let you know...

    --Juergen

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 16, 2011 at 10:11 AM

    Hi,

    thanks all for your answer 😊

    I try with another Build 18...

    And the COPA data are imported successfully 😊

    Just one remark concerning the license with 1.00 Build 20, the license are temporary and we see it in the Properties of our SID (we can install a Temporary license Key)

    But with Build 18, we can see the license... we have an message: "Licensing functionality is not active in this SAP HANA database"

    Do we have an limitations or restriction date?

    Because i see also this message with Build 15 and now we can't install this Build (15), we have always an error on start DB (see in trace fodler) : 'can't retrieve a Valid License'

    Best regards,

    Eric

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.