Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Error in 2008 R2 Express

Author  Topic 

rrperez
Starting Member

4 Posts

Posted - 2010-12-06 : 01:43:51
Connected to Microsoft SQL Server Microsoft SQL Server 2008 R2 - 10.50.1600.1
java.sql.SQLSyntaxErrorException: [Vignette Corp.][SQLServer JDBC Driver][SQLServer]Invalid object name 'CL_PROPERTIES'.

Can anyone help with this problem, it is an error found in the log of a collaboration server.

Setup:

Database Server - SQL Server 2008 R2 Express
Application Server - uPerform

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-06 : 03:50:08
The error says that it's looking for an object called 'CL_PROPERTIES' and that object is not there.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

rrperez
Starting Member

4 Posts

Posted - 2010-12-06 : 04:32:25
So do I need to create that object, how?

another thing is upon installation of the collaboration server, an error was detected about database schema upgrade.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-06 : 05:15:14
Maybe

If the schema upgrade failed, that's a likely reason for the missing object. I think you need to speak to someone who can support hat collaboration server (whatever it is)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

rrperez
Starting Member

4 Posts

Posted - 2010-12-06 : 20:55:51
Its Vignette Collaboration which embeds uPerform Server.

I'm just confused because in their guide, there should be no problem on the installation part, does the problem resides in the SQL Server or on the collaboration server itself?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-07 : 01:12:38
Absolutely no way to tell from here, that's why I suggest you call up support for that product.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-12-07 : 09:14:40
Are you sure you are connecting to the right server and the right database? What does the connection string look like? (don't post any ip's, usernames or password please )

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -