Skip to Content
avatar image
Former Member

"Program terminated in remote system NONE: Logon failed" when adding a new table

Hello,


I set up a replication flow from a SAP ERP 6.0 EHP7 with SAP ASE 16.0 source to SAP HANA 1.0 rev 82 target
I am using a standalone SLT system NetWeaver 7.0 with DMIS 2011_1_731 (with SP 1 to 7).
I have 100 tables to replicate.

I succeeded to set up replication for 57 tables. These tables are replicating properly.
Whenever I try to add a new one (with LTRC transaction, Data Provisioning -> Start Replication), the new table is marked as 'Failed' after a little while.

When I press 'Show Error Log' button I got an obscure error message:

"Program terminated in remote system NONE: Logon failed "

I do not understand this message. I checked both on SAP ASE source and SAP HANA target. I am still able to connect against both source and target.

Can you please tell how to troubleshoot this error.


Thanks in advance,

Christian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 19, 2014 at 02:58 PM

    Hi Christian,

    Please check this thread: -

    Regards,

    V Srinivasan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 16, 2014 at 08:59 PM

    Hi Christian,

    Please check the RFC Connection(Authorisation as well as Connection test) between your SLT & Source system.Secondly the DBCO conn between HANA & SLT.

    Are you using a separate Tablespace for the logging tables of the source?

    Regards,

    Joydeep

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Saritha,

      I reconfigured both source and SLT system because they were not stable.

      The SM21 and ST22 do not hold error message now.

      I ran the SM50 transaction on both source and standalone SLT server. Please see below the output.

      SLT server:

      Time    18.11.2014, 09:45:27   
      Total Number of Processes    63   
      Dialog    10 / 9 (Total/Free) , Average Load = ( 0,024 / 0,005 / 0,007)   
      Update    1 / 1 (Total/Free)   
      Background    50 / 7 (Total/Free) , Average Load = ( 42,993 / 40,127 / 38,216)   
      Spool    1 / 1 (Total/Free)   
      Update Task II    1 / 1 (Total/Free)   
      Configurable    63   
      Preemptions    3 


      ERP source:

      Time    18.11.2014, 09:46:11   
      Total Number of Processes    24   
      Dialog    15 / 7 (Total/Free) , Average Load = ( 8,326 / 8,014 / 7,600)   
      Update    1 / 1 (Total/Free)   
      Background    6 / 6 (Total/Free) , Average Load = ( 0,006 / 0,002 / 0,001)   
      Spool    1 / 1 (Total/Free)   
      Update Task II    1 / 1 (Total/Free)   
      Configurable    19   
      Blockade Handling    2.208   
      Preemptions    5   

      I checked the HANA target:
      indexserver.ini -> session -> maximum_connections = 65536
      indexserver.ini -> session -> maximum_external_connections = 65536

      I reduced my ambitions to replicate 42 tables.

      The "Data Transfer Jobs" is now set to 50.

      I checked LTRC -> Load statistics. All the tables are in finished state.

      The system is stable with the current amount of tables.

      Nevertheless, my question remains. Assume that I want to replicate 100 tables, how must I set following parameters:

      - On source ERP NetWeaver server:

      rdisp/wp_no_dia   = ?

      - On SLT Netweaver server:

      Data Transfer Jobs =?

      rdisp/wp_no_btc    = ?

      Regards Christian

  • avatar image
    Former Member
    Nov 20, 2014 at 09:31 AM

    First thank you for answering my questions. I really appreciate your answers.

    I rechecked the documentation.

    "Application Operations Guide SAP Landscape Transformation Replication Server Document Version: 2.3 – 2014-07-08"

    Page 29 - 30

    3.5.2.2 Data Transfer Jobs
    This section explains the relationship between the number of data transfer jobs and the number of available background work process.
    Data transfer and data transformation processing on SLT server system is accomplished by the background work processes of the underlying SAP NetWeaver ABAP application server. Each job occupies 1 background work process in the SAP LT Replication Server system. For each configuration, the parameter Data Transfer Jobs restricts the maximum number of data load job for each mass transfer ID (MT_ID). In total, a mass transfer ID (MT_ID) requires at least 4 background jobs to be available:
     One monitoring job (master job)
     One master controller job
     At least one data load job
     One additional job either for the migration objects definition, access plan calculation or to change configuration settings in the Configuration & Monitoring Dashboard

    Example
    If you set the parameter Data Transfer Jobs to 04 in a configuration “SCHEMA1”, a mass transfer ID 001 is assigned. As a result, the following jobs should be in the system:
    1 Master controller job: /1LT/IUC_REP_CNTR_001
     At most 4 parallel jobs for MT_ID 001: /1LT/IUC_LOAD_MT_001_001/~002/~003/~004
    When configuring your data load or replication scenario, consider the following:
     Do not define more data transfer jobs than the number of available application server background work processes. If all available background work processes are already occupied by jobs, any other job will have to wait until a free work process becomes available. This can lead to long wait times until a new activity (for example creating triggers) can start, and can also result in significantly increased latency times for data replication.
     The number of dialog work processes in the source system corresponds 1:1 with the number of data transfer jobs in the SAP LT Replication Server system.
     Besides the work processes allocated by the data transfer jobs you need to provide additional available work processes for controller and monitoring jobs, the migration objects definition, access plan calculation or to perform configuration changes, and so on.

    Sizing for SAP LT Replication Server involves determining how many work processes are required to perform the initial load of data into the target system within an acceptable timeframe, and accomplish the change capturing and the transfer of data changes to the target system within expected latency times.
    Ensure that you add enough additional work processes to allow other required SAP LT Replication Server jobs to run.
    Finally, you map the number of required application server work processes to their system resource consumption (CPU, memory, disc space) using the formulas provided by the SLT Sizing Guide.
    With the simple formula below, you can calculate the number of required application server work processes (WPs) on the SLT Server for each active SLT configuration.
    The number of required work processes can be determined by adding
     The Number of required data transfer jobs ,
     plus one background work process for Central Master (Monitoring) Job (only one per system!),
     plus one background work process for Master Controller Job,
     plus 3-5 additional empty background work processes (recommended per configuration),
     plus approx. 3 dialog work processes (recommended for each configuration).

    Note: A lack of available free application server work processes can negatively affect the data load or data replication processes.


    To summarize everything, the number of 'Data Transfer Jobs' must be set depending of the number of source tables, it is not the actual number of tables.

    Assume that for my 100 tables I use 10 'Data Transfer Jobs' :

    - The number of work processes on the SLT server would be 20. I took the simple formula of the documentation:
    10 data transfer jobs ,
    + 1 background work process for Central Master (Monitoring) Job (only one per system!),
    + 1 background work process for Master Controller Job,
    + 5 additional empty background work processes (recommended per configuration),
    + 3 dialog work processes (recommended for each configuration).

    - The number of dialog processes on the source server would be 10 ( equal to the number of 'Data Transfer Jobs')

    Am I correct ?


    Regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Christian,

      Definitely all SAP servers having above dialog and background processes what you calculated.

      You should confirm the background work processes before replication. All customers should maintain dialog processes more numbers.

      Regards,

      V Srinivasan