Topic
  • 6 replies
  • Latest Post - ‏2014-12-03T13:50:14Z by MichalPaluch
swap-techsa
swap-techsa
2 Posts

Pinned topic IBM Endpoint Manager for SUA 9.0 import failed

‏2014-02-10T11:04:20Z |

Hi ,

We have IEM and SUA on Linux Server  .SUA import is schduled .

We  have installed 3 clients including server till now.

I have installed SUA Server before 15 days initial import was successful after that scheduled import was also succesfull ,from yesterday the import is failing 

It shows following error:

2014-02-10 10:09:56 (+0:00:00.000) INFO: TEMA version: 9.0.20131217-1737
2014-02-10 10:10:12 (+0:00:16.178) INFO: Calling Model.before_snapshot: Success
2014-02-10 10:10:12 (+0:00:00.028) INFO: Install software catalog to staging tables: Success
2014-02-10 10:10:12 (+0:00:00.021) INFO: Calling SAM::Catalog.before_snapshot: Success
2014-02-10 10:10:12 (+0:00:00.003) INFO: Calling SAM::PartNumber.before_snapshot: Success
2014-02-10 10:10:12 (+0:00:00.110) INFO: Calling SAM::CitSwConfigFile.before_snapshot: Success
2014-02-10 10:10:12 (+0:00:00.247) INFO: Calling SAM::ContractFact.before_snapshot: Success
2014-02-10 10:10:12 (+0:00:00.026) INFO: Determine models which need catalog update: Success
2014-02-10 10:10:12 (+0:00:00.007) INFO: Importing charge units as needed: Success
2014-02-10 10:10:13 (+0:00:00.123) INFO: Initialize datasource Data Source: Success
2014-02-10 10:10:13 (+0:00:00.587) INFO: ETL from Data Source - DatasourceSite                     (0x000000000018D2C5 - 0x00000000001B2F14): Success
2014-02-10 10:10:13 (+0:00:00.044) INFO: ETL from Data Source - RawDatasourceAnalysisActivation    (0x00000000001A0EBF - 0x00000000001B2F14): Success
2014-02-10 10:10:13 (+0:00:00.232) ERROR: NativeException: com.ibm.db2.jcc.am.SqlException: There is not enough storage available to process the statement.. SQLCODE=-930, SQLSTATE=57011, DRIVER=3.64.104:         select Sitename as sitename,
               ID       as id,
               case when Sitename = 'ActionSite' then dbo.fn_ExtractField('CustomSiteName', 0, Fields) else null end as custom_sitename,
               Name     as name,
               0        as is_retrieved_property,
               0        as is_reserved,
               Fields   as fields,
               case when ParentID = 1 then 1 else 0 end as deleted
        from BES_OBJECT_DEFS
        where Sequence  > 1707711
          and Sequence <= 1781524
          and dbo.fn_ExtractField('Fixlet Type', 0, Fields) = 'Analysis'
        union all
        select 'ActionSite' as sitename,
               ID           as id,
               null         as custom_sitename,
               Name         as name,
               1            as is_retrieved_property,
               case when dbo.fn_ExtractField('IsReserved', 0, Fields) = 'Yes' then 1 else 0 end as is_reserved,
               Fields       as fields,
               case when ParentID = 1 then 1 else 0 end as deleted
        from BES_OBJECT_DEFS
        where Sequence     > 1707711
          and Sequence    <= 1781524
          and ContentType  = 5
          and dbo.fn_ExtractField('SMIME', 0, Fields) is not null
 
