Skip to Content
0

wis 10901 incorrect syntax near keyword confirm - sybase db

May 12, 2017 at 10:50 AM

151

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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 !?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 08, 2017 at 07:26 AM
0

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]


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 16, 2017 at 01:40 PM
0

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

SAP Note: 2410657

Share
10 |10000 characters needed characters left characters exceeded