txkADOPPreparePhaseSychronize.pl unexpected error for adop

After aborting a adop session I ran into a bit of a problem with fs_clone. Log files weren't helping so I ran:

adop phase=fs_clone loglevel=statement

This is what I saw

*******FATAL ERROR*******
PROGRAM : (/oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME    : Mon Jan  4 16:45:03 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 4 16:45:03 2016
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> SQL> Connected.
SQL> SELECT clone_status||',' FROM ad_adop_session_patches WHERE status in ('R','F','N') AND bug_number = 'CLONE' AND node_name = 'oraapdev' AND adop_session_id =
                                                                                                                                                            *
ERROR at line 1:
ORA-00936: missing expression
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
STACK TRACE
 at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
        TXK::Error::abort('TXK::Error', 'HASH(0xb12ca0)') called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
        TXK::Common::doError('TXK::SQLPLUS=HASH(0x24f4958)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
        TXK::Common::setError('TXK::SQLPLUS=HASH(0x24f4958)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
        TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x24f4958)', 0) called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
        TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x24f4958)', 'HASH(0x229cd08)') called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
        TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x2542af0)', 'SELECT clone_status||\',\' FROM ad_adop_session_patches WHERE...') called at /oa01/oradata/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
        TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x2542af0)', 'SELECT clone_status||\',\' FROM ad_adop_session_patches WHERE...') called at /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 3327
        main::getCloneStatus() called at /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 1364
        main::checkCloneStatus('STARTED') called at /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 5975
        main::startCloneProcess() called at /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 2085
        main::createPatchApplTop() called at /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 629
    [UNEXPECTED]Error occurred running "perl /oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/oa01/oradata/fs1/inst/apps/DEV_oraapdev/appl/admin/DEV_oraapdev.xml -patchcontextfile=/oa01/oradata/fs2/inst/apps/DEV_oraapdev/appl/admin/DEV_oraapdev.xml -promptmsg=hide -console=off -mode=create -sessionid=11 -timestamp=20160104_164228 -outdir=/oa01/oradata/fs_ne/EBSapps/log/adop/11/fs_clone_20160104_164228/DEV_oraapdev"
I had aborted the previous session but not run cleanup in full mode. Well lesson learnt but I still needed to somehow move forward with this one and apply the patch. It was not getting the session id from the txkADOPPreparePhaseSynchronize.pl file. I started digging and made the following updates to get it working. I would not recommend this on PROD but to get things moving along this definitely helped me.

update APPLSYS.AD_ADOP_SESSIONS
set status = 'C'
where ADOP_SESSION_ID =11;
update  APPLSYS.ad_adop_session_patches
set bug_number = 'CLONE'
where ADOP_SESSION_ID =11;
commit;
Reference

• Adop Fs_clone Fails with ORA-00936: missing expression (Doc ID 2050946.1)