TDM Portal: login issue

Document ID : KB000073150
Last Modified Date : 13/03/2018
Show Technical Document Details
Issue:
Able to login into TDM Datamaker, but not TDM Portal
Environment:
Product:    TDM Portal
Database: Oracle
Cause:
Null values are being stored in Sg_Proj_Id
Resolution:
- [click] Test Data from Datamaker ribbon
User-added image
- [click] Tables, under DATAMAKERADMIN in Oracle Schema Explorer
User-added image
- [select] GTREP_SECURITY_GROUP * now the SQL window shows: SELECT * FROM DATAMAKERADMIN.GTREP_SECURITY_GROUP
User-added image
- [click] 'play' The SQL Window shows the user numbers, names, descriptions, and other fields.
User-added image
View the data, look for nulls
User-added image
Go back to the SQL window: SELECT * FROM DATAMAKERADMIN.GTREP_SECURITY_GROUP where sg_admin is null
User-added image
This returned 3 values.
User-added image
Scroll over, and changed the value of Sg Admin from to N and save.
User-added image
Re-run the query. If there are any nulls, repeat the above steps until null fields have valid data in them.