Support Centre

Find articles, help and advice.

 
Welcome, Guest Login

Support Center

BES - Message Channel appears in debug mode when it should be off

Last Updated: Jan 05, 2015 12:53PM UTC
On some occasions, for one reason or another, a message channel may become 'stuck' in debug mode, even if the message channel configuration appears to suggests otherwise. There are several ways and levels debugging can be enabled on message channels, as outlined in another support article. If you have tried to remove debug, as detailed in the aforementioned support article, yet the channel continues to log debug output, it is likely that the debug flags in the database have not been updated correctly.

The ppmd determines debugging from the ISS_PP_MC_View table, which is a join on two tables: ISS_PP_MCdef_Table and ISS_PP_MCcomp_Table. The two columns s_mcdebug and s_compdebug define if the program is launched with the debug parameter s_compdebugparms. If either parameter has a value of "1" for true, then the program is launched with the debug parameter.

To check the debug flags in the database and remove any trace of debug, use the following SQL. The examples below use the ISS demo message channel - replace any instances of ISS to the channel of your choice:

PostgreSQL:

Check the columns s_mcdebug and s_compdebug in the ISS_PP_MC_View table (0 = debug off, 1 = debug on):

select s_mc, s_mcname, s_mcdebug, s_compdebug from ISS_PP_MC_View where s_mcname = 'ISS';

 s_mc | s_mcname | s_mcdebug | s_compdebug
---------+-----------------+------------------+--------------------
    1    | ISS           |         1         |           1


In the example above, the debug parameter in both the ISS_PP_MCdef_Table (s_mcdebug) and ISS_PP_MCcomp_Table (s_compdebug) is set to 1 (enabled). To update the s_mcdebug parameter and set debug to 0, run the following SQL:

update ISS_PP_MCdef_Table set s_debug = 0 where s_mcname = 'ISS';

To update the s_compdebug parameter and set debug to 0, run the following SQL (s_mc is the message channel id from the ISS_PP_MC_View table):

update ISS_PP_MCcomp_Table set s_debug = 0 where s_mc = 1;


If you now check the ISS_PP_MC_View table again, you should see the debug parameters set to 0:

select s_mc, s_mcname, s_mcdebug, s_compdebug from ISS_PP_MC_View where s_mcname = 'ISS';

 s_mc | s_mcname | s_mcdebug | s_compdebug
---------+-----------------+------------------+--------------------
    1    | ISS           |         0         |           0

A recycle of the message channel is required for these changes to be picked up.

Sybase:

The SQL statements for Sybase are slightly different to that of PostgreSQL:

View the ISS_PP_MC_View table:

select s_mc, s_mcname, s_mcdebug, s_compdebug from ISS_PP_MC_View where s_mcname = "ISS"

Update debug parameters:

update ISS_PP_MCdef_Table set s_debug = 0 where s_mcname = "ISS"
update ISS_PP_MCcomp_Table set s_debug = 0 where s_mc = 1

A recycle of the message channel is required for these changes to be picked up.
 

Contact Us

desk.com@interlinksoftware.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete