System copy issue

[Former Member]

Dears,

Recently I competed system copy of my producation server into the dev server.

SAP release ECC5 ,Oracle 9i,Wndows 2003 server.

For copy i restored the prd offline backup in dev server,then create the control file on dev,then created OPS$ users on DEV and then changed the dba_schema in environmental variable in dev from SAPDEV to SAPPRD.

System got up and I performed all post actions.

Now the issue is that sometimes i am getting dump in my dev server ant any location.Like sometimes on executing on any tcode or sometimes on clicking at particular option.

The dump is :

DBIF_RSQL_TABLE_UNKNOWN

Table is known or does not exist.

Error analysis:

Table M_MAT1A either does not exist in database or is not listed in data dictionary.

then what i did i went to se14 and i created this table manually basically i also found that this is not a table,its a view.

Thus here my problem resolved but after some time also i got the dump again but this time it was for different view.

This is happening and i searched on all forums and SAP marketplace but didn't get anything.

Please help.

Deepak

[Former Member]

Hi Deepak,

could you please provide the abap dump in detail?

Regards,

Srihari

[markus_doehr2]

Did you maybe fiddle during the installation of the original system with the .TSK files? Those views are created using the SAPVIEW.TSK package during installation. I saw people here on SDN suggest to set errors there to "OK" manually to continue the installation.

Check if that view is there on the source system.

Markus

[Former Member]

Hi,

These views exist on source system.

Deepak

[antonio_voce]

Hi

Check !!!

Note 119941 - Missing tables after system copy

[Former Member]

Hi Deepak,

kindly verify if the notes below improves your situation:

662644 - Composite SAP Note: ORA-00942

736313 - ORA-00942 when accessing Oracle dictionary tables

Additionally have you installed successfully the license. Please confirm with the below commands.

-> saplicense -test

-> saplicense -get

-> saplicense -show

-> R3trans -dx

If still its not resolved, please let me know.

Thanks

Kishore

[antonio_voce]

Are the two system (PRD and DEV) at the same oracle patch level ?

Did you follow all steps descrived in homogeneous system copy guide ?

Note 147243 - R3COPY under NT Oracle

[Former Member]

Hi,

I followed all the actions as mentioned in note and patch level of oracle is also same.

Deepak