[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sybase replication subscription creation error

Posted on 2011-05-05
2
Medium Priority
?
833 Views
Last Modified: 2012-05-11
I am getting the following error when I try to create a table or database subscription

I. 2011/05/05 15:14:06. PRIMARY Replication Server: Created subscription <test_1_dbsub> for database replication definition <test_1_db_repdef> with replicate at <SYB_RSSD_GEN.test_2> without materialization.
I. 2011/05/05 15:14:06. REPLICATE Replication Server: Created subscription <test_1_dbsub> for database replication definition <test_1_db_repdef> with replicate at <SYB_RSSD_GEN.test_2> without materialization.
E. 2011/05/05 15:14:07. ERROR #15575 DSI EXEC(108(1) SYB_RSSD_GEN.test_2) - dl/ddldb.c(6564)
        Incorrect syntax with the TRACE value ''.
I. 2011/05/05 15:14:07. The DSI thread for database 'SYB_RSSD_GEN.test_2' is shutdown.

The repdef gets created fine , only when I try to create the db subscription I get this error :

1> create subscription test_1_dbsub for database replication definition test_1_db_repdef
2>  with primary at SYB_RSSD_GEN.test_1 with replicate at SYB_RSSD_GEN.test_2  without materialization
3>
4> go
Subscription 'test_1_dbsub' is in the process of being created.

Also note that subscription has been valid after the creation but the DSI is down with above error.
 2011/05/05 15:14:07. ERROR #15575 DSI EXEC(108(1) SYB_RSSD_GEN.test_2) - dl/ddldb.c(6564)
        Incorrect syntax with the TRACE value ''.

Please help me in this.
0
Comment
Question by:Deepak_FIL
2 Comments
 
LVL 13

Accepted Solution

by:
alpmoon earned 500 total points
ID: 35700147
It looks like a problem with trace option setting. I am not familiar with trace options. However, you can disable it by alter connection command:

alter connection to data_server.database
set trace to ''

Then you can start DSI connection without trace option.
0
 
LVL 2

Author Closing Comment

by:Deepak_FIL
ID: 35700694
u got it right. thanks buddy. all points to u
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question