Skip to Content
avatar image
Former Member

wis 10901 incorrect syntax near keyword confirm - sybase db

Hello,

We have just upgraded the test system to SAP BO 4.2 SP 3 and I have this strange error message :

The error is generated by the db field :

select

table_name.ConfirmExec

from

table_name

Any idea why the ConfirmExec is not ok in 4.2 SP3 ? In 4.0 SP12 the same report is working ok.

sybase-error.jpg (12.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 07, 2017 at 02:39 PM

    Does anyone know if Sybase driver version 15.07.00.501 is by default installed with SAP BO 4.2 SP 3 ?

    Can the fact that now we can run also stored procedures influence the fact that now we can't run the above script anymore? Maybe is somewhere in SAP BO stated that Exec is a reserved word !?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 08, 2017 at 07:26 AM

    details from logfile :

    FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2
    ENCODING:UTF-8
    RECORD_SEPARATOR:30
    COLUMN_SEPARATOR:124
    ESC_CHARACTER:27
    COLUMNS:Location|Guid|Time|Tzone|Trace|Log|Importance|Severity|Exception|DeviceName|ProcessID|ThreadID|ThreadName|ScopeTag|MajorTick|MinorTick|MajorDepth|MinorDepth|RootName|RootID|CallerName|CallerID|CalleeName|CalleeID|ActionID|DSRRootContextID|DSRTransaction|DSRConnection|DSRCounter|User|ArchitectComponent|DeveloperComponent|Administrator|Unit|CSNComponent|Text
    SEVERITY_MAP: |None| |Success|W|Warning|E|Error|A|Assertion
    HEADER_END
    ..\ocaframework\ServiceMgrFactory.cpp:82:-: TraceLog message 1
    |a5f864a5-6a7a-f384-6a35-b86988434304|2017 06 08 08:22:04:322|+0200|Error| |>>|E| |WebIRichClient|38968|25756|| |0|0|0|0|-|-|-|-|-|-||||||||||||assert failure: (..\ocaframework\ServiceMgrFactory.cpp:82). (s_svcMgr!= NULL : ServiceMgrFactory::Init must be called before use getServiceMgr()).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 2
    |912bdb93-9087-3774-591a-1dcbc42a843d|2017 06 08 08:22:49:637|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 3
    |dfc5dd8f-8e7a-dad4-8941-420bf6f8ed47|2017 06 08 08:22:49:640|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 4
    |18b273c8-e452-2704-88ad-3b3389d741d7|2017 06 08 08:22:49:644|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 5
    |de10fa87-5bac-1ce4-7abe-ce7dc7615a8c|2017 06 08 08:22:49:647|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 6
    |ce06102f-ed0f-d9e4-ea6a-7ab13007af37|2017 06 08 08:22:49:651|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 7
    |8aa63be4-effe-1814-cbcc-7ee1888a0478|2017 06 08 08:22:49:654|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65:-: TraceLog message 8
    |c665f9df-92c6-0d44-fa47-8d70d73c897f|2017 06 08 08:22:49:658|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\private\sdk\scomobjectbase.h:65). (m_ObjectLocale!=0 : class ATL::CComObject<class CComEventDetails>).
    d:\a42sr32\src\platform.library.common\export\iface\ocalibhelper/typeholder.h:903:-: TraceLog message 9
    |e8293508-fc49-aad4-d95f-93c38e8c5076|2017 06 08 08:22:49:662|+0200|Error| |>>|E| |WebIRichClient|38968|20436|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:48.48:1|WebIRichClient.processDPCommandsEx|localhost:38968:20436.53:1|CqnyCvamr009s8.mIBU_HNI1b|||||||||||assert failure: (d:\a42sr32\src\platform.library.common\export\iface\ocalibhelper/typeholder.h:903). ((newFlag & BITMASK_KIND) == 0 : no message).
    csgenjob.cpp:990:void __thiscall CSCore::GenericJob::Prepare(const class bo_utf8string &): TraceLog message 10
    |0099ab26-d033-e214-ca75-52230bbe087d|2017 06 08 08:22:52:223|+0200|Error| |>=|E|X|WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||Uncaught Exception in SilentScope: CS::DBDriver_Prepare: 0.001
    Error=[Server SYBASET2NE] Incorrect syntax near the keyword 'Confirm'.
    
    csgenjob.cpp:987:void __thiscall CSCore::GenericJob::Prepare(const class bo_utf8string &): TraceLog message 11
    |be17e72a-9e25-91e4-99e2-ffb8d238cee8|2017 06 08 08:22:52:227|+0200|Error| |>=|E|X|WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||Uncaught Exception in SilentScope: CS::GenericJob_Prepare: 0.005
    Error=[Server SYBASET2NE] Incorrect syntax near the keyword 'Confirm'.
    
    csjob.cpp:926:enum ConnectionServer::Status __thiscall CSCore::OpenJob::Describe(const class bo_utf8string &,class ConnectionServer::DescriptionSet &) throw(class ConnectionServer::Error,class std::exception): TraceLog message 12
    |89766324-6574-0634-3b89-52099734678b|2017 06 08 08:22:52:231|+0200|Error| |>=|E|X|WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||Uncaught Exception in SilentScope: CS::OpenJob_Describe: 0.009
    Error=[Server SYBASET2NE] Incorrect syntax near the keyword 'Confirm'.
    
    kc3cdbtbdacs.cpp:371:long __cdecl DoReportCSError(const class ConnectionServer::Error &,const int,const char *const ,const struct ConnectionServer::JobResultSet *const ): TraceLog message 13
    |71eff081-2f7b-f5d4-bb53-255537b6e260|2017 06 08 08:22:52:234|+0200|Error| |>>|E| |WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||**ERROR:C3_dacs:CS::Error : (DBD(1),ID:769) "[Server SYBASET2NE] Incorrect syntax near the keyword 'Confirm'.
    " . [kc3cdbtbdacs.cpp;371]
    kc3CoreEngineImpl.cpp:4538:void __thiscall IECore::kc3CoreEngineImpl::ExecuteActionMDP(const struct IECore::kc3CommandParser::DPCOMMAND &,class std::basic_ostream<char,struct std::char_traits<char> > &,class std::map<long,class std::vector<class IECore::OutputAttachment,class std::allocator<class IECore::OutputAttachment> >,struct std::less<long>,class std::allocator<struct std::pair<long const ,class std::vector<class IECore::OutputAttachment,class std::allocator<class IECore::OutputAttachment> > > > > &): TraceLog message 14
    |c1bb8c23-55eb-0284-ea47-fe31b282604e|2017 06 08 08:22:52:248|+0200|Error| |>>|E| |WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||**ERROR:IECore_kc3CoreEngineImpl:ExecuteActionMDP failed : -2147467259 S(5) [kc3CoreEngineImpl.cpp;4538]
    kc3CoreEngineImpl.cpp:1844:enum IECore::IECoreStatusCode __stdcall IECore::kc3CoreEngineImpl::processDPCommandsEx(const class IECore::UTF8Buffer &,const class std::map<long,class std::vector<class IECore::CommandAttachment,class std::allocator<class IECore::CommandAttachment> >,struct std::less<long>,class std::allocator<struct std::pair<long const ,class std::vector<class IECore::CommandAttachment,class std::allocator<class IECore::CommandAttachment> > > > > &,class std::basic_ostream<char,struct std::char_traits<char> > &,class std::map<long,class std::vector<class IECore::OutputAttachment,class std::allocator<class IECore::OutputAttachment> >,struct std::less<long>,class std::allocator<struct std::pair<long const ,class std::vector<class IECore::OutputAttachment,class std::allocator<class IECore::OutputAttachment> > > > > &): TraceLog message 15
    |cac058b1-68b4-f344-8abc-e54b9a1b67c6|2017 06 08 08:22:52:252|+0200|Error| |>>|E| |WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||**ERROR:IECore_kc3CoreEngineImpl:Caught a BOException: : ExecuteActionMDP failed [kc3CoreEngineImpl.cpp;1844]
    |1ce61ead-14ab-39f4-e849-cea350771e18|2017 06 08 08:22:52:256|+0200|Error| |==|E|X|WebIRichClient|38968|22756|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||Uncaught Exception in SilentScope: IESessionImpl:processDPCommandsEx: 0.099 Args=(Operation="") Vars=(Method Call Parameter Operation="")
    EntityActivityNotifier.cpp:114:__thiscall GenericContainer::EntityActivityNotifierWithTLSContext::~EntityActivityNotifierWithTLSContext(void): TraceLog message 17
    |2df73337-bba0-4f14-69b6-c451be209b8d|2017 06 08 08:22:52:259|+0200|Error| |<<|E|X|WebIRichClient|38968|22756||{|1|1|1|1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||GenericContainer_EntityActivityNotifier:EntityActivityNotifierWithTLSContext_Destructor
    EntityActivityNotifier.cpp:114:__thiscall GenericContainer::EntityActivityNotifierWithTLSContext::~EntityActivityNotifierWithTLSContext(void): TraceLog message 18
    |f70327ae-db6b-9624-9810-f02e864a7161|2017 06 08 08:22:52:262|+0200|Error| |<<|E|X|WebIRichClient|38968|22756||}|1|1|1|1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||GenericContainer_EntityActivityNotifier:EntityActivityNotifierWithTLSContext_Destructor: 0.004
    IESessionImpl.cpp:1189:unsigned long __thiscall IESessionImpl::processDPCommandsEx(const class OBFixSeq<unsigned char> &,const class OBFixSeq<unsigned char> &,enum IEPlugin_TokenMode,const class OBFixSeq<unsigned char> &,const class OBVarSeq<struct IEPlugin_CommandAttachment> &,unsigned char,class OBFixSeq<unsigned char> *&,class OBVarSeq<struct IEPlugin_OutputAttachment> *&): TraceLog message 19
    |045d4c52-7a9d-84e4-e89f-ab956edd67e4|2017 06 08 08:22:52:266|+0200|Error| |>>|E| |WebIRichClient|38968|22756|| |1|2|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||**ERROR:IESessionImpl:**EXCEPTION CAUGHT AT: [IESessionImpl.cpp;1189]
    kctRequestProc.cpp:779:void __thiscall cdztools::RequestProcBasic::generateResult(class OBFixSeq<unsigned char> *&,const char *,const char *,const char *,const unsigned char *,const unsigned char *,class std::basic_istream<char,struct std::char_traits<char> > *,int,bool &): TraceLog message 20
    |cbd9a4f2-6536-3104-3b07-850e5f3c5168|2017 06 08 08:22:52:269|+0200|Error| |>>|E| |WebIRichClient|38968|22756|| |1|2|1|0|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|Webi SDK.CorbaServerImpl.doProcess()|fmstcrbo005:38968:16.63:1|WebIRichClient.processDPCommandsEx|localhost:38968:22756.60:1|CqnyCvamr009s8.mIBU_HNI22|||||||||||**ERROR:RequestProc:user: roo01367, doc: "<unknown>", error stream: <ERRORS>
    <ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="The following database error occurred: [Server SYBASET2NE] Incorrect syntax near the keyword 'Confirm'. . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)" PREFIX="ERR">
    <DEBUGINFO BORESULT="5" FILENAME="kc3cdbtbdacs.cpp" LINEPOSITION="3149" MODULENAME="C3_CS"/>
    <REQUESTINFO COMMANDID="0" COMMANDNAME="Validate custom SQL" DPID="DP0" DPLONGNAME="" DPNAME=""/>
    <REASON>
    <CONTENT>
    </CONTENT>
    </REASON>
    </ERROR>
    </ERRORS>webirichclient-38968-2017-06-08-06-22-04-321-trace.txt
    [kctRequestProc.cpp;779]

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2017 at 01:40 PM

    the issue was solved after applying Patch 7 as suggested by SAP

    SAP Note: 2410657

    Add comment
    10|10000 characters needed characters exceeded