WebSphere Commerce 7 | REST calling BOD framework | Calls not reaching the WCS Server | Port 80 Issue


I have implemented REST Service, which calls BOD framework to fetch the data from WebSphere Commerce Database. When I tried to call this from the URI, we noticed that the call is not at all reaching the WebSphere Commerce server.

When we tried to debug the issue, it has been noticed the following messages in the logs,
TCP Channel TCP_2 initialization failed.  The socket bind failed for host * and port 80.  The port may already be in use.

Got the culprit :)

Port 80 is using by some application in my laptop and we have followed these steps to fix the issue,
  • Open the command prompt and run NETSTAT command
         netstat -ao 

    Here is the output for the same,
    Proto  Local Address   Foreign Address  State        PID   
     TCP    0.0.0.0:80        BCY4:0       LISTENING       4
  • Now, we have tried to find out, which resource/application is using this port 80
    • Go to Windows Task Manager --> View --> Select Columns --> Opted PID (Process Identifier)

    • Sort with PID and noticed, this PID 4 is getting used by IIS Server (http) 


  •  Stopped the http with the following command,
       net stop http 
  • Restart your WebSphere Commerce server and try to check which resource/application is using port 80,

 

 

Issue has been fixed and you can notice this kind of issues, if your machine has Skype, Connectify Me, HTTP Server installations. Make sure that, these applications doesn't use Port 80.

Thanks Aniket Sharma and Shashi Kumar for your ideas in resolving this socket bind failed exception.
at 1 comment:
Labels: , ,
Location: Bengaluru, Karnataka, India

WebSphere Commerce 7 | Installation Tips | Deleting Out of Box Tables | Script

Whenever you do installation of WebSphere Commerce and trying to setup your Oracle Database with Out Of Box schema, you might be using "setdbtype" command with "createdb" option. "setdbtype" command with "createdb" option, creates OOB tables schema in the empty database.

 And, for some reason, if you wanted to cleanup all the WebSphere Commerce OOB data/tables and to bring to the earlier state (Empty DB), you can use the following steps,
  • Run the following query in your Database,
select 'drop table '||table_name||' cascade constraints;' from user_tables;
  • The output of the query will be the cleanup script of all the tables. Copy the script and run it again in the database, so that it deletes all the tables present in the Database.

