topic Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error in Active IQ Unified Manager Discussions

wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

scheckel — Thu, 05 Jun 2025 06:08:29 GMT

Hi,

i am running SLES 11 and getting errors on when setting up a wfa user with wfa_ocsetup.sh

cat /proc/version

Linux version 3.0.58-0.6.6-default (geeko@buildhost) (gcc version 4.3.4 [gcc-4_3-branch revision 152973] (SUSE Linux) ) #1 SMP Tue Feb 19 11:07:00 UTC 2013 (1576ecd)

vml3978:/tmp # cat /etc/SuSE-release

SUSE Linux Enterprise Server 11 (x86_64)

VERSION = 11

PATCHLEVEL = 2

vml3978:/tmp # ./wfa_ocsetup.sh /opt/NTAPdfm/java

Verifying archive integrity... All good.

Uncompressing WFA OnCommand Setup.....

*********************** Welcome to OnCommand Setup Utility for Linux ************************

* This utility enables remote read-only access to OnCommand(DFM) database

tables, access is granted only to non-sensitive tables of DFM schema

* It is recommended you override the default user credentials, if you do not

override, setup will grant access to the default user

* This utility requires a valid Java Runtime Environment(JRE)(6 or higher)

* Usage: './wfa_ocsetup.sh <PATH-TO-JRE>'

a. For OnCommand(DFM) versions which ship with Java (OC 5.0 or higher) you

can point the installer to the 'java' folder in your DFM installation

Example: './wfa_ocsetup.sh /opt/NTAPdfm/java'

b. For DFM versions which do not ship with Java (DFM 4.0.x or lower), you have

to install Java Runtime Environment separately, and point to that JRE

Example: './wfa_ocsetup.sh /usr/lib/jvm/default-java/jre'

*********************************************************************************************

******************** Please override the default credentials below **************************

Override DB Username [wfa] :

Override DB Password :

Default credentials will be used if not overridden

**************************** Start of response from the database ****************************

>>> Connecting to database

<<< Connected

=== Failed to drop user '' SQL Anywhere Error -154: Wrong number of parameters to function 'sp_droplogin'

Exception in thread "main" com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near ',' on line 1

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)

at com.netapp.wfa.ocsetup.a.c(Unknown Source)

at com.netapp.wfa.ocsetup.Main.main(Unknown Source)

***************************** End of response from the database *****************************

**************************************** End of Setup ***************************************

Can you please have a look.

Best wishes,

Markus

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

bdave — Tue, 05 Mar 2013 14:42:39 GMT

Hi Markus,

Thanks for sending over the details. Failed to drop user is normally okay because most of the time the user didn't exist anyway. The fact that the user is showing up as '' (blank instead of 'wfa'), makes me think this might be a bug with the script not handling the default choices well. Can you try re-running it and plugging in a user name and password, and let us know if that works? Be sure to remember what you entered so you can set up the datasource in WFA correctly.

Thanks,

Dave

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

sinhaa — Tue, 05 Mar 2013 17:11:40 GMT

If the user doesn't exits, it gives an expected error, but still the new user gets created successfully. From the above details I see that no user has been created and the setup has thrown an unexpected exception. If the user doesn't exits the setup shows the follwoing:

=== Failed to drop user 'abhishek' SQL Anywhere Error -140: User ID 'abhishek' does not exist
=== Created user 'abhishek'
>>> Granting access
<<< Granted access

***************************** End of response from the database *****************************

**************************************** End of Setup ***************************************

Re-run the set-up, it should perhaps work.

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

pitrakou — Mon, 18 Mar 2013 10:46:17 GMT

Hi just ran into this error too, and this happens when you do not type in a user account at the prompt:

******************** Please override the default credentials below **************************

Override DB Username [wfa] :

You get a different error if the account does not exist.

So yes I think it's a error in the script that needs to be corrected so that it can use the account in the parenthesis []

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

sinhaa — Mon, 18 Mar 2013 11:54:26 GMT

Hi pitrakou,

Are you also using the SUSE linux ? Can you post the Error message?

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

pitrakou — Mon, 18 Mar 2013 11:58:28 GMT

Linux version 2.6.18-308.11.1.el5 (mockbuild@hs20-bc2-3.build.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-52))

-bash-3.2$ ./wfa_ocsetup.sh /sbcimp/run/tp/sun/jre/v1.7.0_15-64bit/

