Skip to Content
author's profile photo Former Member
Former Member

sp_helpdb fails with Msg 11021

Hi.

When trying to run sp_helpdb with arguments, some info are missing and returns "

Msg 11021, Level 16, State 2"

Appreciate any help with this.

1> sp_helpdb master
2> go
name db_size owner dbid created durability status
------ ------------- ----- ---- ------------ ---------- ------------------
master 13,0 MB sa 1 Dec 09, 2009 full mixed log and data

(1 row affected)
Msg 11021, Level 16, State 2:
Server 'FNR', Line 1:
Function STR invoked with wrong number or type of argument(s).
device segment
------ ----------
master default
master logsegment
master system
(return status = 0)


1> select @@version
2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.5/EBF 17336 SMP/P/Sun_svr4/OS 5.8/ase155/2391/64-bit/FBO/Tue Nov 10 01:27:55 2009

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 30, 2019 at 05:00 PM

    Hi Paul,

    This is a very old ASE version, I have to recommend upgrading it to 16.0 on general (and as it turns out, specific) principles.

    There were a couple of reports of this error 8-10 years ago and a bug (Cr 646295) was opened for it, but has not been fixed (probably because the issue has not been reported on later releases). The bug is also strange, with conversion between FLOAT and NUMERIC datatypes appearing to be somehow mysteriously bound up with the PCI module (used to enable server-side JAVA) and (possibly) a client running on windows with a region setting of "German".

    Suggested workarounds for the CR were:

    Disable PCI by sp_configure "enable pci", 0
    OR Don't use German Germany in region setting in the pc OR Setup the "Decimal symbol" to '.' as opposed to ',' in the pc OR Boot ASE with trace flag 4065

    Traceflag 4065 causes ASE to use an alternate method for converting FLOAT to NUMERIC.

    If you do upgrade ASE to 15.7 or higher and still experience the issue, please open a support incident.

    Cheers,
    Bret Halford
    Support Architect, ASE

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.