Category: - clear 
Installation, Setup, Administration, Monitoring 
1Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D38376   Category: Installation, S...     Status: Submitted
Tags:  

Recently we came across situation where we did migration from oracle to HANA and our source DB changed . 

 

We have to drop old oracle connection and created new HANA connection as source DB . By doing this we lost all transformation work and table history along with config on that particular Mass ID . 

 

Please provide migration utility for mass ID in SLT so we can over come this situation without affecting anything on SLT tarnsformation and config . .

 

-Suharsh 

comment »  

 
6Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D38372   Category: Installation, S...     Status: Submitted

We have went through situation recently in our SLT production environment after SP11 upgrade.

 

Issue:

 

1) Data load jobs  did not restart mid night as they are supposed to be restarted by design

2) Jobs are in ACTIVE state for more than 36 hours and replication stopped at some time with no reason recorded in application logging of LTRC

3) Business escalated to admin team as there is  data records mis-match between source (ECC) and HANA target environment

4) Team logged into SLT system to verify if there were errors , No failed replication indication in LTRC transaction under data transfer tab for replication failures

5) Issue was resolved only after restarting the configuration .

 

Request for enhancement:

 

1) Health check framework should check date and time stamp of data load jobs and restart them if they exceed 24 hours to ensure there are no issues in replication

 

2) Alert mechanism should be in place if data transfer jobs does not restart after 24 hours in order to inform adminstrat

More...

comment »  

 
2Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D38344   Category: Installation, S...     Status: Submitted
Tags:  

Currently we have seen multiple incidents where replication was unregistered and SRID for site has not been delted successfully in nameserver.ini and it shows two worker nodes in nameserver.ini . There is SAP note for this issue which tells to use hdbnsutil -reconfig , however seems like this is not a fix for this issue in daisy chain replication . 

 

In order to make solution simple and working in right way i would like to propose some kind of automated XS tile which can repair .INI files to original topology and OR complete HANA installation repair option is needed so we can bring system back to normal .

 

Also we have seen SQL 28000 error message when topology is messed up which makes impossible to login to system so if we can get install repair option thru command line and or toplogy fix command which is much mature than iniTopology without DATALOSS.

 

This is important and should be incorporated to troubleshooting tools .

 

-Suharsh 

More...

comment »  

 
6Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D37595   Category: Installation, S...     Status: Submitted
Tags:  bods  cdc  designer  ds  srs 

When developing in Data Services Designer using SRS, it is often the case that subscriptions, replication definitions and ORC connections are created in SRS that don’t end up being used/required.  The functionality should exist in Data Services Designer to remove any subscriptions, replication definitions and ORC connections created that are not required, giving the Data Services developer the ability to clean-up after development is complete.  This functionality needs to be Designer as  the Data Services developer does not necessarily have the access/experience to complete this clean-up directly in SRS.  Even for an SRS administrator completing this clean-up is not necessarily an easy task, it is challenging to identify which subscriptions, replication definitions and ORC connections belong to which BODS repositories, especially when there are multiple BODS developers/repositories using SRS.  If this clean-up is not done it can lead to issues in SRS and makes it difficult to troublesh

More...

comment »  

 
2Votes
Promote Idea
Vote Up
Demote Idea
Vote Down
D35133   Category: Installation, S...     Status: Submitted
Tags:  

Currently we dont have any automated mechanism for Automating DATA PROVISING agent including HA failover and SDI API's . Please provide automated SOLMAN template that we can use for monitoring the replication and transformation snerios . 

 

Transformation and replication monitoring is also needed for SLT and SDA Snerios . ETL tools monitoring is missing in SOLMAN .

 

Please let us know when this is possible ?

 

-Suharsh 

comment »  

 
Displaying results 1 - 5 of 5