Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00936: missing expression while insert data into flow table

et4891May 31 2021

I am trying to create flow control to be included for IKM so I can get the flow control to work in mapping for having E$ table to catch any exceptions, but there isn't any template on the code of the flow table. None of the IKM included flow control. Then I figured, using the Oracle VM https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html it has built in flow control in IKM so I copied the code from there to my ODI, but I am getting ORA-00936: missing expression when running the mapping.
This is the code I copied
image.pngNot sure if these versions has to do with errors but this is the version I am using
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Oracle IDE 12.2.1.3.0
Version in VM is below
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Oracle IDE 12.2.1.3.1

Comments

Christian.Shay -Oracle
Answer

Hi Bob,
When I have seen something this extreme, usually something went wrong in the installation and it needs to be reinstalled.
What version of our extension are they using?
What OS and version are they using?
What version of the .NET Runtime are they using?
Lets try to reinstall, and lets wait after each step to give it a chance to complete and open and close VS Code with each step:
Uninstall the extension, wait 2 minutes, restart VS Code, wait 2 more minutes, reinstall of the extension, wait 2 minutes, and then restart vscode.
Let me know if this fixes it for them.

Marked as Answer by BobMilli · Apr 28 2022
1 person found this helpful
BobMilli

Hello,
Thanks for your help.
It was due, as you suspected, as a missing correct .NET Runtime.
Issue fixed !
Regards,
Bob

Christian.Shay -Oracle

Hi Bob,
We are supposed to prompt the user if they don't have the correct .NET Runtime installed and we offer to take them to a web page to show them how to install it.
Did that happen in this case? If not, that is a serious issue and I would appreciate it if you could let me know what versions of .NET Runtime they had installed on their machine when this failure occurred. If we did notify them about the missing .NET Runtime, but they ignored it, then this is expected behavior.

1 - 3

Post Details

Added on May 31 2021
#11g, #12c, #business-intelligence-applications, #control, #data-integrator, #system-management-and-integration, #workflow
1 comment
867 views