7 Replies Latest reply: Feb 8, 2013 4:29 AM by Aysik RSS

    RPM 13.2 Price Change Problem

    Chandramouly P
      While creating a price change ...when the item is submitted for conflict checking ,its completing the task,when clicking on submit ,its successfully showing the status as submitted,but when clicking approve, the conflict check is giving out a alert saying" conflict check has completed",but the status on the price change is still being shown as "conflict checking"..
      any reasons for such behaviour?
        • 1. Re: RPM 13.2 Price Change Problem
          Yaasheen-Oracle
          Hi Chandramouly,

          We would need the WLS log to ascertain if there was any exception thrown at the time of conflict check.

          Change the logging level to DEBUG in log4j.xml which resides in <ORACLE_HOME>/user_projects/domains/soa_domain/servers/<rpm_
          server>/tmp/_WL_user/<rpm_app_name>/<encrypted_folder>/conf

          Recreate the issue and send the log from : <ORACLE_HOME>/user_projects/domains/sso_domain/servers/RPM132_MS/logs.

          for the timestamp when the issue had occurred at your end.

          Thanks
          Yaasheen
          • 2. Re: RPM 13.2 Price Change Problem
            Chandramouly P
            <?xml version="1.0" encoding="UTF-8" ?>
            <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

            <!-- ===================================================================== -->
            <!-- -->
            <!-- Log4j Configuration File -->
            <!-- -->
            <!-- For more configuration infromation and examples see the Jakarta -->
            <!-- Log4j website: http://jakarta.apache.org/log4j -->
            <!-- -->
            <!-- ===================================================================== -->

            <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"
            debug="false">

            <!-- ============================== -->
            <!-- Append messages to the console -->
            <!-- ============================== -->
            <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
            <param name="Threshold" value="DEBUG" />
            <param name="Target" value="System.out" />
            <layout class="com.retek.rpm.log4j.RPMLog4jPatternLayout">
            <!-- additions to pattern layout:
            %T: current jta transaction id
            %H: current hibernate session hash code
            -->
            <param name="ConversionPattern"
            value="%d{ABSOLUTE} %-5p (%t) [%c{1}] %m%n" />
            </layout>
            </appender>


            <!-- ======================================================== -->
            <!-- Append messages to a file that is rolled daily. -->
            <!-- ======================================================== -->
            <appender name="RpmLogFile"
            class="org.apache.log4j.RollingFileAppender">
            <param name="File" value="/home/oracle/Oracle/Middleware/user_projects/domains/formsdomain/servers/rpm_server/logs/RPM.log" />
            <param name="MaxFileSize" value="1024KB" />
            <param name="MaxBackupIndex" value="10" />
            <param name="Threshold" value="ERROR" />
            <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
            value="%d{dd-MM-yyyy HH:mm:ss} %-9.9p %m%n" />
            </layout>
            </appender>


            <!-- ======================= -->
            <!-- Setup the loggers -->
            <!-- ======================= -->


            <logger name="com.retek.rpm">
            <level value="ERROR" />
            </logger>
            <logger name="com.oracle.retail.rpm">
            <level value="ERROR"/>
            </logger>

            <logger name="com.retek.rpm.domain.external.dao">
            <level value="ERROR"/>
            </logger>

            <logger name="com.retek.rpm.domain.task.service">
            <level value="ERROR"/>
            </logger>

            <logger name="com.retek.rpm.domain.core.service.JmsContext">
            <level value="ERROR"/>
            </logger>

            <logger name="com.retek.rpm.domain.core.service.RPMServerContext">
            <level value="ERROR"/>
            </logger>
            <!-- This logger should be set at ERROR level, since it generates lots of logs -->
            <logger
            name="com.retek.rpm.domain.core.service.RPMServerContext_DEBUG">
            <level value="ERROR" />
            </logger>

            <logger name="com.retek.rpm.domain.core.service.RPMHibernateTransactionController">
            <level value="ERROR"/>
            </logger>
            <logger name="com.retek.platform.persistence.hibernate.HibernateSessionDispenser">
            <level value="ERROR"/>
            </logger>

            <logger name="com.oracle.retail.rpm.domain.businessprocess.service">
            <level value="ERROR"/>
            </logger>

            <logger name="com.oracle.retail.rpm.promotions.service">
            <level value="ERROR"/>
            </logger>

            <logger name="net.sf.hibernate.transaction">
            <level value="ERROR"/>
            </logger>

            <logger name="net.sf.hibernate.SQL">
            <level value="ERROR"/>
            </logger>

            <!-- ======================== -->
            <!-- setup the default logger -->
            <!-- ======================== -->
            <root>
            <level value="WARN" />
            <appender-ref ref="CONSOLE" />
            <appender-ref ref="RpmLogFile" />
            </root>

            </log4j:configuration>


            there is a logging level given for a number of loggers,which specific logger's value do i need to change to DEBUG ?

            regards.
            • 3. Re: RPM 13.2 Price Change Problem
              Yaasheen-Oracle
              hi,

              Change the following :

              <logger name="com.retek.rpm">
              <level value="ERROR" />
              </logger>
              <logger name="com.oracle.retail.rpm">
              <level value="ERROR"/>
              </logger>

              to

              <logger name="com.retek.rpm">
              <level value="DEBUG" />
              </logger>
              <logger name="com.oracle.retail.rpm">
              <level value="DEBUG"/>
              </logger>

              Thanks
              Yaasheen
              • 4. Re: RPM 13.2 Price Change Problem
                Chandramouly P
                ####<Dec 6, 2012 2:52:02 PM IST> <Info> <Common> <retailsols> <rpm_server> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1354785722173> <BEA-000628> <Created "1" resources for pool "RPMNonXADataSource", out of which "1" are available and "0" are unavailable.>
                ####<Dec 6, 2012 2:52:02 PM IST> <Info> <JDBC> <retailsols> <rpm_server> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1354785722860> <BEA-001128> <Connection for pool "RPMNonXADataSource" closed.>
                ####<Dec 6, 2012 2:52:03 PM IST> <Info> <Common> <retailsols> <rpm_server> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1354785723192> <BEA-000628> <Created "1" resources for pool "RPMNonXADataSource", out of which "1" are available and "0" are unavailable.>
                ####<Dec 6, 2012 2:52:04 PM IST> <Info> <Common> <retailsols> <rpm_server> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1354785724597> <BEA-000628> <Created "1" resources for pool "RPMNonXADataSource", out of which "1" are available and "0" are unavailable.>
                ####<Dec 6, 2012 2:52:04 PM IST> <Info> <Common> <retailsols> <rpm_server> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1354785724901> <BEA-000628> <Created "1" resources for pool "RPMNonXADataSource", out of which "1" are available and "0" are unavailable.>
                ####<Dec 6, 2012 2:57:24 PM IST> <Info> <Health> <retailsols> <rpm_server> <weblogic.GCMonitor> <<anonymous>> <> <> <1354786044634> <BEA-310002> <70% of the total memory in the server is free>
                i did just like u asked me to ...these are the contents of the log file at the timestamp i recreated the issue.
                Regards.

                Edited by: Chandramouly P on Dec 6, 2012 1:29 AM
                • 5. Re: RPM 13.2 Price Change Problem
                  Yaasheen-Oracle
                  Hi,

                  It is still in Info mode.

                  ####<Dec 6, 2012 2:52:04 PM IST> <Info>

                  Can you check which logger is i Info and make it to Debug. Probably a rpm server bounce might help for the changes to take effect

                  Can you verify if the back end tables for the Price Change - rpm_price_change. What is the status in it ?

                  Thanks
                  Yaasheen
                  • 6. Re: RPM 13.2 Price Change Problem
                    Chandramouly P
                    none of the logger is info mode,
                    and the status of the item in RPM_PRICE_CHANGE is pricechange.state.conflictChecking.it didnt change to approve.

                    REgards
                    • 7. Re: RPM 13.2 Price Change Problem
                      Aysik
                      Hi,

                      Please check if the item is already on Clearance which may be the reason for the perennial Conflict Check status

                      select CLEAR_IND from ITEM_LOC where item = '' and loc = '';

                      Thanks,
                      Aysik