Symptom
Error: Sybase connection error: failed to allocate global context for server <repser_mtrc> check connection parameters and permissions
The replication server user needs <connect target, create object>
Follow up errors encountered:
Engine failed to allocate global context for replication server – the prompt to check for user permissions was a red herring. The LC_ALL local set in Syb Rep Server was not picked up.
Setting export LC_ALL=en-USA-utf-8 resolved the issue
Job was processing update/delete rows without a key column
Error #1
Engine failed to allocate global context for replication server – the prompt to check for user permissions was a red herring. The LC_ALL local set in Syb Rep Server was not picked up.
Setting export LC_ALL=en-USA-utf-8 resolved the issue
Connection to the replication agent failed because the Requested server name was not found, this resulted in an internal directory control layer error.
Error #2
Job was processing update/delete rows without a key column
Setting the “Use input keys” parameter in the options tab of the target table got us past this point to another bottleneck.
Error #3
Connection to the replication agent failed because the Requested server name was not found, this resulted in an internal directory control layer error.
The Replication server interphases file on linux was commented out and so could not be read
The entry <server,port> combination was uncommented to resolve this bit
Error#4
Initial job launch was ok, changes were made to the primary database to test replicatioin functionality – this test failed
The Sybase open client (Dsedit) did not have an entry for the replication agent configured in DS and in the Replication server on the linux machine
This was added via the Dsedit tool
Read more...
Environment
Data services:
- Designer : 14.2.5.800
- Repo : 14.2.5.0000
IPS :
- SAP BusinessObjects BI Platform 4.1 Support Pack 5
- Version: 14.1.5.1501
Replication:
- Continuous flow method - log based
- Rep agent on Windows machine bundled with Sybase Anywhere
- Sybase replication server installed on Linux
Source database:
- SQL Server 2008
- Source table being monitored for changes: <table name>
Product
Keywords
KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.