• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

CMDB explorer - EV 2016.1.300 - error 500
#1
Hi guys,

EV 2016.1.300 - when displaying CI (whater type) in CMDB Explorer (flash version) - I'm getting error:

Message (Detail): NetConnection.Call.Failed: HTTP: Status 500
Message (string): error
Message (Code): Channel.Call.Failed
Source: "PHPInterfaces"
Operation: "callSMOMethod"
Body: (Array) #0
[0] "smo_data_server_class"
[1] "ExecuteQueriesWithDomain"
[2] (Array) #1
  [0] "SELECT A.ASSET_ID,....

Screenshot is attached in document.

SQL query (also attached) is giving results nice and quick when run on the database.

At the same time in JavaSc CMDB Explorer - is working fine,so with &cmdbjs=true - is sort of workaround.
But all baselines - old ones -not working, and not showing.

Tried: 
different apachi front server
different user
differet client browsers and PCs
restarted SMO services, front services... 
DB indexes

No help...

This issue first showed in UAT environment, and as more changes where made not sure exactly after what change exactly. Loads of CIs where imported, and loads of CI relationships. But no clue when this happened.

So, I did same set of changes in another envrironment - carefully checking Cmdb explorer - and it worked for all changes.

But - when I did the same thing in PROD environment - error appered after importing set of 12 000relationsihps.
Importing set of 5 relationships - worked fine, but full set of 12 000 relationships caused errors.

DB indexes were checked, and no luck.

MSSQL log - is clear and not errors related to time of CMDB explorer are recorded.

Does anyone have any idea what might be the cause?
Even better  -how to fix it :-)?

doktabar, proud to be a member of EV CONNECT FORUM since Nov 2015.

#2
(02-15-2019, 09:13 AM)doktabar Wrote: Hi guys,

EV 2016.1.300 - when displaying CI (whater type) in CMDB Explorer (flash version) - I'm getting error:

Message (Detail): NetConnection.Call.Failed: HTTP: Status 500
Message (string): error
Message (Code): Channel.Call.Failed
Source: "PHPInterfaces"
Operation: "callSMOMethod"
Body: (Array) #0
[0] "smo_data_server_class"
[1] "ExecuteQueriesWithDomain"
[2] (Array) #1
  [0] "SELECT A.ASSET_ID,....

Screenshot is attached in document.

SQL query (also attached) is giving results nice and quick when run on the database.

At the same time in JavaSc CMDB Explorer - is working fine,so with &cmdbjs=true - is sort of workaround.
But all baselines - old ones -not working, and not showing.

Tried: 
different apachi front server
different user
differet client browsers and PCs
restarted SMO services, front services... 
DB indexes

No help...

This issue first showed in UAT environment, and as more changes where made not sure exactly after what change exactly. Loads of CIs where imported, and loads of CI relationships. But no clue when this happened.

So, I did same set of changes in another envrironment - carefully checking Cmdb explorer - and it worked for all changes.

But - when I did the same thing in PROD environment - error appered after importing set of 12 000relationsihps.
Importing set of 5 relationships - worked fine, but full set of 12 000 relationships caused errors.

DB indexes were checked, and no luck.

MSSQL log - is clear and not errors related to time of CMDB explorer are recorded.

Does anyone have any idea what might be the cause?
Even better  -how to fix it :-)?

Hello,
Stop using CMDB in Flash, use CMDB in javascript (add &cmdbjs=yes at the end of URL)

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#3
We are aware of that workaround (as posted above)

What about old baselines?
How to make EV using JS link by default whenever opens CMDB explorer?
Are there any limitations in number of relationships that can be displayed in Flash?
How was that working for other companies before JS?
doktabar, proud to be a member of EV CONNECT FORUM since Nov 2015.

#4
(02-18-2019, 07:22 AM)doktabar Wrote: We are aware of that workaround (as posted above)

What about old baselines?
How to make EV using JS link by default whenever opens CMDB explorer?
Are there any limitations in number of relationships that can be displayed in Flash?
How was that working for other companies before JS?

Javascript is not a workaround it's a replacement of Flash

Quote:What about old baselines?
 Old baselines (save in flash) are restore/compatible

Quote:How to make EV using JS link by default whenever opens CMDB explorer?
Editor should replace Flash (or provide a parameter) in futur version 
https://wiki.easyvista.com/xwiki/bin/vie...DB+-+Graph


Quote:The CMDB graph is being rewritten in JavaScript. It is provided in a beta version in parallel with the current version described on this page.
To use the beta version, add the parameter cmdbjs=1 in the URL.
Note: As this is a beta version, it is not recommended to activate it on production bases.



Quote:Are there any limitations in number of relationships that can be displayed in Flash?
Don't know (i'm not editor), try to active in other parameter "{CMDB} CMDB graph: Load the table containing the relationships at startup"

Quote:How was that working for other companies before JS?
With few relationship or small number of levels displayed

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#5
Abbe,

Thanks! Your post was helpful-and pointed me in the right direction.

Solution for not showing CMDB explorer lies indeed in Other paremeters.

But it is not as I would expected how things work:

"{CMDB} CMDB graph: Load the table containing the relationships at startup"
"Used to improve performance when displaying the CMDB graph by loading the list of relationships between CIs when starting ev|SM. Note: CONFIGURATION_ITEM_LINK table."

Is the key - if you put TRUE, it will NOT work, but if you put FALSE it will work for more than approx. 10 000 relations.
This thing would/should notice anyone seriously using EV for Configuration mng since version 2016.

Maybe it's just me...Anyway - thats workaround....
doktabar, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)