Here is the sample script, generated from my Database,
drop table CMMETADATA cascade constraints;
drop table CMSMALLFILE cascade constraints;
drop table CMWORKSPACE cascade constraints;
drop table CMWSSCHEMA cascade constraints;
drop table CNTRDISPLY cascade constraints;
drop table CNTRNAME cascade constraints;
drop table CNTRSTORE cascade constraints;
drop table COLLABWS cascade constraints;
drop table COLLATERAL cascade constraints;
drop table COLLDESC cascade constraints;
drop table COLLTYPE cascade constraints;
drop table CONTRACT cascade constraints;
drop table CONTRLRULE cascade constraints;
drop table COUNTCODE cascade constraints;
drop table COUNTRY cascade constraints;
drop table CPEMAILMAP cascade constraints;
drop table CPENDORDER cascade constraints;
drop table CPGNLOG cascade constraints;
drop table CPGNSTATS cascade constraints;
drop table CPITMAP cascade constraints;
drop table CPOFFER cascade constraints;
drop table CPPMN cascade constraints;
drop table CPPMNACC cascade constraints;
drop table CPPMNCAT cascade constraints;
drop table CPPMNDESC cascade constraints;
drop table CPPMNDISC cascade constraints;
drop table CPPMNORD cascade constraints;
drop table CPPMNPROD cascade constraints;
drop table CPPMNVAL cascade constraints;
drop table CPWALLET cascade constraints;
drop table CREDITLINE cascade constraints;
drop table CRULESCALE cascade constraints;
drop table CSEDITATT cascade constraints;
drop table CTXDATA cascade constraints;
drop table CTXMGMT cascade constraints;
drop table CURCONVERT cascade constraints;
drop table CURCVLIST cascade constraints;
drop table CURFMTDESC cascade constraints;
drop table CURFORMAT cascade constraints;
drop table CURLIST cascade constraints;
drop table CURMSGID cascade constraints;
drop table CWMEMBER cascade constraints;
drop table DAEMON cascade constraints;
drop table DBDELIVERY cascade constraints;
drop table DBDTFREQ cascade constraints;
drop table DBMEAS cascade constraints;
drop table DBMEASFM cascade constraints;
drop table DBTEMPLATE cascade constraints;
drop table DBVIEW cascade constraints;
drop table DEVICEFMT cascade constraints;
drop table DISPCGPREL cascade constraints;
drop table DISPENTREL cascade constraints;
drop table DISTARRANG cascade constraints;
drop table DKADJMNT cascade constraints;
drop table DKOFFER cascade constraints;
drop table DKPDCCATENTREL cascade constraints;
drop table DKPDCCOMPLIST cascade constraints;
drop table DKPDCDESC cascade constraints;
drop table DKPDCOFFERREL cascade constraints;
drop table DKPDCREL cascade constraints;
drop table DKPREDEFCONF cascade constraints;
drop table DMACTATTR cascade constraints;
drop table DMACTIVITY cascade constraints;
drop table DMACTTYPE cascade constraints;
drop table DMCAMPAIGN cascade constraints;
drop table DMELEMENT cascade constraints;
drop table DMELEMENTNVP cascade constraints;
drop table DMELEMENTTYPE cascade constraints;
drop table DMELESTATS cascade constraints;
drop table DMELETEMPLATE cascade constraints;
drop table DMEMSPOTCMD cascade constraints;
drop table DMEMSPOTDEF cascade constraints;
drop table DMEMSPOTORD cascade constraints;
drop table DMEMSPOTPAGE cascade constraints;
drop table DMEMSPOTSTATS cascade constraints;
drop table DMEXPFAMILY cascade constraints;
drop table DMEXPLOG cascade constraints;
drop table DMEXPSTATS cascade constraints;
drop table DMEXPTYPE cascade constraints;
drop table DMMBRGRPPZN cascade constraints;
drop table DMPAGE cascade constraints;
drop table DMTEMPLATETYPE cascade constraints;
drop table DMTRIGLSTN cascade constraints;
drop table DMTRIGSND cascade constraints;
drop table DMUSERBHVR cascade constraints;
drop table ECEOUT cascade constraints;
drop table ECETMPT cascade constraints;
drop table ECTPTITM cascade constraints;
drop table EDPATMPAY cascade constraints;
drop table EDPATMREF cascade constraints;
drop table EDPORDER cascade constraints;
drop table EDPPAYHIST cascade constraints;
drop table EDPPAYINST cascade constraints;
drop table EDPREFINST cascade constraints;
drop table EDPRELEASE cascade constraints;
drop table EDPRELHIST cascade constraints;
drop table EDPRMA cascade constraints;
drop table EMLBADADDR cascade constraints;
drop table EMLBOUNCED cascade constraints;
drop table EMLCAMPREL cascade constraints;
drop table EMLCFG cascade constraints;
drop table EMLCONTENT cascade constraints;
drop table EMLGRPREL cascade constraints;
drop table EMLMCREL cascade constraints;
drop table EMLMSG cascade constraints;
drop table EMLPOLICY cascade constraints;
drop table EMLPROMO cascade constraints;
drop table EMLRCPTS cascade constraints;
drop table EMLRPTEVTS cascade constraints;
drop table EMLSTRPLCY cascade constraints;
drop table EMLUSRRECV cascade constraints;
drop table EMSPOT cascade constraints;
drop table ESMAPOBJ cascade constraints;
drop table ESMAPTYP cascade constraints;
drop table EXCHORDERS cascade constraints;
drop table EXPERIMENT cascade constraints;
drop table EXPLOG cascade constraints;
drop table EXPRESULT cascade constraints;
drop table EXPSTATS cascade constraints;
drop table EXPTYPE cascade constraints;
drop table FFMCENTDS cascade constraints;
drop table FFMCENTER cascade constraints;
drop table FILEUPLOAD cascade constraints;
drop table FLCOMPOSE cascade constraints;
drop table FLDOMNDESC cascade constraints;
drop table FLINSTANCE cascade constraints;
drop table FLOW cascade constraints;
drop table FLOWADMIN cascade constraints;
drop table FLOWDESC cascade constraints;
drop table FLOWDOMAIN cascade constraints;
drop table FLOWTYPE cascade constraints;
drop table FLSTATEDCT cascade constraints;
drop table FLSTATEGP cascade constraints;
drop table FLSTATEREL cascade constraints;
drop table FLSTDCTDSC cascade constraints;
drop table FLSTGPDSC cascade constraints;
drop table FLTRANSDSC cascade constraints;
drop table FLTRANSITN cascade constraints;
drop table FLTYPEDESC cascade constraints;
drop table FORUM cascade constraints;
drop table FORUMMSG cascade constraints;
drop table GEONDDS cascade constraints;
drop table GEONODE cascade constraints;
drop table GEOTREE cascade constraints;
drop table GRADDR cascade constraints;
drop table GRANNHIST cascade constraints;
drop table GRANNTMPLT cascade constraints;
drop table GREMLLIST cascade constraints;
drop table GRETDESC cascade constraints;
drop table GREVNTTYPE cascade constraints;
drop table GREVTRMDLG cascade constraints;
drop table GRGFTITM cascade constraints;
drop table GRGFTREG cascade constraints;
drop table GRPERATTR cascade constraints;
drop table GRPURREC cascade constraints;
drop table GRREGRULE cascade constraints;
drop table GRRGSTRNT cascade constraints;
drop table GRUSERAUTH cascade constraints;
drop table HISTOATTR cascade constraints;
drop table HISTOFREQ cascade constraints;
drop table HISTONVP cascade constraints;
drop table ACACGPDESC cascade constraints;
drop table ACACTACTGP cascade constraints;
drop table ACACTDESC cascade constraints;
drop table ACACTGRP cascade constraints;
drop table ACACTION cascade constraints;
drop table ACATTR cascade constraints;
drop table ACATTRDESC cascade constraints;
drop table ACCCMDGRP cascade constraints;
drop table ACCCMDTYPE cascade constraints;
drop table ACCCUSTEXC cascade constraints;
drop table ACCLOGMAIN cascade constraints;
drop table ACCLOGSUB cascade constraints;
drop table ACCMBRGRP cascade constraints;
drop table ACCOUNT cascade constraints;
drop table ACORGPOL cascade constraints;
drop table ACPLGPDESC cascade constraints;
drop table ACPLGPSUBS cascade constraints;
drop table ACPOLDESC cascade constraints;
drop table ACPOLGPPOL cascade constraints;
drop table ACPOLGRP cascade constraints;
drop table ACPOLICY cascade constraints;
drop table ACPOLSUBGP cascade constraints;
drop table ACRELATION cascade constraints;
drop table ACRELDESC cascade constraints;
drop table ACRELGRP cascade constraints;
drop table ACRESACT cascade constraints;
drop table ACRESATREL cascade constraints;
drop table ACRESCGRY cascade constraints;
drop table ACRESGPDES cascade constraints;
drop table ACRESGPRES cascade constraints;
drop table ACRESGRP cascade constraints;
drop table ACRESMEMRL cascade constraints;
drop table ACRESPRIM cascade constraints;
drop table ACRESREL cascade constraints;
drop table ACRLGPDESC cascade constraints;
drop table ACRSCGDES cascade constraints;
drop table ADDRBOOK cascade constraints;
drop table ADDRESS cascade constraints;
drop table ALCHARGE cascade constraints;
drop table APPLY_INIT cascade constraints;
drop table APPLY_MEMBER cascade constraints;
drop table APPLY_RESULT cascade constraints;
drop table APRVSTATUS cascade constraints;
drop table ATCHAST cascade constraints;
drop table ATCHASTLG cascade constraints;
drop table ATCHOBJTYP cascade constraints;
drop table ATCHREL cascade constraints;
drop table ATCHRELDSC cascade constraints;
drop table ATCHRLUS cascade constraints;
drop table ATCHRLUSDS cascade constraints;
drop table ATCHTGT cascade constraints;
drop table ATCHTGTDSC cascade constraints;
drop table ATTACHMENT cascade constraints;
drop table ATTACHUSG cascade constraints;
drop table ATTR cascade constraints;
drop table ATTRDESC cascade constraints;
drop table ATTRDICT cascade constraints;
drop table ATTRDICTGRP cascade constraints;
drop table ATTRDICTGRPATTRREL cascade constraints;
drop table ATTRDICTGRPDESC cascade constraints;
drop table ATTRDICTGRPREL cascade constraints;
drop table ATTRIBUTE cascade constraints;
drop table ATTRTYPE cascade constraints;
drop table ATTRVAL cascade constraints;
drop table ATTRVALDESC cascade constraints;
drop table ATTRVALUE cascade constraints;
drop table AUCPAYINFO cascade constraints;
drop table AUCTDESC cascade constraints;
drop table AUCTION cascade constraints;
drop table AUCTIONLOG cascade constraints;
drop table AUCTSTRREL cascade constraints;
drop table AUCTSTYLE cascade constraints;
drop table AUTOBID cascade constraints;
drop table AUTOBIDLOG cascade constraints;
drop table BASEITEM cascade constraints;
drop table BASEITMDSC cascade constraints;
drop table BID cascade constraints;
drop table BIDLOG cascade constraints;
drop table BIDORDRREL cascade constraints;
drop table BIDPAYMENT cascade constraints;
drop table BILLITEMS cascade constraints;
drop table BKORDALLOC cascade constraints;
drop table BKORDITEM cascade constraints;
drop table BLKRSNCODE cascade constraints;
drop table BLKRSNDESC cascade constraints;
drop table BROADCAST cascade constraints;
drop table BUACCTDET cascade constraints;
drop table BUADDR cascade constraints;
drop table BUCONT cascade constraints;
drop table BUSAUDIT cascade constraints;
drop table BUSCHN cascade constraints;
drop table BUSCHNDESC cascade constraints;
drop table BUSEVENT cascade constraints;
drop table BUSPROF cascade constraints;
drop table BUYERPO cascade constraints;
drop table BUYERPOTYP cascade constraints;
drop table BUYORG cascade constraints;
drop table BUYSUPMAP cascade constraints;
drop table BUYSUPSEC cascade constraints;
drop table BZRPENT cascade constraints;
drop table BZRPENTAT cascade constraints;
drop table BZRPENTSTG cascade constraints;
drop table BZSRVCFG cascade constraints;
drop table BZSVCCFG cascade constraints;
drop table BZSVCSTA cascade constraints;
drop table CACHEIVL cascade constraints;
drop table CALADJUST cascade constraints;
drop table CALCODE cascade constraints;
drop table CALCODEDSC cascade constraints;
drop table CALCODEMGP cascade constraints;
drop table CALCODTXEX cascade constraints;
drop table CALMETHOD cascade constraints;
drop table CALRANGE cascade constraints;
drop table CALRLOOKUP cascade constraints;
drop table CALRULE cascade constraints;
drop table CALRULEMGP cascade constraints;
drop table CALSCALE cascade constraints;
drop table CALSCALEDS cascade constraints;
drop table CALUSAGE cascade constraints;
drop table CAMPAIGN cascade constraints;
drop table CATALOG cascade constraints;
drop table CATALOGDSC cascade constraints;
drop table CATCLSFCOD cascade constraints;
drop table CATCNTR cascade constraints;
drop table CATCONFINF cascade constraints;
drop table CATENCALCD cascade constraints;
drop table CATENTATTR cascade constraints;
drop table CATENTDESC cascade constraints;
drop table CATENTREL cascade constraints;
drop table CATENTRY cascade constraints;
drop table CATENTRYATTR cascade constraints;
drop table CATENTSHIP cascade constraints;
drop table CATENTTYPE cascade constraints;
drop table CATGPCALCD cascade constraints;
drop table CATGPENREL cascade constraints;
drop table CATGROUP cascade constraints;
drop table CATGRPATTR cascade constraints;
drop table CATGRPDESC cascade constraints;
drop table CATGRPPS cascade constraints;
drop table CATGRPREL cascade constraints;
drop table CATGRPTPC cascade constraints;
drop table CATRELTYPE cascade constraints;
drop table CATTOGRP cascade constraints;
drop table CCCHECK cascade constraints;
drop table CCOMMENT cascade constraints;
drop table CERT_X509 cascade constraints;
drop table CHARGETYPE cascade constraints;
drop table CHKARRANG cascade constraints;
drop table CHKCMD cascade constraints;
drop table CHRGTYPDSC cascade constraints;
drop table CIITEMLIST cascade constraints;
drop table CLASIFCODE cascade constraints;
drop table CLCDPROMO cascade constraints;
drop table CLEANCONF cascade constraints;
drop table CLSFCODEDS cascade constraints;
drop table CMBITEMS cascade constraints;
drop table CMDREG cascade constraints;
drop table CMFILE cascade constraints;
drop table CMFILEDIR cascade constraints;
drop table CMFTASK cascade constraints;
drop table CMFTASKDSC cascade constraints;
drop table CMFTASKGRP cascade constraints;
drop table CMFTGCMT cascade constraints;
drop table CMFTGDSC cascade constraints;
drop table CMFTGTSKREL cascade constraints;
drop table CMFTSKMBREL cascade constraints;
drop table CMFWKSPC cascade constraints;
drop table CMFWKSPCDSC cascade constraints;
drop table CMFWSTGREL cascade constraints;
drop table CMLARGEFILE cascade constraints;
drop table HMBITEMS cascade constraints;
drop table ICCNCPTLNK cascade constraints;
drop table ICCONSTRNT cascade constraints;
drop table ICCONSTVAL cascade constraints;
drop table ICDATAREG cascade constraints;
drop table ICDEWIDREG cascade constraints;
drop table ICEXPLDESC cascade constraints;
drop table ICEXPLFEAT cascade constraints;
drop table ICFEATPROP cascade constraints;
drop table ICKNOWDESC cascade constraints;
drop table ICKNOWLEDG cascade constraints;
drop table ICMERDESC cascade constraints;
drop table ICMERTREE cascade constraints;
drop table ICMETAFEAT cascade constraints;
drop table ICMETAPHOR cascade constraints;
drop table ICMETAPROP cascade constraints;
drop table ICMETAREG cascade constraints;
drop table ICMREGDESC cascade constraints;
drop table ICROOTCAT cascade constraints;
drop table ICTPRICES cascade constraints;
drop table IITEM cascade constraints;
drop table IITEMLIST cascade constraints;
drop table INIRULEVAL cascade constraints;
drop table INITIATIVE cascade constraints;
drop table INTVSCHED cascade constraints;
drop table INVADJCODE cascade constraints;
drop table INVADJDESC cascade constraints;
drop table INVADJUST cascade constraints;
drop table INVAVL cascade constraints;
drop table INVCNF cascade constraints;
drop table INVCNFREL cascade constraints;
drop table INVENTORY cascade constraints;
drop table INVOICE cascade constraints;
drop table INVRESERVE cascade constraints;
drop table INVRSRVDSC cascade constraints;
drop table INVRSRVTYP cascade constraints;
drop table ISEDITATT cascade constraints;
drop table ITEMFFMCTR cascade constraints;
drop table ITEMSPC cascade constraints;
drop table ITEMTYPE cascade constraints;
drop table ITEMVERSN cascade constraints;
drop table JURST cascade constraints;
drop table JURSTGPREL cascade constraints;
drop table JURSTGROUP cascade constraints;
drop table KEYS cascade constraints;
drop table LANGPAIR cascade constraints;
drop table LANGUAGE cascade constraints;
drop table LANGUAGEDS cascade constraints;
drop table LISTPRICE cascade constraints;
drop table LMEVENTMAP cascade constraints;
drop table LMSERVER cascade constraints;
drop table LPOPURAMT cascade constraints;
drop table MANIFEST cascade constraints;
drop table MASSOC cascade constraints;
drop table MASSOCCECE cascade constraints;
drop table MASSOCGPGP cascade constraints;
drop table MASSOCTYPE cascade constraints;
drop table MBINFO cascade constraints;
drop table MBRATTR cascade constraints;
drop table MBRATTRVAL cascade constraints;
drop table MBRGRP cascade constraints;
drop table MBRGRPCOND cascade constraints;
drop table MBRGRPDESC cascade constraints;
drop table MBRGRPMBR cascade constraints;
drop table MBRGRPTYPE cascade constraints;
drop table MBRGRPUSG cascade constraints;
drop table MBRREL cascade constraints;
drop table MBRROLE cascade constraints;
drop table MBRVIEWPRF cascade constraints;
drop table MEMBER cascade constraints;
drop table MEMBRAUCT cascade constraints;
drop table MERCHANT cascade constraints;
drop table MERCHCONF cascade constraints;
drop table MERCHCONFINFO cascade constraints;
drop table MERPROFILE cascade constraints;
drop table MESSAGE cascade constraints;
drop table MGPCONDELE cascade constraints;
drop table MGPCONDELENVP cascade constraints;
drop table MGPTRDPSCN cascade constraints;
drop table MLTIME cascade constraints;
drop table MOPICONFIG cascade constraints;
drop table MSGARCHIVE cascade constraints;
drop table MSGMEMREL cascade constraints;
drop table MSGSTORE cascade constraints;
drop table MSGTYPES cascade constraints;
drop table NOTIFY cascade constraints;
drop table NSLOG cascade constraints;
drop table NUMBRUSG cascade constraints;
drop table NUMBRUSGDS cascade constraints;
drop table OFFER cascade constraints;
drop table OFFERDESC cascade constraints;
drop table OFFERPRICE cascade constraints;
drop table OIBTB cascade constraints;
drop table OICOMPLIST cascade constraints;
drop table OICOMPREL cascade constraints;
drop table ONLOG cascade constraints;
drop table ONQUEUE cascade constraints;
drop table ONSLOG cascade constraints;
drop table OPERATOR cascade constraints;
drop table OPERATRDSC cascade constraints;
drop table OPSYSTEM cascade constraints;
drop table ORCOMMENT cascade constraints;
drop table ORCPMAP cascade constraints;
drop table ORDADJDSC cascade constraints;
drop table ORDADJTXEX cascade constraints;
drop table ORDADJUST cascade constraints;
drop table ORDBTB cascade constraints;
drop table ORDCALCD cascade constraints;
drop table ORDCHGRSN cascade constraints;
drop table ORDCHGRSNDS cascade constraints;
drop table ORDCHNLTYP cascade constraints;
drop table ORDERBLK cascade constraints;
drop table ORDERHIST cascade constraints;
drop table ORDERITEMGIFT cascade constraints;
drop table ORDERITEMS cascade constraints;
drop table ORDERMGP cascade constraints;
drop table ORDERMSG cascade constraints;
drop table ORDERS cascade constraints;
drop table ORDERTMPL cascade constraints;
drop table ORDIADJUST cascade constraints;
drop table ORDICALCD cascade constraints;
drop table ORDIMEEXTN cascade constraints;
drop table ORDIOFFER cascade constraints;
drop table ORDIPROF cascade constraints;
drop table ORDISTAT cascade constraints;
drop table ORDITAX cascade constraints;
drop table ORDITEMCONF cascade constraints;
drop table ORDITPROMOCD cascade constraints;
drop table ORDITRD cascade constraints;
drop table ORDMEEXTN cascade constraints;
drop table ORDOPTIONS cascade constraints;
drop table ORDPAYINFO cascade constraints;
drop table ORDPAYMTHD cascade constraints;
drop table ORDPICKHST cascade constraints;
drop table ORDPROMOCD cascade constraints;
drop table ORDQUOTREL cascade constraints;
drop table ORDRELEASE cascade constraints;
drop table ORDRLSTTLS cascade constraints;
drop table ORDSHIPHST cascade constraints;
drop table ORDSTAT cascade constraints;
drop table ORDTAX cascade constraints;
drop table ORDUSERS cascade constraints;
drop table ORGCODE cascade constraints;
drop table ORGENTITY cascade constraints;
drop table OUTPUTQ cascade constraints;
drop table OUTPUTQDSC cascade constraints;
drop table PAREQINFO cascade constraints;
drop table PARTICIPNT cascade constraints;
drop table PARTROLE cascade constraints;
drop table PARTROLEDS cascade constraints;
drop table PASTATS cascade constraints;
drop table PATTRDESC cascade constraints;
drop table PATTRIBUTE cascade constraints;
drop table PATTRPROD cascade constraints;
drop table PATTRVALUE cascade constraints;
drop table PAYMTHD cascade constraints;
drop table PAYMTHDDSC cascade constraints;
drop table PAYMTHDSUP cascade constraints;
drop table PAYSTATUS cascade constraints;
drop table PAYSUMMARY cascade constraints;
drop table PAYSYNCH cascade constraints;
drop table PCSTATS cascade constraints;
drop table PESTATS cascade constraints;
drop table PICKBATCH cascade constraints;
drop table PKGATTR cascade constraints;
drop table PKGATTRVAL cascade constraints;
drop table PKGITEMREL cascade constraints;
drop table PLCYACCDSC cascade constraints;
drop table PLCYACCLCK cascade constraints;
drop table PLCYACCT cascade constraints;
drop table PLCYLCKDSC cascade constraints;
drop table PLCYPASSWD cascade constraints;
drop table PLCYPWDDSC cascade constraints;
drop table PLCYTYCMIF cascade constraints;
drop table PLCYTYPDSC cascade constraints;
drop table POLICY cascade constraints;
drop table POLICYCMD cascade constraints;
drop table POLICYDESC cascade constraints;
drop table POLICYTC cascade constraints;
drop table POLICYTYPE cascade constraints;
drop table PPCBATCH cascade constraints;
drop table PPCCREDIT cascade constraints;
drop table PPCEXTDATA cascade constraints;
drop table PPCPAYINST cascade constraints;
drop table PPCPAYMENT cascade constraints;
drop table PPCPAYTRAN cascade constraints;
drop table PRCORSN cascade constraints;
drop table PRCORSNDSC cascade constraints;
drop table PROCBUYPRF cascade constraints;
drop table PROCMSGVW cascade constraints;
drop table PROCPROTCL cascade constraints;
drop table PROCSYS cascade constraints;
drop table PRODSETDSC cascade constraints;
drop table PRODUCTSET cascade constraints;
drop table PROFILE cascade constraints;
drop table PROFNVSTRG cascade constraints;
drop table PRSETCEREL cascade constraints;
drop table PSETADJMNT cascade constraints;
drop table PURCHASELT cascade constraints;
drop table PVCBINDING cascade constraints;
drop table PVCBUFFER cascade constraints;
drop table PVCDEVMDL cascade constraints;
drop table PVCDEVSPEC cascade constraints;
drop table PVCMDLSPEC cascade constraints;
drop table PVCSESSION cascade constraints;
drop table PX_COUPON cascade constraints;
drop table PX_DESCRIPTION cascade constraints;
drop table PX_DYNATTR cascade constraints;
drop table PX_ELEMENT cascade constraints;
drop table PX_ELEMENTNVP cascade constraints;
drop table PX_GROUP cascade constraints;
drop table PX_GRPPOLICY cascade constraints;
drop table PX_POLICY cascade constraints;
drop table PX_PROMOARG cascade constraints;
drop table PX_PROMOAUDIT cascade constraints;
drop table PX_PROMOAUTH cascade constraints;
drop table PX_PROMOCD cascade constraints;
drop table PX_PROMOPOLICY cascade constraints;
drop table PX_PROMOTION cascade constraints;
drop table PX_PROMPROM cascade constraints;
drop table PX_RWDOPTION cascade constraints;
drop table PX_TEMPLATE cascade constraints;
drop table PX_TPLTGRP cascade constraints;
drop table PX_USAGE cascade constraints;
drop table QTYCONVERT cascade constraints;
drop table QTYFMTDESC cascade constraints;
drop table QTYFORMAT cascade constraints;
drop table QTYUNIT cascade constraints;
drop table QTYUNITDSC cascade constraints;
drop table QTYUNITMAP cascade constraints;
drop table QUEUE cascade constraints;
drop table QUEUECSR cascade constraints;
drop table QUEUEDESC cascade constraints;
drop table RA cascade constraints;
drop table RABACKALLO cascade constraints;
drop table RADETAIL cascade constraints;
drop table RCPTAVAIL cascade constraints;
drop table RECEIPT cascade constraints;
drop table REFKEYS cascade constraints;
drop table REFUNDMTHD cascade constraints;
drop table REPCUSTREL cascade constraints;
drop table REPDLVRY cascade constraints;
drop table REPORT cascade constraints;
drop table RFQ cascade constraints;
drop table RFQCATEGRY cascade constraints;
drop table RFQPROD cascade constraints;
drop table RFQRSP cascade constraints;
drop table RFQRSPEVAL cascade constraints;
drop table RFQRSPPARL cascade constraints;
drop table RFQRSPPROD cascade constraints;
drop table RFQRSPTCRL cascade constraints;
drop table RFQTARGET cascade constraints;
drop table RLDISCOUNT cascade constraints;
drop table RMA cascade constraints;
drop table RMAAUTHLOG cascade constraints;
drop table RMACHARGE cascade constraints;
drop table RMAIADJCRD cascade constraints;
drop table RMAIDNYRSN cascade constraints;
drop table RMAITEM cascade constraints;
drop table RMAITEMCMP cascade constraints;
drop table RMAITEMSERIAL cascade constraints;
drop table RMATAX cascade constraints;
drop table ROLE cascade constraints;
drop table ROLEASNPRM cascade constraints;
drop table ROLEDESC cascade constraints;
drop table RTNDNYDESC cascade constraints;
drop table RTNDNYRSN cascade constraints;
drop table RTNDSPCODE cascade constraints;
drop table RTNDSPDESC cascade constraints;
drop table RTNRCPTDSP cascade constraints;
drop table RTNREASON cascade constraints;
drop table RTNRECEIPT cascade constraints;
drop table RTNRSNDESC cascade constraints;
drop table RULECLSREG cascade constraints;
drop table RULEVALUE cascade constraints;
drop table SASTATS cascade constraints;
drop table SCHACTIVE cascade constraints;
drop table SCHBRDCST cascade constraints;
drop table SCHCMD cascade constraints;
drop table SCHCONFIG cascade constraints;
drop table SCHERRORLOG cascade constraints;
drop table SCHORDERS cascade constraints;
drop table SCHSTATUS cascade constraints;
drop table SEGMENTATION cascade constraints;
drop table SEGMENTATION_REF cascade constraints;
drop table SETCURR cascade constraints;
drop table SETCURRDSC cascade constraints;
drop table SHBTB cascade constraints;
drop table SHDCACRM cascade constraints;
drop table SHIPINFO cascade constraints;
drop table SHIPMODE cascade constraints;
drop table SHPARJURGP cascade constraints;
drop table SHPARRANGE cascade constraints;
drop table SHPJCRULE cascade constraints;
drop table SHPMODCLCD cascade constraints;
drop table SHPMODEDSC cascade constraints;
drop table SITE cascade constraints;
drop table SMTPHOST cascade constraints;
drop table STADDRESS cascade constraints;
drop table STAGLOG cascade constraints;
drop table STATECODE cascade constraints;
drop table STATEPROV cascade constraints;
drop table STBRCODES cascade constraints;
drop table STBRWSER cascade constraints;
drop table STCGRYDESC cascade constraints;
drop table STCONF cascade constraints;
drop table STDCNTRY cascade constraints;
drop table STDOMAIN cascade constraints;
drop table STENCALUSG cascade constraints;
drop table STERROR cascade constraints;
drop table STFLNAME cascade constraints;
drop table STGMERTAB cascade constraints;
drop table STGMRSTTAB cascade constraints;
drop table STGSITETAB cascade constraints;
drop table STGUINDTAB cascade constraints;
drop table STLFFMREL cascade constraints;
drop table STLOC cascade constraints;
drop table STLOCATTR cascade constraints;
drop table STLOCDS cascade constraints;
drop table STMERCNF cascade constraints;
drop table STORBLKRSN cascade constraints;
drop table STORE cascade constraints;
drop table STORECAT cascade constraints;
drop table STORECENT cascade constraints;
drop table STORECGRP cascade constraints;
drop table STORECGRY cascade constraints;
drop table STORECNTR cascade constraints;
drop table STOREDEF cascade constraints;
drop table STOREENT cascade constraints;
drop table STOREENTDS cascade constraints;
drop table STOREGRP cascade constraints;
drop table STOREITEM cascade constraints;
drop table STORELANG cascade constraints;
drop table STOREMBRGP cascade constraints;
drop table STOREMERCH cascade constraints;
drop table STOREREL cascade constraints;
drop table STORETRANS cascade constraints;
drop table STORITMFFC cascade constraints;
drop table STORLANGDS cascade constraints;
drop table STQOTCFG cascade constraints;
drop table STRELTYP cascade constraints;
drop table STRELTYPDS cascade constraints;
drop table SUBKEYS cascade constraints;
drop table SUBORDADJ cascade constraints;
drop table SUBORDERS cascade constraints;
drop table SUBORDTAX cascade constraints;
drop table TAGCLASS cascade constraints;
drop table TAGDISPLAY cascade constraints;
drop table TAGDPLYREL cascade constraints;
drop table TAXCGRY cascade constraints;
drop table TAXCGRYDS cascade constraints;
drop table TAXJCRULE cascade constraints;
drop table TAXTYPE cascade constraints;
drop table TCATTR cascade constraints;
drop table TCDESC cascade constraints;
drop table TCPITMAP cascade constraints;
drop table TCSUBTYPDS cascade constraints;
drop table TCSUBTYPE cascade constraints;
drop table TCTYPE cascade constraints;
drop table TDPSCNCNTR cascade constraints;
drop table TERMCOND cascade constraints;
drop table TFALGOPOL cascade constraints;
drop table TFALGOREG cascade constraints;
drop table TFALGOTYPE cascade constraints;
drop table TFALGPOLDS cascade constraints;
drop table TFALGTYPDS cascade constraints;
drop table TFALREGDSC cascade constraints;
drop table TFDOMAIN cascade constraints;
drop table TFDOMDSC cascade constraints;
drop table TFEXTENG cascade constraints;
drop table TFSBDOMAIN cascade constraints;
drop table TFSBDOMDSC cascade constraints;
drop table TFTRADENG cascade constraints;
drop table TFTRENGDSC cascade constraints;
drop table TICKLER cascade constraints;
drop table TKLACTHIST cascade constraints;
drop table TKLRACTDSC cascade constraints;
drop table TKLRACTION cascade constraints;
drop table TKLRREASON cascade constraints;
drop table TKLRRSNDSC cascade constraints;
drop table TMPBOLIST cascade constraints;
drop table TMPCMPLIST cascade constraints;
drop table TMPFFCLIST cascade constraints;
drop table TMPPROCID cascade constraints;
drop table TMPRADTL cascade constraints;
drop table TMPRCTLIST cascade constraints;
drop table TORCPMAP cascade constraints;
drop table TRADEPOSCN cascade constraints;
drop table TRADING cascade constraints;
drop table TRANSPORT cascade constraints;
drop table TRDATTACH cascade constraints;
drop table TRDDEPAMT cascade constraints;
drop table TRDDESC cascade constraints;
drop table TRDPSCNXML cascade constraints;
drop table TRDPURAMT cascade constraints;
drop table TRDREFAMT cascade constraints;
drop table TRDTYPE cascade constraints;
drop table TRDTYPEDSC cascade constraints;
drop table TXCDCLASS cascade constraints;
drop table TXCDSCHEME cascade constraints;
drop table USERDEMO cascade constraints;
drop table USERPROF cascade constraints;
drop table USERPVCDEV cascade constraints;
drop table USERPWDHST cascade constraints;
drop table USERREG cascade constraints;
drop table USERS cascade constraints;
drop table USRTRAFFIC cascade constraints;
drop table UTMERINFO cascade constraints;
drop table UTREGIP cascade constraints;
drop table VENDOR cascade constraints;
drop table VENDORDESC cascade constraints;
drop table VERSIONSPC cascade constraints;
drop table WCSDICTNRY cascade constraints;
drop table WCSDTNRYDS cascade constraints;
drop table WCSGBLDATA cascade constraints;
drop table WMMMAP cascade constraints;
drop table WTAXINFO cascade constraints;
at No comments:
Labels: , ,
Location: Bengaluru, Karnataka, India

