Skip to Content
avatar image
Former Member

DSO Activation fails with error RSS2_DTP_RNR_SUBSEQ_PROC_SET in RSSTATMAN

Hi Friends,

We are working in BI 7.0 SP 15 , activating a DSO request with two million records in 20 million record DSO. The errors are:

09/01/2008 08:43:53 Log for activation request ODSR_4B0LJFC2OPP0B84B6ZCT8W5QU data package 000001...000070 RSMPC 136

09/01/2008 08:43:53 Request 134392 is already being processed RSBK 205

09/01/2008 08:43:53 Termination in problem report 'RSS2_DTP_RNR_SUBSEQ_PROC_SET' in row ' 244' RSSTATMAN 102

09/01/2008 08:43:53 Errors occured when carrying out activation RSMPC 151

09/01/2008 08:43:53 Analyze errors and activate again, if necessary RSMPC 152

Can you help me interpret this error?

Thanks,

John Hawk

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 06:18 AM

    Hi

    Normally the activation of ODS/DSO of that size takes a while.

    If there is other DSOs to be activated or activating in parellel, then there might be locks at database table level which might cause errors.

    It is best to do the activation when no other DSO activation is running.

    Also, schedule this activation when BI server is a not used a lot.

    For example, mid nights or at worst, weekend midnights.

    For me, this worked when I was activating a DSO for around 5mil records.

    Please let me know how you go.

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 07:34 AM

    Hi,

    Check the request 134392 in your DSO or in PSA. Check if the loading of that request or activation of it is already successful.

    Hope it helps!

    Regards,

    Rose.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 07:29 PM

    Hi Gang,

    After deeper analysis, it appears that the second request load was started after the activation job had activated all data, but before if reached "End of Job" The status of activations was green (updated by the job), but the activation batch job was not finished.

    Very Strange!

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I'm facing same issue.

      Jod for activation of DSO gets cancelled with this log:

      Job started

      Step 001 started (program RSODSACT1, variant &0000000000334, user ID AROSADO)

      Activación is running: Data target Z_0RMPV2, from 14.423 to 14.435

      Overlapping check with archived data areas for InfoProvider Z_0RMPV2

      Data to be activated successfully checked against archiving objects

      RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_INSTANCE_FOR_RNR 14423 LINE 43

      RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_TSTATE_FOR_RNR 7 LINE 243

      RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_INSTANCE_FOR_RNR 14435 LINE 43

      RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_TSTATE_FOR_RNR 7 LINE 243

      Internal session terminated with a runtime error (refer to ST22)

      Job cancelled

      I tried to chang DSO runtime parameters in RSODSO_SETTINGS, but still gets cancelled.

      Any one can help please?