Hello,
Recently I've upgraded odi from 12.1.3 to 12.2.1.4 version and applied the patch bundle ODI Stack Patch Bundle (SPB) 37157608. While testing the loadplans used on the previous version, I'm facing an issue on LKM. The error returns as “ODI-30038: OS command returned 1. Error details are [sh: c-: line xx: syntax error: unexpected end of file”.
As I open the code to understand further, I see that a large part of the code is missing.
The step tecnology is set as “ODI tools” and I see a new column for the target language and it's set to “SQL”.
I'm pasting part of the code I'm able to share
OdiOSCommand
#!/bin/bash
function insert_data(){
sqlplus <%= odiRef.getInfo("DEST_USER_NAME")%>/xxxxx@<%= odiRef.getInfo("DEST_DSERV_NAME")%> <<EOF
whenever sqlerror exit sql.sqlcode;
insert into table1(
column1,
column2,
column3
)
values(
'<%= odiRef.getOption("Source") %>',
'<%= odiRef.getOption("Feed") %>',
'$1'
);
commit;
EOF
return $?
}
(...)
insert_data() (...)
However, as I open the code on the operator tab it shows the code as the following:
OdiOSCommand
#!/bin/bash
function insert_data(){
sqlplus yyyy/xxxxx@zzzzzzzzzz <<EOF
whenever sqlerror exit sql.sqlcode;
insert into table1(
column1,
column2,
column3
)
values(
'Source',
'Feed',
'20250130'
);
commit;
EOF
return $
It's missing the rest of the code and the line the error happens is on the “return $”. It cuts as the “?” appears.
I couldn't find on oracle support an error or issue related.
Thanks