Monday, May 18, 2015

Error SBL-EIM-00306, in "ifb_name.ifb" line 63: Invalid token for right-hand side.

Error SBL-EIM-00306, in "ifb_name.ifb" line 63: Invalid token for right-hand side.

This error is one of the rare-coming errors for experienced professional but common for beginners as the cause is so tuned that is difficult to identify.


Well, with the error description itself it is clear that something is wrong/incorrect in the configuration file. Lets discuss the problem, cause and solution for this.



Problem:

Error encountered on UI when the EIM is run "SBL-EIM-00204: Invalid configuration file (ifb) name". This is a very generic error which may not give you a hint about the actual error. So when you dig the log you may find "Error SBL-EIM-00306, in "ifb_name.ifb" line 63: Invalid token for right-hand side."

Cause: 

The actual cause of this error might be more than one or may be altogether different at different times. The one that i found out (in my case) was a space after the DEFAULT COLUMN parameter. Below was the cause:

DEFAULT COLUMN = ADMIN_ADJ_FLG, "N"   <-- space after statement ends


Solution:

So the simple solution here is to double check for any space after any statement in the ifb, particularly the Default column parameter. The space after this parameter is treated as a token which is not recognized by the EIM engine which reads the configuration file before starting the actual load. The right hand side means that the cause is after "=" sign which is treated as right hand side whereas Default Column is treated as left hand side.


Keep reading...

Mohammed Arif