API Tokens for Jira ERROR: column "username" does not exist at character

[Former user]

Hello friends,

We just recently updated to 1.1.6 for API Tokens for Jira. We're starting to see some errors filling up our database logs:

< 2020-07-07 00:03:34.583 UTC > ERROR: column "username" does not exist at character 117 < 2020-07-07 00:03:34.583 UTC > STATEMENT: SELECT "LAST_USAGE","DESCRIPTION","ID","TOKEN","CREATED","KEY","USERNAME" FROM public."AO_5D4005_TOKEN" WHERE lower(USERNAME) = $1 ORDER BY "ID" < 2020-07-07 00:03:34.631 UTC > ERROR: column "username" does not exist at character 117 < 2020-07-07 00:03:34.631 UTC > STATEMENT: SELECT "LAST_USAGE","DESCRIPTION","ID","TOKEN","CREATED","KEY","USERNAME" FROM public."AO_5D4005_TOKEN" WHERE lower(USERNAME) = $1 ORDER BY "ID" < 2020-07-07 00:03:34.642 UTC > ERROR: column "username" does not exist at character 117 < 2020-07-07 00:03:34.642 UTC > STATEMENT: SELECT "LAST_USAGE","DESCRIPTION","ID","TOKEN","CREATED","KEY","USERNAME" FROM public."AO_5D4005_TOKEN" WHERE lower(USERNAME) = $1 ORDER BY "ID"

Is this something you can help us out with?

Best regards, Clint

[Clinton Zofnas (US - IFS)]

Downgraded to 1.1.5 This resolved.

‌

Jira Server 8.9.0

[Roma Bubyakin [Wombats Corp]]

Hello @Clinton Zofnas (US - IFS)

The issue is duplicate for #18

I’m already working on it

Workaround is downgrade to v1.1.5

‌

What DB you are using?

Regards, Roman

[Roma Bubyakin [Wombats Corp]]

Duplicate of #18.

[Roma Bubyakin [Wombats Corp]]

Hello Clinton,

Could you please confirm that jira-tokens-1.1.7.jar work for you?

Regards, Roman

[Roma Bubyakin [Wombats Corp]]

v1.1.7. Fixed #18 and #19. Plugin fails to read data. 'Lower' function is not working in Postgres (AO-315)

→ <<cset bc9673c0daec>>

[Roma Bubyakin [Wombats Corp]]

Fixed in v1.1.7