Wednesday, July 26, 2017

OIM: ORA-12899: value too large for column "WFMESSAGEATTRIBUTE"."STRINGVALUE" (actual: 2003, maximum: 2000)

The request fails with an error message: ORA-12899: value too large for column "WFMESSAGEATTRIBUTE"."STRINGVALUE" (actual: 2003, maximum: 2000)

The root cause is simple, OIM allows justification of 4000 characters but SOA supports justification of maximum of 2000 characters

We need to restrict justification to 2000 characters in OIM. 

Justification is a inputText field in ADF’s terms and one of the fields property is ‘Maximum Length’. 


Solution: Create a SB,  update the maximum length property to 2000 and test.

Friday, July 21, 2017

Quick Tip#3: Storing JSON data in Oracle Database

For the last couple of years, I have used JSON as my go to data format. Many a times, I had to store the JSON in the database. I used the same approach of storing it as a VARCHAR2/CLOB/BLOB and then validating the data via API. Also there was no check on what else could exist in that column(junk value or error insertion) resulting in even more validations for my data.

Now, Oracle has come up with JSON support in databases 12.1.0.2 version, which is really helpful for some one storing the json values in db.

Here is the link to the article, which explains the same in details.


Awesome work, Oracle.  

Wednesday, July 12, 2017

OAM: Learning the basics - Part 5 - SAML

SAML (Security Assertion Markup Language), is the leading SSO protocol and is paramount in understanding the Single Sign Sign(SSO) workings. SAML is the language by which Identity Provider and Service Provider communicates(XML based) to establish the user's identity.

OAM: Learning the basics - Part 4 - Proxy, Forward Proxy, Reverse Proxy

ProxyProxy means that someone is action on behalf of someone else.

Forward Proxy: Here the proxy server is acting on behalf of the client, i.e. the content server is unaware that the request is coming from the ‘Client’.  For the ‘Content Server’, the ‘Client’ does not exist. 

Reverse Proxy: Here the proxy server is acting on behalf of the content server. i.e. the Client is unaware the response is returned from the ‘Content Server’. For the client, the ‘Content Server’ does not exist.