Skip to Content
avatar image
Former Member

DBIF_RSQL_SQL_ERROR during SAP_BASIS component updation

Hi Mates,

We are trying to update SAP_BASIS component from SAPKB73102 to 73103 in IDES. However while updating i got the below errors.

1)

2)

I rectified the first error by increasing saptools space. But i am not able to reslve the second issue. Is there sany db space i still need to increase.

I am attaching the sapdb file.Please check and help.

sp_helpdb

1> sp_helpdb

2> go

name

         db_size

         owner                dbid

         created

         durability

         lobcomplvl

         inrowlen

         status

--------------------------------------------------------

         ----------------------------------------------------

         -------------------- --------------------

         ------------------------------------------------

         --------------------------------------------

         ----------------------------------------

         --------------------------------

         -----------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

-----------------------------------------

<DB Name>

           251904.0 MB

         sapsa                    4

         Jan 17, 2014

         full

                100

             2000

         ddl in tran, allow nulls by default, abort tran on log full, allow wide

          dol rows, deferred table allocation, page compression, allow increment

         al dumps, deallocate first text page,full logging for all

master

              248.0 MB

         sa                       1

         Jan 17, 2014

         full

                  0

             NULL

         mixed log and data

model

               24.0 MB

         sa                       3

         Jan 17, 2014

         full

                  0

             NULL

         mixed log and data

saptempdb

             2048.0 MB

         sa                       6

         Oct 21, 2015

         no_recovery

                  0

             NULL

         select into/bulkcopy/pllsort, trunc log on chkpt, ddl in tran, allow nu

         lls by default, abort tran on log full, mixed log and data, user create

         d temp db, allow wide dol rows

saptools

             5752.0 MB

         sapsa                    5

         Jan 17, 2014

         full

                  0

             NULL

         trunc log on chkpt, ddl in tran, allow nulls by default, abort tran on

         log full, allow wide dol rows, allow incremental dumps,full logging for

          all

sybmgmtdb

              180.0 MB

         sa                   31515

         Jan 17, 2014

         full

                  0

             NULL

         select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data

sybsystemdb

               48.0 MB

         sa                   31513

         Jan 17, 2014

         full

                  0

             NULL

         trunc log on chkpt, mixed log and data

sybsystemprocs

              200.0 MB

         sa                   31514

         Jan 17, 2014

         full

                  0

             NULL

         trunc log on chkpt, mixed log and data

tempdb

             1048.0 MB

         sa                       2

         Oct 21, 2015

         no_recovery

                  0

             NULL

         select into/bulkcopy/pllsort, trunc log on chkpt, ddl in tran, allow nu

         lls by default, abort tran on log full, mixed log and data, allow wide

         dol rows

(1 row affected)

(return status = 0)

1>

Thanks&Regards,

Adarsh

1.JPG (138.8 kB)
2.JPG (129.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 21, 2015 at 10:05 AM

    Hello Adarsh,

    Can we see the dev_w* log file of the worker process number displayed in the second ABAP dump, as well as your ASE errorlog? (/sybase/<SID>/ASE-15_0/install/<SID>.log)

    Thank you

    Regards,

    Cris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Adarsh,

      I can see you have configured max memory to ASE server 2500 MB (2.4 GB). Free memory to ASE server is only 240 MB.

      The current procedure cache is 512 MB.

      Can you please check the memory (RAM) available at the OS/machine and the free available memory that can be added to ASE parameter "max memory" . Then Increase the procedure cache size from 512 MB to 1GB .

      Hope this will be helpful.

      ~Gaurav