SA-9741

Summary

ORA-01979 and ORA-00921 error while executing Segment in batch mode

Error Messages

ORA-01979 Missing or Invalid Password Error for a Role
ORA-00921 The SQL command was not complete. Part of a valid command was entered, but at least one major component was omitted.

Steps to Reproduce

-Executing Segment in batch mode, ORA-01979(Missing or Invalid Password Error for a Role) is thrown
-DBA set the application role without password at database level
-In Vantage.init file, the value set for VenvRolePassword updated with just blank spaces.
-Executed Segment in batch mode and now ORA-00921(The SQL command was not complete. Part of a valid command was entered, but at least one major component was omitted)

Root Cause

The password for the application role was removed at database level and in Vantage.init file, the value set for VenvRolePassword updated with just blank spaces.

Resolution

Steps:
-Set password for application role at database level.
-Stop all CMD processes
-Add VenvRolePassword in  Vantage.init file with value as password for application role.
-Re-start all CMD processes.
-Execute Segment in batch mode.