Skip to Content
avatar image
Former Member

7.1: Creating new Device: CREATE DATA: The specified type is not a valid..

When I try to create a new device I get the error:

" CREATE DATA: The specified type is not a valid data type."

I get the same error when I go to "Statistics" and want to look up a user.

There is a reference to "GET_USERS_FROM_CDS"

Steps to reproduce:

1.) Create new Device

  • Mobile Administrator

  • Administration

  • New Device

  • enter some data ...

  • click "Save"

Error

2.) View Statistics

  • Mobile Administrator

  • Statistics

  • search for User "*"

Error

-


Output in Browser Window

 Error when processing your request

What has happened?

The URL http://sapmid1.sap.ti.elysianfields:50000/sap/bc/webdynpro/sap/sdoe_administration/ was not called due to an error.
 
Note

    * The following error text was processed in the system MID : CREATE DATA: The specified type is not a valid data type.

    * The error occurred on the application server SAPMID1_MID_00 and in the work process 6 .

    * The termination type was: RABAX_STATE

    * The ABAP call stack was:
      Method: GET_USERS_FROM_CDS of program CL_SMMW_USER==================CP
      Method: ONACTIONCREATE of program /1BCWDY/03N7NJWXZ2YG6MVX6820==CP
      Method: IF_WDR_VIEW_DELEGATE~WD_INVOKE_EVENT_HANDLER of program /1BCWDY/03N7NJWXZ2YG6MVX6820==CP
      Method: INVOKE_EVENTHANDLER of program CL_WDR_DELEGATING_VIEW========CP
      Method: IF_WDR_ACTION~FIRE of program CL_WDR_ACTION=================CP
      Method: DO_HANDLE_ACTION_EVENT of program CL_WDR_WINDOW_PHASE_MODEL=====CP
      Method: PROCESS_REQUEST of program CL_WDR_WINDOW_PHASE_MODEL=====CP
      Method: PROCESS_REQUEST of program CL_WDR_WINDOW=================CP
      Method: EXECUTE of program CL_WDR_MAIN_TASK==============CP
      Method: IF_WDR_RUNTIME~EXECUTE of program CL_WDR_MAIN_TASK==============CP

-


Output in ST22 (partial)