WebSphere Commerce 7 | Dataload Utility | Enhancements in Feature Pack 8

As part of WebSphere Commerce Feature Pack 8, there are couple of enhancements to Dataload Utilities,

  • Configuring a Data Load utility scheduler job
Now, you can configure the Data Load utility as a WebSphere Commerce Scheduler. You can schedule Dataload utility as Scheduler and Administrators can configure this job with the WebSphere Commerce Administration Console.
Reference Link: http://goo.gl/3TmRpH
  • Data Load file difference preprocessing
By using this preprocessor that you can compare two input files, such as a previously loaded file and the newest version of this file. The preprocessor generates a difference file that contains only the records in the new file that are not within the old file or that are changed from the records in the old file. The Data Load utility can then load this difference file.

If your routinely loaded files contain many previous loaded records, then running this file difference can result in shorter load times. This preprocess can be scaled to compare files with millions of records.

By default, there are two data reader preprocessors that are provided for running a file difference; one for comparing CSV files (CSVFileDiffPreprocessor) and one for XML files (XmlFileDiffPreprocessor).
Reference Link: http://goo.gl/dB6Hng
  • Loading promotions with the Data Load utility
If you create promotions in lower environments and later, if you replicate the same in higher environments, you can use this feature. After creating promotions, do a data extract of the same and it generates the CSV with the required details. Later, do a dataload with this CSV in the higher environment.
Reference Link: http://goo.gl/RpzsnL
  • Loading promotion folders and promotions into promotion folders
