SQL Anywhere database - I have a problem with ASA 5.5 (error in EventLog, sqlactrs.dll)

Author

I have a problem with ASA 5.5 (error in EventLog, sqlactrs.dll)

Roman Dinnik

2005-06-22, 9:23 am

In EventLog of server i'm have the message:

Open Procedure for service "SQL_ANYWHERE" in DLL
" c:\sybase\sqlany50\w
in32\sqlactrs.dll" failed. Performance data for this
service will not be available. Status code returned is DWORD 0

Wath is problem?

Stephen Rice

2005-06-22, 9:23 am

Roman Dinnik wrote:
> In EventLog of server i'm have the message:
>
> Open Procedure for service "SQL_ANYWHERE" in DLL
> " c:\sybase\sqlany50\w
in32\sqlactrs.dll" failed. Performance data for this
> service will not be available. Status code returned is DWORD 0
>
> Wath is problem?
>
>
>

I snipped this from the public solved cases database...

This error is not produced by SQL Anywhere but instead by the operating
system. The performance monitor is trying to start monitoring all
applications that it has listed in the registry. When it tries to
make a call to SQLACTRS.dll while the engine is not running it is unable
to get performance data.

The workaround would be to delete the registry folder:
HKEY_LOCAL_MACHINE\S
ystem\CurrentControl
Set\Services\SQL_Any
where\Performance

Note that you may no longer be able to access performance data for SQL
Anywhere after making this change.

/steve
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

--- Please Post ---
Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
"Report a bug" are all available on www.ianywhere.com

Breck Carter [TeamSybase]

2005-06-22, 8:23 pm

Could it also be caused by a second instance of the engine starting? I
seem to remember being told only the first one gets to use the
counters, the second one gets the message.

Or it could be a hosed registry... which in my experience is unfixable
without reinstalling Windows.

And if you don't need the counters, you just ignore the message :)

Breck

On 22 Jun 2005 07:20:36 -0700, Stephen Rice <NSsrice@ianywhere.com>
wrote:

>Roman Dinnik wrote:
>
>I snipped this from the public solved cases database...
>
>This error is not produced by SQL Anywhere but instead by the operating
>system. The performance monitor is trying to start monitoring all
>applications that it has listed in the registry. When it tries to
>make a call to SQLACTRS.dll while the engine is not running it is unable
>to get performance data.
>
>The workaround would be to delete the registry folder:
> HKEY_LOCAL_MACHINE\S
ystem\CurrentControl
Set\Services\SQL_Any
where\Performance
>
>
>Note that you may no longer be able to access performance data for SQL
>Anywhere after making this change.
>
>
>/steve

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links