Tech Byte: How to solve error preventing access to store-level settings using node selection in RP Prism Admin Console

Node selection in the Administration Console allows you to specify settings for different levels, from corporate and subsidiary all the way down to store and workstation. Using node selection properly is vital to ensure your selected settings are applied in the proper context.

At times an error occurs which prevents the user from accessing the store level through node selection. 

 

Problem

Cannot access the store-level settings using node selection in Admin Console.

 

 

 

Cause

Invalid characters in one or more of the store detail fields replicated to RP Prism from RIL.

 

Solution

Identify the characters in the RIL stores table, correct the detail in the OPTIONS > System Preferences > Local Preferences > Stores > General area of RIL, and replicate the change to RP Prism.

 

Steps

1. Open the Technician's ToolKit in RIL and go to SQLShell.
2. Run each SQL diagnostic statement (provided below under "Store Detail Diagnostic Statements") to identify fields in the store table of RIL which contain invalid characters.

 

 

3. Log into RIL and go to OPTIONS > System Preferences > Local Preferences > Stores > General to correct the fields containing invalid characters.
4. If Day-to-Day replication is not already set up, you can initialize STORES using a custom RIL --> Prism Profile. Consult the Connection Manager documentation detail if needed.

 

Store Detail Diagnostic Statements

select * from store where address1 like '%"'or address2 like '%"' or address3 like '%"'or address4 like '%"'or address5 like '%"'

select * from store where address1 like '%"%'or address2 like '%"%' or address3 like '%"%' or address4 like '%"%'or address5 like '%"%'

select * from store where address1 like '"%'or address2 like '"%' or address3 like '"%' or address4 like '"%' or address5 like '"%'

select * from store where address1 like '%>'or address2 like '%>' or address3 like '%>' or address4 like '%>' or address5 like '%>'

select * from store where address1 like '%>%'or address2 like '%>%' or address3 like '%>%' or address4 like '%>%'  or address5 like '%>%'

select * from store where address1 like '>%'or address2 like '>%' or address3 like '>%' or address4 like '>%'or address5 like '>%'

select * from store where address1 like '%<'or address2 like '%<' or address3 like '%<' or address4 like '%<'or address5 like '%<'

select * from store where address1 like '%<%'or address2 like '%<%' or address3 like '%<%' or address4 like '%<%'or address5 like '%<%'

select * from store where address1 like '<%'or address2 like '<%' or address3 like '<%' or address4 like '<%' or address5 like '<%'

select * from store where address1 like '%&'or address2 like '%&' or address3 like '%&' or address4 like '%&' or address5 like '%&'

select * from store where address1 like '%&%' or address2 like '%&%'or address3 like '%&%' or address4 like '%&%'or address5 like '%&%'

select * from store where address1 like '&%'or address2 like '&%' or address3 like '&%' or address4 like '&%' or address5 like '&%'

select * from store where address1 like '%'''or address2 like '%''' or address3 like '%''' or address4 like '%''' or address5 like '%'''

select * from store where address1 like '%''%'or address2 like '%''%' or address3 like '%''%' or address4 like '%''%' or address5 like '%''%'

select * from store where address1 like '''%'or address2 like '''%' or address3 like '''%' or address4 like '''%' or address5 like '''%'

 

--store name

select * from store where store_name like '"%'

select * from store where store_name like '%"%'

select * from store where store_name like '%"'

select * from store where store_name like '>%'

select * from store where store_name like '%>%'

select * from store where store_name like '%>'

select * from store where store_name like '<%'

select * from store where store_name like '%<%'

select * from store where store_name like '%<'

select * from store where store_name like '&%'

select * from store where store_name like '%&%'

select * from store where store_name like '%&'

select * from store where store_name like '#%'

select * from store where store_name like '%#%'

select * from store where store_name like '%#'

select * from store where store_name like '''%'

select * from store where store_name like '%''%'

select * from store where store_name like '%'''

 

 

Additional

Below is a list of invalid characters that can cause this problem.

 

Character	Description
"	Double-quote character
‘	Apostrophe (single-quote) character
<	Less-than character
>	Greater-than character
&	Ampersand character