kumarson

留下成长点滴...
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

排序规则转换错误

Posted on 2013-08-27 15:36  kumarson  阅读(428)  评论(0编辑  收藏  举报

1、问题描述

     提示

 1 2013-06-25 14:02:08 INFO [con.out] [2013-06-25 14:02:08,750 ERROR RPC-7]getRowSetBySeqTable() query: com.kingdee.eas.fi.ap.app.ApInvoiceQuery
 2 2013-06-25 14:02:08 INFO [con.out] [2013-06-25 14:02:08,750 ERROR RPC-7]getRowSetBySeqTable() sql: SELECT 
 3 
 4 "APINVOICE".FNumber AS "NUMBER", 
 5 "APINVOICE".FType AS "BILLTYPE", 
 6 "APINVOICE".FBillStatus AS "BILLSTATUS", 
 7 "ASSTACTTYPE".FName_l2 AS "ASSTACTTYPE.NAME", 
 8 (("APINVOICE".FAsstActNumber || ' ') || "APINVOICE".FAsstActName_l2) AS "ASSTACCT", 
 9 (("MATERIAL".FNumber || '  ') || "MATERIAL".FName_l2) AS "MATERIAL", 
10 "MATERIAL".FModel AS "MATERIAL.MODEL", 
11 "MEASUREUNIT".FName_l2 AS "MEASUREUNIT.NAME", 
12 "EXPENSEITEM".FNumber AS "EXPENSEITEM.NUMBER", 
13 "EXPENSEITEM".FName_l2 AS "EXPENSEITEM.NAME", 
14 "ENTRIES".FQuantity AS "ENTRIES.QUANTITY", 
15 "ENTRIES".FUnitPrice AS "ENTRIES.UNITPRICE", 
16 "ENTRIES".FAmount AS "ENTRIES.AMOUNT", 
17 "ENTRIES".FTaxRate AS "ENTRIES.TAXRATE", 
18 "ENTRIES".FTaxAmount AS "ENTRIES.TAXAMOUNT", 
19 "APINVOICE".FTotalAmount AS "TOTALAMOUNT", 
20 "APINVOICE".FBillDate AS "BILLDATE", 
21 "APINVOICE".FID AS "ID", 
22 "CURRENCY".FName_l2 AS "CURRENCY.NAME", 
23 "CURRENCY".FPrecision AS "CURRENCY.PRECISION", 
24 "APINVOICE".FCompanyID AS "COMPANY.ID", 
25 "APINVOICE".FAsstActTypeID AS "ASSTACTTYPE.ID", 
26 "APINVOICE".FCurrencyId AS "CURRENCY.ID", 
27 "APINVOICE".FAsstActNumber AS "ASSTACTNUMBER", 
28 "ENTRIES".FID AS "ENTRIES.ID", 
29 "APINVOICE".FDrawer AS "DRAWER", 
30 "MATERIAL".FPricePrecision AS "MATERIAL.PRICEPRECISION", 
31 "AUDITPERSON".FName_l2 AS "AUDITPERSON.NAME", 
32 "APINVOICE".FCussAddress AS "CUSSADDRESS", 
33 "APINVOICE".FCussPhone AS "CUSSPHONE", 
34 "APINVOICE".FCussBank AS "CUSSBANK", 
35 "APINVOICE".FCussAcctBank AS "CUSSACCTBANK", 
36 "APINVOICE".FTxRegisterNo AS "TAXREGISTERNO", 
37 "APINVOICE".FDescription AS "DESCRIPTION", 
38 "ACCOUNTBANK".FBankAccountNumber AS "ACCOUNTBANK.BANKACCOUNTNUMBER", 
39 "ENTRIES".FActualAmount AS "ENTRIES.ACTUALAMOUNT", 
40 "ENTRIES".CFApproveTime AS "ENTRIES.APPROVETIME", 
41 "ENTRIES".CFIsApproved AS "ENTRIES.ISAPPROVED", 
42 "ENTRIES".CFApproverId AS "ENTRIES.APPROVERID", 
43 "APPROVERUSER".FName_l2 AS "APPROVERUSER.NAME"
44 
45 FROM T_AP_ApInvoice AS "APINVOICE"
46 
47 LEFT OUTER JOIN T_AP_ApInvoiceEntry AS "ENTRIES"
48 ON "APINVOICE".FID = "ENTRIES".FParentId
49 
50 LEFT OUTER JOIN T_BD_Currency AS "CURRENCY"
51 ON "APINVOICE".FCurrencyId = "CURRENCY".FID
52 
53 LEFT OUTER JOIN T_BD_AsstActType AS "ASSTACTTYPE"
54 ON "APINVOICE".FAsstActTypeID = "ASSTACTTYPE".FID
55 
56 LEFT OUTER JOIN T_BD_Person AS "AUDITPERSON"
57 ON "APINVOICE".FAuditPersonId = "AUDITPERSON".FID
58 
59 LEFT OUTER JOIN T_BD_AccountBanks AS "ACCOUNTBANK"
60 ON "APINVOICE".FAccountBankId = "ACCOUNTBANK".FID
61 
62 LEFT OUTER JOIN T_BD_Material AS "MATERIAL"
63 ON "ENTRIES".FMaterialID = "MATERIAL".FID
64 
65 LEFT OUTER JOIN T_BD_MeasureUnit AS "MEASUREUNIT"
66 ON "ENTRIES".FMeasureUnitID = "MEASUREUNIT".FID
67 
68 LEFT OUTER JOIN T_SCM_ExpenseItem AS "EXPENSEITEM"
69 ON "ENTRIES".FExpenseItemID = "EXPENSEITEM".FID
70 
71 LEFT OUTER JOIN T_PM_User AS "APPROVERUSER"
72 ON "ENTRIES".CFApproverId = "APPROVERUSER".FID
73 
74 WHERE "APINVOICE".FID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND "ENTRIES".FID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1) OR ("APINVOICE".FID = ? OR ("APINVOICE".FID IS NULL) AND ? = 1) AND ("ENTRIES".FID = ? OR ("ENTRIES".FID IS NULL) AND ? = 1))
75 
76 ORDER BY 
77 "ID" ASC
78 2013-06-25 14:02:08 INFO [con.out] [2013-06-25 14:02:08,750 ERROR RPC-7]getRowSetBySeqTable() occur error:
79 java.sql.SQLException: 无法解决 equal to 运算中 "Chinese_PRC_CS_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。
80     at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
81     at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
82     at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
83     at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
84     at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
85     at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
86     at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:293)
87     at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
88     at com.kingdee.bos.dao.query.server.BaseDataAccess.excuteSQL(BaseDataAccess.java:357)
89     at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSetBySeqTable(VirtualModeDataAccess.java:1044)
90     at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerGetRowSet(VirtualModeDataAccess.java:861)
91     at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.doAllQueryTask(VirtualModeDataAccess.java:1751)
92     at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.pi12(Unknown Source)
93     at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.processInvoke(Unknown Source)
94     at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
95     at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:610)
96     at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:121)
97     at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
98     at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
99     at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:131)
View Code

2、处理方式

1 --修改某个列的方法为
2 ALTER   TABLE   T_AP_ApInvoiceEntry
3 ALTER   COLUMN   CFApproverID   varchar(50)   COLLATE   Chinese_PRC_CS_AS
4 
5 --说明
6 --Chinese_PRC_CS_AS:区分大小写
7 --Chinese_PRC_CI_AS:不区分大小写