patchgeneric.sql Fails to Help Upgrading Fisheye from Version 1.6.6 to Version 2.8.0
症状
Execution of patchgeneric.sql fails as follow:
java -Xmx2048m -jar <FISHEYE_HOME>/lib/hsqldb-1.8.0.10.jar --inlineRC "URL=jdbc:hsqldb:file:<FISHEYE_INST>/var/data/crudb/crucible;shutdown=true,USER=sa,PASSWORD=" patchgeneric.sqlSQL Error at 'patchgeneric.sql' line 3:
"delete from FR_EXTRA where fileRevision not in (Select REVISION_ID from REVISION)"
Integrity constraint violation FKD00FBDDBD91F70A1 table: REVISION_COMMENT
原因
Integrity constraint violation FKD00FBDDBD91F70A1 table: REVISION_COMMENT
This is happening because there is file revisions in the Fisheye/Crucible database for file versions that have not been indexed by Fisheye. This could happen with Crucible 1.6.6 but in the later versions it became mandatory for a crucible revision to have its associated file version indexed by Fisheye.
ソリューション
Execute the attached patch-Revision_Comment.sql:
java -Xmx2048m -jar <FISHEYE_HOME>/lib/hsqldb-1.8.0.10.jar --inlineRC "URL=jdbc:hsqldb:file:<FISHEYE_INST>/var/data/crudb/crucible;shutdown=true,USER=sa,PASSWORD=" patch-Revision_Comment.sqlThen execute again the original command using patchgeneric.sql
java -Xmx2048m -jar <FISHEYE_HOME>/lib/hsqldb-1.8.0.10.jar --inlineRC "URL=jdbc:hsqldb:file:<FISHEYE_INST>/var/data/crudb/crucible;shutdown=true,USER=sa,PASSWORD=" patchgeneric.sql関連情報
最終更新日 2018 年 7 月 31 日
Powered by Confluence and Scroll Viewport.