Thanks . I will check that database. ================================ Tran Thanh Tri HISP Viet Nam Cell phone: +84903670967 Website: http://tringuyenvn.com ================================
2009/10/23 Lars Helge Øverland <[email protected]>: > > > On Thu, Oct 22, 2009 at 11:41 AM, Trí Trần Thanh <[email protected]> > wrote: >> >> Hi Lars. >> >> W have problem with Add Report Excel Item action. We are bugging it but >> We don't know what the problem is ?If We create empty database and run dhis. >> It is working fine .But with Cần Thơ database. Sometimes errors, sometimes >> not . >> >> I send for you database. >> >> [-] (org.springframework.dao.DataIntegrityViolationException): Could not >> execute JDBC batch update; nested exception is >> org.hibernate.exception.ConstraintViolationException: Could not execute JDBC >> batch update >> >> [-] Gây ra bởi (java.sql.BatchUpdateException): Batch entry 0 insert into >> reportexcel_items (name, itemtype, excelrow, excelcolumn, itemexpression, >> periodtype, sheetno, reportexcelitemid) values (ttttttttttttt, organisation, >> 1, 1, 1, selected_month, 1, 5747) was aborted. Call getNextException to see >> the cause. > > > Hi Tri, > > you are (obviously) violating a constraint in the db. I am only seeing two > constraints for the reportexcel_items table, the primary key and the foregin > key to reportexcel. My only suggestion would be to 1) make sure the > reportexel that item refers to acually exists 2) run that query directly in > pgadmin to get a more detailed error log. > > > Lars > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
