Issue
Symptoms
error :The used SELECT statements have a different number of columns
Release
Jakarta Patch 9c
Resolution
The cause of the issue can be seen in the node log. If you have training in searching the node log <Node log browser> , search for the statement "The used SELECT statements have a different number of columns" at around the time you suspect the issue occurred. There will be an email query that caused this. Find sys_emailxxxx that is directly after the 'FROM' (i.e. '...FROM sys_emailxxx') where 'xxxx' is the number of the email, and replace the xxxx in these two scripts. Then run the following in Scripts Background:
GlideTableManager.invalidateTable('sys_emailxxxx');
GlideCacheManager.flushTable('sys_emailxxxx');
You might need to the clear the system's cache after this (cache.do).
