| |
Results |
|
MCLG: Using Collage with a Microsoft SQL Server 2000 named instance
|
When using a named instance, the host name is typically specified in the format of "computer_name\instance_name". However, when using a JDBC driver, the host name is simply the computer name of the SQL Server machine, for example "computer_name".
|
|
|
|
MCLG 4.0: ''System username is not allowed to log on to the database server'' error when setting up MSSQL server to connect with Collage.
|
MCLG 4.0: ''System username is not allowed to log on to the database server'' error when setting up MSSQL server to connect with Collage.
|
|
|
|
Problem with Content | Search | by date on non-English MS/SQL
|
If you use the "between" and specify valid dates, the query gets mangled when running to an SQL server that is not English. For example, if you wanted to search for assets modified between 1/11/2006 and 1/12/2006 (Nov1 to Dec1). This then shows this SQL in the log :
|
|
|
|
MCLG: MSSQL: Error ''Error changing password for the database owner. Error accessing project - possible wrong password supplied'' when attempting to change password for a project.
|
If the password for the database owner was changed via the SQL Server Enterprise Manager tool, then Collage will no longer be able to connect to the database. Collage will need to be synchronized so it can connect to the database. This is done by clicking the "Change Password" button on the Edit Project screen.
|
|
|
|
MCLG: Migrating or Copying project and get The system cannot find the path specified
|
Simply login to sql server and set the files size to unrestricted growth. You will probably want to delete the partially created database first.
|
|
|
Serena® Collage® Version 5.1.3 Release Notes
|
1.5 Database IMPORTANT! This has been completely fixed for SQL Server 2005, however the error may still occur with SQL Server 2000 if you upload files greater than 400 MB. (ENH104624) To improve deployment performance with Oracle, the "Analyze" query in the GatherTableStatistics stored procedure should be replaced with the dbms_stats package.
|
|
|
|
MCLG: Backing up databases when using MSSQL as the database server appends to the backup file.
|
The following scenario occurs when Collage is setup to use MSSQL server as the database server for projects or the admin database. When backing up the project or admin database via the System | Setup screen in Collage this causes the resulting backup file on the MSSQL server to be appended to the last backup instead of overwriting an existing backup. For instance if the project database was 5 mb in size the first time a backup was initated, the resulting .bak
|
|
|
|
MCLG: Invalid system user is specified for the database server.
|
There is a configuration option with MSSQL server that either allows the server to respond to a static port (1433 by default) or a dynamic port. In order for Collage to work with MSSQL it has to be set to respond to a static port. The MSSQL documentation has details on how to set that up but if MSSQL is setup to use dynamic ports you will see the error listed in this kb doc.
|
|
|
|
MCLG: How to create the admin database on MSSQL after the install is finished.
|
Run this at the command line to create the admin database again if the initial installation fails for some reason. ./collage.sh database-create-admin ms_sql_server 2000 <system username> <system password> ie
|
|
|
|
MCLG: Randomly one of multiple schedule deploy that start at the same time fail with "Activity Not Started"
|
Folder.PrepareReadFolderCache-SQLState(23000),SQLException:[Microsoft][ SQLServer 2000 Driver for JDBC][ SQLServer ]Violation of PRIMARY KEY constraint 'PK__ActiveUsers__6FB49575'. Cannot insert duplicate key in object 'ActiveUsers'. SQLState: 23000 errorCode: 2627-[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The statement has been terminated.
|
|
|
