Either demo data or entitymodel definition has problem. Can someone look into this problem?
I found 6 places with unique="true" in trunk as below. I simply changed "true" into "false", then started from creating a new database. accounting\entitydef\entitymodel.xml 1,931: <index name="GLACCT_UNQCD" unique="true"> marketing\entitydef\entitymodel.xml 216: <index name="CNTLSTCST_MSG_ID" unique="true"> party\entitydef\entitymodel.xml (2 matches) 714: <index name="COMMEVT_MSG_ID" unique="true"> 1,007: <index name="EMAIL_VERIFY_HASH" unique="true"> product\entitydef\entitymodel.xml (2 matches) 1,839: <index name="INVITEM_SOFID" unique="true"> 1,842: <index name="INVITEM_ACTNM" unique="true"> I found demo data doesn't specify value for some of these fields, default value of them is null. When inserting multiple records of data, demo data seeding will get failure due to the unique index constrain. Thanks. Weixue Zhang 发件人: Abhijeet Pandey 发送时间: 2009-08-27 16:03:30 收件人: user 抄送: weixuezhang; Abhijeet Pandey 主题: Re: problem Running with MS-SQL Hi Zhang, Thanks for this. Can you guide me that if i need to change all "unique=false" in all the entitymodel.xml (there are about 26 of them)? Hi All, Does anyone have an idea that why it happens with MSSQL ? Thanks , Abhijeet Pandey On Sun, Aug 16, 2009 at 4:16 PM, Weixue Zhang <weixuezh...@hotmail.com> wrote: I am using ms sql server 2005 and this problem had bothered me for long time. At last I found it was caused by a few unique indices of some tables (You can find them by searching with "unique="true"" in files entitymodel.xml). After I changed them into "unique=false", demo data works fine. Can anybody explain why this problem doesn't exist with other database servers, and why we need to set unique=true at some indices while most others are unique=false? Weixue Zhang -- View this message in context: http://www.nabble.com/problem-Running-with-MS-SQL-tp24895969p24992345.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Abhijeet Pandey