Query does not execute

General
1

Good day.
I have a situation with a query that seems to execute correctly ( I say seems because I get no errors) but in the server nothing is updated.
My payload looks like this:

{
  StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}

and my flow is like this:

image
image941×217 23.9 KB

The "Upgrade SHRDMGR" node receives the payload fine (as per the debug node) but the server
produced no updates.

The SQL in Upgrade SHRDMGR is as follows:

begin 
 baninst.learneroutcome.p_update(
        :StudentPIDM,
        :DegreeSequence,
        :OutcomeStatus,
        TO_DATE('10000101', 'YYYYMMDD'),
        TO_DATE(:GraduationDate,'MM/DD/YYYY'),
        '',
        :term,
        '',
        '',
        :GraduationStatus,
        '',
        TO_DATE('10000101', 'YYYYMMDD'),
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        USER,
        'GradAutomation',
        NULL,
        NULL
    );
end;

Any ideas to tackle this problem?

p.s. I'm using oracle-exec if that helps.

2

In your flow there is no debug attached to the upgrade node.

3

Sorry. I copied the altered version.

image
image790×213 22.4 KB

Nevertheless, the result in updateDbg is :

{

  StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}
4

  1. What is the full name of the 'oracle-exec' node? Searching - using the flows tab with the keyword 'oracle' doesn't show any node with 'exec' in it.

  2. What is the output of the termDog debug node? and can you set it to display the complete msg object. And copy and paste the output to a reply.

  3. Also set the updateDbg node to display the complete msg object also paste that to your reply.

5

@zenofmud,

Thanks for your reply.
1.
image

  1. termDbg node:
{
StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}
  1. updateDbg node: Is the same as termDbg

Because updateDbg has the correct information and updateError has not errors, at first glace I thought it was OK, until I checked the actual server and had not updated the info.

6

What would you expect the output of the update SHRDMGR to be?

Also it doesn’t look like you changed the debug node to display the complete msg object.

7

@zenofmud,

I'm not sure I understand your question. (sorry, I'm new to NR).
What do you mean by "changed the debug node to display the complete msg".

Is there a way to produce more output from the debug node?
If that's the case, could you tell me how to enable it?

8

Set it in the Output field dropdown

9

Thanks Colin!!

@zenofmud,
I got it to work. Appreciate your help.