otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Workflow Configuring Workflow components - including Agents, Milestones, Notifications Auto Data Assignment and Events.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old August 24th, 2007, 18:21
Junior Member
 
Join Date: Dec 2006
Location: Chicago
Posts: 25
Thanks: 3
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
bfolan is on a distinguished road
Send a message via MSN to bfolan
Time Based Milestone Query

I am trying to test a time based milestone which uses a saved query to retrieve the timeout time. Unfortunately everytime the query runs (viewed through the system logs):

java.sql.SQLException: ORA-00911: invalid character java.sql.SQLException: ORA-00911: invalid character at oracle.jdbc.dbaccess.DBError.throwSqlException

The query shoulds a date field from the database. Does anyone have experience on using time based milestone which uses a saved query to retrieve the expiration date?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
riq-saved query rj5316 Rating 1 December 14th, 2007 17:09
Milestone monitor rj5316 Workflow 10 December 5th, 2007 12:56
Milestone Monitor Refresh error "ArrayIndexOutOfBoundsException" sknmail@rediffmail.com Workflow 0 October 25th, 2007 19:09
[SOLVED] Lead time for shipment start time bob_romijn Planning 1 August 8th, 2007 14:27
Auto tendering based on Service Provider tender cutoff time engyeowkee Execution 3 June 2nd, 2007 08:26



All times are GMT. The time now is 23:40.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37