Create promotion folders, and sort promotions into the promotion folders
Reference Link: http://goo.gl/6oCPvN
  • Loading customer segment members by email address with the Data Load utility
A customer segment is group of customers who share one or more attributes that are relevant to marketing activities. 

For example, you can define a customer segment that contains all registered customers, or all customers that spent over $1000 at the store, or all male customers over the age of 40. You can then use these customer segments as targets for advertising, promotions, and suggestive selling.

After you create a customer segment, you can specify that customer segment as a target when you create:
    Web and dialog activities
    Email activities
    Promotions
    Introduced in Search rules

You can create a customer segment that business users can manage in the Marketing tool by loading a list of email addresses.
Reference Link: http://goo.gl/PlVJq3
  • Update mode for Catentry Dataload
Earlier, Dataload utility used to support Insert, Replace and Delete Modes. Now, with this Feature Pack 8, it is supporting Update mode.

Use this update mode for loading changes to catalog entry information. This update mode compares catalog entry data in an input file with the corresponding catalog entry data in the database. The utility then replaces or adds data for only the columns that are specified in the input file. All other columns remain unchanged.
Reference Link: http://goo.gl/saSoaY
  • Category Deletion
With this new WebSphere Commerce Feature Pack 8, you can mark categories for delete instead of explicitly deleting the categories.
Reference Link: http://goo.gl/dvlhMo
  • Reuse attribute assigned values with the Data Load utility
