search cancel

Cannot generate APM TeamCenter API token


Article ID: 106748


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE


I cannot generate API security tokens in the Team Center
I can see this error in the Enterprise Manager logs
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO apm_secure_store ( alias, cipher_text, created_date, last_read_date, user_id, client_id) VALUES (?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


APM 10.7, upgrade from 10.5. Oracle database


The apm_secure_store table was missing completely.
This was after an upgrade from 10.5 to 10.7 but the table is not created/altered in 10.7 so it would appear the table has been missing since installation.


You can find the scripts to create the table in the Enterprise Manager installation.
Under EM_HOME/install/oracle/database-scripts, you can find the script createtables-oracle-xx.x.x.x.sql, for example createtables-oracle-

CREATE TABLE apm_secure_store(
alias VARCHAR(256) NOT NULL,
cipher_text CLOB NOT NULL,
created_date TIMESTAMP NOT NULL,
last_read_date TIMESTAMP,
client_id VARCHAR(256) NOT NULL,
user_id VARCHAR(256),
PRIMARY KEY (alias, user_id)


Additional Information

Details on creating/managing the database schema manually