SQL error 2812 - Please help !

[Former Member]

Hi All,

I got the errors at step 25 of 26 in ECC 6.0 installation.

ERROR 2008-09-01 13:41:41.953

FRF-00025 Unable to call function. Error message: SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'. .

INFO 2008-09-01 13:41:41.968

RFC connection closed.

ERROR 2008-09-01 13:41:41.968

MUT-03025 Caught ERfcExcept in Modulecall: SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'..

ERROR 2008-09-01 13:41:41.984

FCO-00011 The step runRADDBDIF with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|2|0|runRADDBDIF was executed with status ERROR ( Last error reported by the step :Caught ERfcExcept in Modulecall: SQL error 2812 occurred: Could not find stored procedure 'sap_get_index_type'..).

I tried to follow sap note 460268, but I am not be able to run SE38 with DDIC user. I got message " You are not authorirzation to use transaction SE38"

Please help me.

Thank you,

Quoc

[former_member189546]

Hello,

you can reset the default password of the SAP* user by deleting the

SAP* user account from the DB table usr02.

delete from usr02 where mandt='<Client>' and bname='SAP*';

Afterwards you will be able to log on to SAP in client 000:

user: SAP*

password: PASS

The password is case sensitive

regards,

John Feely

[Former Member]

The problem solved. Thanks All

[markus_doehr2]

What SQL Server version do you use and what ERP DVDs?

Markus

[Former Member]

Hi Markus,

It's SAP ECC6.0 Ehp4 and I am using 51038620_13 BS 7 SR1 Installation Master Windows Server on x64 64bit and SQL Server 2005 SP3 (51036539 RDBMS MSSQLSRV 2005 SP3)

The installation stop at step 25 of 26 ( running report).

Thanks,

Quoc

[markus_doehr2]

> It's SAP ECC6.0 Ehp4 and I am using 51038620_13 BS 7 SR1 Installation Master Windows Server on x64 64bit and SQL Server 2005 SP3 (51036539 RDBMS MSSQLSRV 2005 SP3)

Is the system started? Can you logon to the system?

Markus

[Former Member]

yes. the system started. I can login with DDIC user, but this user doesn't have any authorization.

[Former Member]

Hi Quoc

Please use a user with appropriated privileges.

You can configure user privileges creating a role on transaction PFCG ou setting a role on user using SU01

Or if you can, you could use SAP default administrator users like DDIC.

Hope that it helps you

Kind regards

Marcelo

[Former Member]

Thanks Marcelo,

DDIC user doesn't has authorization to run any transaction. The installation not completed ( stop at step 25 of 26) could be the problem. Is there any way to set user authorization at DB level.

[Former Member]

Hi Quoc

Try to use user SAP* instead of DDIC.

In addition, please verify in SU01 if DDIC user has the SAP_ALL and SAP_NEW profiles set.

You could try to use transaction SA38 instead of SE38, please check if you can.

Kind Regards

Marcelo Macedo.

[Former Member]

Hi Marcelo,

Do you know the default password for SAP* user ?

Thanks,

Quoc