Control-M Server is not getting Started!!

suru81 · Post by **suru81** » 16 Feb 2010 2:19

After checking Start ALl via ctm_menu SQL Server is showing as running

CONTROL-M Manager Menu
-----------------------------

Select one of the following options:

1 - Check All

2 - Start All
3 - Start Database
4 - Start CONTROL-M/Server

5 - Stop All
6 - Stop Database
7 - Stop CONTROL-M/Server

q - Quit

Enter option number ---> []:1

-----------------------------

SQL Server is running.

CONTROL-M is not running.

-----------------------------

But Control-M server is not getting started as getting below error Database 'ctrlm620' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.”
Error: 926, Severity: 14, State: 1

Below is the error log :

00:00000

2010/02/15 16:04:26.56 server During undo the timestamp to be assigned to a page is less than the current page timestamp. Page = 1305, object
id = 96000342, page timestamp = (0000 097a4e14), new page timestamp = (0000 097a4ad1).
00:00000

2010/02/15 16:04:26.56 server Error: 12546, Severity: 18, State: 1
00:00000

2010/02/15 16:04:26.56 server During undo the timestamp to be assigned to a page is less than the current page timestamp. Page = 1305, object
id = 96000342, page timestamp = (0000 097a4e14), new page timestamp = (0000 097a4ad1).
00:00000

2010/02/15 16:04:26.57 server Error: 12313, Severity: 21, State: 1
00:00000

2010/02/15 16:04:26.57 server Internal error: Insert into page id 1305 of index id 3 of table 'CMR_AJF' (id = 96000342) in database 'ctrlm620
' tried to replace undeleted RID (1089,6) at slot 12 and ridposn 3. Try dropping and recreating the index.
00:00000

2010/02/15 16:04:26.58 server Error: 3414, Severity: 21, State: 1
00:00000

2010/02/15 16:04:26.58 server Database 'ctrlm620' (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the
cause.
00:00000

2010/02/15 16:04:26.58 server Recovery has restored the value of 'local async prefetch limit' for '32K' pool in 'default data cache' from '80
' to 'DEFAULT'.

Please suggest

rahulsehgal · Post by **rahulsehgal** » 16 Feb 2010 3:50

Hi suru81,

Try checking the port settings for Control-M Server as this error usually comes when the ports are not set accordingly, also check ports used by Control-M is in use by any other application or not.

You can check Port settings for Control-M in Parameter Customization menu in ctm_menu on Control-M Server, thanks.

Regards,
Rahul Sehgal

suru81 · Post by **suru81** » 17 Feb 2010 6:54

Nope this isn't the issue..Issue is that sybase database is actually not getting started ---Database '%.*s' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause. due to H/W error

rahulsehgal · Post by **rahulsehgal** » 17 Feb 2010 3:04

Suru81,

May be you are right as its a hardware issue or Sybase server issue, but I faced the same issue before while installing Control-M 6.4 Server with MSSQL Server as backend on Windows, when we tried writing the table in Control-M EM after installation, it works fine, but when we tried to upload the same it didn't worked because Server was unable to communicate with EM Database and its OWN database, when we check port settings, they were not correctly set and some firewall settings were also causing issue in communication.

Regards,
Rahul Sehgal

philmalmaison · Post by **philmalmaison** » 18 Feb 2010 3:10

did you try to stop the database (mv the core if it's one) and restart the database (checking that no process runing on controlm server user) ?

regards
philmalmaison

suru81 · Post by **suru81** » 22 Feb 2010 11:29

We have tried all possible thing..rebooting the host/unmount/mount the FS but all through its giving SYBASE H/W error..

Below is the latest error from CTM_MENU==>Check all

The context allocation routine failed when it tried to load localization files!!
One or more following problems may caused the failure

Your sybase home directory is /opt/controlm/620/server/sybase. Check the environment variable SYBASE if it is not the one you want!
Cannot access file /opt/controlm/620/server/sybase/config/objectid.dat

SQL Server is not running.

The context allocation routine failed when it tried to load localization files!!
One or more following problems may caused the failure

Your sybase home directory is /opt/controlm/620/server/sybase. Check the environment variable SYBASE if it is not the one you want!
Cannot access file /opt/controlm/620/server/sybase/config/objectid.dat

CONTROL-M is not running.

-----------------------------

philmalmaison · Post by **philmalmaison** » 22 Feb 2010 4:07

what is the content of your $SYBASE (do a echo $SYBASE)
do you have something more reliable in ~/sybase/ASE*/data/error.log ?

regards
philmalmaison