|
Home > Archive > Commerce Server General > September 2006 > error - Invalid object name 'SystemProps'
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
error - Invalid object name 'SystemProps'
|
|
| Victor S 2006-09-21, 1:21 pm |
| Hi folks, I am new to Commerce Server.
I downloaded "CS2007Dev_EN.exe" and tried to install it.
Install goes well, howevere when I get to the Configuration Wizard portion
it immediately throws an error "Invalid object name 'SystemProps'" and
configuration wizard fails after that.
Can anyone provide me with some troubleshooting ideas?
Here is the snippet from the error log:
[10:47:35 INFO] The ComparisonStyle for Database 'MSCS_Admin' is 196609
[10:47:35 ERROR] CSConfig failed during configuration of feature
Administration Database (Feature.MS.CS.Admin).
[10:47:35 ERROR] Exception occured during feature configuration:
Microsoft.CommerceServer.Internal.Config.ConfigurationException: Invalid
object name 'SystemProps'. ---> System.Data.SqlClient.SqlException: Invalid
object name 'SystemProps'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.CommerceServer.Internal.ServerUtility. ExecuteSqlScriptFromString(SqlConnection
connection, SqlTransaction transaction, String sqlScriptContents)
at
Microsoft.CommerceServer.Internal.ServerUtility.ExecuteSqlScript(SqlConnection connection, SqlTransaction transaction, String sqlFileName)
at
Microsoft.CommerceServer.Internal.ServerUtility.ExecuteSqlScript(String
connectionString, String sqlFileName)
at
Microsoft.CommerceServer.Internal.Config.DBConfig.ExecuteSqlScript(String
connectionString, String scriptFilePath)
--- End of inner exception stack trace ---
at
Microsoft.CommerceServer.Internal.Config.DBConfig.ExecuteSqlScript(String
connectionString, String scriptFilePath)
at Microsoft.CommerceServer.Internal.Config.AdminConfig.ConfigureAdminDB()
at Microsoft.CommerceServer.Internal.Config.AdminConfig.Configure()
at
Microsoft.CommerceServer.Internal.Config.ConfigurationDriver.ConfigureHelper(List`1 orderedListOfFeatures).
[10:47:35 INFO] Exception was non-fatal. Beginning rollback.
| |
| John Inman [MSFT] 2006-09-23, 1:32 am |
| Is your database set to Case-Sensitive collation? If so, this would
explain the problem, Commerce Server 2007 does not support SQL
case-sensitive collations.
If not, can you let us know what the SQL collation is set to?
Hope this helps
John
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
| |
| Victor S 2006-09-23, 1:32 am |
| John thank you for taking your time!
I did go over install docs and noticed that db needs to be set to -
SQL_Latin1_General_CP1_CI_AS.
The problem was, as it appears to be that, I created databases manually on
the SQL server (is what I asumed I had to do from the intall guide), before
running the wizard. Once I deleted databases and actually allowed
Configuration Wizard to create them for me, itworked like a charm.
Again, thank you for taking a stab at it.
|
|
|
|
|