Db Creation Error

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Db Creation Error

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Db Creation Error

Page: [1]

Message

<< Older Topic Newer Topic >>

Db Creation Error - 21.Oct.2009 2:18:30 AM

hakkurt

Posts: 7
Joined: 16.Jul.2007
Status: offline

Hi

We tried to evaluate Gfi 6. When we want to add a new store, MA gives following error.
Checking database schema...
Create schema failed. Database cannot be used.
Please select another database or contact GFI Technical Support.

We are using Sql server 2005 9.00.3073.00 Turkish_CI_AI collation, I change db collation to Latin, it is also failed

We installed and tested Ma v5 on same DB server successfully

Thanks for your assistance

Post #: 1

RE: Db Creation Error - 21.Oct.2009 9:09:35 AM

hakkurt

Posts: 7
Joined: 16.Jul.2007
Status: offline

When I investigate Managementproviders log error shows detailed

2009-10-21,16:16:44,118,1,"#00000AD0","#0000000F","info   ","ManagementProviders","(MSSql) Stored Procedure [BrowseMessagesFA] >> Created"
2009-10-21,16:16:44,306,1,"#00000AD0","#0000000F","warning","ManagementProviders","Warning: (MsSql) Add audit trail failed (MArc Actions) Action [None]: Audit Call Context is not set"
2009-10-21,16:16:44,384,1,"#00000AD0","#0000000F","error ","ManagementProviders","Error: (MSSql) CreateSchema. RollingBack
;message: Must declare the scalar variable '@usrId'.
;Must declare the scalar variable '@usrId'.
;stack trace:    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(TdsParserStateObject 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 Store.Management.MsSqlSchemaProvider.CreateSchema(String connectionString, Schema schemaConfiguration, SchemaDetails& schemaDetails)
;"
2009-10-21,16:24:21,897,1,"#00001544","#00000008","info   ","ManagementProviders","(FS) Initializing"
2009-10

(in reply to hakkurt)

Post #: 2