Error In statistics Tab in LTR Configuration

[Former Member]

Hello Experts,

I am new to SAP HANA and we are using SLT To load data from non-sap system(Oracle)

to load data to hana system, when configuring SLT using LTR we are getting a error in Statistics tab

I have attached the screen shot, and the tables(DD02L,DD02t & DDo8L) are not getting populated in Data Provisioning in

sap hana studio

I think the issue is with privileges for the schema i created, i am using system user but still not able to access the same

Could you please help.

Thanks & Regards,

Kishore

[FCI · Accepted solution]

Hi Kishore,

The ECC user you are using don't have enough authorization.

You need to assign him the role SAP_IUUC_REPL_REMOTE .

Regards,

Frederic

[Former Member · Accepted solution]

Hello Frederic,

Still getting the same error, got the role added to the ecc user.

Thanks

Kishore

[Former Member · Accepted solution]

Hello Kishor,

You need to make sure that the user that is used for connecting via RFC have the required authorization. this user is the user that goes to the ECC system via RFC connection and tries to create the triggered and logging tables.

1. login to ECC --> goto SM66 check which user id coming inRFC from SLT system.

2. provide required authorization to the user mentioned in RFC.

Else

restart the replication for a perticular table... just to regenerate the error msg.

goto SU53 and check authorization for the RFC user coming from SLT system.

Let me know if this help you.

Regards

Amar Ghuge

[former_member252769 · Accepted solution]

Hi Kishore,

Once you got the roles added.

Stop the replication of that table and put again in replication.

Regards

BJ

[Former Member · Accepted solution]

Hello Jones,,

I deleted the LTR configuration and recreated it, first error in statistics tab is resolved

but still not able to populate the table content of DD* from ECC to HANA, the table are visible in

Data Provisioning

Thanks & Regards,

Kishore

[Former Member · Accepted solution]

Hi Amar,

it is the same user which i have assigned the user role mentioned in

above reply, but still not able to populate the DD* table data in hana.

Thanks & Regards,

Kishore

[Former Member · Accepted solution]

Hello Frederic,

now i am getting this error, while loading data , this is from LTRC

Program terminated in remote system GRDCLNT100: User ALEREMOTE does not have required authority to

Could you please let me know which role i have to update for aleremote

Thanks & Regards

Kishore

[former_member252769 · Accepted solution]

Hi Kishore,

Please check if your LTRS system should have enough work processes (via SM50) and check how many background process you have.

Also, make sure that DB user in target HANA should have below privileges:

CREATE SCHEMA

ROLE ADMIN

USER ADMIN

Regards

BJ

[Former Member · Accepted solution]

Hello BJ,

still facing the same issue, i create Data provisioning using system user for my schema TESTECC, it created user with schema name TESTECC, and when granting permission

i am using system user to login to hana studio, not sure which user sql editor i should execute permission

thanks

kishore

[FCI · Accepted solution]

This error happened on the ECC side so let's focus on this system.

Any more information on the SM21 ?

Can you try to assign SAP_ALL  to ALEREMOTE ? just to validate that this is an authorization issue.

The role SAP_IUUC_REPL_REMOTE  was assigned to this user ?

Regards,

Frederic

[former_member252769 · Accepted solution]

Hi Kishore,

Proper approach would be create DB user with above privileges and let LTRS handle the replication user creation automatically (with required authorizations) and schema.

In your case, please make sure that your user TESTECC should have:

Authorizations:

SELECT authorization on table SYS_REPL.RS_REPLICATION_COMPONENTS to read SAP LT RS configuration info.

Roles:

TESTECC_DATA_PROV

TESTECC_POWER_USER

TESTECC_USER_ADMIN

TESTECC_SELECT_USER

Give SAPL_ALL and SAP_NEW to RFC user from source system.

If still error comes then send the screenshot.

Regards

BJ

[Former Member · Accepted solution]

Sure BJ, will try the same and get back to you, we are having network issues

not able to connect,

[Former Member · Accepted solution]

Hello Kishor,

I would agree with Frederik, please concentrate on ECC system roles... for simplicity follow below approach..

1. Stop the replication for all the DD* table from ltrc--> goto table overview --> select data provisioning --> give table names and select stop replication.

once replication is stooped that table entry be no longer will available in LTRC tcode table overview

2. goto ECC system start the system trace for authentications --> check the authentication for the user which is used in RFC to connect from slt to ECC system.

3. set up same tracing for background user in SLT system.

4. once done start the replication of the DD* tables in LTRC one after the another. and then check the roles and the authorization missing

5. assign the required authss and then try.. again

Please let us know the result preferable would be error screen shot,.

Regards,

Amar Ghuge

[Former Member · Accepted solution]

Hi Amar,

I tried all possible options but still getting error

please find my reply to the original post

Thanks & Regards,

Kishore

[Former Member · Accepted solution]

Hi Federic,

I tried all possible options but still getting error

please find my reply to the original post with all details

I added all available roles to aleremote in ECC, we dont have sap_all & SAP_new roles in ecc system.

Thanks & Regards,

Kishore

[Former Member]

Hi All,

Thank you very much the issue is resolved,

data is getting populated to DD* tables in HANA studio

Thanks & Regards,

Kishore

[former_member252769]

Cheers mate !!

[Former Member]

Hello BJ,

I tried replicating and load data from MARA table in ecc to hana DB, i am getting the below error

i went to ecc to check the status in tcode IUUC_Remote, there are no triggers for table MARA

I think the system is not able to create automatically triggers for MARA table.

I searched a lot but of no use

Thanks & Regards,

Kishore

[former_member252769]

Hi Kishore,

Open a new discussion.

Also mention which is the database of your source ERP system.

Regards

BJ

[Former Member]

HI All,

Adding few more images

Thanks & Regards,

Kishore

[former_member252769]

Hi Kishore,

Please add SAP_ALL and SAP_NEW in profiles not in roles.

Then once again, stop the erroneous table and replicate.

Regards

BJ

[Former Member]

Good one BJ cheers

Amar Ghuge

[Former Member]

Hello BJ,

Please find all the screen shot as attached

I am still getting the same error, i followed the steps provided by all in this blog.

I opened sql editor on system login and tried providing privileges to this user but it saying authorization issues, please find the screen shot attached.

And for aleromote user in ecc there is no sap_new or SAP_All roles so I added almost 650 roles available in ECC but still same error.

Thanks & Regards,

Kishore

[former_member252769]

Hi Kishore,

Please add SAP_ALL and SAP_NEW in profiles not in roles.

Then once again, stop the erroneous table and replicate.

Regards

BJ

[Former Member]

Hi BJ,

thank you so much the data has replaced, from all the DD* Tables,

& it is working fine now,

Thanks & Regards,

Kishore

[Former Member]

Hi Shakthi,

We are trying with SAP system (ECC), for the time being

but our actual source will be oracle, the development of oracle database is till going on.

Thanks & Regards,

kishore

[Former Member]

Hi Kishore,

Non SAP system will not have tables DD02L,DD02t & DDo8L and these table are only required when loading data from SAP system.

These SAP tables holds table definition.

Thanks,

Shakthi Raj Natarajan.