IBM has released two new Lotus Foundation Appliances: http://www.tivoli-foundations.com/ These are made up of: * Application Manager - ITM 6 in a box * Service Manager - Service Desk (TSRM) in a box

Click to read more ...

In OMNIbus 7.2.0, the generic_clear trigger does not work if the value in the AlertGroup field is greater than 64 characters.

Click to read more ...

In Tivoli Netcool/OMNIbus it isn't only servers that are highly resilient. OMNIbus probes can also be configured to provide hot-standby.

Click to read more ...

Problem

User applied interim fix pack 7.1.0.3-TIV-SRM-IF0002 on to a CCMDB/TSRM install. Afterwards it was noticed that when clicking on reports and selecting any report to run, a pop-up comes up asking which report they would like to run. Within 1/2 sec an error also pops up on the screen as follows;

BMXAA4210E - Database error number -7 has occurred.

The character "&" following "COMPANY" and runtype" is not valid.

 In the logs the following appears;

0000004f SystemOut O 15 Jul 2009 12:35:15:167 [ERROR] BMXAA6713E - The MBO fetch failed in the mboset with the SQL error code:-7

com.ibm.db2.jcc.c.SqlException: The character "&" following "COMPANY' and runtype" is not valid.

at com.ibm.db2.jcc.c.fg.e(fg.java:1596)

at com.ibm.db2.jcc.c.fg.a(fg.java:1206)

at com.ibm.db2.jcc.b.gb.g(gb.java:140)

at com.ibm.db2.jcc.b.gb.a(gb.java:39)

at com.ibm.db2.jcc.b.w.a(w.java:34)

at com.ibm.db2.jcc.b.vb.g(vb.java:139)

at com.ibm.db2.jcc.c.fg.n(fg.java:1177)

at com.ibm.db2.jcc.c.fg.a(fg.java:1832)

at com.ibm.db2.jcc.c.fg.a(fg.java:473)

at com.ibm.db2.jcc.c.fg.executeQuery(fg.java:457)

at psdi.mbo.MboSet.getNextRecordData(MboSet.java:2994)

at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2529)

at psdi.mbo.MboSet.fetchMbos(MboSet.java:2495)

at psdi.mbo.MboSet.getMbo(MboSet.java:1815)

at psdi.webclient.beans.report.ReportRoxListBean.initialize(ReportRoxListBean.java:58)

at psdi.webclient.system.beans.DataBean.getMboSet(DataBean.java:1257)

at psdi.webclient.system.beans.DataBean.getZombie(DataBean.java:2098)

at psdi.webclient.controls.TableCol.initialize(TableC 

Solution

Regenerate the report pages as follows:

Go to --> administration --> reporting- -> report administration --> press enter to display all reports --> then press the generate request pages on the bottom left of the app.

It will take a few minutes to process all the reports, after which the error message will stop appearing.

Below are a few tips to help with successful loading of data in CSV format through MEA (now known as Integration Framework)

1. Ensure that your Object Structure supports flat files

There is a text box on the object structure record that needs to be checked to allow this object to be used with CSV files.

2. Use the correct format

Export a test record to get a CSV template in the correct format to import back in.

3. Include Enterprise service and External system in file

Ensure that the first line includes the name of your enterprise service and external system. (again exporting a test record will show you the format)

4. Remove any extra commas from the first line of the CSV file

If there are 15 columns in the spreadsheet, when you edit the file in Excel and save it, it will add 15 commas to the end of the first line and cause the import to fail. After editing the file in Excel, re-open it in notepad and remove all commas after the last character on the first line.

5. Commas are deleted by Excel

When using Office 2003 (could also be other versions), if the last column in the spreadsheet is blank, any commas at the end of the line, after about row 16, get deleted by Excel. This is noticed when you re-open the document in notepad. As a workaround when in Excel, I usually fill the last column with ‘XXXXX’ then use notepad++ to search and replace the value with null afterwards.

6. If using the sequential queue to load. Ensure that the queue is empty.

If previous files were loaded and failed, the queue will be ‘blocked’ until these messages have been deleted. To see if the queue has error messages in it go to ‘Integration – ‘Message Reprocessing’.

If there are messages in the queue they will be displayed one at a time under the messages box. To clear these, check the box next to the message and click ‘select action – ‘delete message’.

If there is more than one message then this can be very time consuming as there will a 5 seconds delay before the next message appears. To delete these in bulk login to the WebSphere console and navigate to the sequential queue;

Service Integration (in left hand column ‘Buses’ click on ‘intjmsbus’ ‘messaging engines’ click on the ‘ctgNode01.MXServer-intjmsbus’ ‘queue points’ click on the sequential queue ‘SQINBD@ctgNode01.MXServer-itjmsbus’ ‘Runtime’ tab  Messages

Then select ‘Delete All’

7. Check for any non standard characters within the file.

Use notepad++ to open your file and check for any non standard characters within the file that will cause issues while loading.