Hello HomerJ,
The error you are experiencing is a known issue in ALM11.00 in patch 17 and 18 within the SA logs.
This is a known issue that has been reported to HP and further information (if you have a valid HPO Passport ID here:
https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/LID/QCCR1J72393
As per HP:
''After upgrading to ALM 11.0 Patch 17 and now in patch 18 SA logs are capturing a new and unseeing error message pointing to PROJECT_INFO table under qcsiteadmin_db which is not valid for ALM 11.
The error is only captured when there are more than 15-20 concurrent users connected to the application.
This has been reported when using JBOSS as well as when using WebSphere as the application server.
This is a known issue on ALM 11 and already reported to R&D but is deferred meaning that the issue has been reviewed and determined as a valid request, however it is unable to be addressed at this time.
This is a known issue and the error will not break functionality if the customer does not use Gossip (AKA: HP ALM Synchronizer).
If customer uses Gossip, this table should be manually created in Site Admin db. The DDL for MS SQL Server db is as below:
CREATE TABLE [td].[PROJECT_INFO](
[PI_PUID] [varchar](36) NOT NULL,
[PI_KEY] [varchar](255) NOT NULL,
[PI_VALUE] [varchar](255) NULL,
CONSTRAINT [PI_PK] PRIMARY KEY ([PI_PUID] ASC,[PI_KEY] ASC))
The query for Oracle DB is the following:
create table QCSITEADMIN_DB11.PROJECT_INFO
(PI_PUID varchar(36) not null,
PI_KEY varchar(255) not null,
PI_VALUE varchar(255) null,
constraint PI_PK primary key (PI_PUID,PI_KEY)
);
If customer do not use Gossip (HP Synchronizer), they could just ignore the error. If they insist on resolving the error, creating the table above manually is the workaround for this issue.
Note: Please keep in mind that is always important to create backups of all the data before changing anything on the ALM system. Also any kind of change instituted from the DB is not supported from HP, since it is only a workaround.''
I hope this helps clarify your issue.
Thanks,
Dan