Posts

Latest Post

MySQL procedure Insert error “Column count doesn't match value count at row 1”

Image
Recently I have came across a strange situation in MySQL Database. I have created a MySQL procedure that uses insert statement to insert values in database table. However, It was working fine previously but all of a sudden it stopped working with below error code-

Problem
Error Code: 1136. Column count doesn't match value count at row 1

Normally this error indicates my insert columns have a mismatch values i.e. consider a insert statement as shown below-
insert into table1(col1,col2,col3,col4,col5) values(val1,val2,val4,val5)

We can clearly see that col3 has a missing value in above statement i.e. mismatch of columns and corresponding values. However this was not a case with mine. Every column has corresponding value but still same error.
Cause Upon close observation of other DB objects, I saw that there was a trigger associated with the table that has missing attributes and hence the same was causing error while inserting values in this table
Solution Necessary correction done in trigger …

WSO2 Api Manger version 3.0.0 Token API CORS Issue

Image
Recently I have come across a situation where I have done the single node installation of WSO2 API Manager Version 3.0.0. and come across challenges in accessing the Token APIs  that is used to generate/revoke the token. Below is the detailed summary of the issue and solution-

Environment:
OS: Linux Ubuntu 16.04
Database:MySQL 8.x
WSO2 APIM: 3.0.0
WSO2 APIM and my Angular Application is running on two different VMs

Problem:
All the backend APIs were successfully registered with OAuth security. However, there was provision to enable/disable CORS per API basis via publisher as show below-

Now, we can't allow the the token validity to an indefinite time and hence specific duration is specified say 15 mins for API access and then the client need to request for a new token. The API that provides a new token is native to WSO2 APIM and there is no UI based provision in version 3.0.0 to enable/disable CORS (Cross Origin Resource Sharing). So there came a problem in my Angular application that was…

Good alternative of MS Visio- Draw.io

Image
In this post I'll describe how this wonderful tool has helped me in creating business diagrams on the fly and that's absolutely at zero cost, yes absolutely zero cost. Let's quickly see this wonderful tool.
So are you looking for creating workflows/flowchart/diagrams for your business needs? Draw.io might be one of the good solution you can definitely give a try. This tool has a number of features that can help you to build your diagrams more quickly, especially need of icons/images/arrows/outline images etc are available on the fly(some might require internet connectivity). So let's see how you can get start with draw.io-
Availability- Online & Offline Online- Just open the URL- https://draw.io (Save your diagrams on different cloud options-GoogleDrive & Onedrive or local disk as well) Offline- Download the installer and get this working on your local machine (windows, linux, macOS) Download Link- https://github.com/jgraph/drawio-desktop/releases/tag/v12.1.0
Let'…

Oracle SOA 12c- Human Task Approval Issue

Image
In this post, I'll discuss about the recent issue of multi-step human task approval workflow. The scenario belongs to issue of a multi step user task approval where the request was initiated by Oracle IDAM and workflow being fulfilled using Oracle SOA. Below is the summary of the use case-

Environment
Oracle Soa Suite 12c, Oracle IDAM 12c

Problem
There was a two step approval process where approval request was initiated from Oracle IDAM system (OIM). All user base resides in OIM system at LDAP/DB level. Dynamic user assignment was there to act on user task. Initially, there was two level approval task where one user per level was assigned i.e. one user can act on a task. Later, the requirement changed as task assignment to group for level 2 approval. The task assignment was being done using business rules. So, changes done and the composite was deployed and tested out. The approval flow was fine up to level 1 but after approval by level 2 (any group member) it shows the workflow statu…

JDeveloper 12c (SOA QuickStart) failed to start after updating the macOS

Image
Recently one of the strange issue came with one of my colleague with respect to jDeveloper 12c Startup. Below is the summary of the issue and solution-

Environment:
macOS Sierra, jDeveloper 12c (SOA12c QuickStart)

Problem: 
macOS was continuously giving the prompt for update. Mistakenly update was clicked and macOS updated to macOS Mojave (10.1.4.6). System reboot done.When jDeveloper was started, only jDev splash screen came and gone. However, jDeveloper was not startedAfter several attempts, same thing happened and jDev was failed to start.Alternatively when tried to start via terminal, following logs were shown
Oracle JDeveloper 12c Release 12.2.1.3.0
 Copyright (c) 1997, 2017, Oracle and/or its affiliates. All rights reserved.

java.lang.RuntimeException: Exception in org.eclipse.osgi.framework.internal.core.SystemBundleActivator.start() of bundle org.eclipse.osgi.
at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.resume(InternalSystemBundle.java:233)
at org.eclipse.osgi.fram…

Oracle Weblogic Server 12c RAC Connection

Image
Oracle Database 12c RAC
In this post I'll list down the stepwise process to create a JNDI connection with Oracle RAC (Real application cluster) database. Following are the steps of the same-

Step 1
Login to Weblogic server console. Navigate to left pagination menu and select data sources. Now, create a new data source connection with type- GridLink
Step 2
Specify the connection & JNDI name-

Step 3
Set transaction(s) type-
Step 4
Specify various GridLink options-
Step 5
Setting connection properties-
Step 6
Testing the connection specified in step 5
Step 7
Now click on Test All Listeners if you fill everything correctly you will come up with “connection test for jdbc…. Succeeded ”.
Step 8
Now check FAN Enabled .which means  Fast Application Notification (FAN) that is a high availability notification mechanism that Oracle RAC uses to notify other processes about cluster configuration and service-level information, including status changes such as UP or DOWN events.
Step 9
Testing ONS configuration…

Oracle SOA Suite 12c Guided Learning path

Image
Guided Learning path
I have received a lot of queries regarding the Guided Learning Path(GLP) of Oracle SOA Suite. Based on my experience, I'll try to list down the prerequisites and the learning path to Oracle SOA Suite 12c that will help for a beginner/intermediate developer to move further in this domain.

Overview- Oracle SOA
What is SOA ?Overview of Oracle SOAReal Life ExamplesBenefits of using Oracle SOA SuiteImportance- Oracle SOA SuiteIntroduction to Web Services
Overview of XML, XSD, Web-Services, SOAP, UDDI, WSDLOverview of XML, XSD, Web-Services, SOAP, UDDI, WSDLWeb Services Sample Demonstration.Understanding WSDLService Component Architecture (SCA)
Introduction to Service Component ArchitectureBuilding blocks of SCAOverview of Oracle SOA Suite 12cIntroduction to Components of Oracle SOA SuiteInstallation Oracle SOA Suite- QuickStart
Overview of WebLogic serverOverview WebLogic Domains and Server instancesSetting up Oracle SOA EnvironmentManaging and Monitoring Composite Appli…