BO Login issue

[former_member596160]

Hi All,

We are having issue with BO from last one month, suddenly we get disconnect from the server and not able to login. When we access Bi launchpad / CMC and after giving user ID/ password it just doesn’t do anything.

In the OS level (Linux) all BO services shows in running state, however when we tried to restart the server using stopserver.sh it hangs. After we restarted CMS db BO started working again, this happened 3 times in a month.

First time all BO server ( prod, dev, pre and test ) had the issue, then 2^nd and 3^rd time Prod and Dev server had the issue, other two were running.

We have raised with SAP and they said issue doesn’t seems to be with BO however with infra, however AWS team said on the OS everything was normal and they don’t see any logs also which indicates issue.

Then SAP support team said, it’s a bug with Prod Hana DB , however Dev DB looks fine and this statement is confusing as we having issue with almost all the servers.

Hana DB team observed that at the time of issue all BO session were occupied in Hana DB and in the logs they saw one query which caused the issue:

48066[thr=7491]: SqlExecutor, TID: 24, UTID: 127874146, CID: 246259, LCID: 246259, parent: ---, SQLUserName: "VIP_CMS", AppUserName: "", AppName: "", ConnectionContext: 246259 {LDBID: 2, LCID: 246259}, StatementContext: (1) 1057676641415705 {Parent: 246259, SessionContext: {ObjHdl: 139829205514240, CID: 246259, LCID: 246259, User: "VIP_CMS", Schema: "VIP_CMS, Version: 8, ContextID: 46536}}, type: "SqlExecutor", method: "", detail: "", command: "{SQL: INSERT INTO FRONTIER2 SELECT DISTINCT RELTABLE.CHILDID, 10, '37B-2B8478003260' FROM FRONTIER, (SELECT 619 RELATIONSHIPID, ParentID PARENTID, ObjectID CHILDID, 0 ISMEMBER, 0 ORDINAL FROM VIP_CMS.CMS_InfoObjects7) RELTABLE WHERE FRONTIER.OBJECTID = RELTABLE.PARENTID AND RELTABLE.RELATIONSHIPID IN (619) AND

However if I run the query from QB, it says invalid query.

Can someone please suggest what else can we check or what could be the issue.

BO version: BO4.2 SP05 Patch 3 (Upgraded in Feb)

Hana version: Hana 1.0 SPS9

Regards,

Garima

[LepreuxLoic]

Hi,

This looks similar to issue fixed some time ago about search of objects in CMC with HANA as System database: https://launchpad.support.sap.com/#/notes/2697723
In this case performance can be impacted, and if HANA gets slowed down too much then other activity in BI Suite will freeze as well.

It's normal you cannot execute a SQL query directly in QueryBuilder. You have first to find which CMS Query corresponds to SQL sent to HANA, and this one you can check in QB.

Regards,
Loic

[former_member596160]

Hi Loic,

Thanks for your reply!

I will check the note , however can you tell me how can I check :

It's normal you cannot execute a SQL query directly in QueryBuilder. You have first to find which CMS Query corresponds to SQL sent to HANA, and this one you can check in QB.

I am not very good with query builder ☹

Thanks,

Garima

[LepreuxLoic]

Hi Garima,

It can be difficult to identify a CMS Query from a SQL Query, it's much easier the other way ...

You could configure your Central Management Server to output timing for all queries it receives, and you will likely spot queries that take long time and then investigate those. (KBA: https://launchpad.support.sap.com/#/notes/1207172)

To investigate where time is spent in a CMS Query, you can use QueryBuilder to execute same statement just by adding "SHOW STATS" at the end of query. It will return many statistics from execution in CMS, including SQL Query generated and how long it took to execute.

You could also find what kind of relationship is referenced in piece of SQL found by HANA team, there is a '619' which is an InfoObject in your CMS that will maybe tell us more about which kind of operation is related. (you can execute in QB: "SELECT STATIC FROM CI_APPOBJECTS, CI_INFOOBJECTS, CI_SYSTEMOBJECTS WHERE SI_ID=619")

Regards,

Loic

[former_member604952]

1. Hostname/IP address and request port binding in CMS, IFRS, OFRS might help if there is a communication issue.

2. Query in error message shows Insert Into temp table, so this does not seem related to user auth check. Check which report/schedule is running when the DB sessions are occupied again to see if this is blocking DB resources.

Will come up with more suggestions later. Meanwhile give a try for the above.

Regards,

Chetan

[ayman_salem]

check if you are using the supported HANA version for CMS.

according to PAM, HANA 1.0 SPS09 should be Revision 92 and above (see BI 4.2 SP05 - PAM page 13)

[former_member596160]

Hello Aymen,

Thanks for the reply!

Can you tell me what does it meant revision 92 and above?

Regards,

Garima

[ayman_salem]

...

see Note 2021789 for HANA revision details