You can use the Data Load utility to reuse assigned values for attributes when the same value is needed for multiple catalog entries. By reusing attribute assigned values across catalog entries, you can reduce the number of duplicate values that are created in the database.
Reference Link: http://goo.gl/Tl0UTO
  • Loading marketing objects with the Data Load utility
You can configure the Data Load utility to load marketing data to create customer segments, e-Marketing Spots, activities, marketing content, and any associated assets. By using the Data Load utility to load this data, you can quickly create multiple marketing objects and types of objects in a single operation.
Reference Link: http://goo.gl/ZA2DoQ

Dataload Utility Enhancements for WebSphere Commerce Feature Pack 8 Reference Link: http://goo.gl/R3byCc
at No comments:
Labels: , , , , ,
Location: Bengaluru, Karnataka, India

WebSphere Commerce 7 | Dataload Jobs | Dataload Summary in the Logs | Feature Pack 6 Vs Feature Pack 8



With Feature Pack 6:
===============================================================================
WebSphere Commerce Data Load
===============================================================================

Load started at: Thu Sep 05 09:05:59 EDT 2013
Initialization completed in 2.229 seconds.

Processing CatalogEntry...

----------------------------------------------------------------------------------
Load summary for load item: CatalogEntry.
----------------------------------------------------------------------------------
Business Object Configuration: wc-loader-catalog-entry.xml
Data loader mode: Replace.
Batch size: 1.
Commit count: 100.
Error Tolerance Level: 1.
Error Count: 0.
Amount of business objects processed: 13.
Amount of business objects committed: 13.
Data loader initialization time: 0 seconds.
Data loader execution began: Thu Sep 05 09:06:07 EDT 2013
Data loader execution ended: Thu Sep 05 09:06:13 EDT 2013
Data loader completed in 5.765 seconds.
Total flush time: 0 seconds.
Total commit time: 0.003 seconds.
CSV file location: C:\IBM\WCDE_ENT70\bin\..\samples\DataLoad\Catalog\CatalogEntries.csv.
Affected tables (13):
Table name: BASEITEM, Affected number of rows: 5.
Table name: BASEITMDSC, Affected number of rows: 5.
Table name: STOREITEM, Affected number of rows: 5.
Table name: ITEMVERSN, Affected number of rows: 5.
Table name: DISTARRANG, Affected number of rows: 5.
Table name: CATENTRY, Affected number of rows: 13.
Table name: STORECENT, Affected number of rows: 13.
Table name: CATENTDESC, Affected number of rows: 13.
Table name: CATGPENREL, Affected number of rows: 13.
Table name: LISTPRICE, Affected number of rows: 13.
Table name: ITEMSPC, Affected number of rows: 8.
Table name: VERSIONSPC, Affected number of rows: 8
Table name: CATENTREL, Affected number of rows: 8
----------------------------------------------------------------------------------

