Skip to content

[Error 8017] [SQLState 28000] The UserId, Password or Account is invalid

ERROR:
Your lab group has not been created. [Teradata Database] [TeraJDBC 15.10.00.09] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

DESCRIPTION:
You may see above error while creating a new datalab group in viewpoint.

ISSUE:
You will see this error because the user with which you are creating data labs group do not have required permission on the underlying database where you are creating this data lab group.

RESOLUTION:
Grant below permissions to the user (sysdba in my example) and try creating the data lab group again.
GRANT USER ON DATALABS to sysdba;
GRANT CREATE ROLE to sysdba WITH GRANT OPTION;
GRANT EXECUTE ON DBC.LogonRule to sysdba;

How to increase Max connection limit – Netezza

To change to the parameter startup.maxConnections, please note that downtime is required.

1) Check the setting prior to change:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections =

2) Modify this line in the /nz/data/config/system.cfg file:
startup.maxConnections = 1000

* If the file is absent, you can create it as a new file and append the line into it.

3) Restart using ‘nzstop’ and ‘nzstart’

4) Check again to see if the setting has changed:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections = 1000