Tuesday, December 4, 2012
Sunday, November 11, 2012
Saturday, November 10, 2012
Friday, November 9, 2012
Wednesday, November 7, 2012
IBM Support Portal How-to videos on YouTube
IBM Electronic Support Channel
- Electronic Support Channel (all videos are posted here by scrolling down to "Uploaded Videos" section) - http://www.youtube.com/IBMElectronicSupport
- What is the IBM Support Portal? - http://www.youtube.com/watch?v=0VzVfdKA8zo
- IBM Support Portal Overview - http://www.youtube.com/watch?v=laOCDj5xdAs
- Getting started with IBM Support Portal using Quick Start - http://www.youtube.com/watch?v=2mORmlZGLWI
- Inside and IBM Support Centre - http://www.youtube.com/watch?v=TUy2cq8IPL0
- Managing Your Product List in the IBM Support Portal - http://www.youtube.com/watch?v=P7vqYH6pH0E
- Getting Started with IBM Support: How to Obtain an IBM ID - http://www.youtube.com/watch? v=afQmxE4wjIg&feature=results_main&playnext=1&list=PL421D5E967BB1398D
- Downloading Products from Passport Advantage - http://www.youtube.com/watch?v=HuatqV8jpu4&feature=related
- How to download software fixes from Fix Central - http://www.youtube.com/watch?v=G0Q02Mvx07c&feature=related
- Installing and running IBM Support Assistant - http://www.youtube.com/watch?v=TUv8mge8PIk&feature=related
- The IBM Web Problem Reporting Initiative - http://www.youtube.com/watch?v=HphQ3qYMy1M&feature=results_video&playnext=1&list=PL421D5E967BB1398D
- Glossary of Support Terms - http://www.youtube.com/watch?v=YHbo9HDrI98
- Accelerated Value Program features of the IBM Support Portal - http://www.youtube.com/watch?v=UrNbdIIXgUA
- Electronic Support Channel (all videos are posted here) - http://www.youtube.com/IBMElectronicSupport
Sterling Integrator - Database to XML Mapping
Here is the process for oracle and I am sure it's gonna be same for other databases as well,
1. Install Oracle Client Software. (Not Server).
2. Put database server entry in tnsnames.ora file.
3. Go to Control Panel where you installed Map editor create System DSN. When you click on
Add you should see Oracle client there. (If you installed oracle client property)
4. Provide required database credentials and complete DNS creations.
5. Bring up your map editor create new map choose data format as SQL (Database
Connectivity).
6. Go to Source Side properties in map editor go to Data Source tab select your DNS name and
it will list all your tables and when you select table you can auto generate fields.
From here regular mapping. Be careful while editing tnsnames.ora.
1. Install Oracle Client Software. (Not Server).
2. Put database server entry in tnsnames.ora file.
3. Go to Control Panel where you installed Map editor create System DSN. When you click on
Add you should see Oracle client there. (If you installed oracle client property)
4. Provide required database credentials and complete DNS creations.
5. Bring up your map editor create new map choose data format as SQL (Database
Connectivity).
6. Go to Source Side properties in map editor go to Data Source tab select your DNS name and
it will list all your tables and when you select table you can auto generate fields.
From here regular mapping. Be careful while editing tnsnames.ora.
Sunday, November 4, 2012
Tuesday, October 2, 2012
Override Persistence Level in Business Process
Here is how we can override persistence level in Workflow dynamically,
<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_FULL</assign>
<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_MINIMAL</assign>
<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_FULL</assign>
<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_MINIMAL</assign>
Friday, September 28, 2012
Append two Arrays in Java
Still need to optimize this method but this works with out any issues,
public String[] appendArrays(String[] arrayToAdd, String[] arrayFromAdd) {
List<String> list = new ArrayList<String>(Arrays.asList(arrayToAdd));
if (arrayFromAdd != null && arrayFromAdd.length > 0) {
list.addAll(Arrays.asList(arrayFromAdd));
} else {
arrayFromAdd = new String[]{"N/A"};
list.addAll(Arrays.asList(arrayFromAdd));
}
return list.toArray(new String[list.size()]);
}
public String[] appendArrays(String[] arrayToAdd, String[] arrayFromAdd) {
List<String> list = new ArrayList<String>(Arrays.asList(arrayToAdd));
if (arrayFromAdd != null && arrayFromAdd.length > 0) {
list.addAll(Arrays.asList(arrayFromAdd));
} else {
arrayFromAdd = new String[]{"N/A"};
list.addAll(Arrays.asList(arrayFromAdd));
}
return list.toArray(new String[list.size()]);
}
Convert ResultSet to Array in Java
public String[] convertRStoArray(ResultSet resultSet, boolean closeResultSet) {
String[] arrayofDataColumns = null;
Map columnsMap = new HashMap();
int columns = 0;
try {
List<String> record = new ArrayList<String>();
while (resultSet.next()) {
arrayofDataColumns = new String[resultSet.getMetaData().getColumnCount()];
columns = (resultSet.getMetaData()).getColumnCount();
String value = null;
for (int i = 1; i <= columns; i++) {
value = resultSet.getString(i);
record.add(value);
if (columnsMap.containsKey(i)) {
if (value != null && !value.equals("")) {
if (columnsMap.get(i) != null && !columnsMap.get(i).equals("") && !columnsMap.get(i).equals(value)) {
value = columnsMap.get(i) + "|" + value;
columnsMap.put(i, value);
}
}
} else {
columnsMap.put(i, value);
}
}
Object[] keys = columnsMap.keySet().toArray();
for (int ii = 0; ii < keys.length; ii++) {
arrayofDataColumns[ii] = (String) columnsMap.get(ii + 1);
}
}
} catch (Exception e) {
logger.log(Level.SEVERE, "Got the exception in convertRStoArray:" + e.getMessage());
} finally {
if (closeResultSet)
closeResultSet(resultSet);
}
return arrayofDataColumns;
}
String[] arrayofDataColumns = null;
Map columnsMap = new HashMap();
int columns = 0;
try {
List<String> record = new ArrayList<String>();
while (resultSet.next()) {
arrayofDataColumns = new String[resultSet.getMetaData().getColumnCount()];
columns = (resultSet.getMetaData()).getColumnCount();
String value = null;
for (int i = 1; i <= columns; i++) {
value = resultSet.getString(i);
record.add(value);
if (columnsMap.containsKey(i)) {
if (value != null && !value.equals("")) {
if (columnsMap.get(i) != null && !columnsMap.get(i).equals("") && !columnsMap.get(i).equals(value)) {
value = columnsMap.get(i) + "|" + value;
columnsMap.put(i, value);
}
}
} else {
columnsMap.put(i, value);
}
}
Object[] keys = columnsMap.keySet().toArray();
for (int ii = 0; ii < keys.length; ii++) {
arrayofDataColumns[ii] = (String) columnsMap.get(ii + 1);
}
}
} catch (Exception e) {
logger.log(Level.SEVERE, "Got the exception in convertRStoArray:" + e.getMessage());
} finally {
if (closeResultSet)
closeResultSet(resultSet);
}
return arrayofDataColumns;
}
Saturday, September 22, 2012
IBM Sterling B2B Integrator Code List Deployment through Command Prompt
C:\Sirish\SterlingIntegrator\install\tp_import>import.cmd -update -passphrase passphrase -input C:\Sirish\bpml_coding\Sirish.xml
This is the format requires to import from command prompt.
Sirish.xml
<?xml version="1.0" encoding="UTF-8"?>
<SI_RESOURCES xmlns="http://www.stercomm.com/SI/SI_IE_Resources" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" GISVersion="6000" FrameworkVersion="2">
<CODE_LISTS>
<CODE_LIST_XREF>
<LIST_NAME>Sirish</LIST_NAME>
<SENDER_ID/>
<RECEIVER_ID/>
<LIST_VERSION>2</LIST_VERSION>
<SIResourceDefaultVersion>true</SIResourceDefaultVersion>
<STATUS>1</STATUS>
<COMMENTS/>
<USERNAME>Sirish Reddy Gongal Reddy</USERNAME>
<CREATE_DATE>2012-09-21 14:43:16.087</CREATE_DATE>
<CODE_LIST_XREF_ITEMS>
<CODE_LIST_XREF_ITEM>
<SENDER_ITEM>Sirish Reddy</SENDER_ITEM>
<RECEIVER_ITEM>Gongal Reddy</RECEIVER_ITEM>
<TEXT1>Target System - One</TEXT1>
<TEXT2>Target System - Two</TEXT2>
<TEXT3>Target System - 3</TEXT3>
<TEXT4>Target System - 4</TEXT4>
<TEXT5>Target System - 5</TEXT5>
<TEXT6>Target System - 6</TEXT6>
<TEXT7>Target System - 7</TEXT7>
<TEXT8>Target System - Eight</TEXT8>
<TEXT9>Target System - Nine</TEXT9>
<DESCRIPTION>Just Testing the Auto Import</DESCRIPTION>
</CODE_LIST_XREF_ITEM>
</CODE_LIST_XREF_ITEMS>
</CODE_LIST_XREF>
</CODE_LISTS>
</SI_RESOURCES>
Tuesday, September 11, 2012
Offset for given Time Zone
import java.util.TimeZone;
public String getTimeZoneOffSet(String timeZoneID) {
TimeZone tz = TimeZone.getTimeZone(timeZoneID);
int rawOffset = tz.getRawOffset();
int hour = rawOffset / (60 * 60 * 1000);
int minute = Math.abs(rawOffset / (60 * 1000)) % 60;
return hour + ":" + minute;
}
Test:
tc.getTimeZoneOffSet("America/New_York")); This returns Offset for NY -->-5:0
Using Calendar Class
import java.util.Calendar;
public int getOffsetForTimeZone(String timeZoneId) {
int a;
Calendar calendar = new GregorianCalendar();
TimeZone timeZ = calendar.getTimeZone();
timeZ = timeZ.getTimeZone(timeZoneId);
a = (int) ((timeZ.getRawOffset()) * (2.77777778 / 10000000));
return a;
}
public String getTimeZoneOffSet(String timeZoneID) {
TimeZone tz = TimeZone.getTimeZone(timeZoneID);
int rawOffset = tz.getRawOffset();
int hour = rawOffset / (60 * 60 * 1000);
int minute = Math.abs(rawOffset / (60 * 1000)) % 60;
return hour + ":" + minute;
}
Test:
tc.getTimeZoneOffSet("America/New_York")); This returns Offset for NY -->-5:0
Using Calendar Class
import java.util.Calendar;
public int getOffsetForTimeZone(String timeZoneId) {
int a;
Calendar calendar = new GregorianCalendar();
TimeZone timeZ = calendar.getTimeZone();
timeZ = timeZ.getTimeZone(timeZoneId);
a = (int) ((timeZ.getRawOffset()) * (2.77777778 / 10000000));
return a;
}
Thursday, September 6, 2012
Graphical Process Modeler not opening in Sterling Integrator
Most of the times we get the below exception while opening Graphical Process modeler because the IP address in the below URL is not correct. Sterling Integrator host address and GMP host address different then we need to fix the host name and make it common.
com.sun.deploy.net.FailedDownloadException: Unable to load resource: http://192.168.235.76:15000/gbm/pmodeler/ProcessModeler.jnlp
at com.sun.deploy.net.DownloadEngine.actionDownload(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
at com.sun.javaws.Launcher.updateFinalLaunchDesc(Unknown Source)
at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
at com.sun.javaws.Launcher.launch(Unknown Source)
at com.sun.javaws.Main.launchApp(Unknown Source)
at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
at com.sun.javaws.Main$1.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
How to Fix:
1. Stop Sterling Integrator.
2. <SI_Install>/bin folder and execute the below commnad.
3. <SI_Install>/bin> patchJNLP.cmd <put your hostname here>
4. Start the Sterling Integrator and go to Business Process Manager and Run Graphical Process Modeler. (Don't use old jnlp file and download fresh copy)
com.sun.deploy.net.FailedDownloadException: Unable to load resource: http://192.168.235.76:15000/gbm/pmodeler/ProcessModeler.jnlp
at com.sun.deploy.net.DownloadEngine.actionDownload(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
at com.sun.javaws.Launcher.updateFinalLaunchDesc(Unknown Source)
at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
at com.sun.javaws.Launcher.launch(Unknown Source)
at com.sun.javaws.Main.launchApp(Unknown Source)
at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
at com.sun.javaws.Main$1.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
How to Fix:
1. Stop Sterling Integrator.
2. <SI_Install>/bin folder and execute the below commnad.
3. <SI_Install>/bin> patchJNLP.cmd <put your hostname here>
4. Start the Sterling Integrator and go to Business Process Manager and Run Graphical Process Modeler. (Don't use old jnlp file and download fresh copy)
Subscribe to:
Posts (Atom)