SIT 192.168.118.168
内部测试sit： System Integration TestCase
PRE -elect 192.168.130.125
(用户测试uat： User Acceptance Test 略过)
PRD product 192.168.121.146
apps
58.240.18.246
http://edm.s*****.cn:9080/mailpicture/sale/trace?task=174&email=siemens800@msn.com&urlAddr=https://www.s*****.cn/webapp/wcs/stores/servlet/LogonForm?storeId=10052ILOVESEDMcatalogId=10051ILOVESEDMkrypto=1jDgONua6tU1KYQxJ4aMIfuMpJEvPM8OSc7uU6yfQ67tudV2H6oBZ%2B4nmhpvPGTgpmhZh2%2B0vOXERddfF%2BvdcOnu/n6mkoytzxXes49kMlsitbf6An2rh3EtiR/hqRqM95KzrboQNFcjM7jzbIjB7zXHOjCf278LILOVESEDMddkey=http:LogonForm
Message: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query
Caused by:Stack Trace:
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query at SaleController$_closure4.doCall(SaleController.groovy:87) at SaleController$_closure4.doCall(SaleController.groovy) ... 42 moreCaused by: org.hibernate.exception.DataException: could not execute query ... 44 moreCaused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null at java.lang.Throwable.Class: SaleController At Line: [87] Code Snippet:(Throwable.java:57) at java.sql.SQLException. (SQLException.java:113) at com.ibm.db2.jcc.c.SqlException. (SqlException.java:72) at com.ibm.db2.jcc.c.tf.e(tf.java:1680) at com.ibm.db2.jcc.c.tf.a(tf.java:1260) at com.ibm.db2.jcc.b.jb.o(jb.java:611) at com.ibm.db2.jcc.b.jb.j(jb.java:264) at com.ibm.db2.jcc.b.jb.c(jb.java:57) at com.ibm.db2.jcc.b.w.c(w.java:42) at com.ibm.db2.jcc.b.cc.g(cc.java:178) at com.ibm.db2.jcc.c.tf.p(tf.java:1256) at com.ibm.db2.jcc.c.uf.d(uf.java:2344) at com.ibm.db2.jcc.c.uf.d(uf.java:2458) at com.ibm.db2.jcc.c.uf.X(uf.java:508) at com.ibm.db2.jcc.c.uf.executeQuery(uf.java:491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) ... 44 more
wcs_exception
exception1
com.ibm.commerce.exception.ParameterNotFoundException
Middleware
http://www.skywayradio.com/tech/commerce/
http://www-01.ibm.com/support/docview.wss?uid=swg21178357&aid=5
http://publib.boulder.ibm.com/infocenter/wchelp/v5r6m1/index.jsp?topic=/com.ibm.commerce.api.doc/com/ibm/commerce/exception/ParameterNotFoundException.html
http://www-01.ibm.com/support/docview.wss?uid=swg21315983
VSS
; srcsafe.ini;; Three of these variables -- Data_Path, Users_Path, and Users_Txt -- must; be in srcsafe.ini. Any other variable here can be overridden in ss.ini.; Similarly, any ss.ini variable can be placed in srcsafe.ini to set a; system "default," which individual users can still override in ss.ini.; The two important paths used by SourceSafe.Data_Path = dataTemp_Path = temp; This tells admin where to put personal directories for new users.Users_Path = users; From this, find users.txt; from that, in turn, find ss.ini for a user.Users_Txt = users.txt; The following line contains common file groupings.File_Types = VB(*.vb;*.resx;*.xsd;*wsdl;*.vbproj;*.sln;*.cls;*.bas;*.vb?;*.fr?),VC(*.c;*.cpp;*.cxx;*.vcproj;*.sln;*.def;*.ds?;*.h;*.hpj;*.hpp;*.hxx;*.ico;*.inl;*.mak;*.rc;*.rc2;*.rgs;*.bmp;*.cur),WEB(*.aspx;*.ascx;*.asmx;*.master;*.asax;*.config;*.asa;*.asp;*.css;*.dbp;*.dtq;*.ht?;*.htm*;*.pkp;*.sql;*.stm;*.sct;*.htx;*.shtml;*.alx),VCSharp(*.cs;*.csproj;*.sln),VJSharp(*.jsl;*.java;*.vjproj;*.vjp;*.sln),XML(*.xml;*.xsl;*.xsd;*.xslt;*.xsx;*.xss),VFP(*.cdx;*.db?;*.dc?;*.fpt;*.fr?;*.idx;*.lb?;*.mn?;*.mpr;*.pj?PrjEntryTimeout = 15Multiple_Checkouts = NoCheckout_LocalVer_Disabled = YesUseHelperService = Yes Use_Network_Name = No[TimeZone]Name = (GMT+08:00) 北京，重庆，香港特别行政区，乌鲁木齐TZ_Bias = -480TZ_DaylightBias = -60TZ_DaylightDate = 0000/00/00 00:00:00.000TZ_StandardBias = 0TZ_StandardDate = 0000/00/00 00:00:00.000TZ_UseDaylightSavingTime = Yes
\\192.168.134.65\vss_b2c\
$/50.Development/Programming Guide/srcsafe.ini
xxx Programming Standards & Guideline.doc
24. <!-- [endif]-->开发环境系统管理员密码重置
更改IBM WebSphere Commerce贸易加速器后台登陆密码为 wcsadmin
http://localhost/webapp/wcs/admin/servlet/db.jsp
update userreg set status = 1, passwordexpired = 0, logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020', salt = 'hsdbacehyoyn' where users_id=-1000;
v
一般系统错误 13485223026 错误类型 错误消息键 消息 始发的命令 1 _ERR_GENERIC 用户 CMN3101E：由于“CMN0409E”，系统不可用。 系统 在处理期间发生以下错误：com.ibm.commerce.exception.ParameterNotFoundException : 在处理期间发生以下错误：{0}。。 Correlation Identity: 89ae85a0-bc82-11de-aba9-84284adc17ac Additional Data: null 当前异常： 消息： _ERR_GENERIC 堆栈跟踪： com.ibm.commerce.exception.ParameterNotFoundException: 在处理期间发生以下错误：{0}。 at com.ibm.commerce.datatype.MapBasedTypedProperty.getString(MapBasedTypedProperty.java:194) at com.s*****.commerce.security.commands.SNCheckVerificationCodeCmdImpl.performExecute(SNCheckVerificationCodeCmdImpl.java:53)、、、
异常跟踪结束。 解决: 数据库某些关联表的字段storeId被改变了，在url后添加即可$storId=0 https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0总结： 查找还有那些storeId http://localhost/webapp/wcs/admin/servlet/db.jsp select STORE_ID, DIRECTORY from store;| STORE_ID | DIRECTORY |
| 0 | NULL |
| 10001 | 'ExtendedSitesHub' |
| 10002 | 'ExtendedSitesCatalogAssetStore' |
| 10003 | 'ConsumerDirectStorefrontAssetStore' |
| 10004 | 'B2BDirectStorefrontAssetStore' |
| 10051 | 'Sample B2B Store' |
| 10052 | 'B2C Store' |
exception 2 :
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon 指定的登录标识或密码不正确。请验证提供的信息并重新登录。
exception 2 .1 :
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0
您当前没有使用WebSphere贸易加速器访问商店的权限。请与系统管理员联系以验证您的访问控制。
参考：
WebSphere Commerce中的需求链模型及其部署
( ), 北京交通大学研究生，IBM CDL WebSphere Commerce组实习生
( ), 软件工程师，IBM CSDL WebSphere Commerce组 ( ), 高级软件工程师，IBM CSDL WebSphere Commerce组http://www.ibm.com/developerworks/cn/websphere/library/techarticles/0607_linhua/index.html
原因:
新配的商品统计功能(stat)资源文件(D:\WCToolkitEE60\xml\tools\stat\resource.xml)在注册到总资源配置文件(D:\WCToolkitEE60\xml\config\wc-server.xml)时,老子wc-server.xml找不到儿子resource.xml里正确的内容,它认为非法,所以立刻关闭登陆口权限。
解决：
D:\WCToolkitEE60\xml\tools\stat\resource.xml
d
d
exception 3
http://www.s*****.cn/webapp/wcs/stores/servlet/CategoryDisplayView?langId=-7&storeId=10052&catalogId=10051&top_category=11682&top=Y&categoryId=11682
| 错误类型 | 错误消息键 | 消息 | 始发的命令 | ||||
|---|---|---|---|---|---|---|---|
| 1 | _ERR_COMMAND_EXCEPTION |
| /webapp/wcs/stores/servlet/CategoryDisplayView |
javax.ejb.ObjectNotFoundException: catalogGroupReferenceNumber=11682
http://japan.coach.com/online/handbags/CategoryDisplayView?storeId=13001&catalogId=13500&langId=-10&categoryId=null&t1Id=38765&t2Id=null&tier=2&identifier=wallets_seewhatsnew&rm=1
| Error Type | Error Message Key | Message | Originating Command | ||||
|---|---|---|---|---|---|---|---|
| 1 | _ERR_COMMAND_EXCEPTION |
| /online/handbags/CategoryDisplayView |
Caused by: java.lang.NumberFormatException: For input string: "null"
exception 4
一般系统错误
错误类型 错误消息键 消息 始发的命令 1 _ERR_TOOLS_GENERIC 用户 系统 处理期间发生以下错误："{0}"。 /webapp/wcs/tools/servlet/NewDynamicListView -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Correlation Identity: c38a06d0-bd5b-11de-8f5a-84284add8412 Additional Data: null当前异常： 消息： _ERR_UNKNOWN_NAMESPACE 堆栈跟踪： com.ibm.commerce.tools.util.ResourceNotFoundException: 因为找不到名称空间 "sales"，系统无法从该名称空间装入 "LogisticsDepotSite"。 at com.ibm.commerce.tools.util.ResourceDirectory.lookup(ResourceDirectory.java:491) at com.ibm.commerce.tools.util.ResourceDirectory.lookup(ResourceDirectory.java:465) at com.ibm.commerce.tools.common.ui.NewDynamicListBean.setParameters(NewDynamicListBean.java:943) at com.ibm._jsp._NewDynamicList._jspService(_NewDynamicList.java:125) at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:93) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1643) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:819) at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:216) at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:255) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:347) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at com.ibm.commerce.struts.ECActionServlet.processRequest(ECActionServlet.java:237) at com.ibm.commerce.struts.ECActionServlet.doGet(ECActionServlet.java:179) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1643) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136) at com.ibm.commerce.dynacache.filter.CacheFilter$2.run(CacheFilter.java:376) at com.ibm.commerce.dynacache.filter.CacheFilter.doFilter(CacheFilter.java:507) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121) at com.ibm.commerce.webcontroller.RuntimeServletFilter.doFilterAction(RuntimeServletFilter.java:269) at com.ibm.commerce.webcontroller.RuntimeServletFilter.access$000(RuntimeServletFilter.java:65) at com.ibm.commerce.webcontroller.RuntimeServletFilter$1.run(RuntimeServletFilter.java:191) at com.ibm.commerce.webcontroller.RuntimeServletFilter.doFilter(RuntimeServletFilter.java:212) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:819) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3189) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:253) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:229) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1970) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:116) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:434) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:373) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101) at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1704) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1475) 异常跟踪结束。 添加命名空间解决： D:\WCToolkitEE60\xml\config\wc-server.xml、、、
exception 5
--------------------------------------------------------------------------------
问题： myeclipse--Project>>>CommerceAccelerator--D:\WCToolkitEE60\workspace\CommerceAccelerator\WebContent\WEB-INF\struts-config.xml 异常： Unable to create part An error has occurred when creating this editor 解决: 1. struts-config.xml--右键--Open With--XML Source Page Editor--首行空白处添加空格--保存 2. struts-config.xml--右键--Open With--Struts Configuration File Editor--OK --------------------------------------------------------------------------------end