V8 - Crystal Runtime XI R2 not Releasing Sessions

Yahoo Archive
1
Update:

The session are not hanging. They will close on their own after about 60
minutes. Epicor's workaround was to allow more server sessions in the
database config so that don't run out and get the error. Problem is each
session takes 64Mb of RAM while it is open.

> Could you tell me how to kill the ODBC connections in Promon?

You can kill them under the shutdown database options, but I would think it
would be hard to tell which session was which. They will close on their own
if you don't run out of resources first.

> How to get to Promon and the steps required?

Sure. Create a shortcut on your server desktop as follows:

E:\epicor\oe100b\bin\_mprshut.exe -0 e:\epicor\mfgsys80\db\mfgsys

Hope that helps!

Brian
2
We are having a problem when running reports based on Crystal runtime XI R2
after upgrading our test database to the 808 patch. After the report is run,
the ODBC session is not closed. Thus after three reports our server runs out
of "resources". We can fix it by killing the odbc user sessions in promon.

Has anyone else seen this? We spent a lot of time with Epicor support and
they don't seem to have an answer yet. We suspect the program is with the
Crystal runtime and not Progress. Support is still trying to figure out the
problem, but in the meantime I'm wondering if we are the only ones seeing
this problem?

Thanks
Brian


[Non-text portions of this message have been removed]
3
We are also having the same problem. And like you have not gotten a solution From Epicor. I have been running reports for people as they need them, but that will get old real fast.
Could you tell me how to kill the ODBC connections in Promon? How to get to Promon and the steps required? I'd appreciate any help.

Thanks
Melissa Hietala
UMC, Inc.

Brian Boyes <Brian.Boyes@...> wrote:
We are having a problem when running reports based on Crystal runtime XI R2
after upgrading our test database to the 808 patch. After the report is run,
the ODBC session is not closed. Thus after three reports our server runs out
of "resources". We can fix it by killing the odbc user sessions in promon.

Has anyone else seen this? We spent a lot of time with Epicor support and
they don't seem to have an answer yet. We suspect the program is with the
Crystal runtime and not Progress. Support is still trying to figure out the
problem, but in the meantime I'm wondering if we are the only ones seeing
this problem?

Thanks
Brian


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



SPONSORED LINKS
Manufacturing software Membership database software Database mortgage software Pda database software Database management software Database marketing software

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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





---------------------------------
How low will we go? Check out Yahoo! MessengerÂ’s low PC-to-Phone call rates.

[Non-text portions of this message have been removed]