prometheus告警

            开始时间: 16:09:21 

            错误代码: N1609211  

            sql类型: SELECT   

            sql: [16:09:21]  -------------------------------------------------------------

CODE:N1609211

Error:15_102_1_-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],[EditUserId],[EditUserName],[EditDesc],[EditStatus] from [E_Amazon_BrowseTreeUs_V2] (nolock) where 1=1 and UsBrowsePathByNameCn like '%'+@UsBrowsePathByNameCn+'%' and EditUserId in (100003,94,8953,100059,224,100112,2577,100585,1941,100065,8042,563,1062,1222,2304,3418,3708,3723,6250,7522,100161,7571,9024,9084,2356,3469,3788,3943,5574,6031,6361,7459,100193,393,7735,9097,9120,9271,994,1027,1282,1472,2139,3801,4193,7521,100405,7567,7645,7840,7987,8461,8513,8679,8737,8801,8802,8842,9057,9081,9109,9159,9160,9668,3542,3616,3771,3967,5786,6323,7479,100586,271,100066,7861,7949,7952,8040,8103,8185,8229,8257,9031,9043,9045,9041,1479,2768,3731,5304,5925,6474,100189,202,8146,8233,8234,8260,9008,9042,9285,1037,1322,2582,3758,5210,5286,5471,5815,6002,6279,6300,100732,7725,7909,8462,8614,8803,8804,8813,8814,8859,8878,8903,8910,8926,8933,8977,9049,9050,9058,9059,9112,9113,9161,9255,9330,9331,9348,9366,9374,100061,139,304,7674,8197,543,1013,2045,4321,100062,1114,100118,7995,996,1025,1837,2296,2947,3452,4214,4432,4516,4517,4563,5754,5926,6033,6453,100498,4660,100441,8735,3286,3473,3964,4238,4657,4841,4898,4957,6756,100442,8318,8860,3355,3446,3503,3505,4239,4279,4324,4336,4793,100495,8469,9329,3308,4322,4356,4440,4621,4745,4827,4866,6318,100496,8147,8672,8678,8826,3338,3384,4794,4863,4867,6426,6670,6687,100589,7988,8752,8841,9524,6402,6403,7413,100590,3339,3474,3504,3901,4622,4700,100628,8870,8932,4039,100117,7569,7669,7681,7824,8051,9063,3197,4897,6712,100571,3236,7402,7433,7507,100688,100175,954,1021,1024,1073,2342,3532,4226,4681,100493,2148,4274,4762,4820,4831,5012,5179,100064,1770,100166,7948,1005,1575,4608,6240,6627,100168,9254,9316,2000,100169,2129,5427,100717,7983,7994,8642,9077,4646,7131,100744,8700,8781,8845,9309,9357,9362,3334,4639,6868,7098,100608,3428,100446,7739,7832,8013,1780,2596,2901,4562,4653,6206,100587,7759,7833,8710,8805,8840,4511,6522,6523,6685,100111,100517,7502,8929,100060,8206,8207,8208,8209,8287,8288,8289,8290,8291,8554,8555,8556,8557,882,2859,4367,4747,5205,100521,4047,4048,4049,1834,5741,7971,8482,8871,8934,9138,9188,9187,9232,9333,9358,9531,100518,4393,100104,5356,5357,5358,5359,371,1319,1316,1468,1830,2235,3207,3247,4365,4907,5670,5765,7029,7151,7176,7179,7189,7208,7209,7245,7295,7389,7525,7526,7573,7622,7640,7652,7711,7865,7894,7905,7958,8019,8190,8292,8309,8311,8353,8395,8431,8488,8489,8662,8636,8727,8726,8691,8739,8760,8779,8798,8833,8868,8894,8889,8948,8946,8947,8944,9000,9026,9028,9046,9075,9102,9099,9136,9137,9162,9186,9264,9222,9224,9249,9276,9278,9279,9280,9273,9287,9291,9310,9311,9332,9320,9326,9338,9359,9378,9407,9399,9432,9400,9402,9404,9477,9478,9484,9486,9489,9488,9494,9492,9493,9521,9534,9533,9532,9530,9542,9572,9583,9591,9590,9589,9614,9615,9613,9617,9634,9633,9620,9635,9625,9642,9665,9673,9674,7634,7942,8092,8093,8094,8203,8301,8302,8303,8304,8305,8360,8646,8660,8915,8936,8942,8943,8950,8951,8955,8956,8957,8958,8959,8960,8961,8962,8963,8964,8965,8966,8967,8968,8969,8970,8971,8972,8973,8974,9032,9047,9282,9283,9297,9302,9303,9312,9318,9319,9356,9379,9386,9387,9396,9397,9401,9421,9428,9429,9454,9460,9461,9462,9463,9464,9465,9466,9475,9476,9485,9491,9495,9497,9498,9499,9501,9512,9513,9514,9515,9517,9535,9550,9551,9554,9558,9559,9561,9562,9563,9573,9588,9592,9593,9619,9624,9626,9627,9628,9629,9630,9645,9646,9670,9671,100129,138,1790,1861,2442,2710,2844,3475,3753,4029,5199,5274,5678,6178,6924,100063,435,610,956,1107,1356,4206,4265,4361,4473,4579,4612,4714,4902,4960,903,100067,100588,7628,7710,6912,6913,6914,6915,6940,7044,7060,7835,7836,7837,8030,8031,8032,8033,8034,8035,8036,8037,8038,8039,8533,8534,8535,8536,8537,8538,8539,8540,8541,8542,7780,7781,7782,7783,7784,7785,7872,7873,7874,7875,7937,7938,7939,7940,7941,7973,7974,7975,7976,7977,8061,8062,8063,8064,8065,7786,7787,7788,7789,7790,7888,7889,7890,7891,7892,8244,8245,8246,8247,8248,8249,8250,8251,8252,8253,7791,7792,7793,8117,8118,8135,8136,8162,8163,8165,8166,8167,8168,8170,8171,8172,8173,8174,8175,8176,8177,8178,8180,8846,8847,8848,8849,8850,8851,8852,7795,7797,7796,7798,7820,7821,7822,7823,7838,7839,8043,8044,8066,8067,8068,8069,8077,8079,8081,8264,8481,8484,8485,8486,8122,8267,8330,8331,8487,9315,9323,9324,9325,9648,9649,6957,7418,7420,7422,7426,7361,7362,7363,7364,7382,7383,7384,7385,333,6528,7114,7194,7254,7259,7283,7368,7503,7519,7541,7548,7582,7601,7600,7768,7826,7842,7856,7926,7959,8057,8083,8084,8107,8218,8219,8298,8315,8316,8317,8325,8328,8338,8339,8340,8369,8414,8415,8416,8429,8430,8498,8531,8635,8669,8686,8721,8767,8768,8843,8865,8872,8900,8902,8920,8921,8938,8940,8941,8980,8985,8988,9014,9020,9021,9022,9071,9073,9095,9096,9103,9106,9116,9144,9152,9154,9155,9156,9165,9168,9169,9173,9174,9207,9211,9212,9213,9215,9216,9217,9218,9219,9220,9233,9234,9235,9236,9239,9243,9247,9268,9288,9290,9304,9321,9322,9339,9340,9341,9342,9343,9351,9352,9367,9368,9372,9380,9381,9382,9383,9408,9410,9411,9412,9414,9415,9416,9417,9418,9424,9425,9426,9455,9456,9479,9480,9482,9505,9506,9507,9508,9509,9510,9511,9519,9520,9523,9545,9547,9548,9549,9566,9567,9568,9569,9571,9594,9595,9596,9609,9610,9612,9621,9622,9636,9637,9638,9639,9640,9650,9651,9652,9653,9654,9655,9656,9657,9658,9659,9660,9661,9662,9663,9675,9676,9677,9678,9679,9680,9681,9682,9683,9684,9685,751,1049,3724,4093,9295,100522,100008,100125,541,100664,7606,2253,3150,3235,5948,6148,100665,592,5319,6373,1444,100524,6897,100663,8351,9449,998,4011,100666,8622,8770,8780,8795,9422,5125,5176,100525,4814,100611,8017,8757,5526,5876,7154,100667,8784,4018,5220,100526,4088,100668,9140,7153,100669,8058,4566,7274,100670,297,5416,5778,100671,5692,5762,5835,100672,9369,1439,100673,100610,659,100017,220,3778,1360,1361,1440,100108,8733,2248,100675,8774,1266,6452,100677,7614,8041,8619,8918,9037,9473,5057,100678,8618,1950,3027,6260,100109,1886,100679,8996,2605,2640,3495,7265,100110,2632,100680,7985,7197,7404,1197,100681,2130,5138,6866,100736,8890,2809,6517,100018,71,2,241,685,3221,100073,389,100070,327,100154,8124,1900,2573,3349,3659,3766,4036,4840,6315,7511,100155,7608,8356,8655,692,1986,3660,4138,6400,6730,6927,100156,350,100188,7635,7777,8239,9108,3015,3128,5583,5688,6367,7136,100234,7667,8240,8378,2160,2952,3183,3226,4490,5062,6855,100235,100081,546,100227,7699,9051,9195,9526,625,1524,2594,5642,5643,6947,100228,8987,9298,2842,5323,5852,7059,7144,100457,7568,8476,8761,9437,1812,6456,6832,100487,7731,8526,9440,9580,3541,3748,6196,7058,100552,8715,8853,9388,3650,6390,6821,100553,8002,6151,6299,100084,3445,100229,7810,8259,8553,9293,9585,2001,6939,100230,7918,7953,8023,8463,8711,9442,9581,1151,1827,2940,100458,8931,9447,2603,3117,5128,5910,6334,100486,7714,9139,9527,2113,4035,4597,7186,7442,100554,9284,9377,9468,2135,6329,7284,100555,7794,7886,9598,6068,6646,6831,100085,231,100225,8704,3285,3347,3471,4484,4776,4781,6067,6304,7416,100226,7689,9225,9672,2107,3329,5308,5807,5983,100428,8796,9469,3955,6738,7438,4034,100485,9177,9441,9578,4109,5030,5412,100550,8728,9539,9564,5638,7102,100551,9196,4890,4891,5633,6680,6717,100086,1811,100218,7885,3710,7536,7547,100219,7657,7744,9435,2441,3164,3507,4696,5215,100220,7694,7695,8492,8625,2914,5076,100454,3343,3584,3906,4666,6303,6882,6883,100544,8895,9193,2475,3903,4538,5727,6364,100545,7921,9083,1244,7508,100087,390,100221,8856,9062,9253,1967,3630,3845,4683,7510,100222,8854,9577,552,2994,3627,5625,6788,7108,7546,100455,7775,9199,3740,5893,7290,7509,100484,2878,3869,3908,5061,6458,7275,100546,8702,9176,9579,2651,5344,100547,9433,9556,3911,5568,5981,6005,7291,100088,267,100223,7745,5411,5862,6428,6589,6743,100224,9017,9308,655,2648,2916,2955,4537,6816,6824,100456,7762,8983,2528,3804,5629,6180,6606,100483,7771,7991,9446,9448,2782,6682,6716,6741,100548,2110,5293,5631,6745,7147,7164,100549,3770,6183,6288,6809,7105,100089,2175,100231,7879,7680,7749,8220,9101,9436,9537,2735,3260,100232,9198,9347,9445,3163,3171,3361,7381,100459,8714,9586,5570,5654,6860,100482,7979,7981,9044,5053,6751,7181,100556,7947,8676,8904,9064,2886,6931,100557,9226,9281,9370,3277,100123,2121,100558,7658,7688,8460,8523,8820,9451,1882,5827,6655,6849,100559,9450,9439,9525,9647,2912,3443,3846,6695,6865,7278,7444,100560,8021,8892,9444,5664,7277,7374,7553,100351,7585,8137,9419,9483,9503,2714,5612,5721,7017,7163,100410,3264,100612,403,9431,9470,2824,5305,100613,7668,8355,8898,9080,3713,5262,100614,7607,9546,3619,5685,6241,6325,100753,342,8674,100754,9601,9602,9603,9604,9605,9606,9607,100745,7920,9197,9202,9438,9565,4959,100150,106,5433,5557,100015,3056,100196,1098,3465,100543,9335,9344,3120,6369,100016,357,374,100439,844,3059,5049,5247,5841,6157,100724,8620,9541,9623,5343,5972,100030,3442,100143,9631,2880,3083,3133,3701,5055,100144,2469,2780,3411,4051,6653,100145,100321,3568,3946,5694,100738,3502,5029,5432,100437,100095,8855,9616,3578,3595,6126,6292,100096,8003,967,1985,3586,4008,100690,497,100746,440,1953,1954,1974,2367,5320,5458,100541,1534,100542,3166,4968,5912,6004,100740,8624,8817,9597,9600,3457,6046,100741,8822,1776,3232,100162,2807,100447,7706,7774,2834,3156,100682,753,100574,8829,100683,100183,412,8825,9557,2219,2427,4624,6051,100453,9090,1976,3813,3960,5907,7480,100684,957,100214,7986,8675,9328,9584,2527,2815,4862,6702,100720,8615,8677,8824,8879,9079,9107,9313,4020,5868,6266,6419,6754,100742,1150,100722,9294,2512,2858,3210,3297,3521,4845,100743,9373,9632,2285,6526,6719,7545,100190,208,2626,527,5805,5809,5812,2730,2679,2414,8000,100500,100074,8181,1521,6147,100157,8778,9391,1802,1803,3557,5158,100158,9094,9363,9528,3276,4798,5785,6198,100170,2187,100561,9360,6331,100501,8806,8897,100176,7686,7687,8782,4053,5013,100503,1003,3057,3430,100505,7829,9618,5848,7491,100502,8869,8994,9263,5593,5993,6016,6461,100564,6043,6070,6199,6244,7270,7271,2416,100575,7830,7376,100131,1416,100576,7701,5420,6306,100578,9334,4235,6520,100579,100577,6853,6933,100721,7862,7936,7999,8867,100519,100607,100723,230,9098,100715,100716,7742,8306,856,988,1258,1866,2183,3223,3638,5014,7293,7319,7298,7436,100718,7692,8210,9085,9300,6678,7305,7313,7317,7338,7347,7476,100719,7586,8050,8059,8821,8930,2645,6848,7315,100520,100041,2808,4640,4664,100572,100182,100573,100213,100103,2445,3642,6335,290,100079,857,2057,3130,3321,3874,3875,6314,6397,100080,901,2698,3087,100725,100726,8818,9158,9403,9504,9555,1076,2027,6006,100727,100728,100492,8708,5177,100629,7755,7980,8828,8896,5897,100630,7770,8143,8759,9371,9666,651,5872,100737,100527,1405,7443,1122,1567,100755,8161,9040,3101,5361,100756,7734,8762,100757,8020,9030,6519,6753,100528,8470,1991,100733,9346,9641,100734,9052,100686,7656,8321,2387,6811,100687,6596,100735,9007,9353,2884,100747,100748,7982,8001,8885,9474,5417,6432,6679,100749,9078,9180,9251,9345,9354,9502,9540,100600,9068,7311,7543,7819,100601,8268,7304,100602,6837,7309,100604,8909,9023,9082,1518,6748,100605,8256,9110,9178,6677,7310,100660,8004,9390,7308,100615,9336,9443,9487,7327,7159,100616,7883,8101,8102,8226,8989,9181,9262,9299,9364,9420,7103,7117,7132,7145,7169,100643,9194,9227,9587,7314,7316,100644,7748,7321,7544,100645,7352,7354,7353,7323,7325,100646,8141,9643,7328,7329,7330,100647,7659,9011,9667,7355,7331,7332,7334,100648,7805,7335,7337,8764,100649,100619,7297,100620,7139,100641,7357,7296,7538,100652,7348,7350,100653,7625,7934,9039,7469,100654,7754,7359,7351,100627,9292,7172,100650,7675,7984,8459,9100,9536,7339,7342,100651,7590,8005,8350,9355,7343,7346,100661,8295,100662,7312,100685,100729,588,8723,9192,100730,8384,9003,9163,7349,100731,9016,9121,100674,,9686) ) AS PagerTable

PARAMS:@UsBrowsePathNodeID = ,@UsBrowsePathByNameCn = Home & Kitchen(家居、厨具、家装)>>Storage & Organization(收纳用品)>>Garage Storage & Organization(车库存储和收纳)>>Other (Garage Storage & Organization)(车库存储和收纳) ,

MESSAGE:Incorrect syntax near ','.

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.TryConsumeMetaData()

在 System.Data.SqlClient.SqlDataReader.get_MetaData()

在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 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.DALExtendV2.E_Amazon_BrowseTreeUs_V2ExtendV2.GetPagerModelListWithUserDep(E_Amazon_BrowseTreeUs_PSParameters parameters, List1 userList, Int32& recordCount)

在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonBrowseTreeMappingV2.bindData()

在 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)

---