[JBoss jBPM] - Deleting data from jbpm tables in database
by ksdeger
We have a system that is successfully using JBPM. It creates a very large number of process instances a day, so we would like to delete them when they have completed to free up space in the database.
I am going to write code using GraphSession.deleteProcessInstance to do this, but until I can get that done I was hoping to put out a quick SQL script to do the clean up. I have the SQL script completed, but there is something odd going on. The jbpm_bytearray table has a large number of rows with no values in the name_ or filedefinition_ columns. Also, the id_'s for these rows do not appear in the jbpm_variableinstance bytearrayvalue_ column. I looked at the jbpm hibernate cfg.xml files, and I can't figure out where these rows are coming from, or how I would know to which process instance they belongs.
Just as an example, I ran a single file through our JBPM flow, and after the clean up, which removes all the jbpm_bytearray and jbpm_byteblock rows which have valid references in the jbpm_variableinstance table, there were still 276 new rows in the jbpm_blockbyte table.
I cannot leave this data to accumulate as it eventually kills the database.
Any suggestions? We are using JBoss 4.0.1sp1 and JBPM 3.0.2.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983143#3983143
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983143
19Â years, 6Â months
[JBossWS] - Re: Possible JBoss SwA Bug
by rayymlai
We run the JBossWS swa sample codes, and encounter this problem.
If you uncomment out the build.xml the wstool task example, we find this error.
Could any one help to see if this is a bug in JBossWS?
We also find that there are a few JBossWS sample subprojects sharing the same problem.
| 1. In JBossWS 1.0.3 samples, cd to samples\swa.
|
| 2. Uncomment the following in the build.xml.
|
| <!-- samples/swa - ->
|
| <wstools dest="${build.test.dir}/wstools/resources/samples/swa/WEB-INF"
|
| config="${resources.dir}/wstools-config.xml"/>
|
| -->
|
| 3. ant generate-sources
|
| There should be an error:
|
| C:\projects\jbossws-1.0.3.GA\samples\swa>ant generate-sources
|
| Buildfile: build.xml
|
|
|
| init:
|
| [available] DEPRECATED - <available> used to override an existing property.
|
| [available] Build file should not reuse the same property name for different v
|
| alues.
|
| [echo] jboss.home = c:/jboss-4.0.4.ga
|
| [echo] tomcat.home = c:/projects/jbossws-1.0.3.ga/lib/tomcat
|
| [echo] java.home = C:\Java\jdk1.5.0_06\jre
|
| [echo] node0 = MTVL04AL3H1430
|
|
|
|
|
| compile:
|
|
|
| generate-sources:
|
| [wstools] log4j:WARN No appenders could be found for logger (org.jboss.ws.tool
|
| s.WSTools).
|
| [wstools] log4j:WARN Please initialize the log4j system properly.
|
| [wstools] java.io.IOException: Cannot parse config: Failed to parse source: cvc-complex-type.4: Attribute 'name' must appear on element 'operation'. @ *unknow
|
| n*[12,18]
|
| [wstools] at org.jboss.ws.tools.config.ToolsSchemaConfigReader.readConfig(
|
| ToolsSchemaConfigReader.java:141)
|
| [wstools] at org.jboss.ws.tools.WSTools.readToolsConfiguration(WSTools.jav
|
| a:150)
|
| [wstools] at org.jboss.ws.tools.WSTools.generate(WSTools.java:79)
|
| [wstools] at org.jboss.ws.tools.ant.wstools.execute(wstools.java:103)
|
| [wstools] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
|
| va:275)
|
| [wstools] at org.apache.tools.ant.Task.perform(Task.java:364)
|
| [wstools] at org.apache.tools.ant.Target.execute(Target.java:341)
|
| [wstools] at org.apache.tools.ant.Target.performTasks(Target.java:369)
|
| [wstools] at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
|
| a:1216)
|
| [wstools] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
|
|
|
| [wstools] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
|
| faultExecutor.java:40)
|
| [wstools] at org.apache.tools.ant.Project.executeTargets(Project.java:1068
|
| )
|
| [wstools] at org.apache.tools.ant.Main.runBuild(Main.java:668)
|
| [wstools] at org.apache.tools.ant.Main.startAnt(Main.java:187)
|
| [wstools] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
|
| [wstools] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
|
| [wstools] Caused by: org.jboss.xb.binding.JBossXBException: Failed to parse so
|
| urce: cvc-complex-type.4: Attribute 'name' must appear on element 'operation'. @
|
| *unknown*[12,18]
|
| [wstools] at org.jboss.xb.binding.parser.sax.SaxJBossXBParser.parse(SaxJBo
|
| ssXBParser.java:156)
|
| [wstools] at org.jboss.xb.binding.UnmarshallerImpl.unmarshal(UnmarshallerI
|
| mpl.java:169)
|
| [wstools] at org.jboss.ws.tools.config.ToolsSchemaConfigReader.readConfig(
|
| ToolsSchemaConfigReader.java:137)
|
| [wstools] ... 15 more
|
| [wstools] Caused by: org.xml.sax.SAXException: cvc-complex-type.4: Attribute '
|
| name' must appear on element 'operation'. @ *unknown*[12,18]
|
| [wstools] at org.jboss.xb.binding.parser.sax.SaxJBossXBParser$MetaDataErro
|
| rHandler.error(SaxJBossXBParser.java:326)
|
| [wstools] at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Sour
|
| ce)
|
| [wstools] at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown S
|
| ource)
|
| [wstools] at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown S
|
| ource)
|
| [wstools] at org.apache.xerces.impl.xs.XMLSchemaValidator$XSIErrorReporter
|
| .reportError(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.xs.XMLSchemaValidator.reportSchemaErro
|
| r(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.xs.XMLSchemaValidator.addDefaultAttrib
|
| utes(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartEleme
|
| nt(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unk
|
| nown Source)
|
| [wstools] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElem
|
| ent(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$Fragmen
|
| tContentDispatcher.dispatch(Unknown Source)
|
| [wstools] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDoc
|
| ument(Unknown Source)
|
| [wstools] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown So
|
| urce)
|
| [wstools] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown So
|
| urce)
|
| [wstools] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
|
| [wstools] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Sou
|
| rce)
|
| [wstools] at org.jboss.xb.binding.parser.sax.SaxJBossXBParser.parse(SaxJBo
|
| ssXBParser.java:152)
|
| [wstools] ... 17 more
|
|
|
| BUILD FAILED
|
|
|
|
thanks
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983141#3983141
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983141
19Â years, 6Â months
[JBossCache] - Re: TreeCache replication: No ClassLoaders found and using T
by jyoonyang
anonymous wrote : 1) Where is the class that calls cache.registerClassLoader() located?
It is in the war. It is a singleton class loaded by Spring. cache.registerClassLoader() is called inside initialization method.
anonymous wrote : 2) Are you setting up a scoped loader repository in jboss-app.xml?
I would like to, but for now I have that commented out.
anonymous wrote : 3) In jbossweb-tomcat55.sar/META-INF/jboss-service.xml, what are the values for "Java2ClassLoadingCompliance" and "UseJBossWebLoader"?
<attribute name="Java2ClassLoadingCompliance">false</attribute>
| <attribute name="UseJBossWebLoader">false</attribute>
|
anonymous wrote : 4) You say that after you set up marshalling "Now the cache is not getting replicated." Please be more specific -- what is happening?
I added an item into "test" in one cache node in the cluster. I try to do a lookup on the other cache node, and it fails. I also was looking from JMX console. I invoked "printDetails". I see the item in one node, but not in the other.
I have also tried manually putting and item from the JMX console. I don't see this item when I invoke "printDetails" on the other node.
Another exception. When I invoked remove method from JMX console, I am seeing "javax.management.IntrospectionException: Failed to find PropertyEditor for type: org.jboss.cache.Fqn"
Thanks much!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983140#3983140
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983140
19Â years, 6Â months
[JBoss Eclipse IDE (users)] - Re: Does JBossIDE2.0.0 Beta2 support EJB3 Project deployment
by kstretch
Not sure if this is related but...
I just upgraded from 3.1/1.6 to 3.2.1/2.0B
Took me a while but I think I have everything running again (well almost)
I had to set the server name to the same server name as in my old workspace and restart eclipse (Before restaring eclipse, selecting on the server name/finish had no effect). After that the JBOSS EJB Libraries [error] switched to the name of my server and compiled correctly.
However now the "deploy" option doesn't show up and I have to manually copy the jar files into my deployment directory.
As well in "Server View" it wants a "Configuration Path" which is currently set to "/Servers/depName/" and eclipse keeps trying to create this new project (which I delete). Trying to "Browse" it only allows me to select one project and none of my projects seem to be valid. Further it only allows me to select one project at a time and I have multiple projects that all use the same server.
If I try "Add and Remove Projects" on the server I get "there are no projects that can be added or removed from the server"
For now it works... I just hope someone is working on this "gotcha"!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983138#3983138
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983138
19Â years, 6Â months