Program exiting with exit code: 0.
Load completed successfully with no errors.

Load ended at: Thu Sep 05 09:06:13 EDT 2013
Load completed in 13.901 seconds.

With Feature Pack 8:
===============================================================================
WebSphere Commerce Data Load
===============================================================================

Load started at: Thu Sep 05 09:05:59 EDT 2013
Initialization completed in 2.229 seconds.

Processing CatalogEntry...

----------------------------------------------------------------------------------
Load summary for load item: CatalogEntry.
----------------------------------------------------------------------------------
Business Object Configuration: wc-loader-catalog-entry.xml
Data loader mode: Replace.
Batch size: 1.
Commit count: 100.
Error Tolerance Level: 1.
Error Count: 0.
Amount of business objects processed: 13.
Amount of business objects committed: 13.
Data loader initialization time: 0 seconds.
Data loader execution began: Thu Sep 05 09:06:07 EDT 2013
Data loader execution ended: Thu Sep 05 09:06:13 EDT 2013
Data loader completed in 5.765 seconds.
Total flush time: 0 seconds.
Total commit time: 0.003 seconds.
Total ID resolver time: 1.138 seconds.
CSV file location: C:\IBM\WCDE_ENT70\bin\..\samples\DataLoad\Catalog\CatalogEntries.csv.
Affected tables (13):
Table                |     Total |    Insert |    Update |    Delete
---------------------|-----------|-----------|-----------|-----------
BASEITEM             |         5 |         0 |         5 |         0
BASEITMDSC           |         5 |         0 |         5 |         0
STOREITEM            |         5 |         0 |         5 |         0
ITEMVERSN            |         5 |         0 |         5 |         0
DISTARRANG           |         5 |         0 |         5 |         0
CATENTRY             |        13 |         0 |        13 |         0
STORECENT            |        13 |         0 |        13 |         0
CATENTDESC           |        13 |         0 |        13 |         0
CATGPENREL           |        13 |         0 |        13 |         0
LISTPRICE            |        13 |         0 |        13 |         0
ITEMSPC              |         8 |         0 |         8 |         0
VERSIONSPC           |         8 |         0 |         8 |         0
CATENTREL            |         8 |         0 |         8 |         0

----------------------------------------------------------------------------------

Program exiting with exit code: 0.
Load completed successfully with no errors.

Load ended at: Thu Sep 05 09:06:13 EDT 2013
Load completed in 13.901 seconds.
at No comments:
Labels: , , ,
Location: Bengaluru, Karnataka, India
Subscribe to: Posts (Atom)

My Writings........

HCL Commerce v9.1 | Local Store Vs Remote Store

  Local Store Remote Store Project Type Migrated (Lift & Shift) - Newly Imp...