iGrid and database connection loss

[Former Member]

Hello,

We have an irpt page with an iGrid that refreshes automatically every 4 seconds.

This grid shows data read from a SQL Server query, and the page is constantly displayed on an industrial monitor

I found that after a couple of days, the iGrid seems to loose the connection to the database, and, even if the query returns some data, on the iGrid you can't see either the SQL result or the name of the column of the grid.

Instead, you see just a couple of hyphens like '--'

If you reopen the page everything is good.

MII 12.0.8, Internet Explorer 6

How do you suggest to procede? To open a ticket to SAP?

It's really important to us not to have to reload the page.

Thank you in advance.

[jamie_cawley]

Could be your session expiring, did you look in the log files for an error?

Jamie

[Former Member]

Shouldn't the igrid keep the session always alive? It constantly refreshes so I don't expect the session expires...

[jamie_cawley]

That will keep your mii session active, but you still have a netweaver ticket that is set to expire after 8 hours by default. You should see this in the logs.

Jamie

[Former Member]

Thank you Jamie, I didn't know the netweaver ticket. Do you know how to manage the netweaver ticket in order to prevent it to expire after 8 hours?

[jamie_cawley]

It can be modified in the config tool under Services u2013 com.sap.security.core.ume.service u2013 login.ticket_lifetime. Not sure if you can turn it off, I would recommend posting a message in the netweaver forum.

Jamie