Web service response messages are intermittently dropped,even when the response has been validated using a reverse proxy such as the TCP/IP Monitor.


1) Open your current WebSphere Commerce configuration file
    <WCDE_installdir>/workspace/WC/xml/config/wc-server.xml

2) Locate the following OutboundConnector definition:

<OutboundConnector default="true"
enabled="true"
id="-101"
name="HTTP-WS"
retries="3">
<ConnectionSpec
ClassName="com.ibm.commerce.wc.messaging.adapters.jcahttp.JCAHTTPConnectionSpecImpl"
default="true" />
<InteractionSpec
ClassName="com.ibm.commerce.wc.messaging.adapters.jcahttp.JCAHTTPInteractionSpecImpl"
default="true">
<EditableProperty Admin="userName"
display="false"
editable="yes"
name="setBasicAuthenticationName"
value="" />
...
...

3) Add the following EditableProperty definition:

<EditableProperty Admin="bufferResponse"
display="false" editable="yes"
name="setIsBufferResponse" value="true"/>
</InteractionSpec>

4) Save and Re-start the server for the changes to get reflected

Query to reset the password of the user.
 
UPDATE userreg SET status=1,  passwordexpired=0,
logonpassword= (SELECT logonpassword FROM userreg WHERE logonid='wcsadmin'),
salt= (SELECT salt FROM userreg WHERE logonid='wcsadmin')
where logonId=< logonid of user being reset >

To export the data from the database in Websphere using Massextract utility.

We can use the massextract utility to extract the data from the database into an XML document. This utility makes use of an XML file which can be called as the extraction filter  which is an XML document having the query to extract the data.

Command to execute -
massextract.cmd -filter SampleFilter.xml -outfile SampleExtracted.xml -dbname <dbname> -dbuser <dbuser> -dbpwd <dbpassword


Log -    WC_installdir/logs/massload.oracle.log

Note - 

• We can use the custom table in the same extraction filter along with the WCS tables to extract the data.
• There can be only one table need to be defined for the schemaentity and no complex joins allowed.
• Unquie id needs to be defied for each <functionDef />

SampleFilter.xml 

 <sqlx>
<functionDef id="Product" description="Extract Product"
schemaentity="site">
       <body>
        select * from site
      </body>
 </functionDef>

    <execute id="Product" description="Extract Product"
schemaentity="site">
      </execute>

</sqlx>

SampleExtracted.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE import [
<!ELEMENT  import  (  site  )*>
<!ELEMENT    site    EMPTY>
<!ATTLIST    site
    databasevendor    CDATA    #IMPLIED
    edition    CDATA    #IMPLIED
    version    CDATA    #IMPLIED
    release    CDATA    #IMPLIED
    mod    CDATA    #IMPLIED
    fixpack    CDATA    #IMPLIED
    compname    CDATA    #IMPLIED
    optcounter    CDATA    #IMPLIED
>
]>

<import>
<site
    databasevendor="IBM"
    edition="ENT"
    version="7"
    release="0"
    mod="0"
    fixpack="7"
    compname="BASE"
    optcounter="7"
/>
</import> 

Ref -

http://www-01.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.ibm.commerce.data.doc/tasks/tml_extract.htm?lang=en

http://www-01.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.ibm.commerce.data.doc/refs/rml_extract_filter_example.htm?lang=en

IBM Knowledge Center Link

http://www-01.ibm.com/support/knowledgecenter/

Adding words to dictionaries in Management Center
 
We can add new words or pharases to Management Center spell checker dictionary so that they are no longer flagged as misspelled words.The Management Center spell checker dictionary is case-sensitive.

• Update /LOBTools/WebContent/WEB-INF/dictionaries/addenda.xml
• Within the addenda.xml file, add the new words or phrases that you want the spell checker to recognize.

             <?xml version="1.0" encoding="UTF-8" ?>
             <dictionary>
                  <word locale="en-US,fr-FR">sampleword1</word>
                  <word locale="en-US">sampleword2</word>
             </dictionary>

Note: Spell check does not support the following languages:
         Japanese
         Korean
         Romanian
         Simplified Chinese
         Traditional Chinese

To renew a self-signed certificate and chained certificate
 

1. Login to administrative console
2. Click Security > SSL certificate and key management.
3. Under Related Items, click Key stores and certificates.
4. Click the appropriate <keystore name> to which you want to add the new certificate.
5. Under Additional Properties, click Personal certificates to list the personal certificates.
6. Select a personal certificate from the list.
7. Click the Renew button.
8. Click Apply then OK.

Session Timeout change for Management Center and Sales Center

• Udpate wc-server.xml for InactivityTimeout and Threshold value

              <ExpiryManagement

                   ExpiryMgmtChannelId="-4"
                   InactivityTimeout="15"
                   Threshold="15"
                   enable="true"
            />

            where
 
            InactivityTimeout
                   The lease time of the session in minutes. The session remains active within this  time(minutes)

           Threshold
                   The allowable time in minutes to renew the lease. If a request comes in within this threshold time and after the lease time, the lease on the activity is renewed. In the sample configuration, for example, the threshold time is 15 minutes. Therefore, the activity remains active for 30 (15 + 15) minutes.

• Deploy the file to the WebSphere Commerce EAR.
• Republish the WebSphere Commerce application.