cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Datasource 0HR_PA_PA_1

Former Member
0 Kudos

Hi All

Please can someone assist with an error when trying to extract the Head Count data from HCM.

I run the datasource 0HR_PA_PA_1 in RSA3 and get the following short dump immediately:

Runtime Errors         CREATE_DATA_UNKNOWN_TYPE

Except.                CX_SY_CREATE_DATA_ERROR

Date and Time          17.04.2013 12:13:26

Short Text

     CREATE DATA: The specified type "/BI0/OIEMPLOYEE" is no valid data type.

What happened?

     Error in the ABAP Application Program

     The current ABAP program "SAPLRS_BCT_PA_EXTRACTION" had to be terminated

      because it has

     come across a statement that unfortunately cannot be executed.

Error analysis

     An exception occurred that is explained in detail below.

     The exception, which is assigned to class 'CX_SY_CREATE_DATA_ERROR', was not

      caught in

     procedure "RS_BCT_PA_GET_DATA" "(FUNCTION)", nor was it propagated by a RAISING

      clause.

     Since the caller of the procedure could not have anticipated that the

     exception would occur, the current program is terminated.

     The reason for the exception is:

     The dynamically specified type "/BI0/OIEMPLOYEE" at CREATE DATA is no valid

      data type.

     The type is either unknown or an object type.

  Module type                             (FUNCTION)

  Module Name                             RS_BCT_PA_GET_DATA

Missing RAISING Clause in Interface

     Program                                 SAPLRS_BCT_PA_EXTRACTION

     Include                                 LRS_BCT_PA_EXTRACTIONU01

     Row                                     1

     Module type                             (FUNCTION)

igger Location of Exception

  Program                                 SAPLRS_BCT_PA_EXTRACTION

  Include                                 LRS_BCT_PA_EXTRACTIONU01

  Row                                     28

  Module type                             (FUNCTION)

  Module Name                             RS_BCT_PA_GET_DATA

urce Code Extract

ne  SourceCde

  1 FUNCTION rs_bct_pa_get_data.

  2 *"----------------------------------------------------------------------

  3 *"*"Lokale Schnittstelle:

  4 *"  IMPORTING

  5 *"     VALUE(I_REQUNR) TYPE  SBIWA_S_INTERFACE-REQUNR

  6 *"     VALUE(I_ISOURCE) TYPE  SBIWA_S_INTERFACE-ISOURCE OPTIONAL

  7 *"     VALUE(I_MAXSIZE) TYPE  SBIWA_S_INTERFACE-MAXSIZE OPTIONAL

  8 *"     VALUE(I_INITFLAG) TYPE  SBIWA_S_INTERFACE-INITFLAG OPTIONAL

  9 *"     VALUE(I_UPDMODE) TYPE  SBIWA_S_INTERFACE-UPDMODE OPTIONAL

10 *"     VALUE(I_DATAPAKID) TYPE  SBIWA_S_INTERFACE-DATAPAKID OPTIONAL

11 *"     VALUE(I_PRIVATE_MODE) OPTIONAL

12 *"  TABLES

13 *"      I_T_SELECT TYPE  SBIWA_T_SELECT OPTIONAL

14 *"      I_T_FIELDS TYPE  SBIWA_T_FIELDS OPTIONAL

15 *"      E_T_RSBCTPA_0HR_PA_PA_1 STRUCTURE  RSBCTPA_0HR_PA_PA_1 OPTIONAL

16 *"  EXCEPTIONS

17 *"      NO_MORE_DATA

18 *"      ERROR_PASSED_TO_MESS_HANDLER

19 *"----------------------------------------------------------------------

   20

   21   DATA l_s_code TYPE LINE OF aqtcode.

   22

   23   DATA: l_msg(240),    "#EC NEEDED

   24         l_line TYPE i. "#EC NEEDED

   25

   26   IF i_initflag = sbiwa_c_flag_on.

   27     linetype = '/bi0/oiemployee'.

>>>>>     CREATE DATA: g_t_employee_index TYPE SORTED TABLE OF (linetype)

   29                     WITH UNIQUE DEFAULT KEY INITIAL SIZE 0,

   30                  g_t_employee_all_index TYPE SORTED TABLE OF (linetype)

   31                     WITH UNIQUE DEFAULT KEY INITIAL SIZE 0.

   32

   33     ASSIGN g_t_employee_all_index->* TO <g_t_employee_all_index>.

   34

   35     linetype = '/bi0/oiperson'.

   36     CREATE DATA: g_t_person_index TYPE SORTED TABLE OF (linetype)

   37                     WITH UNIQUE DEFAULT KEY INITIAL SIZE 0,

   38                  g_t_person_all_index TYPE SORTED TABLE OF (linetype)

   39                     WITH UNIQUE DEFAULT KEY INITIAL SIZE 0.

   40   ENDIF.

   41

   42   DATA: l_s_employee_all_index TYPE REF TO data.

   43   CREATE DATA: l_s_employee_all_index TYPE ('/bi0/oiemployee').

   44   FIELD-SYMBOLS: <l_s_employee_all_index> TYPE ANY.

   45

   46   DATA: l_datefrom LIKE sy-datum,

   47         l_dateto   LIKE sy-datum.

I have never installed HCM before and am do not know ABAP, but considering it is a SAP std program, I need to assume that I am doing something incorrectly.

I am trying to load data into the cube :0PAPA_C02 - I have not loaded any other HCM data, and do not need to load any other HCM data unless its to fix this issue.

Thank you

Accepted Solutions (0)

Answers (1)

Answers (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi Catherine,

Seems like there is wrong sap standard program. so you may need to apply SAP OSS note. please check in sap market place with respctive error along with data source name.

please look at this OSS Note -  1158871.

I think, you may be maintained master data for 0EMPLOYEE.

Thanks