Unrecognized bind variable passed to the bind call

[ralvez]

Hi Steve,

I modified the flow. It looks like this:

You will notice that there are 2 items in Distinction that is connected to the template (where the code is) and then to the DB.

The error is the yet the same. That's what makes me think of corruption.
To be honest I'm kinda lost now

[ralvez]

BTW. If you think that being able to see the whole flow may be helpful I can post it.

[Steve-Mcl]

@ralvez

If you think that being able to see the whole flow may be helpful I can post it.

No, you have too many bespoke nodes that talk to "things" I dont have nor do i have access to your "things".

What i am confused about here is: you have implemented the stuff I said to do (in a function) BUT you have a template node going into the SQL node!!!

Show me the output of "Debug 156"

[ralvez]

The outpu of debug 156 is:

{"Student PIDM":740840,"Student ID":200516153,"Degree Sequence":1,"Institutional Honors":"D","Transcript Indicator":"Y","Commencement Report":"Y"}

Which BTW is the same as the output of the Distinction node which is connected to the template.

Now I have a question.
I understood that the idea was to implement your code suggestion in the template but your comments make me think that, if fact, that may not have been your intention.
Did I misunderstand something?

[ralvez]

I made some changes to the code based on your comment where you mentioned that you where thinking of a function. ( Well, I think that's what you meant )
So it now looks like this:

I get a "better" result as it seems to like to execute the query without the Student PIDM error.
I have to test further but I think we made progress in the right direction. Thanks!!

[ralvez]

@Steve-Mcl ,

After a few tests I think we are good. I did not get in your earlier comments that we were replacing the template with a function.
Using a function and placing the code to be executed in the oracle-db (SHDGIH INSERT) does the trick.
Thanks for all the help.