Runtime Errors         CREATE_DATA_UNKNOWN_TYPE
Exception              CX_SY_CREATE_DATA_ERROR
Date and Time          01.04.2008 14:44:52
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text                                                                                |
|    CREATE DATA: The specified type " " is not a valid data type.                                 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened?                                                                                |
|    Error in the ABAP application program.                                                        |
|                                                                                |
|    The current ABAP program "CL_SMMW_USER==================CP" had to be                         |
|     interrupted because it contains                                                              |
|    a statement that 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 "GET_USERS_FROM_CDS" "(METHOD)", 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 type " " specified dynamically in CREATE DATA is not a valid                              |
|    data type.                                                                                |
|                                                                                |
|    The type is either unknown or an object type.                                                 |
----------------------------------------------------------------------------------------------------
...
----------------------------------------------------------------------------------------------------
|System environment                                                                                |
|    SAP-Release 710                                                                               |
|                                                                                |
|    Application server... "SAPMID1"                                                               |
|    Network address...... "192.168.0.222"                                                         |
|    Operating system..... "Windows NT"                                                            |
|    Release.............. "5.2"                                                                   |
|    Hardware type........ "2x AMD64 Level"                                                        |
|    Character length.... 16 Bits                                                                  |
|    Pointer length....... 64 Bits                                                                 |
|    Work process number.. 8                                                                       |
|    Shortdump setting.... "full"                                                                  |
|                                                                                |
|    Database server... "SAPMID1"                                                                  |
|    Database type..... "ADABAS D"                                                                 |
|    Database name..... "MID"                                                                      |
|    Database user ID.. "SAPMID"                                                                   |
|                                                                                |
|    Char.set.... "C"                                                                              |
|                                                                                |
|    SAP kernel....... 710                                                                         |
|    created (date)... "Oct 26 2007 00:16:54"                                                      |
|    create on........ "NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00"                              |
|    Database version. "SQLDBC 7.6.3.008 CL 159187 "                                               |
|                                                                                |
|    Patch level. 80                                                                               |
|    Patch text.. " "                                                                              |
|                                                                                |
|    Database............. "MaxDB 7.6, MaxDB 7.7"                                                  |
|    SAP database version. 710                                                                     |
|    Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows                |
|     NT 6.0"                                                                                |
|                                                                                |
|    Memory consumption                                                                            |
|    Roll.... 16192                                                                                |
|    EM...... 16759296                                                                             |
|    Heap.... 0                                                                                |
|    Page.... 0                                                                                |
|    MM Used. 15082896                                                                             |
|    MM Free. 1673088                                                                              |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|User and Transaction                                                                              |
|    Client.............. 001                                                                      |
|    User................ "ZKIAGE"                                                                 |
|    Language Key........ "E"                                                                      |
|    Transaction......... " "                                                                      |
|    Transaction ID...... "57E9FFDC4586F17A8FC6000C29364070"                                       |
|                                                                                |
|    Program............. "CL_SMMW_USER==================CP"                                       |
|    Screen.............. "SAPMHTTP 0010"                                                          |
|    Screen Line......... 2                                                                        |
|    Debugger Active..... "none"                                                                   |
|                                                                                |
|    Information on Caller ofr "HTTP" Connection:                                                  |
|    Plug-in Type.......... "HTTP"                                                                 |
|    Caller IP............. "192.168.100.191"                                                      |
|    Caller Port........... 50000                                                                  |
|    Universal Resource Id. "/sap/bc/webdynpro/sap/sdoe_administration/"                           |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Information on where terminated                                                                   |
|    Termination occurred in the ABAP program "CL_SMMW_USER==================CP" -                 |
|     in "GET_USERS_FROM_CDS".                                                                     |
|    The main program was "SAPMHTTP ".                                                             |
|                                                                                |
|    In the source code you have the termination point in line 133                                 |
|    of the (Include) program "CL_SMMW_USER==================CM001".                               |
|    The termination is caused because exception "CX_SY_CREATE_DATA_ERROR" occurred                |
|     in                                                                                |
|    procedure "GET_USERS_FROM_CDS" "(METHOD)", but it was neither handled locally                 |
|     nor declared                                                                                |
|    in the RAISING clause of its signature.                                                       |
|                                                                                |
|    The procedure is in program "CL_SMMW_USER==================CP "; its source                   |
|     code begins in line                                                                          |
|    1 of the (Include program "CL_SMMW_USER==================CM001 ".                             |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Source Code Extract                                                                               |
----------------------------------------------------------------------------------------------------
|Line |SourceCde                                                                                |
----------------------------------------------------------------------------------------------------
|  103|      root_profile_table = ls_cds_list-tablename .                                          |
|  104|    ENDIF.                                                                                |
|  105|                                                                                |
|  106|  ENDLOOP.                                                                                |
|  107|                                                                                |
|  108|  LOOP AT lt_mbo_segm_infm INTO ls_mbo_segm_infm .                                          |
|  109|                                                                                |
|  110|    CASE ls_mbo_segm_infm-sfld_orgname .                                                    |
|  111|                                                                                |
|  112|      WHEN 'LOGIN_NAME' .                                                                   |
|  113|        tbl_fld_login_nm = ls_mbo_segm_infm-sfld_name .                                     |
|  114|      WHEN 'FIRST_NAME' .                                                                   |
|  115|        tbl_fld_first_nm = ls_mbo_segm_infm-sfld_name .                                     |
|  116|      WHEN 'LAST_NAME' .                                                                    |
|  117|        tbl_fld_last_nm = ls_mbo_segm_infm-sfld_name .                                      |
|  118|      WHEN 'LONG_NAME' .                                                                    |
|  119|        tbl_fld_full_nm = ls_mbo_segm_infm-sfld_name .                                      |
|  120|                                                                                |
|  121|    ENDCASE.                                                                                |
|  122|  ENDLOOP.                                                                                |
|  123|                                                                                |
|  124|                                                                                |
|  125|  DATA : var1 TYPE bapiusname .                                                             |
|  126|  DATA: lt_tmp_ref  TYPE REF TO data.                                                       |
|  127|  DATA: ls_tmp_ref  TYPE REF TO data.                                                       |
|  128|                                                                                |
|  129|  FIELD-SYMBOLS : <lt_tmp>  TYPE ANY TABLE.                                                 |
|  130|  FIELD-SYMBOLS : <ls_tmp>  TYPE any,                                                       |
|  131|                  <area> TYPE any.                                                          |
|  132|                                                                                |
|>>>>>|  CREATE DATA lt_tmp_ref TYPE TABLE OF (root_profile_table).                                |
|  134|  ASSIGN lt_tmp_ref->* TO  <lt_tmp>.                                                        |
|  135|                                                                                |
|  136|  CREATE DATA ls_tmp_ref TYPE  (root_profile_table).                                        |
|  137|  ASSIGN ls_tmp_ref->* TO  <ls_tmp>.                                                        |
|  138|                                                                                |
|  139|                                                                                |
|  140|***Search based on the Importing Parameter - I_USER_NAME ******                             |
|  141|  lv_login_name = i_user_name .                                                             |
|  142|  lv_first_name = i_first_name .                                                            |
|  143|  lv_last_name = i_last_name .                                                              |
|  144|                                                                                |
|  145|  wildcard_flag = ''.                                                                       |
|  146|  REPLACE ALL OCCURRENCES OF '*' IN lv_login_name WITH '%'.                                 |
|  147|  IF sy-subrc EQ 0.                                                                         |
|  148|    wildcard_flag = 'X'.                                                                    |
|  149|  ENDIF.                                                                                |
|  150|  REPLACE ALL OCCURRENCES OF '*' IN lv_first_name WITH '%'.                                 |
|  151|  IF sy-subrc EQ 0.                                                                         |
|  152|    wildcard_flag = 'X'.                                                                    |
----------------------------------------------------------------------------------------------------

Thanks for any help 😊

Andre

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 02, 2008 at 07:28 AM

    Hi Stefan,

    thanks for the info. But how do I regenerate the Userdetails data object?

    Cheers, Andre

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Andre,

      Got to SDOE_WB transaction and give SAP BASIS 7.10* SWCV and you can find two data objects, just try to activate it again or re-generate.

      Let me knoe if the problem is solved.

      Cheers,

      Karthick

  • avatar image
    Former Member
    Apr 01, 2008 at 01:08 PM

    Hi Andre,

    Can you kindly tell me which SP you are in.

    This problem will occur when ever we setup the mobile landscape for the first time.

    Kindly implement this note:1131893

    This should solve the problem.

    Cheers,

    Karthick

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2008 at 01:21 PM

    After I installed my system from scratch with 7.10 SP4 I implemented Composite Note 1106933 dated 01.02.2008:

    1. 1069963 (To be applied before upgrading to SP04 from SP02 only)

    2. 1131893 Clean Basis Data Objects

    3. 1121795 (Web Dynpro related SNOTE) - mandatory to apply

    4. 1126371 Delta Generation SP04 NOTE

    5. 1116789 After Delta Generation, Monitoring shows Error

    6. 1104040 Critical fixes for SP04 upgrade

    7. 1118764 DOE: Issues with transaction SDOE_RMM01

    8. 1120046 SP04 Core features Fix

    9. 1123293 SP04 Consolidated Fixes

    10. 1126028 MassDeviceSetup_Silent.bat is not downloaded

    I did not implement Note 1069963 since this was not an upgrade

    These 4 notes are now listed in the version dated 25.03.2008 and I have not yet implemented them

    11. 1140612 MDS supports Client installation with DB2E

    12. 1142086 Device recovery does not work when queue is deleted.

    13. 1153702 Avoiding Backend Downtime during Initial Load.

    14. 1154306 Adjust BAPI Wrapper and Data Object Fix.

    So I did Note 1131893

    Should one of the missing 4 notes fix my problem?

    I will implement them as soon as possible.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      have you tried to regenerate the Userdetails data object.

      This could be a generation issue.

      You could also create a CSN message if this does not help.

      Best Regards,

      Stefan

  • avatar image
    Former Member
    Apr 03, 2008 at 12:44 PM

    Hi Stefan, hi Karthick,

    that helped. I generated them manually in SDOE_WB. They all had the yellow traffic light.

    but now I get a syntax error on SDOE_LOAD. I will open a new thread on this one.

    Thanks for your help!! (points assigned 😊

    Andre

    Add comment
    10|10000 characters needed characters exceeded