DateTime:2025-06-25 19:03:59
Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire
FROM ServiceCenter..PlatformAccounts pa 
INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF'
LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId
LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2402' AND PlatformID='118' AND pa.RecordId='1998') fms where fms.num  between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 
UrlReferrer:
Url:
post:
cookies:
ip:
header:
Source:Vayava.Common
StackTrace:   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 387
   在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 327
   在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10685


DateTime:2025-06-25 19:19:02
Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire
FROM ServiceCenter..PlatformAccounts pa 
INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF'
LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId
LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2134' AND PlatformID='88' AND pa.RecordId='1947') fms where fms.num  between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 
UrlReferrer:
Url:
post:
cookies:
ip:
header:
Source:Vayava.Common
StackTrace:   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 387
   在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 327
   在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10685