dumps with particular transaction

[Former Member]

Hi Gurus,

i have installed NEW sap netviewer for quality system and restore database of PRD with Q70 SID . ALL transaction working fine but i am not able to run transaction XD01,XD02,XD03 it is giving dump for this perticular transaction.

i have restore database two to three times.

windows platform 2003 sp1

Databse : SQL 2005 Sp1

and this transaction deal with table TMODF(Pooled table)

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 07.09.2010 12:18:22

Short text

SQL error in the database when accessing a table.

Missing RAISING Clause in Interface

Program SAPMF02D

Include MF02DFT0

Row 2,083

Module type (FORM)

Module Name TABSTRIP_DYNSEL_OB20

Trigger Location of Exception

Program SAPMF02D

Include MF02DFT0

Row 2,093

Module type (FORM)

Module Name TABSTRIP_DYNSEL_OB20

Source Code Extract

Line SourceCde

2063 ENDIF.

2064 * Partnerrollen

2065 IF rf02d-d0324 IS INITIAL.

please advice.....

Regards

Sainath Nazare

[sebastian_dusch · Accepted solution]

Hi,

did you do a system copy or a clean installation.

If you just restore your backup the database schema and users won't fit.

If you want to install a NW from a backup or detach/attach a database, you should always do a System Copy.

Best,

Sebastian Dusch

[Former Member · Accepted solution]

Dear Sebastian

i have applied same process for DR server of PRD its working fine but it is creating problem for quality

Please advice......

Regards

Sainath

[sebastian_dusch · Accepted solution]

Hi,

your DR server usually has the same SID, so the schema and logins would be the same. Since your new server has a different SID the schema and login is different.

Your Q70 systems tries to select data from q70 schema which does not exist in your production database.

Best,

Sebastian Dusch

Edited by: Sebastian Dusch on Sep 7, 2010 11:40 AM

[former_member185954]

Hello Sainath,

Since your database is already up and running, schema may not be a problem.

I am assuming you have executed the following:

SE06 - > Post processing after system copy.

BDLS -> Conversion of SIDs.

Regards,

Siddhesh

[Former Member]

Dear Siddesh/Sebastian,

I have already done this activities ... but if i go for se16 for TMODF table it showing me zero entries where in PRD system it showing 233 entries . even i have tried to enter manually that entries but still it is showing same dump

Regards

Sainath

[former_member185954]

Hello Sainath,

Please ask your functional team to look into this, since all other functionality is working fine. I don't think this is a BASIS issue.

This is on the assumption that your system is up and running fine and there are not other dumps in the system.

Regards,

Siddhesh