[步骤]
prometheus告警
开始时间: 10:40:08
错误代码: N10400820
sql类型: SELECT
sql: [10:40:08] -------------------------------------------------------------
CODE:N10400820
Error:16_8152_10_-2146232060
SQL:SELECT COUNT(1) FROM ( select [ID],[UsBrowseNodeID],[UsBrowsePathNodeID],[UsBrowsePathByNameCn],[AddTime],[UpdateTime],[MappingState],[GBMappingNum],[JPMappingNum],[AUMappingNum],[CAMappingNum],[DEMappingNum],[ESMappingNum],[FRMappingNum],[ITMappingNum],[MXMappingNum],[INMappingNum],[AEMappingNum],[NLMappingNum],[SGMappingNum],[BRMappingNum],[SAMappingNum],[SEMappingNum],[TRMappingNum],[PLMappingNum],[IsTranslate],[IsAgainMapping],[BEMappingNum] from [E_Amazon_BrowseTreeUs_V2] (nolock) where 1=1 and UsBrowsePathByNameCn like '%'+@UsBrowsePathByNameCn+'%' ) AS PagerTable
PARAMS:@UsBrowsePathNodeID = ,@UsBrowsePathByNameCn = Books(36)(书)>>Literature & Fiction(25)(文学与小说)>>Historical Fiction(17)(历史小说)>>Other(0)(其他) Books(36)(书)>>Literature & Fiction(25)(文学与小说)>>History & Criticism(9)(历史与批评)>>Regional & Cultural(12)(区域与文化)>>Asian(4)(亚洲的)>>Other(0)(其他) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Sweet Potatoes(0)(红薯) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Truffles(0)(松露) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Water Chestnuts(0)(荸荠) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Other(0)(其他) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Crushed(0)(碎) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Diced(0)(切丁) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Peeled(0)(去皮) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Stewed(0)(炖) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Sun-Dried(0)(晒干) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Sun-Dried Tomato Paste(0)(晒干番茄酱) Books(36)(书)>>Engineering & Transportation(3)(工程与运输)>>Engineering(18)(工程)>>Telecommunications & Sensors(12)(电信和传感器)>>Satellite(0)(卫星) Books(36)(书)>>Engineering & Transportation(3)(工程与运输)>>Engineering(18)(工程)>>Telecommunications & Sensors(12)(电信和传感器)>>Signal Processing(0)(信号处理) Home & Kitchen(14)(家居厨房)>>Home Décor(28)(家庭中心)>>Home Décor Accents(26)(家庭口音)>>Decorative Accessories(21)(装饰配件)>>Decorative Bookends(0)(装饰板) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Childrens Literature(0)(儿童文学) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Erotica(0)(黄色书刊) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Fiction(0)(小说) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Journalism & Nonfiction(0)(新闻与非虚构) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Mystery(0)(神秘) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Play & Scriptwriting(0)(游戏和剧本) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Poetry(0)(诗歌) Books(36)(书)>>Other (Reference)(0)(其他（参考）)>>Writing, Research & Publishing Guides(3)(写作，研究和出版指南)>>Writing(14)(写作)>>Romance(0)(浪漫) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>I Ching(0)(我清) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>Numerology(0)(命理) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>Palmistry(0)(手相) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>Prophecy(0)(预言) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>Runes(0)(符文) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>New Age & Spirituality(24)(新时代与灵性)>>Divination(10)(卜筮)>>Tarot(0)(塔罗牌) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Religious Intolerance & Persecution(0)(宗教不容忍与迫害) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Science & Religion(0)(科学与宗教) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Sociology(0)(社会学) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Angelology & Demonology(0)(天使学与恶魔学) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Anthropology(0)(人类学) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Apologetics(0)(护教学) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Christology(0)(基督) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Creationism(0)(神创论) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Ecclesiology(0)(教会论) Books(36)(书)>>Religion & Spirituality(17)(宗教与灵性)>>Religious Studies(17)(宗教研究)>>Theology(5)(神学)>>Christian(19)(基督教)>>Ecumenism(0)(普世主义) Books(36)(书)>>Literature & Fiction(25)(文学与小说)>>History & Criticism(9)(历史与批评)>>Regional & Cultural(12)(区域与文化)>>European(8)(欧洲的)>>Other(0)(其他) Books(36)(书)>>Literature & Fiction(25)(文学与小说)>>Humor & Satire(3)(幽默与讽刺)>>Other(0)(其他) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Tomato Paste(0)(番茄酱) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Tomato Sauce(0)(番茄酱) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Canned, Jarred & Packaged Foods(0)(罐装，罐装和包装食品)>>Vegetables(0)(蔬菜)>>Tomatoes(0)(番茄)>>Other(0)(其他) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Condiments & Salad Dressings(0)(调味品和沙拉酱)>>Bruschetta(0)(布鲁斯凯塔) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Condiments & Salad Dressings(0)(调味品和沙拉酱)>>Cocktail Sauce(0)(鸡尾酒酱) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Condiments & Salad Dressings(0)(调味品和沙拉酱)>>Condiment & Salad Dressing Gifts(0)(调味品和沙拉酱礼品) Grocery & Gourmet Food(42)(食品杂货店)>>Pantry Staples(0)(餐具主食)>>Condiments & Salad Dressings(0)(调味品和沙拉酱)>>Horseradish(0)(辣根) ,
MESSAGE:String or binary data would be truncated.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
在 System.Data.SqlClient.SqlDataReader.Read()
在 System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
在 System.Data.SqlClient.SqlCommand.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
在 RB.DALExtend.E_Amazon_BrowseTreeUs_V2Extend.GetPagerModelList(E_Amazon_BrowseTreeUs_PSParameters parameters, Int32& recordCount)
在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonBrowseTreeMappingV2.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_amazon_amazonbrowsetreemappingv2_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
[结果]
[期望]