Issue with accesing Caché database tables with Azure Datafactory
Hello community members!
I am trying to connect to Caché database from Azure data factory using ODBC connection. The aim is to read data from Caché and write it in Azure blob storage using copy activity. The ODBC connection is successful and i can see the Caché tables, but i'm facing an error while reading the table contents.
I'm getting the below error :
ERROR [HY000] [Cache ODBC][State : S1000][Native Code 400]
[SQLCODE: <-400>:<Es ist ein nicht behebbarer Fehler aufgetreten >]
[Cache Error: <<PROTECT>%0AmBk1^%sqlcq.SYA.cls691.1 ^SB700(""),/database/db4/syb/>]
[Location: <ServerLoop - Query Fetch>]
[%msg: <Unexpected error occurred: <PROTECT>%0AmBk1^%sqlcq.SYA.cls691.1 ^SB700(""),/database/db4/syb/>]
Can anyone suggest what could be going wrong here and where to look for the issue?
Thanks.
.
<PROTECT> means that you don't have enough permissions to read this database
And there is no simple answer to it, the easiest way is to add %All role to the user, which tries to access data.
the way to understand this is to determine what resource is required to access the database associated with /database/db4/syb/. You can find this out by going to System Administration->Configuration->System Configuration->Local Databases and view the table that is associated with /database/db4/syb/. You should see something like
find your and find the Resource then add the Resource to the Role you are connecting with. While adding %All as a role will prevent the error it will also grant a whole lot more permissions than just the <protect> error.
Hi Stephen,
Thanks for the response. Following your suggestion we found that a role was missing, after creating the role and assigning it to the user, it worked.
Can you describe how did you connect to ADF to Cache Database?
Hello, I am running a database with 2022.1.0. I would like to know the set up guide used and parameters to get the ODBC connection to test successful from the SHIR and ADF. Thanks