Skip to Content
0

SDI Real Time Flowgraph HANA -> HANA not working

Nov 10, 2017 at 09:28 AM

400

avatar image

I have what I thought would be a simple scenario, where I have a source table in HANA, a transformation in SDI (Flowgraph) and a target table, in HANA, the same database/schema as the source.

It is working fine when I run this in batch mode.
When I tick the boxes 'Real Time' at container level and on the source table, I get the following message when trying to activate:

hdbflowgraph] "SCHEMA.Package/name.hdbflowgraph": flowgraph XML content error; ERROR: Virtual Table Data Source/Input Type is not found in Realtime Flowgraph

What is going wrong here?

My impression from Werner Daehn's blog was that the only thing I needed to do to convert a batch job into a real-time job is to tick those boxes.
( https://blogs.sap.com/2014/12/09/hana-sps09-smart-data-integration-realtime-table-replication/ )

Apparently, there is more to it than just that, but I can't think of what...

Is it because I use a local source instead of a remote source?

Any suggestions welcome... .

Jan.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jan Van Ansem Nov 22, 2017 at 09:12 AM
1

I had a reply from SAP explaining I was using the wrong HANA adapter. The one I was using was HANA (ODBC). There is now also a HANA Agent based Adapter. I changed the remote source and now it is working fine.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Jan,

I am facing the same kind of error while creating a Real time Flowgraph

Virtual Table Data Source/Input Type is not found in Real time Flow graph

All the source tables are virtual tables and i am using HANA Adapter.

Is there any other steps that you had taken to resolve this issue.

Regards,

Abhishek

0
Jan Van Ansem Nov 14, 2017 at 11:48 PM
0

Right, I got a bit further with this one. I changed the source table from a local table to a remote table, and now I no longer have the problem with 'Virtual Table not found in Realtime Flowgraph'.

However, I do have the next problem, which is a message saying:

"CREATE REMOTE SUBSCRIPTION is not permitted on remote source:"

I have checked the privileges of the
- Owner of the Remote Source,
- _SYS_REPO

- Developer who creates the Flowgraph

All of them have the privilege set for the remote source to 'CREATE REMOTE SUBSCRIPTION'.

The message says the action is not permitted, not that the user is not authorised, so I am probably looking in the wrong place.

Why could it be 'not permitted' to create a remote subscription on a remote source?

Any suggestions where to look are gratefully received....

Share
10 |10000 characters needed characters left characters exceeded