View Composer 2.5 installation problem

[dcarle]

We've made a separate server for our oracle 11 and one for our vCenter. (both server are 64 bit win2008 SP2 Enterprise)

So first we made the DB for the vcenter server and installed the vcenter server without problems.

Then we made an second database for the view composer and trying to install the composer 2.5 on de vCenter server. but when we come to the screen to enter the DB options, we get stuck.

Testing the ODBC succeeded.

In the vmware-sviconfig we see this when it occurres:

This image shows the databases on the DB-server

It there someone who had the same problem and found a solution or someone who can help me?

tnx

[eeg3]

Are you using the 32bit or 64bit ODBC panel to create the DSN?

____________

blog.eeg3.net | Useful VMware-related Links

If you found this or any other post helpful, please consider the use of the Helpful/Correct buttons to award points.

[dcarle]

I open the odbc from the administrative tools and I checked the properties: %SystemRoot%\system32\odbcad32.exe

Update:

today I also installed a 32bit oracle client on the vcenter server where I want to install View Composer. And added the oracle ODBC driver. After that I configured a 32bit DSN (C:\Windows\SysWOW64\odbcad32.exe)

So in my 64bit ODBC administrator I got a DSN for vcenter (working perfect) and in my 32bit ODBC administrator I got a DSN for the view composer (connection test succeeded)

But now in the installation of view composer I got the same problem, because the installer opens automaticaly the 64bit ODBC administrator.

How can I use the 32bit ODBC administrator during the View Composer installation?

Here you can see when I start the view composer installation that the proces is 32 bit:

[stozka]

quite insane,

got same error when connecting to 2008 sp 1 sql.

My OS is Windows 2008 64 SP2.

First i try with R2 but it didn't work, so i've change the OS for supported.

This got to be some kind of a bug.

[stozka]

well the solution is following,

if you check

docs and settings \ all users \ view composer \logs you will find

stem.Data.Odbc.OdbcException: ERROR [http://SQL Server Native Client 10.0|http://SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteScalar()

at VMware.Sim.SimConfig.Operation.OdbcManager.ExecuteCommand(String commandText)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.ExecuteScript(DatabaseType dbType, String folderName, String scriptName)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.SchemaCheck(IOutput output)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.DatabaseOperationExecute(IOutput output)

-

---

SviConfig Log End----

---

-

---

SviConfig Log Start----

---

-

---

SviConfig Log End----

---

on sql 2008 you need to do following

1) user must be dbowner

2) user must have server roles, not just public,

well enough of troubleshooting, let's move on

p.s:

i'm not sure exactly which roles are necessary!!

[dcarle]

my log is a bit different:

to make sure to have enough right, I try with the system user, or is this wrong?

2010-09-17 15:46:37,790 | INFO | SimConfig.Operation.OdbcManager - Current driver:SQORA32.DLL

2010-09-17 15:46:37,821 | INFO | SimConfig.Operation.OdbcManager - Current driver:SQORA32.DLL

2010-09-17 15:46:37,821 | INFO | SimConfig.Operation.OdbcManager - Current driver:SQORA32.DLL

2010-09-17 15:46:37,821 | INFO | SimConfig.Operation.OdbcManager - Current driver:SQORA32.DLL

2010-09-17 15:46:38,306 | FATAL | SimConfig.Operation.DatabaseOperation - Unexpected error.

System.OverflowException: Arithmetic operation resulted in an overflow.

at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount)

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteScalar()

at VMware.Sim.SimConfig.Operation.OdbcManager.ExecuteCommand(String commandText)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.ExecuteScript(DatabaseType dbType, String folderName, String scriptName)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.SchemaCheck(IOutput output)

at VMware.Sim.SimConfig.Operation.DatabaseOperation.DatabaseOperationExecute(IOutput output)

-

---

SviConfig Log End----

---

-

---

SviConfig Log Start----

---

-

---

SviConfig Log End----

---

[dcarle]

Has somenone configured a oracle database for his view composer? How did you configures the roles ad priviledges for the user that you use for this database?

[stozka]

you should install it by the book if you have supported versions of Windows and SQL.You only have to be sure that your oracle dbowner user is a temporary super-user until someone posts which permission are exactly nedeed for the server role on the SQL server. Don't forget temporary since this can lead to a serious security problems. hope that helps at least a bit !

[dcarle]

I even tried with the system user but no succes. I've created a new user, with exactly the same privileges as the user for the vcenter database, no succes.

I followed the install guide, but the instal guide doesn't tell about the creation of the view composer user in oracle.

Here you can see the user I created:

[virtualroe]

Has anyone come up with a solution for this problem? i am encountering the same problem on installation. The interesting thing is that i did find this mentioned in the Oracle forums regarding a bug with ODBC and .NET.

http://forums.oracle.com/forums/thread.jspa?threadID=1123816&tstart=0

I am looking to see if that will make a difference for me. The discussion doesnt indicate what patch is required and if its needed on client or database. I will put up some follow up if I have any success.

[virtualroe · Accepted solution]

Sorry for the multiple posts, so going back to my original posting about the bug in ODBC and .NET, Oracle did release a patch for the Windows Client. The patch number is 9966926. (patching can be done using the opatch utility that is included with the install).

One thing to note is when I was doing my patch, I was failing on the oci.dll update. This still occurred after stopping the Oracle based services. When I ran process monitor on my host I determined that these services were also hooked into the DLL:

COM+ System Application

Distributed Transaction Coordinator

VMWare Tools Service (This is because I am running my Virtual Center on a VM)

Once I confirmed that nothing had a hook into that DLL, the patch was able to apply successfully. After a reboot, I ran the installer for View Composer and it installed. At this point I havent ran any extensive tests beyond the installation, but its definitely progress.

[dcarle]

Correct answer: we applied the patch on the database server and on the vcenter server (oracle client). Thanks