The table you are getting an error on is an OLAP table, ProductDimension. I have had frequent problems with new installs on SQL Server and these tables. Try running quickInitDataWarehouse.
Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell ----- Original Message ----- From: "Abhijeet Pandey" <abhijeet.pan...@gmail.com> To: "user" <u...@ofbiz.apache.org>, "dev" <dev@ofbiz.apache.org> Sent: Friday, September 4, 2009 7:57:05 AM GMT -07:00 US/Canada Mountain Subject: Re: Re: problem Running with MS-SQL Hi, i am able to connect to ofbiz with demo data after doing modification suggested. but i am not able to add product. i am getting below error --> The Following Errors Occurred: Error: Error trying to begin transaction, could not process method: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductDimension]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)) (Error while inserting: [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished Good(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.))) calling service addProductToCategory in createProductInCategory does the changes suggested below is the culprit ? Plz guide. Thanks, Abhijeet Pandey On Mon, Aug 31, 2009 at 5:42 AM, weixuezhang <weixuezh...@hotmail.com>wrote: > 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 > -- Abhijeet Pandey
