[JBoss jBPM] - Re: Purge existing process instances
by kbutler
Duh - I just saw the DataModel Wiki
http://wiki.jboss.org/wiki/Wiki.jsp?page=Jbpm31DataModel ,
somehow I missed it on the Wiki page.
I have corrected my earlier script, for SQLServer, by adding the rest of the tables from the Execution Model. Note that JBPM_MESSAGE is not part of my 3.0.1 installation, so is omitted here.
By way of apology, here is the final script for SQLServer users, note the skirting of a FK.
| delete from JBPM_LOG
| delete from JBPM_TIMER
| delete from JBPM_MODULEINSTANCE
| delete from JBPM_TOKENVARIABLEMAP
| delete from JBPM_TASKINSTANCE
| delete from JBPM_VARIABLEINSTANCE
|
| -- Must temporarily drop FK from Token -> ProcInstance
| if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TOKEN_PROCINST]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
| ALTER TABLE [dbo].[JBPM_TOKEN] DROP CONSTRAINT FK_TOKEN_PROCINST
|
| -- Clear tables
| delete from JBPM_PROCESSINSTANCE
| delete from JBPM_TOKEN
|
| -- Re-add dropped FKs
| ALTER TABLE [dbo].[JBPM_TOKEN] ADD
| CONSTRAINT [FK_TOKEN_PROCINST] FOREIGN KEY
| (
| [PROCESSINSTANCE_]
| ) REFERENCES [dbo].[JBPM_PROCESSINSTANCE] (
| [ID_]
| )
|
| delete from JBPM_SWIMLANEINSTANCE
| delete from JBPM_POOLEDACTOR
| delete from JBPM_TASKACTORPOOL
| delete from JBPM_COMMENT
| delete from JBPM_RUNTIMEACTION
| delete from JBPM_BYTEBLOCK
| delete from JBPM_BYTEARRAY
|
Comments welcome.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959928#3959928
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959928
19 years, 9 months
[Installation, Configuration & Deployment] - Re: Windows Explorer automatically pops up displaying C:\Pro
by PeterJ
Eureka! The key is the statement that you installed to "C:\Program". Up to now I assumed that some code was tripping over the space in "Program Files" and causing a wierd Explorer window to show. Anyway, I installed to c:\program, logged out and back in, and guess what appeared on my screen? Also, there very briefly flashed a dialog box which then very conveniently hid itself behind the Explorer window. I pulled that dialog box back out front and here is what it says:
anonymous wrote : Title: File Name Warning
| Text: There is a file or folder on your computer called "C:\Program" which
| could cause certain applications to not function correctly. Renaming it
| to "C:\Program1" would solve this problem. Would you like to rename
| it now?
This makes sense based on how Windows converts long file names into short file names to support older 16-bit programs.
The solution is to rename c:\program to something else (I use c:\apps). You do not have to unistall and reinstall JBoss, there is no registry information or anything like that that points to the existing directory. Though, the uninstall script will not work since it still has the c:program directory, but uninstaling JBoss is easy - just delete the directory.
This is why I like trying to solve wierd problems posted on this forum - I almost always learn something new! Thanks, Marcus, it's been a trip!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959922#3959922
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959922
19 years, 9 months