Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Rick

Avatar / Picture

Senior Veteran
Registered:
Posts: 259
Reply with quote  #1 
I'm having a problem where an action which reads data from an external database is reliably unreliable!

The action reads data from an external database and assigns it to a variable as follows:

processname.memVar = SelectSql(new OracleConnection1(),"SELECT field1||',Reference: '||field2||','||nvl(field3, field4||' '||field5)||','||replace(field6,',',' ') from table1 where nvl(lre_modified_date, lre_created_date) >=  @DateLastRun  order by 1", SQLArg("@DateLastRun", FormatDateTime(ProcessContext.WhenStageStarted,"dd-MMM-yyyy")))

When I try to run the action on which this code sits nothing happens on the client and I get the following error message in the designer log:

Details:Failed to execute 'system action'. Exception 'ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.' occurred when attempting to 'Run script'. ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.

However, if I immedietly run the action a second time - it works!

Now, normally this would just be an annoyance for the users but in this instance the code has to run on a timed action, not a user action. Because the timed action fails the first time it's not going to try a second time.

If I set up the same query as a business object and use the 'test' function it works every time. (I can't use a business object on the action because of the way I want to access the data returned.)

I'm guessing this might be a config issue with my Oracle ODBC driver but it's set up the same as my v7 server so I'm not sure what the problem is.

Can anyone help, please?

Cheers,
Rick

__________________

Another full day of doing nothing but rearranging zeros and ones. :)
You know it will be a good day when there is no human interaction on the schedule.

0
PresuminEd

Avatar / Picture

Member
Registered:
Posts: 25
Reply with quote  #2 

Hi Rick,

I may be wrong here...but are you using Microsoft driver for talking to Oracle?  Only that would make me nervous...

Cheers,
Ed.


__________________
Any comments I make are mine alone, and do not necessarily reflect the views of my employer...May contain nuts...Open other side up...Contents may have settled during transportation...
0
Rick

Avatar / Picture

Senior Veteran
Registered:
Posts: 259
Reply with quote  #3 
Hi Ed,

No, I'm using an Oracle ODBC driver (the microsoft one makes me nervous too). The weird thing is that it fails with that error message the first try and then works on the second.

Rick.

__________________

Another full day of doing nothing but rearranging zeros and ones. :)
You know it will be a good day when there is no human interaction on the schedule.

0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!