While creating DB connection ECC using DB02 got error

[former_member203760]

Hi Experts,

While i am creating DB connections in tx:DB02 , i am geeting error like below,

After this i tried to create db connection in LTRC i got error like below:

I have done below step for this,

1. HANA DB instllation,

2.SLT add-on DMIS in ECC6 EHP7

3.DBLS files for HANA in ECC6 EHP7 system and restarted

4.I have installaed HANA DB client in SLT server and given HDBCLIENT ENV varable.

5.After  this i tried to do above steps.

Please help me is there any missing from above process. please let me know for move forward.

Thanks in advance.

Jana

[former_member203760 · Accepted solution]

Hi All,

Thank you very much for every one. i have solve my issue while copying libSQLDBCHDB.dll file from HANA DB client  SQLDBC zip file to SLT server usr/sap/SID/DVEBMGS/exe.

Thanks

Jana

[former_member203760]

Hi Experts,

Please help me for the above issue i have re-checked everything is fine.

Thanks in Advance.

Jana

[jimguo]

Hi,

I suggest to check work process trace to see what is the problem.

Thanks.

Jim

[jimguo]

Hi,

Please review SAP KBA 1828028 and see if it helps.

Thanks.

Jim

[former_member203760]

Hello Jim,

I have seen this Snote already, but i am not able to edit the table DBCON in SM0 i got error like

Display and Maintenance of view/table DBCON not allowed.

Please guide me to solve this issues.

Thanks

Jana

[basis_offshoresupport]

Hi Jana,

Try to use DBCO and you should be able to maintain .

thanks,

Om

[former_member203760]

Hi Om,

I am able to maintain values in DBCO but, still i am facing same issue in LTR and LTRC.

i need help on creating configuration in SLT server, for this what i need do pre-steps please help me.

Thanks

Jana

[Saritha_K]

Hi,

Its very strange that you are not getting any system logs for it.

For the error message "Error in opening the connection.." generally we get to see some logs in ST22, SM21.

are you able to login in Hana Studio using your credentials?

Can you check whether SYSTEM user is locked or not by any chance?

Regards,

Saritha K

[former_member203760]

Hi Saritha,

I have checked in ST22 and SM21, but no errors in there also.

I am able to log with SYSTEM user in HANA studio.

Please help me. and if possible provide any contact no like gmail or skype. so that i will reach you for this issue.

Thansk

Jana

[basis_offshoresupport]

Hi Jana,

You have to re-check complete configuration steps especially with host ,  users  & roles , can you provide complete steps are you are following.

Are you are to login to HANA studio with System user ?

Thanks,

Om

[former_member203760]

Hello Om,

I followed steps like below,

1.I have installed HANA and i am ble to log in with SYSTEm user.

2.I have don DMIS 2011 _731 add-on With SP08 in ECC6 EHP7.

3.I have created a user in ECC with below roles,

SAP_IUUC_REPL_ADMIN

SAP_IUUC_REPL_DISPLAY

SAP_IUUC_REPL_REMOTE.

4. I have activated all services in SiCF

5. After this i have maintain HDB details in DBCO and try to created connection in LTR i am facing issue here.

Please let me if i have missed anything.

Thanks

Jana

[Saritha_K]

Hi,

Based on your SAP kernel and DMIS version, have you applied all patches?

Regards,

Saritha K

[former_member203760]

Hi Saritha,

I have applied the latest kernal to the ECC and i have taken DBSL patch from HANA data base also.

thanks

Jana

[Saritha_K]

Hi,

Can you check if LTR tcode is working for you or not?

Using LTR t-code you can create a SLT configuration as well.

moreover, in your LTRC screen, I cant see any password as such.

maybe thats why you are not able to create a connection to db.

Pls ensure you are putting the correct hostname as well.

SAP Note 1759156 can be used to verify your installation steps.

SAP Note 517484 can be used to check SLT-specific web services.

Below  link would be useful to you-

http://help.sap.com/hana/SAP_Landscape_Transformation_for_SAP_HANA_Operations_Guide_en.pdf

Hope this helps!!

Regards,

Saritha

[former_member203760]

Hi Saritha,

Thank your for your response.

I am able to run tx:LTR also but i am getting error while click o create like below,

Please help me for this.

Thanks

Jana

[tobias_koebler]

Hi, do you have the proper roles assigned for your HANA user? Check the system log, there you see the roout cause of the error.

Best, Tobias

[former_member203760]

Hi Tobias,

I have assigned below roles for the SLT user,

SAP_IUUC_REPL_ADMIN

SAP_IUUC_REPL_DISPLAY

SAP_IUUC_REPL_REMOTE.

I am not able to get any information on system log.

Please help us for this.

Thanks

Jana

[former_member203760]

HI Saritha,

Thank you very much for your quick response.

I have Done all post installation steps like services activation in SICF, creating user,assigned required roles for that user also.

I having Source and SLT server in same server with DMIS 2011 SP08 and HANA SP09.my ECC version is ECC6 EHP7 with kernel 741.

Please tell me is there any other way to solve this issue.

Thanks

Jana

[tobias_koebler]

I am not talking about installation -> I am talking about the user that is used to connect to the HANA database. Check the Security Guide for this purpose.

Best, Tobias

[former_member203760]

Hi Tobias,

I am using correct user(SYSTEM) only for HANA data base .I need to do any configuration in HANA Studio.

thanks

Jana