Error unknown service id in graphical view data preview - SAP Datawarehouse Cloud (DWC)

[kameshwaren]

Hello all,

I am getting an error "unknown service id" when trying to view the data in JOIN or UNION node in the graphical view or sql view i created in SAP DWC. I tried to use the local table created and populated using data flow in DWC and i tried using the table created using real time replication in DWC as well. Both of them showing same error .

But i am able to use data viewer if the view is not having any join and its having only one table in it.

i am using 90 days trial account to use DWC. Please let me know how to check the details of this error and resolve it.

Thanks

//PK

[bechevar1]

Encountered the same error with trial version attempting to preview data in a join, projection, or calculated node. The output also generated the same error, but once saved and deployed successfully the view previewed correctly.

[kameshwaren]

Hi Xavier,

Thanks for your inputs 🙂

But just want to let you know that i tried all the combinations of cardinality , none to none, one(0,1) to many, many to many, exactly 1 to exactly 1. Nothing works. Also i am not using any associations in my view.

Regards

//PK

[XaviPolo]

Check the cardinality in JOIN. I remember that if it wasn't right, I got that error or a similar one at some point.

Also check that the view you are making does not have an association with one of the joined tables.

I hope that helps.