Error Executing DTP

[Former Member]

Hello ,

I am facing issue in Production Sytem of BI .

In my DSO the last request that was updated to Infucube through DSO was on 26 June .

After that there are request in DSO till date which are notupdated to Infocube through the DTP .

There is a Error in DTP that I am getting the errors are :

1.

Diagnosis

An exception wrong_date was raised while executing function module

RST_TOBJ_TO_DERIVED_TOBJ .

System Response

Processing the corresponding record has been terminated.

Procedure

To analyze the cause, set a break point in the program of the

transformation at the call point of function module

RST_TOBJ_TO_DERIVED_TOBJ . Simulate the data transfer process to

investigate the cause.

2. Exception fiscvarnt missing

3. Transformation inactive request cannot be executed

And the last Question i have is -

As when the DTP will run it will pick the all request from DSO that was not updated to cube after 26 June .

Thanks ,

Rahul

[Former Member]

Hello Everyone,

An exception wrong_date was raised while executing function module

RST_TOBJ_TO_DERIVED_TOBJ .

Above error is a common error if there are some issues regarding automatic time conversion in transformation.

If you have assighned a field of data source to a field of DSO / Cube without writing FORMULA (making direct conversion) , this error will come at DTP execution time.

Always use formula for time conversion in transformation.

i.e. if you want to map a DATE of datasource to 0CALMONTH of a DSO, it should be assigned using formula as bellow.

DATE_MONTH( BUDAT ). This will convert 01/01/2011 date to 01.2011 format in DSO.

This is one of the solutions for RST_TOBJ_TO_DERIVED_TOBJ . error. I had same and resolved by above method.

[Former Member]

Please check the "Details" tab of DTP monitor screen and pay attention to the Data Packages that have RED indicator. Check if there is any information related to Date fields with invalid data. If so, go to PSA for the corresponding data package and correct the data. Save the changes to PSA. Delete the RED request from data target and re-start the DTP.

Good luck!

Bill

[Former Member]

The target gets request from two different sources.

One request was missing.After activation of both request the error didnt appear.

I am closing the thread as it was not closed.

Thanks,

Rahul

[Former Member]

fiscvarnt missing - Check for all the infoobjects for which fiscvariant is required as source object and check the routines for any errors related to Fiscal year variant. ( mostly time charecterisitcs you need to check)

[mansi_dandavate]

Is your transformation inactive from DSO to cube?

Also it seems that the fiscal variant is not updated correctly? you might be getting blank values for it which wont be there in the master data...

Do you have any routines where you are calculating any date fields? Seems some wrong date was populated...

Yes when you load a DTP from DSO to cube it will update all the requests since 26th June...

[Former Member]

Hello Mansi ,

Thanks for the reply .

I checked the Transformation it is Active only .

I checked in the DTP there is a Start Routine there but it doesnt seem there is calculation of the field

Thanks ,

Rahul

[gaurav_kothari]

Is there any routine for the date in your transformations from your DSO to the cube ?

Check if the fiscal variant is mapped correctly in the transformations.

regards,

Gaurav

[mansi_dandavate]

Chk in the change log table of the DSO, if you have any records with blank fiscal year variant...

Whats the code in the start routine?

paste it here...

Also are there any other individual routines?

[sven_mader2]

The status of transformation and DTP isn't everytime ok. Often I see active, but when I restart the RSA1 or I execute a DTP, then the DTP is inactive.

1.) transport this two object (always is different transport requests)

2.) see the long text:

"To analyze the cause, set a break point in the program of the

transformation at the call point of function module

RST_TOBJ_TO_DERIVED_TOBJ . Simulate the data transfer process to

investigate the cause."

=> debug the DTP

Sven

[Former Member]

Hello Mansi ,

I checked the Change Log Table for DSO there are few records for which the 0FISCVARNT is blank .

The code for the Start Routine is as :

----

---

• CLASS routine IMPLEMENTATION

----

---

*

----

---

CLASS lcl_transform IMPLEMENTATION.

----

---

• Method start_routine

----

---

• Calculation of source package via start routine

----

---

• <-> source package

----

---

METHOD start_routine.

*=== Segments ===

FIELD-SYMBOLS:

<SOURCE_FIELDS> TYPE tys_SC_1.

DATA:

MONITOR_REC TYPE rstmonitor.

*$*$ begin of routine - insert your code only below this line *-*

... "insert your code here

*-- fill table "MONITOR" with values of structure "MONITOR_REC"

*- to make monitor entries

DELETE SOURCE_PACKAGE WHERE statecsys2 = '10'.

• we do not want to have service order templates updated.

DELETE SOURCE_PACKAGE WHERE crmtmpltyp IS NOT INITIAL.

• determine target time unit of estimated duration -> MIN

• read SAP-Code for ISO-Code 'MIN'

CALL FUNCTION 'UNIT_OF_MEASURE_ISO_TO_SAP'

EXPORTING

iso_code = 'MIN'

IMPORTING

sap_code = gv_target_unit_ordtim

• unique = lv_unique

EXCEPTIONS

not_found = 1

OTHERS = 2.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

... "to cancel the update process

• raise exception type CX_RSROUT_ABORT.

$$ end of routine - insert your code only before this line -

ENDMETHOD. "start_routine

----

---

Please help me with the suggestion you have .

Thanks ,

Rahul