VERIFIED SOLUTION i
X

Resolve Sybase repository not getting created in Sagent -Product Hang

Issue

Not able to create Sybase repository while installing Sagent. Product hangs on repository creation using SAINRP as well.

Cause

Issue is specific to sybase database. Default database created in Sybase is of size 4 MB ,which is shared by data  and logs.
 
Sybase throws below exception when trying to create repository using SAINRP.
 
"Server Message: Number 7415, Severity 10
Line 1:
The transaction log in database ActivityMonitoring is almost full. Your transaction is being suspended until space is made available in the log."

SAINRP does not captures this error result in hang.
 

Resolution

UPDATED: March 28, 2017


The solution is to create a new database in Sybase having a separate disk for data and logs. 

Create a new database in Sybase 

1) Create 2 disks using below mentioned commands in Sybase Client:
 
a) Create a disk for data in path c:\tmp with name data_01 of size 'x' MB .
disk init
name=data_01,

physname ="c:\tmp\data_02.dat",
size = "x M"
go
 
b) Create a disk for data in path c:\tmp with name log_01 of size 'y' MB.
Note: Size may vary depending upon repository size.
disk init
name=log_01,
physname ="c:\tmp\log_02.dat",
size = "y M"
go
 
2) Then create DATABASE in Sybase Client using the above created disks
CREATE DATABASE sagent1
ON data_01="x M"
LOG ON log_01=" y M"
go
 
 
 

Environment Details

Product Feature: Repository
Database: Sybase
Sagent Version: V6.5 onwards


 

Downloads

  • No Downloads