cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error "-10401" when accessing table "RSEUMOD".

former_member184280
Participant
0 Kudos

Hi,

We are trying a migration of a system from DB2 to MaxDB.

The import was successful, however once we login to the system we get the below dump.

Category               Installation Errors

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          2014-05-27 13:42:16

Short text

     SQL error "-10401" when accessing table "RSEUMOD".

What happened?

     Error Text of the Database: "Conversion of parameter/column (49) would truncate

      data"

Error analysis

     An exception occurred that is explained in detail below.

     The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

      in

     procedure "RS_WORKBENCH_CUSTOMIZING" "(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:

     Error Text of the Database: "Conversion of parameter/column (49) would truncate

      data"

Missing RAISING Clause in Interface

     Program                                 SAPLWB_CUSTOMIZING

     Include                                 LWB_CUSTOMIZINGU01

     Row                                     1

     Module type                             (FUNCTION)

     Module Name                             RS_WORKBENCH_CUSTOMIZING

Line  SourceCde

   25       IF sy-subrc = 0.

   26         IF rseumod-wb99 IS INITIAL.

   27           rseumod-wb99 = 'X'.

   28           IF rseumod-editcntrl IS INITIAL.

   29             rseumod-editcntrl = 'X'.

   30           ELSE.

   31             if rseumod-editcntrl ne 'A'.

   32               CLEAR rseumod-editcntrl.

   33             endif.

   34             IF rseumod-pcmode IS INITIAL.                   "HT9905

   35               rseumod-pcmode = '2'.

   36             ENDIF.                                          "HT9905

   37           ENDIF.

   38 *          endif.

   39         ELSE.

   40           CLEAR rseumod-wb99.

   41         ENDIF.

   42         rseumod-ch_html   = 'X'.

   43         rseumod-ch_busi   = 'X'.

   44         EXPORT rseumod TO MEMORY ID 'RSEUMOD'.

   45       ELSE.

   46         CLEAR entry_found.

   47 *       Noch keine Einstellungen vorhanden

   48         rseumod-uname     = sy-uname.

   49         rseumod-wb99      = 'X'.

   50         rseumod-editcntrl = 'A'.           "HT200710 neues Frontend default

   51         rseumod-motif     = 'X'.

   52         rseumod-style     = space.

   53         rseumod-lowercase = 'X'.

   54         rseumod-line_size = 255.

>>>>>         INSERT rseumod.

   56       ENDIF.

   57     ENDIF.

   58   ENDIF.

   59

   60 * initialize browser selection

   61   IF rseumod-rep_start IS INITIAL   AND

   62      rseumod-ris_start IS INITIAL   AND

   63      rseumod-rl_start  IS INITIAL   AND

   64      rseumod-wmr_start IS INITIAL   AND

   65      rseumod-wcb_start IS INITIAL   AND

   66      rseumod-whb_start is initial   AND

   67      rseumod-twb_start is initial   AND

   68      rseumod-br_init is initial.

   69     rseumod-rep_start = 'X'.

   70     rseumod-ris_start = 'X'.

   71     rseumod-rl_start  = 'X'.

   72     rseumod-wmr_start = 'X'.

   73     rseumod-wcb_start = 'X'.

   74     rseumod-whb_start = 'X'.

Active Calls/Events

No.   Ty.          Program                             Include                             Line

      Name

    4 FUNCTION     SAPLWB_CUSTOMIZING                  LWB_CUSTOMIZINGU01                     55

      RS_WORKBENCH_CUSTOMIZING

    3 FUNCTION     SAPLSTR3                            LSTR3U01                               30

      TRINT_FAULTY_TRANSPORTS

    2 FUNCTION     SAPLSUSF                            LSUSFU01                               40

      SUSR_LOGON_USER_EXIT

    1 MODULE (PAI) SAPMSYST                            SAPMSYST                              500

      D020_USER_EXIT

There are other dumps occurring in the system as well when we execute any transaction.

(see attached file).


Tha

Accepted Solutions (0)

Answers (1)

Answers (1)

david_liu1
Advisor
Advisor
0 Kudos

Hello,

Check SAP note 1547309.

Regards,

David

former_member184280
Participant
0 Kudos

Hi David,

We checked that note 1547309 and installed the MaxDB client once again.

Installation: S6E    /sapdb/S6E/db

Base                7.9.08.21      valid    64 bit

DB Analyzer         7.9.08.21      valid    64 bit

Database Kernel     7.9.08.21      valid    64 bit

Fastload API        7.9.08.21      valid    64 bit

JDBC                7.6.09.00      valid

Loader              7.9.08.21      valid    64 bit

Messages            MSG 0.10302    valid

ODBC                7.9.08.21      valid    64 bit

Redist Python       7.9.08.21      valid    64 bit

SAP Utilities       7.9.08.21      valid    64 bit

SQLDBC              7.9.08.21      valid    64 bit

SQLDBC 76           7.6.06.27      valid    64 bit

SQLDBC 77           7.9.08.21      valid    64 bit

Server Utilities    7.9.08.21      valid    64 bit

However the dump is still there in the system... any idea what couldbe wrong here?

Thanks

- Avi

david_liu1
Advisor
Advisor
0 Kudos

Hi Avi,

You can check in SE14 for the table RSEUMOD and see if there have any inconsistencies.

Regards,

David

former_member184280
Participant
0 Kudos

Hello David,

Even running a DB consistency check in SE14 ends up in a dump.

Is there any other way to figure whats wrong with the DB tables. They seem to be in read only mode.

Warm Regards

- Avi

david_liu1
Advisor
Advisor
0 Kudos


Hi Avi,

Check note 1248769 and see if it helps.

Regards,

David

former_member184280
Participant
0 Kudos

Hi David,

Thanks... the solution worked.

Regards

- Avi

david_liu1
Advisor
Advisor
0 Kudos

Hi Avi,

As the solution worked, could you please set this question as Answered.

Thanks.

David