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:000002010/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:000002010/02/15 16:04:26.56 server Error: 12546, Severity: 18, State: 1
00:000002010/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:000002010/02/15 16:04:26.57 server Error: 12313, Severity: 21, State: 1
00:000002010/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:000002010/02/15 16:04:26.58 server Error: 3414, Severity: 21, State: 1
00:000002010/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:000002010/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
Control-M Server is not getting Started!!
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
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
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
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
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
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
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
Control-M Server
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.
-----------------------------
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
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France