Skip to content

Posts from the ‘Error Resolution’ Category

[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;

ERROR: Concurrent update or delete of same row

ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x572822a U prev 0x572801c]

POSSIBLE ISSUE: You will possibly see this error in Netezaa if you try to update a row which is already deleted.

RESOLUTION: Do not try to update delete record.

Below is the example to support this answer:

TESTDB.ADMIN(ADMIN)=> select * from Test_Recovery;
NUM | DESCRIPTION
—–+————-
1 | ABC
2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> delete from Test_Recovery where NUM=1;
DELETE 1

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389590 | 0 | 1051578600800001 | 2 | XYZ
(1 row)

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is OFF
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> set show_deleted_records=true;
SET VARIABLE

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is ON
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389588 | 91389980 | 1051578600800000 | 1 | ABC
91389590 | 0 | 1051578600800001 | 2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> update Test_Recovery set DESCRIPTION=’AAA’ where NUM=1;
ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x57281f0 U prev 0x572801c]