Skip to Content

unable to update the schema with SQL transform in Data Services 4.2

Hi All,

I implemented one complex query it includes joins,cast ,replace and few more filter conditions. the same query i am able to execute from hana data base.

When i am trying to use with SQL transform in Data services schema is not updating and i am getting the error odbc data source error operation -BODI1130199 and i am able to see the all the tables existing and imported in data store ,am able to view the data in that tables

Kindly suggest me the possible alternative solutions

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 13, 2017 at 02:30 PM

    Hello Chandra.

    Are you sure that you are not using variables into query.

    I have been in a similiar situation and I accidentally changued the datastore or database, even I left global variables.

    Check it and let us know!

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 01:39 PM

    its resolved

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07 at 12:07 PM

    hello good afternoon, you can use global variables in "sql transform dataservices 4.2" because I have already tried brackets, keys, parentheses .. if nothing and I do not recognize the global variable, I want to do this: select * from TABLE where field = {$ variable_global} and what I get is the error odbc data source error operation -BODI1130199, Help please.

    I just want to know if you can use the global variables or not, what else can I do to pass the value of a variable?

    Thank you..

    Add comment
    10|10000 characters needed characters exceeded