This discussion is archived
7 Replies Latest reply: Feb 8, 2013 2:29 AM by user513795 RSS

RPM 13.2 Price Change Problem

Chandramouly P Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    <?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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    ####<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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    user513795 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points