Skip to Content
1
Former Member
Feb 12, 2014 at 02:48 AM

Windows 2012 , BO4.1 Sp2, WEBI Server In Loop

144 Views

Product :- SAP BO4.1 Sp2 Edge full build

CMS DB:- SQL Server 2012

OS:- Windows 2012 Standard

Issue:-

Not able to view sample reports published with BO

It seems that at looking at WEBI logs, the WEBI server is trying to refresh every DP in every universe unnecessarily(even if report is not getting viewed/scheduled)Including audit report convertion universe and monitoring universe as well.This process goes on running

.I can se the no of documents count of WEBI to 0 on WEBI matrics...

I Checked no one is logged in to BO, No schedules are running

this is happening on all installation on Windows2012 i.e 2 dev boexes and 2 pprd boxes...in WEBI logs the following gets repeated for ever DP.

EVENIF NOTHING IS RUNNING AT BACK END I CAN SEE THE WEBI SERVER FLOODED WITH THIS ERRORS....

<ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="Database error: (CS) &quot;Java Class not found in classpath : org.apache.derby.jdbc.EmbeddedDriver&quot; . (IES 10901)" PREFIX="ERR">

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

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

<REASON>

<CONTENT>

</CONTENT>

</REASON>

</ERROR>

</ERRORS>

-----

<ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="Database error: (CS) &quot;Java Class not found in classpath : org.apache.derby.jdbc.EmbeddedDriver&quot; . (IES 10901)" PREFIX="ERR">

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

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

<REASON>

<CONTENT>

</CONTENT>

</REASON>

</ERROR>

</ERRORS>

----------

: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 439

|e4ba1371-739f-cdc4-e898-feadbd96b6c2|2014 02 11 11:44:59:750|-0800|Error| |==|E| |webiserver_BODEV1.WebIntelligenceProcessingServer| 6368|8068|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|webiserver_BODEV1.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:6368:8068.1301:1|ClhQdAjYv0_ip5xAKxvFlr82cdf||||||||||| |Oracle OCI |Oracle 10 |JobId:97656176 |ENTER OCIErrorGet

dvoid * 0x000000000C4BBD50

ub4 1

OraText * 0x0000000000000000

sb4 * 0x0000000009046540

OraText * 0x0000000009046630

ub4 1023

ub4 2

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 440

|0b259581-f4b2-cee4-6aa4-e868ceb2c742|2014 02 11 11:44:59:750|-0800|Error| |==|E| |webiserver_BODEV1.WebIntelligenceProcessingServer| 6368|8068|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|webiserver_BODEV1.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:6368:8068.1301:1|ClhQdAjYv0_ip5xAKxvFlr82cdf||||||||||| |Oracle OCI |Oracle 10 |JobId:97656176 |EXIT OCIErrorGet with return code 0 (OCI_SUCCESS)

dvoid * 0x000000000C4BBD50

ub4 1

OraText * 0x0000000000000000

sb4 * 0x0000000009046540 (12154)

OraText * 0x0000000009046630 [ORA-12154: TNS:could not resolve the connect identifier specified

]

ub4 1023

ub4 2

csjob.cpp:480:void __cdecl CSCore::OpenJob::Initialize(void) throw(class ConnectionServer::Error,class std::exception): TraceLog message 441

|b7e035b9-0ddb-4ba4-58c7-1c1bc8112bb6|2014 02 11 11:44:59:750|-0800|Error| |>=|E|X|webiserver_BODEV1.WebIntelligenceProcessingServer| 6368|8068|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|webiserver_BODEV1.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:6368:8068.1301:1|ClhQdAjYv0_ip5xAKxvFlr82cdf|||||||||||Uncaught Exception in SilentScope: CS::DBDriver_Connect: 9.329

Error=ORA-12154: TNS:could not resolve the connect identifier specified

csjob.cpp:464:void __cdecl CSCore::OpenJob::Initialize(void) throw(class ConnectionServer::Error,class std::exception): TraceLog message 442

|fe2322f3-9cea-f264-8b17-fca7d65c65f7|2014 02 11 11:44:59:750|-0800|Error| |>=|E|X|webiserver_BODEV1.WebIntelligenceProcessingServer| 6368|8068|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|Webi SDK.CorbaServerImpl.doProcess()|USLI-DWAG-BO01:6984:1053.13122:1|webiserver_BODEV1.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:6368:8068.1301:1|ClhQdAjYv0_ip5xAKxvFlr82cdf|||||||||||Uncaught Exception in SilentScope: CS::OpenJob_Initialize: 9.329

Error=ORA-12154: TNS:could not resolve the connect identifier specified

-------------------

<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="2144" MODULENAME="C3_CS"/>

<REQUESTINFO COMMANDID="0" COMMANDNAME="Refresh batch" DPID="DP0" DPLONGNAME="Query 1 - Report Conversion Tool Audit Universe" DPNAME="Query 1"/>

<REASON>

<CONTENT>

</CONTENT>

</REASON>

</ERROR>

</ERRORS>