2014-02-10 10:10:13 (+0:00:00.010) INFO: ETL from Data Source - RawDatasourceAnalysis              (0x00000000001A0EBF - 0x00000000001B2F14): Failed
2014-02-10 10:10:14 (+0:00:00.057) ERROR: Sequel::DatabaseError: NativeException: com.ibm.db2.jcc.am.SqlException: There is not enough storage available to process the statement.. SQLCODE=-930, SQLSTATE=57011, DRIVER=3.64.104
com/ibm/db2/jcc/am/bd.java:682:in `a'
com/ibm/db2/jcc/am/bd.java:60:in `a'
com/ibm/db2/jcc/am/bd.java:127:in `a'
com/ibm/db2/jcc/am/ResultSet.java:4031:in `completeSqlca'
com/ibm/db2/jcc/am/ResultSet.java:4013:in `earlyCloseComplete'
com/ibm/db2/jcc/t4/ab.java:835:in `a'
com/ibm/db2/jcc/t4/ab.java:801:in `n'
com/ibm/db2/jcc/t4/ab.java:253:in `j'
com/ibm/db2/jcc/t4/ab.java:55:in `d'
com/ibm/db2/jcc/t4/p.java:44:in `c'
com/ibm/db2/jcc/t4/qb.java:147:in `j'
com/ibm/db2/jcc/am/io.java:2165:in `ib'
com/ibm/db2/jcc/am/io.java:3194:in `a'
 

Please help with this error .I am new to linux enviornment. 

I have also attached the logs:

Attachments

  • MichalPaluch
    MichalPaluch
    43 Posts

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-02-11T10:52:44Z  

    Hello,

    Looks like there is insufficient memory on the machine to complete the request.

    Can you let me know what are hardware spec of the machine you are running DB2 for IEM and SUA?

  • NHV2_Jan_Marszalek
    NHV2_Jan_Marszalek
    1 Post

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-02-17T08:15:32Z  

    What Michal said is true - there is know problem with dbo.fn_ExtractField method in IEM - it tries to allocate much memory (RAM) - 1 GB. If you don't have so much memory available for your DB2, import will fail. Increasing swap does not help here, I'm afraid.

    Please refer to doc about minimal hw requirements for IEM + SUA on the same machine - it's 8 GB RAM.

  • swap-techsa
    swap-techsa
    2 Posts

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-02-18T07:42:43Z  

    What Michal said is true - there is know problem with dbo.fn_ExtractField method in IEM - it tries to allocate much memory (RAM) - 1 GB. If you don't have so much memory available for your DB2, import will fail. Increasing swap does not help here, I'm afraid.

    Please refer to doc about minimal hw requirements for IEM + SUA on the same machine - it's 8 GB RAM.

    Hi,

    My IEM and SUA Server is on Virtual Machine. Hardware Configuration ( RAM :-16GB ,Disk Space :100 GB)

  • TheTick
    TheTick
    2 Posts

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-11-17T04:23:58Z  

    Hi,

    My IEM and SUA Server is on Virtual Machine. Hardware Configuration ( RAM :-16GB ,Disk Space :100 GB)

    I know this is an old post, but did you by any chance get this resolved? I have my IEM and SUA server on different systems, both with enough RAM (even added more) and I still see the issue. 

    Thanks

  • TheTick
    TheTick
    2 Posts

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-11-17T16:13:48Z  
    • TheTick
    • ‏2014-11-17T04:23:58Z

    I know this is an old post, but did you by any chance get this resolved? I have my IEM and SUA server on different systems, both with enough RAM (even added more) and I still see the issue. 

    Thanks

    So one thing I have found is that running the SQL command on the DB2 server fails. So even without import, the issue is with the SQL and DB2. Here is the statement:

    db2 "select dbo.fn_ExtractField('SourceSiteURL',  0, Fields) as siteurl, dbo.fn_ExtractField('SourceFixletID', 0, Fields) as id, case when dbo.fn_ExtractField('SourceSiteURL',  0, Fields) like '%/CustomSite_%' then 1 else 0 end as is_custom, case when ParentID = 1 then 1 else 0 end as deleted, Sequence as sequence from dbo.LOCAL_OBJECT_DEFS where ContentType  = 6 and Sequence > 0 and Sequence    <= 11827545 and dbo.fn_ExtractField('SourceSiteURL',  0, Fields) is not null"
     

    It seems to be the calls to the functions: dbo.fn_ExtractField('SourceSiteURL',  0, Fields) as siteurl, dbo.fn_ExtractField('SourceFixletID', 0, Fields) as id. If I remove those, no issue.

     

  • MichalPaluch
    MichalPaluch
    43 Posts

    Re: IBM Endpoint Manager for SUA 9.0 import failed

    ‏2014-12-03T13:50:14Z  
    • TheTick
    • ‏2014-11-17T16:13:48Z

    So one thing I have found is that running the SQL command on the DB2 server fails. So even without import, the issue is with the SQL and DB2. Here is the statement:

    db2 "select dbo.fn_ExtractField('SourceSiteURL',  0, Fields) as siteurl, dbo.fn_ExtractField('SourceFixletID', 0, Fields) as id, case when dbo.fn_ExtractField('SourceSiteURL',  0, Fields) like '%/CustomSite_%' then 1 else 0 end as is_custom, case when ParentID = 1 then 1 else 0 end as deleted, Sequence as sequence from dbo.LOCAL_OBJECT_DEFS where ContentType  = 6 and Sequence > 0 and Sequence    <= 11827545 and dbo.fn_ExtractField('SourceSiteURL',  0, Fields) is not null"
     

    It seems to be the calls to the functions: dbo.fn_ExtractField('SourceSiteURL',  0, Fields) as siteurl, dbo.fn_ExtractField('SourceFixletID', 0, Fields) as id. If I remove those, no issue.

     

    Hello, this has been fixed while ago. APAR IV55652