Skip to Content
avatar image
Former Member

missing column in BODS

In a BODS JOB we are using a table comparison to an attribute view on HANA. This works fine the DEV environment. but on Acc I keep getting a missing column message during run-time.

The JOB validates ok and data preview shows the column as expected. I tried a reimport and re-adding the table to the mapping operator.

Any pointers on what might be causing this issue ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 04, 2016 at 01:45 PM

    do you use sorted input\ row by row select in TC? can you run the job in debug - may be able to find out at what point the column goes missing?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2016 at 02:50 PM

    Hi Aasavari,

    thank you for the reply.

    I am using cached comparison table. I can start the job in debug mode but it errors out before hitting the breakpoint just before the Table comparison.

    Kind regards,

    Scott

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 05:18 PM

    if you trace SQL readers - do you see any select statement or create stored proc? For Hana Reading\loading DS will create a stored proc. Does it have that column. Almost looks like something corrupted, what if you create a new datastore and import that table? Do you see the column? What datatype is it?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2016 at 09:50 AM

    Try this: remap to a different table, then go back and immidiately remap to the first table again.

    (I was in a similar sitiuation where Table Comparison would not pick a change after reimport)

    Add comment
    10|10000 characters needed characters exceeded