SOLVED: DSA Server Database Issue

Usage and Config Platform
1

Hi Team,

DSA Server not working Please check FillDb Log

Primary Server Log

Fri, 11 Mar 2016 14:38:08 +0530 – 3860 – Replication failed for server ‘DSAIBMbigfix.XXXX.net’: Database Error: The action site has not been created.
Fri, 11 Mar 2016 14:43:21 +0530 – 3860 – Replication failed for server ‘DSAIBMbigfix.XXXX.net’: Database Error: The action site has not been created.
Fri, 11 Mar 2016 14:48:36 +0530 – 3860 – Replication failed for server ‘DSAIBMbigfix.XXXXnet’: Database Error: The action site has not been created.
Fri, 11 Mar 2016 14:53:50 +0530 – 3860 – Replication failed for server ‘DSAIBMbigfix.XXXX.net’: Database Error: The action site has not been created.

Secondary Server log

Fri, 11 Mar 2016 14:47:53 +0530 – 3968 – Unexpected exception: class ReplicationGraphException
Fri, 11 Mar 2016 14:48:03 +0530 – 3968 – Signature Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:03 +0530 – 3968 – Download Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:03 +0530 – 3968 – Unexpected exception: class ReplicationGraphException
Fri, 11 Mar 2016 14:48:13 +0530 – 3968 – Signature Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:13 +0530 – 3968 – Download Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:13 +0530 – 3968 – Unexpected exception: class ReplicationGraphException
Fri, 11 Mar 2016 14:48:23 +0530 – 3968 – Signature Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:23 +0530 – 3968 – Download Algorithms: sha256, sha1
Fri, 11 Mar 2016 14:48:23 +0530 – 3968 – Unexpected exception: class ReplicationGraphException

Pls Help to resolved this issue

Regards
Suresh

2

Hi Suresh,

the error in the primary server log is the normal message until the secondary successfully completes a first replication from the primary.
So, it is required to understand why the secondary is failing with ReplicationGraphException.

Please, refer to the official documentation for installing additional servers:

http://www.ibm.com/support/knowledgecenter/SS63NW_9.2.0/com.ibm.tem.doc_9.2/Platform/Adm/c_installing_additional_servers_.html

And verify from the Admin tool what the Replication tab reports in the graph.

Regards,
Emiliano

3

HI Emiliano,

We have done the DSA installation as per 9.2.6 standard document.

Tab shows “Connection broken"

Add values to FillDB Registry:

On the primary server add the following string values to “FillDB” registry:
Replication User
Replication Password
Relication Port <1433>
Restart FillDB service
On the DSA server add the following values to “FillDB” registry
Replication User
Replication Password
Restart FillDB service

“FillDB” registry keys for 32 bit OS (HKLM\Software\BigFix\Enterprise Server\FillDB) for 64 bit OS (HKLM\Software\Wow6432Node\BigFix\Enterprise Server\FillDB).

4

Suresh,

from the settings you configured, it looks you are going through the SQL Authentication.
Please, using SQL Management Studio verify you can successfully connect to the both databases, selecting the sql Authentication.
Then, from SQL Management Studio on primary server database, try to connect to the secondary database using the credentials specified in registry for the SQL Authentication.
And, from the secondary server database, try to connect to the primary database as well.

In order for the DSA to successfully work, the previous cross check must work.

Regards,
Emiliano

5

Verify that the database is not a named instance database.

If the databases are setup as named instance database names see the following article for instructions on updating entries in the REPLICATION_SERVERS tables:

http://www-01.ibm.com/support/docview.wss?uid=swg21974540

6

HI Team,

database is a default instance database.

We tried to changes in REPLICATION_SERVERS tables:

Primary Server REPLICATION_SERVERS tables:

0 TECS\BIGFIXSQL http://TECS:52311 300 0 NULL NULL
1 300 1 NULL NULL
2 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 NULL NULL
3 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 NULL NULL
4 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 NULL NULL
5 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 0 NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL

Secondary Server REPLICATION_SERVERS tables:

0 TECS\BIGFIXSQL http://TECS:52311 300 0 0
1 300 1 0
2 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 0
3 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 0
4 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 1 0
5 DSAIBMbigfix.tech.net http://DSAIBMbigfix.tech.net:52311 300 0 0
NULL NULL NULL NULL NULL NULL NULL NULL NULL

7

it’s working fine.Thanks all your Help

We have run the FillDB and BES Root services on Local system Account.

Thanks Niraj

Regards
Suresh

8

So did you run it on a service account that have access to the DB servers? or did you made it to run on Local system account? Please clarify.

9

Hi Techadmin,

Service account that have access to the DB servers

1 Like
10

Thanks for the clarification, you can also edit this post title to ‘Solved’.

11

If I use windows local administrator account (primary & secondary) for bigfix installation and DB for sa user credential (primary & secondary) mean will it work DSA method?