Notifications

117 views

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). 

Additional Information


Article Information

Last Updated:2018-12-26 15:12:03
Published:2018-12-26