Details
-
Bug
-
Resolution: Fixed
-
Medium
-
7.9.3, 7.10.2, 7.11.2, 7.11.3, 7.12.0
-
16
-
Severity 3 - Minor
-
63
-
Description
Issue Summary
The Personal Access Token feature doesn’t work in Confluence 7.11.2 running with the MSSQL database
Steps to Reproduce
- Install Confluence 7.11.2 with MSSQL database
- Select your profile picture at top right of the screen, then choose Settings > Personal Access Tokens
Expected Results
You should be able to create the Personal Access Token
Actual Results
The below exception is seen in the atlassian.confluence.log file:
2021-04-07 16:00:00,056 ERROR [Caesium-1-3] [atlassian.pats.jobs.ExpiryDateTokenCheckEventJob] lambda$publishEventsAboutExpiredTokens$0 Caught error fetching expired tokens -- referer: http://localhost:27112/c7112/setup/setupdata-start.action | url: /c7112/setup/setupdata.action | traceId: d0ac830aa374f424 | userName: anonymous | action: setupdata 2021-04-07 16:00:00,056 ERROR [Caesium-1-3] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job ExpiryDateTokenCheckEventJob#ExpiryDateTokenCheckEventJob failed to run -- referer: http://localhost:27112/c7112/setup/setupdata-start.action | url: /c7112/setup/setupdata.action | traceId: d0ac830aa374f424 | userName: anonymous | action: setupdata com.querydsl.core.QueryException: Caught SQLServerException for select "AO_81F455_PERSONAL_TOKEN"."CREATED_AT", "AO_81F455_PERSONAL_TOKEN"."NAME", "AO_81F455_PERSONAL_TOKEN"."EXPIRING_AT", "AO_81F455_PERSONAL_TOKEN"."ID", "AO_81F455_PERSONAL_TOKEN"."LAST_ACCESSED_AT", "AO_81F455_PERSONAL_TOKEN"."HASHED_TOKEN", "AO_81F455_PERSONAL_TOKEN"."TOKEN_ID", "AO_81F455_PERSONAL_TOKEN"."USER_KEY", "AO_81F455_PERSONAL_TOKEN"."NOTIFICATION_STATE" from "null"."AO_81F455_PERSONAL_TOKEN" "AO_81F455_PERSONAL_TOKEN" where "AO_81F455_PERSONAL_TOKEN"."EXPIRING_AT" < ? and ("AO_81F455_PERSONAL_TOKEN"."NOTIFICATION_STATE" in (?, ?)) at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) at com.querydsl.sql.Configuration.translate(Configuration.java:459) at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502) at ... at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35) at java.lang.Thread.run(Thread.java:748) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'null.AO_81F455_PERSONAL_TOKEN'.
Workaround
This requires downgrading the Personal Access Token (PAT) plugin which may not be compatible with 7.11.2
- Stop Confluence 7.11.2
- Copy/Download the pats-plugin-1.0.3.jar^
^ from Confluence 7.11.1 - Place it in the confluence_install/confluence/WEB-INF/atlassian-bundled-plugins/ folder.
- From the same folder, move the pats-plugin-1.1.2.jar to another folder as backup.
- Start Confluence
