Sybase Replication Agent For HANA can't start

[Former Member]

Dear Experts,

I've started Run_Container.sh after that server terminated,

sybase@saprs:/opt/sybase/REP/RAH/HANARAX/bin> ./RunContainer.sh

./RunContainer.sh: line 78: -XX:+UseConcMarkSweepGC: command not found

12:35:06.751 - SAP HANA Replication Agent Server for Unix & Windows - Runtime is Starting, Process ID is 6753

12:35:06.751 - Using Config File /opt/sybase/REP/RAH/HANARAX/config/ContainerRuntime.xml

12:35:06.751 - Using Global Bootstrap File /opt/sybase/REP/RAH/HANARAX/config/bootstrap.prop

12:35:06.751 - Using Local Bootstrap File /opt/sybase/REP/RAH/HANARAX/instances/AgentContainer/config/bootstrap.prop

12:35:07.165 - Loading Components and Services

12:35:07.331 - Initializing Services

12:35:11.216 - AgentContainer Now Accepting TDS Connections on port 7001

12:35:12.583 - AgentContainer Now Accepting Connections at service:jmx:rmi:///jndi/rmi://saprs:7000/rsng

12:35:12.583 - Runtime Container saprs::AgentContainer [a12e99cb-7de8-46f2-a920-d6f6a31aa174] is Operational

12:35:12.593 - Starting Components

12:35:12.594 - Starting HanaRAX

12:35:12.594 - Starting ContainerAgent

12:35:12.596 - SAP HANA Replication Agent Server for Unix & Windows - Startup is Complete

12:35:12.666 - Hana Replication Agent is Starting

12:35:12.741 - Container Agent is Running

12:35:12.757 - Unable to Checkout Core License, Terminating Server

12:35:12.757 - *** Server Terminating, See Log for Error Information ***

[16.481][Info][12:35:22.762][ContainerShutdownHook:16][CONTAINER] - Shutdown wait exceeded, shutting down

[terry_penna · Accepted solution]

Sorry for not replying sooner. 

When you installed the product did you get a license for RepAgent for HANA? 

Your error message is is showing that it cannot find a license for the RepAgent?

Regards

Terry

[Former Member · Accepted solution]

Dear Terry,

Thank you for your reply, sorry for not replying sooner.

I've downloaded the license and service has been running, but there is a problem with the table column name special character when materialization.

[44.314][Error][08:47:05.328][TaskEngine_4(ParallelMaterializerTask)(/BIC/SU00_COSTS):43][MATERIALIZERTASK] - Materialization of table /BIC/SU00_COSTS failed

[44.314][Error][08:47:05.328][TaskEngine_4(ParallelMaterializerTask)(/BIC/SU00_COSTS):43][LOGGER] - Diagnostic Data for Exception com.sap.db.jdbc.exceptions.JDBCDriverException

    Detected by: com.sap.rahana.materialization.MaterializationTask

    Thread: TaskEngine_4(ParallelMaterializerTask)(/BIC/SU00_COSTS) - [43]

    Description: SAP DBTech JDBC: [257] (at 17): sql syntax error: incorrect syntax near "/": line 1 col 17 (at pos 17)

    SQLCode: 257

    SQLState: HY000

[49.365][Error][08:47:10.379][TaskEngine_4(ParallelMaterializerTask)(RSLPO_PC_THREAD):43][MATERIALIZERTASK] - Materialization of table RSLPO_PC_THREAD failed

[49.365][Error][08:47:10.379][TaskEngine_4(ParallelMaterializerTask)(RSLPO_PC_THREAD):43][LOGGER] - Diagnostic Data for Exception com.sap.db.jdbc.exceptions.JDBCDriverException

    Detected by: com.sap.rahana.materialization.MaterializationTask

    Thread: TaskEngine_4(ParallelMaterializerTask)(RSLPO_PC_THREAD) - [43]

    Description: SAP DBTech JDBC: [257] (at 47): sql syntax error: incorrect syntax near "ROLLUP": line 1 col 47 (at pos 47)

    SQLCode: 257

    SQLState: HY000

[33.795][Error][08:46:54.809][TaskEngine_2(ParallelMaterializerTask)(T77S4):41][LOGGER] - Diagnostic Data for Exception com.sap.db.jdbc.exceptions.JDBCDriverException

    Detected by: com.sap.rahana.materialization.MaterializationTask

    Thread: TaskEngine_2(ParallelMaterializerTask)(T77S4) - [41]

    Description: SAP DBTech JDBC: [257] (at 36): sql syntax error: incorrect syntax near "TOP": line 1 col 36 (at pos 36)

    SQLCode: 257

    SQLState: HY000

Special character :

ROLLUP
RETURN
LIMIT
/
REVERSE
TOP

CUBE 

Tables are made to the replication but can not fill data. Please find attachment file for error log.

Thank you for the help.

RAH_Error_materialize.txt.zip

[terry_penna · Accepted solution]

Sorry I missed your second response.  I am not sure if you have resolved this or have opened and incident regarding this issue?  If you have not opened an issue I am currently investigating what might be wrong and will post another reply when I get an answer.  If you need help sooner on this please open an incident to get more deatiled help on this issue.

-Regards

Terry