IBM Endpoint Manager for SUA 9.0 import failed

Usage and Config BFI
1

(imported topic written by swap-techsa)

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:

2

(imported comment written by MichalPaluch)

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?

3

(imported comment written by NHV2_Jan_Marszalek)

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.

4

(imported comment written by swap-techsa)

Hi,

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