Database Error during Installation

[ajjunit84]

Hi All

I am instalation PI 7.1 on windows 2003 SP2 and MS SQL server 2005 SP2.

The SQL server is installed as a Named Instance for PI.

On the same server ERP is also installed and for the SQL server DB was installed as default instance.

Now while installin PI i got different kind of error and again and again ii started fresh installation.Last time it has created the DB objects etc.Then i got some error related to Java import and i againstarted the installation.

Last time it was struck in the phase of deleting/droping PI schema.

At this time ,i am struck with an error like this

"Error :User table belonging to the dbo schema were found in the database PI

SOLUTION: You can only install an SAP system in a database with no user objects belonging to the system schema dbo. If there already is an SAP system in the database (MCOD), or you install a Java Add-In, you might have to convert the existing system to its own schema, or contact your SAP support."

Can anybody let me know how to resolve it?

Regards

Ajay

[Former Member · Accepted solution]

Hi

you can check if ERP is schems or not as follows:

1. login to SQL server studio and connect to ERP database

and check for the owner of the tables,it should be ECX

2. login to SAP system,in the main screen go to system->status

there you can check under schema who is the owner

it should be ECX

if ERP is schema system,then you will have to install PI as schema system only and the owner should be SID of PI system

Rohit

[ajjunit84]

Hi ,

Do you know how to uninstall a named instance.

I am now trying to uninstall the named instance and install it again .

Regards

Ajay

Edited by: Ajay Sandal on Apr 18, 2009 4:37 PM

[Former Member]

Hi Ajay

refer to http://support.microsoft.com/kb/290991

you will be able to uninstall it

Rohit

[jorge_velasquez]

SAP Support :

execute from MSSQL:

drop table sysdiagrams

Then SAPINST asks if you want to add them and simplyanswering 'yes

Then the table 'sysdiagrams' will be created again by means of SQL

Management Studio:

- Open the Object Explorer, expand the PRD database node and then

expand the 'Database Diagrams' node under the database connection

and selecting 'Yes' when prompted if you want to set up database

diagramming.

Regards

[ajjunit84]

Ok thats fine.

But while installating Pi ,MS SQL DB is already installed and named instance hostname_PIX is also installed for PI,

Now when i launch sapinst for Pi i didn;t get any option like MCOD etc .Only thing is that i receive something like chosse the DB which i choose as host/PIX.

Let me kniow in case there is some other way.

Regards

Ajay

[ajjunit84]

Hi Rohit

I found in ERP status under Database ,name is ECX host is server host name and owner is ECX.

Whats wrong here??

Regards

Ajay

[Former Member]

ok

that shows your ERP system is a schema system

now you should install PI same as you done for ERP(you should install SQL server for PI as default only),also Choose MCOD option while doing PI installation

what is happening is that you are installing PI as a non-schema system,that is why it is giving error

Rohit

[ajjunit84]

Well i tried to check the owner ,but didn't get any information in the properties of the Tables for ECX.

But found there that the table belongs to Schema SAPECXDB ,so i think ERP has schema .

Now ,the issue is the i am not able o see anything related to PIX and while installaing it says objects found in dbo of PID DB.

Not sure how to resolve it.

Regards

Ajay

[Former Member]

this is wrong Ajay

the schema owner must be either dbo or <SID>

login to ERP system,go to system->status

there you will fine schema written there and owner

let me know what it is

Rohit

[ajjunit84]

Hi Rohit

Can you explain more .

Ofcourse ERP is a schema system.It has its schema in ECX db.

Let me know how to confirm this..

Regards

Ajay

[Former Member]

hello Ajay,

Is ERP a non-schema system,

if yes

you have couple of choices:

1. convert ERP to schema system

2. Install PI as schema system

Rohit