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.
| 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.1java.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 ExpressApplication 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 ShawSQL Server MVP |
 |
|
|
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. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-06 : 05:15:14
|
| MaybeIf 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 ShawSQL Server MVP |
|
|
|
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? |
|
|
|
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 ShawSQL Server MVP |
|
|
|
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  )- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
SQL Error in 2008 R2 Express