Error message after refreshing system

[former_member272249]

Dear all,

During the refresh of the Qual system by the Production system, the script user_change.sql failed (note 551915). The script change the old SID (pe1) by the new on (qe2).

The script have updated all tables of the database exept 2 tables (KNA1 and KNVV). These tables keep the old name and the old owner(pe1.KNA1 and pe1.KNVV)

Error message: "Object 'pe1.KNA1' does not exist or is not a valid object for this operation"

I have check these tables into Dev environment and it didn't been changed.

Thank you for your help.

Fabrice CHAINE

[clas_hortien]

Hello,

can you send us the result of

use QE2

select name,uid,xtype from sysobjects where name in ('KNA1','KNVV')

or when you are running on SQL 2005

select name,schema_id,xtype from sys.objects where name in ('KNA1','KNVV')

regards

Clas

[former_member272249]

HI,

In MSSQL 2005:

name schema_id type

KNA1 5 U

KNVV 5 U

Fabrice CHAINE

[clas_hortien]

Hi,

do they stay in the schema, even if you rerun the script for moving the objects ?

You can rerun the script as it will only select the object of the old schema and will

affect the other objects.

Regards

Clas

[former_member272249]

Hi,

Yes these tables keep the old schema when I run again the script.

Let drop the issue. The refresh is urgent, and I have to deliver the system tomorrow morning. I will refresh the system from another restore.

Thanks!

Fabrice CHAINE