Im trying to set openwfe-1.7.3pre0 to use postgres as a backend.
However, I'm having a little trouble setting it up. I have a posgres
db, and I added a xlob user and two tables: owfehistory and
xldocument. I gave access to user xlob to both of them.
It looks like the db-engine-configuration.xml and db-worklist-
configuration.xml files that ship with this version of openwfe are
enabled for postgres and the xlob user, so I didn't change anything
there. I can also connect to the postgres db on port 5432.
However, when I try to launch a workitem after starting openwfe with
=db, I get an error:
* Error : openwfe.org.worklist.WorkListException: failure 1 in
openwfe.org.wlactions.LaunchAction
java.lang.NullPointerException
and logs/worklist.log has this stack trace:
java.lang.NullPointerException
at openwfe.org.wlactions.LaunchAction.run(LaunchAction.java:
140)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at openwfe.org.auth.Actions.executeAction(Actions.java:152)
at
openwfe.org.worklist.impl.RmiWorkSession.executeAction(RmiWorkSession.java:
213)
at
openwfe.org.worklist.impl.RmiWorkSession.launch(RmiWorkSession.java:
450)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:
466)
at sun.rmi.transport.tcp.TCPTransport
$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
The strange thing is the xldocument gets a row added to it, but
owfehistory doesn't get anything added. I also tried creating the owfe
table and user suggested by engine/postgresql_history.sql, but nothing
was added to the tables under that user.
I'm very new to setting up postgres and openwfe, so I'm most likely
doing something wrong. Maybe I am missing a table, or are owfehistory
and xldocument the only ones used?
Please let me know if you would like more info. Thank you so much for
your help!
--Jennifer
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"OpenWFE users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/openwfe-users?hl=en
-~----------~----~----~----~------~----~------~--~---
