Select query on table MARA in report ZMARA is not executed via secondary connection although a redirection with the SAP Business Application Accelerator?

[Former Member]

Hi,

We are doing a HANA Accelerator Custom Report Scenario using SAP HANA as a Secondary Database Connection.

1. I uploaded the Custom Scenario using RDA_MAINTAIN program.

2. I Created Secondary DB Connection using RDA_MAINTAIN Program.

3. I Activated the Custom Scenario using RDA_MAINTAIN program, But at this stage i got a message "Kernel does not support RDA".

After created the scenario i have Activated SQL Trace(ST05) and executed my Z-report and view SQL Trace. But its not showing which Database the data got fetched.

Could you please suggest me the Steps to be followed to execute and monitor the above scenario.

Could you please me in the above issue.

Thanks & Regards,

Ramana SBLSV,

+91 7853055553.

[former_member192616]

Hi,

are you using the right kernel?

Check those notes:

General: 1694697

Kernel 1713986, 1716826

Add-on 1694697, 1597627.

In ST05 in the deails of a trace record you will find the "connection" column. This column is not visible in aggregated views in ST03.

Kind regards,

Hermann

[Former Member]

HI Hermann,

Thank you for the reply.

The issue was we installed HANA on Kernel 7.20 now we have upgraded to Kernel 7.21 but while running HANA Accelerator Custom Scenario, it's giving dump like "Table is unknown or does not exist. "

I have checked ST05 after giving Dump there it's showing in Connection Name as HANA.

So i came to know that it's trying to fetch data of a table from HANA DB.

I have some doubt that whether we need to maintain separate Schema for each and every system which are exist in the landscape or a single Schema will be enough.

Thanks & Regards,

Ramana SBLSV.

[former_member192616]

Hi,

are you connecting with a user that has authorization to read in the schema where your table is?

check replies here:

http://scn.sap.com/community/abap/hana/blog/2013/05/11/how-i-solved-abap-dump-when-trying-to-access-...

Kind regards,

Hermann

[Former Member]

Hi Hermann,

Thank you for your reply and help.

My issue is we have 4 separate systems (Development, Quality, Production and Mock Servers).

Currently we have a created a Secondary DB Connection between DEV and HANA DB, so default its taking SYSTEM as Schema.

Now we are trying to create a Secondary DB Connection between Mock Server and HANA DB and now we want to test HANA Accelerator Custom Scenario. Could you please help me how to proceed to have a separate Schema for MOCK Server in HANA DB and when we test our scenario SQL statements should get execute from HANA Secondary DB.

Could you please provide me if you any screenshots or step by step procedure document.

Thanks & Regards,

Ramana SBLSV.