-
Bug
-
Resolution: Fixed
-
Medium
-
7.9.3, 7.10.2, 7.11.2, 7.11.3, 7.12.0
-
16
-
Severity 3 - Minor
-
63
-
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
- relates to
-
-
- Closed
-
- is related to
-
![[JIRA Server (Bulldog)]](/images/icons/generic_link_16.png "[JIRA Server (Bulldog)]")
OAUTH2-87
You do not have permission to view this issue
- mentioned in
-
Page Failed to load
-
Page Failed to load
-
Page Failed to load
-
Page Loading...
-
-
[CONFSERVER-63279] The Personal Access Token feature doesn’t work when using MS SQL Server
A fix for this issue is available to Server and Data Center customers in Confluence 7.13.0
Upgrade now or check out the Release Notes to see what other issues are resolved.
A fix for this issue is available to Server and Data Center customers in Confluence 7.12.3
Upgrade now or check out the Release Notes to see what other issues are resolved.
The link in Step #2 in the workaround doesn't go anywhere. Can I be provided with the link to the jar file listed? We are currently having a major issue because of this.
A fix for this issue is available to Server and Data Center customers in Confluence 7.11.6
Upgrade now or check out the Release Notes to see what other issues are resolved.