Child pages
  • Example: RSDRI_INFOPROV_READ used in Start Routine
Skip to end of metadata
Go to start of metadata

Summary

  • system: BW on Hana 74 release
  • In the start routine of the trasnformation the function RSDRI_INFOPROV_READ is used to read data from the source provider (of the DTP)
  • If more than one data package are processed and the DTP is executed in serial mode, the following error occurs: 'RS_EXCEPTION 105 TREX-API handle already exists'
  • This happens e.g. in the DTP simulation mode when the second data packe is processed in the start routine
  • Reason: when there are more than one data package, the read process is still 'open' when RSDRI_INFOPROV_READ tries read from ther same provider in the same work process. This is not allowed/possible.
  • Solutions
    • Increase package size so that there is only one data package (then issue will never occur)
    • Assure that the dtp is always executed in parallel (more precisely: serial extraction and parallel processing of subsequent steps like start routine and transformation; more than one workprocess used by DTP) since then the call of RSDRI_INFOPROV_READ is done in a different work process than the extraction. In this scenario the simulation mode of the DTP terminates but the 'normal' processing works.

Screenshots of simple example:

  • Data is loaded from cube STPE_OLAP into cube STPEOLAP2
  • In the transformation there is a start routine using RSDRI_INFOPROV_READ which accesses the cube STPE_OLAP
  • The package size is defined in such a way that there are 2 packages

 Data Flow:

 Start Routine:

 If the DTP is run in the mode 'SIMULATE'

 the following error occurs:

But if the DTP is executed (in parallel mode: serial extraction and parallel processing of subsequent steps like start routine and transformation) it works without any issue:

 

If the DTP is set to 'Serial Processing' the loading process terminates with the same error as during simulation.

When the package size is increased propperly the issue does not occur any longer at all:

 

 

 

  • No labels