Error trying to execute a CABI report (IES 10901) (WIS 10901)

Document ID : KB000006051
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When trying to execute a CABI report the following error appear:

odbc 1.JPG
This behavior occurs time to time and no report can be ran until restart CABI services. Then reports can be executed again.

 

In logs webi logs appear the following:

 

|2b8e5ed9-ae61-dd04-bb33-ad094ea741f3|2017 02 10 23:52:30:928|-0500|Error| |>>|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|1300|| |1|12|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408025:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408025:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:1300.40757:1|Cm9cYKpzFE3rk8OK8sJAKdc3707b|||||||||||**ERROR:RequestProc:user: System Account, doc: "<unknown>", error stream: <ERRORS>

<ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="Database error: A database error has occured. (IES 10901)" PREFIX="ERR">

<DEBUGINFO BORESULT="5" FILENAME="kc3cdbtbdacs.cpp" LINEPOSITION="2728" MODULENAME="C3_CS"/>

<REQUESTINFO COMMANDID="0" COMMANDNAME="Refresh batch" DPID="DP0" DPLONGNAME="Query 1 - SUNARP" DPNAME="Query 1"/>

<REASON>

<CONTENT>

</CONTENT>

</REASON>

</ERROR>

</ERRORS>

 [kctRequestProc.cpp;777]

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4122

|00800359-8331-c404-faaa-2244218c298f|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |ENTER SQLGetDiagRec

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    1

        SQLTCHAR *    0x0000000031366480

        SQLINTEGER *    0x0000000031366364

        SQLTCHAR *    0x0000000031366490

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4123

|118bb429-26aa-eda4-18c5-9aceb7dad0fc|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    1

        SQLTCHAR *    0x0000000031366480 [01000]

        SQLINTEGER *    0x0000000031366364 (5701)

        SQLTCHAR *    0x0000000031366490 [[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'mdb'.]

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360 (81)

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4124

|2bd49d4e-4efc-bda4-d9e1-a93c77b47d91|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |ENTER SQLGetDiagRec

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    2

        SQLTCHAR *    0x0000000031366480

        SQLINTEGER *    0x0000000031366364

        SQLTCHAR *    0x0000000031366490

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4125

|736e5f14-f679-8aa4-3b7a-70125a683b62|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    2

        SQLTCHAR *    0x0000000031366480 [01000]

        SQLINTEGER *    0x0000000031366364 (5703)

        SQLTCHAR *    0x0000000031366490 [[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360 (86)

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4126

|8d819625-3da6-e9e4-5aee-2cf142b66615|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |ENTER SQLGetDiagRec

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    3

        SQLTCHAR *    0x0000000031366480

        SQLINTEGER *    0x0000000031366364

        SQLTCHAR *    0x0000000031366490

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4127

|d1800989-21d5-51d4-fbb2-dd8a8ccdf6a4|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |EXIT SQLGetDiagRec with return code 100(SQL_NO_DATA)

        SQLSMALLINT    2

        SQLHANDLE    0x0000000006559BD0

        SQLSMALLINT    3

        SQLTCHAR *    0x0000000031366480 [01000]

        SQLINTEGER *    0x0000000031366364 (5703)

        SQLTCHAR *    0x0000000031366490 [[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366360 (86)

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4128

|a5313010-d9b2-55d4-9a68-0243d4a49951|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |ENTER SQLGetDiagRec

        SQLSMALLINT    3

        SQLHANDLE    0x000000000655D940

        SQLSMALLINT    1

        SQLTCHAR *    0x0000000031366A90

        SQLINTEGER *    0x0000000031366974

        SQLTCHAR *    0x0000000031366AA0

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366970

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4129

|abb9fbfa-7b5a-ab54-2b39-362bde379205|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)

        SQLSMALLINT    3

        SQLHANDLE    0x000000000655D940

        SQLSMALLINT    1

        SQLTCHAR *    0x0000000031366A90 [42S02]

        SQLINTEGER *    0x0000000031366974 (208)

        SQLTCHAR *    0x0000000031366AA0 [[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'View_Tickets_Todos_CAM'.]

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366970 (92)

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4130

|2dd324ff-7241-dc24-aa83-c3fed5f1d000|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |ENTER SQLGetDiagRec

        SQLSMALLINT    3

        SQLHANDLE    0x000000000655D940

        SQLSMALLINT    2

        SQLTCHAR *    0x0000000031366A90

        SQLINTEGER *    0x0000000031366974

        SQLTCHAR *    0x0000000031366AA0

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366970

tracemgr.cpp:358:void __cdecl TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4131

|795aeead-929d-9ed4-5af1-5b247883cc31|2017 02 10 23:52:31:006|-0500|Error| |==|E| |webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer| 7100|8808|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|Webi SDK.CorbaServerImpl.doProcess()|<SERVER_NAME>:9212:2754.408036:1|webiserver_<SERVER_NAME>.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:7100:8808.40761:1|Cm9cYKpzFE3rk8OK8sJAKdc37080||||||||||| |ODBC |MS SQL Server 2012 |JobId:562955120 |EXIT SQLGetDiagRec with return code 100(SQL_NO_DATA)

        SQLSMALLINT    3

        SQLHANDLE    0x000000000655D940

        SQLSMALLINT    2

        SQLTCHAR *    0x0000000031366A90 [42S02]

        SQLINTEGER *    0x0000000031366974 (208)

        SQLTCHAR *    0x0000000031366AA0 [[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'View_Tickets_Todos_CAM'.]

        SQLSMALLINT    513

        SQLSMALLINT *    0x0000000031366970 (0)

csgenjob.cpp:990:void __cdecl CSCore::GenericJob::Prepare(const class bo_utf8string &): TraceLog message 4132




Environment:
Product :- CABI 4.1 Sp3SDM 14.1.XCMS DB:- SQL Server 2008/12OS:- Windows 2008 Standard; Windows 2012 Standard
Cause:

In platform search it try to create index on every WEBI report objects for that, it open a report via WEBI server and look for DP(*) that time uses connection as well so as indexing on and if one of the connection is having problem WEBI will go in loop to try to chase for it;  also after some time the same process to index it and goes on toss

Note(*): DP stands for 'Data Provider' aka a query.

Resolution:

Go to CMC->application->Platform Search Application->Click Stop Indexing
In Crawling Frequency select "schedule option"
Click on-> Save and close

Additional Information:

SAP Community