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

[Former Member]

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>

[Former Member · Accepted solution]

It was platform search that was putting WEBI on toss..

Go to CMC->application->Platform Search Application->Click Stop Indexing

In Crawling Frequency select schedule option-> Save and close

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 and also after some time the same process to index it and goes on toss….

[Former Member · Accepted solution]

Thank you for sharing the information.

Really helpful.

[Former Member]

Hello Amol,

Which  Drive is your installation directory ?

Is SIA running ?

1945071 - Web Intelligence does not function if installing BI 4.x in a drive other than the default C: drive on Windows Server

2012

[Former Member]

Hello Dharmendra,

This note is not matching...as some time once in 20 request , I am able to see one report. Also I am not getting any error message in infoview....moreover one of the node I have installed BO in C drive but still no success.

Thank You,

Amol

[Former Member]

Hi Amol,

We can see there is a message "Error=ORA-12154: TNS:could not resolve the connect identifier specified"

The message could possibly be related with connection server as well. Have you been successfull in checking the logs of Connection server? Also it would be important to look into the CMS traces as all communication has to be validated by CMS db.

What would be the performance of the system during the time, any spikes observed in CPU usage. Check the cpu utilization for wips by comparing the PID of WIPS in CMC and taskmanager.

At the same time end-to-end tracing would help a lot. Have a look in the Document

[Former Member]

In addition to this I have reason to believe that the software downloaded is not complete. This is be3cause you are facing the same scenario in all servers.

So try to redownload the package and perform the installation.

[Sriram2009]

Hi Amol

Kindly refer the SAP Notes

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

1204916 - Error: "ORA-12154" when connecting to Oracle from a Windows 64-bit platform

1257937 - Error: "ORA-12154: TNS: Listener could not resolve service_name given in connect descripto...

Regards

Ram

[Former Member]

I feel some problem with BO as software downlaod is correct.....

the question is even if no one is getting logged in still why WEBI is going in loop to execute every data provider query in backend

at CMS trace it says deadlock at database thats again a different issue all together.......

[Former Member]

Hi Amol,

What about the Connection server? The logs clearly mention an issue with Connection.

sjob.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

Hence I suspect there can be only be 3 scenarios, here we have a corruption in BO corba stream which does seem to be due to presently downloaded software as the behavior has been found across the landscape.

Or else we have an issue with drivers installed.

Or issue with firewall / anti-virus (which seems to be remote, cause I believe you have already taken care of that )

We can try options as below:

1. Re-install drivers.

2. Perform a repair of the installation.

Still an end to end trace would give us better results.

May be we can try to create new CNS / WIPS and disable the original servers in one of the box and see the behavior.