Wednesday, July 24, 2013

Teradata error 3541 The request to assign new PERMANENT space is invalid.

While creating a new user or cloning a user from existing user, we may come across the error 3541. 

known remedy is to Either decrease the PERMANENT space in the new database or increase the PERMANENT space in the parent database.

Monday, July 1, 2013

Failure 3523 after teradata version upgrade

There are scenarios when user or owner has specific user rights on specific object or database, the statement  or stored procedure may fail with error code 3523(Failure 3523 COLLECT_STATS:The user does not have STATISTICS access to test_db.user_tbl), this is seen mostly after any upgrade,patch or efix. at this moment you may wonder what has gone wrong.

we could fix the issue by just compiling the stored procedure.