Verifying archive integrity... All good.

Uncompressing WFA OnCommand Setup.....

*********************** Welcome to OnCommand Setup Utility for Linux ************************

* This utility enables remote read-only access to OnCommand(DFM) database

tables, access is granted only to non-sensitive tables of DFM schema

* It is recommended you override the default user credentials, if you do not

override, setup will grant access to the default user

* This utility requires a valid Java Runtime Environment(JRE)(6 or higher)

* Usage: './wfa_ocsetup.sh <PATH-TO-JRE>'

a. For OnCommand(DFM) versions which ship with Java (OC 5.0 or higher) you

can point the installer to the 'java' folder in your DFM installation

Example: './wfa_ocsetup.sh /opt/NTAPdfm/java'

b. For DFM versions which do not ship with Java (DFM 4.0.x or lower), you have

to install Java Runtime Environment separately, and point to that JRE

Example: './wfa_ocsetup.sh /usr/lib/jvm/default-java/jre'

*********************************************************************************************

******************** Please override the default credentials below **************************

Override DB Username [wfa] :

Override DB Password :

Default credentials will be used if not overridden

**************************** Start of response from the database ****************************

>>> Connecting to database

<<< Connected

=== Failed to drop user '' SQL Anywhere Error -154: Wrong number of parameters to function 'sp_droplogin'

Exception in thread "main" com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near ',' on line 1

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)

at com.netapp.wfa.ocsetup.a.c(Unknown Source)

at com.netapp.wfa.ocsetup.Main.main(Unknown Source)

***************************** End of response from the database *****************************

**************************************** End of Setup ***************************************

If I specify an account it completes without error:

-bash-3.2$ ./wfa_ocsetup.sh /sbcimp/run/tp/sun/jre/v1.7.0_15-64bit/

Verifying archive integrity... All good.

Uncompressing WFA OnCommand Setup.....

*********************** Welcome to OnCommand Setup Utility for Linux ************************

* This utility enables remote read-only access to OnCommand(DFM) database

tables, access is granted only to non-sensitive tables of DFM schema

* It is recommended you override the default user credentials, if you do not

override, setup will grant access to the default user

* This utility requires a valid Java Runtime Environment(JRE)(6 or higher)

* Usage: './wfa_ocsetup.sh <PATH-TO-JRE>'

a. For OnCommand(DFM) versions which ship with Java (OC 5.0 or higher) you

can point the installer to the 'java' folder in your DFM installation

Example: './wfa_ocsetup.sh /opt/NTAPdfm/java'

b. For DFM versions which do not ship with Java (DFM 4.0.x or lower), you have

to install Java Runtime Environment separately, and point to that JRE

Example: './wfa_ocsetup.sh /usr/lib/jvm/default-java/jre'

*********************************************************************************************

******************** Please override the default credentials below **************************

Override DB Username [wfa] :wfa

Override DB Password :

Default credentials will be used if not overridden

**************************** Start of response from the database ****************************

>>> Connecting to database

<<< Connected

*** Dropped existing 'wfa' user

=== Created user 'wfa'

>>> Granting access

<<< Granted access

***************************** End of response from the database *****************************

**************************************** End of Setup ***************************************

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

sinhaa — Mon, 18 Mar 2013 12:09:42 GMT

Thank you. This issue is being looked at and we shall get back to you as soon as possible.

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

sputrevu — Mon, 18 Mar 2013 13:44:32 GMT

Thanks a lot Tony !

From Tony :

Just did a bit more testing and this is what happens:

If I just do a return and return i.e. blank username and password, then it runs OK and I get the expected results
Type in wfa as the account and wfa as the password, it runs OK, and I get the expected results
If I leave the account blank (just do a return) and then type in a password, I get the same error message before.

I'm running Red Hat 4.1.2-52)

Issue is with the script handling case 3.

We will fix that.

Sandeep

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

bdave — Tue, 30 Apr 2013 16:34:32 GMT

Hi Sandeep, Abishek,

Was this fixed in WFA 2.0.1?

Thanks,

Dave

Re: wfa_ocsetup.sh on OC 5.1 Failed to drop user '' SQL Anywhere Error

sinhaa — Wed, 01 May 2013 03:07:06 GMT

Dave,

Its not fixed in 2.0.1 and shall be fixed for 2.1.