Re: problem Running with MS-SQL

[Scott Gray]

Hi Weixue,




Thanks
Scott

HotWax Media
http://www.hotwaxmedia.com

On 31/08/2009, at 12:12 PM, weixuezhang wrote:

Could you point me to an example of where the demo data violates a unique constraint?

Either demo data or entitymodel definition has problem. Can someone look into this problem?

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">



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.



Hi All,


Does anyone have an idea that why it happens with MSSQL ?

Thanks ,

Abhijeet Pandey







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

I found 6 places with unique="true" in trunk as below. I simply changed "true" into "false", then started from creating a new database. 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. Can you guide me that if i need to change all "unique=false" in all the entitymodel.xml (there are about 26 of them)? 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

smime.p7s
Description: S/MIME cryptographic signature