BI Publisher java.lang.reflect.InvocationTargetException

When I was doing some crazy experiments with XSL variables in BI Publisher,
came across the error "java.lang.reflect.InvocationTargetException".
The error was generated by the MS Word Addin of BIP while creating a pdf preview. as shown.

The error screen was the following.

A little googling saved me!!! the reason for this error in java is mainly due to incorrect datatype.
Say a variable of type "Number" is getting assigned with a value of type "Text".

Bingo... the error might be in the variable I decalred as below..!!!

<?xdoxslt:set_variable($_XDOCTX,'V_NA',0)?>

and what generated the error should be,

<?xdoxslt:set_variable($_XDOCTX,'V_NA',NAME)?>

The error was resolved by changing the code to

<?xdoxslt:set_variable($_XDOCTX,'V_NA','xyz')?>

And tried again to get a preview.... Ta..da... It Worked.

Macro Cannot be found error in BI Publisher- MS Office

After installing BI Publisher for MS Office Suit I got an error stating "Macro Cannot be found..." Just like anybody else i was also frustrated when i saw the following error for the first time.

Solution
Close all MS Office Applications (Including Outlook, Groove etc)
For 64-bit operating systems, type the following in command prompt:
Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX"
For 32-bit operating systems, type the following in command prompt:
Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"

It worked fine for me and my colleagues

.
Waiting for your valuable feedback.