topic Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory& in Administration and Deployment

What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory"

DanielKaiser — Fri, 10 Dec 2021 08:20:34 GMT

Hi,
we are having a problem, opening a DB2-Table in DI-Studio.

This is what proc contents shows me:

 Die Prozedur CONTENTS

                    Dateiname          DT7VYMAS.WS_VORS_PROTOKOLLIERUNG_OUTPUT    Beobachtungen             .   
                    Membertyp          DATA                                       Variablen                 15  
                    Engine             DB2                                        Indizes                   0   
                    Erstellt           .                                          Beobachtungslänge        0   
                    Zuletzt geändert  .                                          Gelöschte Beobachtungen  0   
                    Schutz                                                        Komprimiert               NEIN
                    Dateityp                                                      Sortiert                  NEIN
                    Etikett                                                                                     
                    Datendarstellung   Standard                                                                 
                    Codierung          Default                                                                  


                                                Engine/Host-abhängige Informationen

                                                    Schema            IDSCHAD   
                                                    Server version:   11.05.0600
                                                    Client version:   11.01.0405


                                          Alphabetische Liste der Variablen und Attribute
 
    #    Variable                            Typ     Länge    Ausg.Format     Einl.Format     Etikett

    3    AUFRUFTIMESTAMP                     Num          8    DATETIME25.6    DATETIME25.6    AUFRUFTIMESTAMP                  
    5    AUSGANGSTIMESTAMP                   Num          8    DATETIME25.6    DATETIME25.6    AUSGANGSTIMESTAMP                
    4    EINGANGSTIMESTAMP                   Num          8    DATETIME25.6    DATETIME25.6    EINGANGSTIMESTAMP                
    8    GEOHINWEISCODE                      Num          8    11.             11.             GEOHINWEISCODE                   
    9    GEOHINWEISCODE_TXT                  Char       500    $500.           $500.           GEOHINWEISCODE_TXT               
   10    HINWEIS_TXT                         Char      2000    $2000.          $2000.          HINWEIS_TXT                      
    6    RETURNCODE                          Num          8    11.             11.             RETURNCODE                       
    7    RETURNCODE_TXT                      Char       255    $255.           $255.           RETURNCODE_TXT                   
   12    ROUTEN_GEFUNDEN                     Num          8    11.             11.             ROUTEN_GEFUNDEN                  
   11    SUCH_KRITERIUM                      Char       255    $255.           $255.           SUCH_KRITERIUM                   
   13    VAR1 Char     32000    $32000.         $32000.         VAR1 
   14    VAR2 Char     32000    $32000.         $32000.         VAR2                  
   15    VAR3 Char      2000    $2000.          $2000.          VAR3             
    2    VAR4 Char       255    $255.           $255.           VAR4
    1    VAR5 Char       255    $255.           $255.           VAR5

Any ideas, how we can fix this?

Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory&quo

ballardw — Fri, 10 Dec 2021 08:50:11 GMT

You may get some help by posting the code that was attempted that caused that error as well as how you connect SAS to the DB database.

Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory&

DanielKaiser — Fri, 10 Dec 2021 08:54:46 GMT

No code. Just rightclick the table in DI-Studio and select "open"

Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory&

ballardw — Fri, 10 Dec 2021 09:04:34 GMT

@DanielKaiser wrote:
No code. Just rightclick the table in DI-Studio and select "open"

Suggest that you provide how the connection was set up and/or connection properties.

Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory&

DanielKaiser — Fri, 10 Dec 2021 09:18:28 GMT

It's a Access to DB2 library. No specific settings, should all be default.
Problem occurs for this table only - all other tables in the library work and can be opened.

What is CORBA? What causes this error? Does not seem to be a database error - more a mishandeled buffer overflow or something like this.

Re: What triggers the error "com.sas.rio.MVASQLException: CORBA memory error. Out of memory&

gwootton — Fri, 10 Dec 2021 13:50:52 GMT

CORBA is part of Java

Common Object Request Broker Architecture (CORBA)
https://docs.oracle.com/javase/7/docs/technotes/guides/idl/corba.html

It looks to me like the Java process is running out of memory.

I suspect the distudio.ini file could be modified to increase the memory allocation (Xmx option) which might help, but I would also check for any available hot fixes / updates for your software and/or open a technical support track.