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 more Caused by: org.hibernate.exception.DataException: could not execute query ... 44 more Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null at java.lang.Throwable.<init>(Throwable.java:57) at java.sql.SQLException.<init>(SQLException.java:113) at com.ibm.db2.jcc.c.SqlException.<init>(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
Class: SaleController
At Line: [87]
Code Snippet:
wcs_exception
exception1
com.ibm.commerce.exception.ParameterNotFoundException
Middleware WebSphere Commerce v6
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 = data Temp_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 = 15 Multiple_Checkouts = No Checkout_LocalVer_Disabled = Yes UseHelperService = Yes Use_Network_Name = No [TimeZone] Name = (GMT+08:00) 北京,重庆,香港特别行政区,乌鲁木齐 TZ_Bias = -480 TZ_DaylightBias = -60 TZ_DaylightDate = 0000/00/00 00:00:00.000 TZ_StandardBias = 0 TZ_StandardDate = 0000/00/00 00:00:00.000 TZ_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 stack: 未整理
解决: url参数没有加&storeId=0
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0
exception 2 .1 :
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0
您当前没有使用WebSphere贸易加速器访问商店的权限。请与系统管理员联系以验证您的访问控制。
参考:
WebSphere Commerce中的需求链模型及其部署
林 华 (hualin@cn.ibm.com ), 北京交通大学研究生,IBM CDL WebSphere Commerce组实习生
冯 庆华 (fengqh@cn.ibm.com ), 软件工程师,IBM CSDL WebSphere Commerce组
邓 佰臣 (dengbc@cn.ibm.com ), 高级软件工程师,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
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE resourceConfig SYSTEM "../common/Resources.dtd"> <!-- *=================================================================== * Licensed Materials - Property of IBM * * WebSphere Commerce * * (c) Copyright International Business Machines Corporation. 2003 * All rights reserved. * * US Government Users Restricted Rights - Use, duplication or * disclosure restricted by GSA ADP Schedule Contract with IBM Corp. *=================================================================== --> <!-- This is the configuration file for the inventory objects that are available in the runtime model --> <resourceConfig> <resource nameSpace="ProductStatSpace"> <!-- resource bundle file mappings --> <!-- bundle出错,拷贝文件,少改了findprice为statistics功能资源配置 --> <resourceBundle name="ProductStatNLS" bundle="com.ibm.commerce.tools.statistics.properties.ProductStatNLS" /> <!-- XML file mappings --> <resourceXML name="BrandStat" file="stat/BrandStat.xml" /> <resourceXML name="CategoryStat" file="stat/CategoryStat.xml" /> </resource> </resourceConfig>
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
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
<ToolsGeneralConfig DTDPath="tools/common;tools/devtools;tools/bi;tools/catalog;schema/xml;sar" XMLCacheSize="0" XMLPath="tools;tools/devtools;WEB-INF/xml/tools;WEB-INF" developmentMode="false" display="false" resourceBundlePath=""> <!-- add by tangxj start --> <resourceConfig file="sales/resources.xml"/> <!-- add by tangxj end --> 、、、 </ToolsGeneralConfig>
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
相关推荐
【描述】:尽管描述中没有提供具体信息,但根据“backend dev”这一关键词,我们可以推断本文将聚焦于IBM WebSphere Commerce平台的后端开发实践和技巧。IBM WebSphere Commerce是业界领先的电子商务解决方案,它为...
IBM WebSphere Commerce是全球领先的电子商务解决方案之一,专为构建、扩展和管理复杂的在线商务环境而设计。这个平台提供了全面的功能,帮助企业实现B2C、B2B以及多渠道的商业运营。下面,我们将深入探讨基于IBM ...
IBM WebSphere Commerce是一款强大的电子商务平台,它为企业提供了一整套解决方案,用于构建、管理和扩展线上购物体验。在安装和配置WebSphere Commerce时,我们需要遵循一系列步骤,确保系统能够正确无误地运行。...
WebSphere MQ,原名MQSeries,是IBM推出的一款企业级的消息中间件产品,它在IT领域扮演着重要的角色,尤其在分布式系统、企业应用程序集成(EAI)以及业务流程自动化中发挥着关键作用。WebSphere MQ V6.0是这个系列...
【IBM WebSphere Portal V6 方案建议书】 1. 概述 WebSphere Portal V6 是IBM 提供的一款企业级的门户解决方案,旨在通过聚合多种应用程序和服务,提高业务效率和用户体验。需求背景通常涉及到企业对统一入口、...
IBM WebSphere Commerce是全球领先的电子商务平台之一,专为企业级在线交易提供强大支持。这款解决方案集成了先进的技术、灵活的架构和丰富的功能,旨在帮助企业构建、管理和优化其数字化商业体验。 在"IBM ...
**IBM WebSphere MQ详解** IBM WebSphere MQ,通常简称为IBM MQ,是IBM提供的一款企业级消息中间件产品。它允许应用程序在不同的网络环境、操作系统和应用架构之间可靠地交换数据,无需关心底层网络的复杂性。...
【IBM WebSphere Portal Express 7.0 安装详解】 IBM WebSphere Portal Express 是一款功能强大的企业级门户服务器,提供了一种集中的平台,用于构建、管理和部署具有个性化、协作和移动功能的Web应用程序。本指南...
MB在aix上的安装文档 BM WebSphere MB_Install_AIX
IBM WebSphere MQ 技术白皮书 IBM WebSphere MQ 是一款功能强大且广泛应用的消息中间件产品,旨在解决 IT 相关的业务问题,并提供可靠的消息提供机制。下面是对 IBM WebSphere MQ 技术白皮书的详细解读和知识点总结...
IBM WebSphere MQ for Linux V6.0 是一款高级消息传递中间件,用于在分布式系统环境中实现可靠的消息传递服务。该版本针对Linux环境进行了优化,旨在提供高性能、高可用性和安全性。 #### 二、版权与版本信息 - **...
【IBM WebSphere Commerce Suite】是IBM提供的一款强大的电子商务平台,专为构建和管理复杂的B2B和B2C在线交易而设计。在这个案例中,它被US&FCS(美国与对外商业服务机构)用于提升其出口贸易服务的能力,旨在帮助...
mqadv_dev75_windows.zip.001 共2个文件,这是第一个 IBM_websphere_MQ v 7.5
mqadv_dev75_windows.zip.001 共2个文件,这是第二个 IBM_websphere_MQ v 7.5
在本文档中,我们将详细介绍如何使用 IBM WebSphere Commerce 平台以及如何对其进行定制化处理,以满足特定业务需求。WebSphere Commerce 是一款功能强大的电子商务解决方案,它为构建、部署和管理复杂的多渠道零售...
IBM_MQ_9.1_LINUX_X86-64_TRIAL.tar.gz 安装包下载,基于此资源可以安装IBM试用版MQ服务,如果想尝试安装此服务可以参考CSDN博文:https://blog.csdn.net/QinNuoer/article/details/104006910 尝试在docker下用...
在OpenSUSE Linux环境下安装IBM Websphere和IBM DB2是一项关键的任务,这对于构建和运行基于Java的企业级应用尤其重要。下面将详细讲解这两个组件的安装过程和DB2数据迁移的操作。 首先,让我们关注IBM Websphere的...
WebSphere Portal 是 IBM 提供的一款企业级门户平台,它允许组织构建、管理和部署集成了多种应用和服务的统一入口。在本安装指南中,我们将详细讨论如何安装 WebSphere Portal V6.0,包括所需介质包、安装步骤以及...