Thank you very much, I've tried it but BE still failed to start, I've tried almost all the solutions posted in symantec forum which related to this error message but still failed, is there any specific setting for the combination of SAP, SQL 2005, Windows 2003 and BE 11d, for example the SQL Server collation... etc
*******************************************************************************************************************
***************************************************************************
***** SGMon log for
\\SAPSLMSVR01 *****
***************************************************************************
BESERVER: [10/30/07 15:18:33] [4032] -1 Starting beserver system service application
BESERVER: [10/30/07 15:18:33] [0324] -1 Entered RpcXfaceServiceMain.
BESERVER: [10/30/07 15:18:33] [0324] -1 Sending start status to scm. (hint 300000)..
BESERVER: [10/30/07 15:18:33] [0324] -1 Initializing ACE...
BESERVER: [10/30/07 15:18:33] [0324] -1 Cblmanger, shutdown Immenient: started.
BESERVER: [10/30/07 15:18:33] [0324] -1 Cblmanger, shutdown Immenient: complete.
BESERVER: [10/30/07 15:18:33] [0324] -1 Cblmanger, check shutdown Ready: started.
BESERVER: [10/30/07 15:18:33] [0324] -1 Cblmanger, check shutdown ready: complete.
BESERVER: [10/30/07 15:18:34] [0324] -1 Initializing work queue...
BESERVER: [10/30/07 15:18:34] [0324] -1 Read from Registry: DBTimeoutInSec=30 ServerInternal=0x0
BESERVER: [10/30/07 15:18:34] [0324] -1 Server Connection String = Application Name=BEWS Server;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BEDB;Data Source=SAPSLMSVR01\VERITAS;Locale Identifier=1033;
BESERVER: [10/30/07 15:18:34] [0324] -1 Initializing Persistent Store (SAPSLMSVR01\VERITAS, BEDB, Backup Exec Server, 30 seconds)...
BESERVER: [10/30/07 15:18:34] [0324] -1 Attemp to GetMyPartition ComputerName=SAPSLMSVR01 PartitionID=0 PartitionGUID=09aa6bf8-7280-4ae6-82b3-2b2ce7ed55c5
BESERVER: [10/30/07 15:18:34] [0324] -1 InitializePartition() Data partition ID from registry=0
BESERVER: [10/30/07 15:18:34] [0324] -1 GetMyPartition() Data partition to use for 'SAPSLMSVR01' is 0
BESERVER: [10/30/07 15:18:34] [0324] -1 InitializePartition() returning 0x0
BESERVER: [10/30/07 15:18:34] [0324] -1 Successfully GetMyPartition ComputerName=SAPSLMSVR01 PartitionID=0 PartitionGUID=09aa6bf8-7280-4ae6-82b3-2b2ce7ed55c5
BESERVER: [10/30/07 15:18:34] [0324] -1 InitializePartition() ok, partitionID=0, oldComputerName=
BESERVER: [10/30/07 15:18:34] [0324] -1 Creating Business Objects...
BESERVER: [10/30/07 15:18:34] [0324] 00 VSN BO Initialization succeeded.
BESERVER: [10/30/07 15:18:34] [0324] -1 Server Configuration: Getting network configuration...
BESERVER: [10/30/07 15:18:35] [0324] -1 UpdateDynamicInfo: cluster open unsuccessful.
BESERVER: [10/30/07 15:18:35] [0324] -1 ServerName:SAPSLMSVR01, ActiveNodeName:,
InstanceName:VERITAS, DatabaseName:BEDB.
BESERVER: [10/30/07 15:18:35] [0324] 01 Server Configuration: BEServer schema version checks OK.
BESERVER: [10/30/07 15:18:35] [0324] 01 Server Configuration: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 02 Ownership: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 03 JobManBO: starting initialization...
BESERVER: [10/30/07 15:18:35] [0324] 03 JobManBO: initialization complete...
BESERVER: [10/30/07 15:18:35] [0324] 04 CAuditLogBO: Initialization completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 SQLLog(33):Database Exception Context:m_QueryTimeoutInSeconds=30 sql={? = CALL DBO.SAVEOWNERSHIP(?,?,?,?,?,?,?)} Error:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp". :: DB Error Set 0: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp". :: DB Error Set 1: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@Timestamp".
BESERVER: [10/30/07 15:18:35] [0324] -1 SQLLog(37):Database Exception Context:Ownership Insert Error:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp". :: DB Error Set 0: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp". :: DB Error Set 1: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@Timestamp".
BESERVER: [10/30/07 15:18:35] [0324] -1 Error(2/56): 137:native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp".
BESERVER: [10/30/07 15:18:35] [0324] -1 Error(2/56): -536837662:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp".
BESERVER: [10/30/07 15:18:35] [0324] -1 Error(5/4): -536837664:No records were found on database request.
BESERVER: [10/30/07 15:18:35] [0324] -1 Error(5/4): -536837661:The database function to insert failed.
BESERVER: [10/30/07 15:18:35] [0324] 05 LoginAccount: Failed creating Default System Logon Account. 0xe00081e2.
BESERVER: [10/30/07 15:18:35] [0324] 05 LoginAccount: Initialization Complete. BO=5.
BESERVER: [10/30/07 15:18:35] [0324] 06 Resource: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 07 ServersBO: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 08 CMediaServerPoolBO: Initialization completed.
BESERVER: [10/30/07 15:18:35] [0324] 09 ScriptMgrBO: Initialization Started. BO=9.
BESERVER: [10/30/07 15:18:35] [0324] -1 Operation: Verify default availability window.
BESERVER: [10/30/07 15:18:35] [0324] -1 Operation: success.
BESERVER: [10/30/07 15:18:35] [0324] 09 ScriptMgrBO: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Initialization Started.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Shrinking DAT files.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Start Dump of Original File.
BESERVER: [10/30/07 15:18:35] [0324] -1
Entering CMQBO : DumpMsgQContents.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 1 allocated items in the machine's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 0 allocated items in the queue's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 0 allocated items in the message's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1
The ??????????%*.*f allocator is NOT full.
BESERVER: [10/30/07 15:18:35] [0324] -1
NextMsgID:2118928152, OrigMsgID:2118928152.
BESERVER: [10/30/07 15:18:35] [0324] -1 No machine data found.
BESERVER: [10/30/07 15:18:35] [0324] -1 Leaving CMQBO : DumpMsgQContents
BESERVER: [10/30/07 15:18:35] [0324] -1
NextMsgID:2118928152, OrigMsgID:2118928152.
BESERVER: [10/30/07 15:18:35] [0324] -1 CMsgReader, Rewriting data but no machine records were read in.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Start Dump of new MODIFIED file.
BESERVER: [10/30/07 15:18:35] [0324] -1
Entering CMQBO : DumpMsgQContents.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 1 allocated items in the machine's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 0 allocated items in the queue's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1 There are 0 allocated items in the message's memory pool.
BESERVER: [10/30/07 15:18:35] [0324] -1
The ??????????%*.*f allocator is NOT full.
BESERVER: [10/30/07 15:18:35] [0324] -1
NextMsgID:2118963702, OrigMsgID:2118928152.
BESERVER: [10/30/07 15:18:35] [0324] -1 No machine data found.
BESERVER: [10/30/07 15:18:35] [0324] -1 Leaving CMQBO : DumpMsgQContents
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Shrinking DAT files Completed.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Not licensed for DDM.
BESERVER: [10/30/07 15:18:35] [0324] 10 MessageQueue: Initialization Complete.
BESERVER: [10/30/07 15:18:35] [0324] 11 Djm: ComputerName:SAPSLMSVR01, NodeName:SAPSLMSVR01. CASServer:.
BESERVER: [10/30/07 15:18:35] [0324] 11 Djm: pMMSFeature is NOT installed, setting mmsUsable FALSE.
BESERVER: [10/30/07 15:18:35] [0324] 11 Djm: pCASOFeature is null, casoUsable set to FALSE.
BESERVER: [10/30/07 15:18:35] [0324] 11 Djm: mmsUsable is FALSE, so setting DjmEnabled to FALSE.
BESERVER: [10/30/07 15:18:35] [0324] 11 Djm 3: DjmMgr:0, DjmClient:0.
BESERVER: [10/30/07 15:18:35] [0324] 01 UpdateDynamicInfo: cluster open unsuccessful.
BESERVER: [10/30/07 15:18:35] [0324] 01 UpdateDynamicInfo: cluster open unsuccessful.
BESERVER: [10/30/07 15:18:35] [0324] -1 SQLLog(82):Database Exception Context:m_QueryTimeoutInSeconds=30 sql={? = CALL DBO.SAVEMACHINEEX(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} Error:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp". :: DB Error Set 0: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp". :: DB Error Set 1: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@ID". :: DB Error Set 2: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@Timestamp".
BESERVER: [10/30/07 15:18:35] [0324] -1 SQLLog(86):Database Exception Context:MachineEx Insert Error:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp". :: DB Error Set 0: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp". :: DB Error Set 1: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@ID". :: DB Error Set 2: native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@Timestamp".
BESERVER: [10/30/07 15:18:35] [0324] 11 Db exception: 0x89, Desc:native=0x89 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Must declare the scalar variable "@timestamp"..
BESERVER: [10/30/07 15:18:35] [0324] 11 Db exception: 0xe00081e2, Desc:-536837662: :: -2147217900:Must declare the scalar variable "@timestamp"..
BESERVER: [10/30/07 15:18:35] [0324] 11 CDjmBO, InitializeMediaServers, SaveToDB, failed:0xe00081e2.
BESERVER: [10/30/07 15:18:35] [0324] 11 DjmBO: InitializeMediaServers failed, err=0xe00081e2
BESERVER: [10/30/07 15:18:35] [0324] -1 Business Object 11 failed to initialize:-536837662
BESERVER: [10/30/07 15:18:35] [0324] -1 RpcXfaceServiceMain: InitializeBOs() failed, BO:11, nRet:-536837662
BESERVER: [10/30/07 15:18:35] [0324] -1 Sending stop pending status to SCM...
BESERVER: [10/30/07 15:18:35] [0324] -1 RpcXfaceServiceMain exited.
BESERVER: [10/30/07 15:18:35] [0324] 01 Server Configuration: All clients (0) disconnected.
BESERVER: [10/30/07 15:18:35] [0324] -1 Cblmanger, shutdown Immenient: started.
BESERVER: [10/30/07 15:18:35] [0324] -1 Cblmanger, shutdown Immenient: complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 Cblmanger, shutdown: closing thread pool...
BESERVER: [10/30/07 15:18:35] [0324] -1 Core::WorkerThreadPool::close( )
BESERVER: [10/30/07 15:18:35] [0324] -1 *** WorkerThreadPool BEGIN ***
BESERVER: [10/30/07 15:18:35] [0324] -1 Core State: 1; Thread Count: 6; Messaging Type: 3; CPU Count: 2
BESERVER: [10/30/07 15:18:35] [0324] -1 Pool Contents:
BESERVER: [10/30/07 15:18:35] [0324] -1 *** WorkerThreadPool END ***
BESERVER: [10/30/07 15:18:35] [0324] -1 Core::WorkerThreadPool::close, timer queue done.
BESERVER: [10/30/07 15:18:35] [0324] -1 *** WorkerThreadPool BEGIN ***
BESERVER: [10/30/07 15:18:35] [0324] -1 Core State: 1; Thread Count: 6; Messaging Type: 3; CPU Count: 2
BESERVER: [10/30/07 15:18:35] [0324] -1 Pool Contents:
BESERVER: [10/30/07 15:18:35] [0324] -1 *** WorkerThreadPool END ***
BESERVER: [10/30/07 15:18:35] [0324] -1 Core::WorkerThreadPool::close, threads terminated.
BESERVER: [10/30/07 15:18:35] [0324] -1 Core::WorkerThreadPool::close( )
BESERVER: [10/30/07 15:18:35] [0324] -1 Cblmanger, check shutdown Ready: started.
BESERVER: [10/30/07 15:18:35] [0324] -1 Cblmanger, check shutdown ready: complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaUtilityBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaUtilityBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DeviceUtilityBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DeviceUtilityBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 NdmpServerBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 NdmpServerBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibrarySlotBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibrarySlotBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibraryPartitionBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibraryPartitionBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaVaultBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaVaultBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaSetBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaSetBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 MediaBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 Nrds: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 AdammCacheBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 AdammCacheBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DataEncryptionKey: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 BackupToDiskBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 BackupToDiskBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibraryBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 LibraryBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DriveBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DriveBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DevicePoolBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 DevicePoolBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 AdammMachineBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 AdammMachineBO: Shutdown.
BESERVER: [10/30/07 15:18:35] [0324] -1 ImageMgmtBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 CDsssBO: Shutdown completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 CMSGroupBO: Shutdown completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 CDebugBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 CAuditConfigurationBO: Shutdown completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 Copy Job: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 PersistentStore: shutdown complete...
BESERVER: [10/30/07 15:18:35] [0324] -1 Catalog BO shutdown succeeded.
BESERVER: [10/30/07 15:18:35] [0324] -1 JobLogBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 ServerObjects: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 Usershares: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 CAlertBO: Shutdown completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 CAlertConfigurationBO: Shutdown completed.
BESERVER: [10/30/07 15:18:35] [0324] -1 Notification: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 JobManager: shutdown started...
BESERVER: [10/30/07 15:18:35] [0324] -1 JobManager: shutdown complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 Job History: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [0324] -1 Job Completion BO: Shutdown Complete.
BESERVER: [10/30/07 15:18:35] [4868] -1 App stopped: SCM pending thread exiting...
BESERVER: [10/30/07 15:18:36] [0324] -1 Reports: Engine failed to shutdown.
BESERVER: [10/30/07 15:18:36] [0324] -1 AdammAdminBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:36] [0324] -1 AdammAdminBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:36] [0324] -1 Djm: Shutdown started.
BESERVER: [10/30/07 15:18:37] [0324] -1 Djm: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 10 MessageQueue: Shutdown Started.
BESERVER: [10/30/07 15:18:37] [0324] 10 MessageQueue: Normal Shutdown - Resetting Delete Corrupt Pfiles.
BESERVER: [10/30/07 15:18:37] [0324] 10 MessageQueue: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 09 ScriptMgrBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 08 CMediaServerPoolBO: Shutdown completed.
BESERVER: [10/30/07 15:18:37] [0324] 07 ServersBO: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 06 Resource: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 05 LoginAccount: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 04 CAuditLogBO: Shutdown completed.
BESERVER: [10/30/07 15:18:37] [0324] 03 JobManBO: shutdown complete...
BESERVER: [10/30/07 15:18:37] [0324] 02 Ownership: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 01 Server Configuration: Shutdown Complete.
BESERVER: [10/30/07 15:18:37] [0324] 00 VSN BO shutdown succeeded.
BESERVER: [10/30/07 15:18:37] [2380] -1 5000 contexts allocated during process lifetime
BESERVER: [10/30/07 15:18:37] [0324] -1 Uninitializing ACE...
BESERVER: [10/30/07 15:18:37] [0324] -1 BEServer shutdown completed.
BESERVER: [10/30/07 15:18:37] [0324] -1 Cblmanger, shutdown Immenient: started.
BESERVER: [10/30/07 15:18:37] [0324] -1 Cblmanger, shutdown Immenient: complete.
BESERVER: [10/30/07 15:18:37] [0324] -1 Cblmanger, check shutdown Ready: started.
BESERVER: [10/30/07 15:18:37] [0324] -1 Cblmanger, check shutdown ready: complete.
*********************************************************************************************************************