Hi Deepak,
This issue is fixed with [1] and will be available with IS 5.4.1-Update3
(Scheduled to be released within the week). However as a workaround, you
can modify the affected query as follows,
In /repository/conf/identity.xml file, change the the
DeleteExpiredDataTask query as follows. Note the parentheses surrounding *%d
*which addresses the syntax error of the query.
...
DELETE TOP *(%d)* FROM
IDN_AUTH_SESSION_STORE WHERE TIME_CREATED < ? AND TENANT_ID =
?
[1] -https://github.com/wso2/carbon-identity-framework/pull/1366
Regards,
Omindu
On Thu, Feb 22, 2018 at 2:44 PM, Chiran Wijesekara wrote:
> This is a known issue which persists in the version you use. However, it
> is fixed in the next release.
> + adding Omindu and Darshana
>
> On Wed, Feb 21, 2018 at 9:49 PM, Deepak Singla
> wrote:
>
>> Gentle Reminder
>>
>>
>>
>> *From:* Deepak Singla
>> *Sent:* Tuesday, February 20, 2018 11:17 AM
>> *To:* 'Chiran Wijesekara'
>> *Cc:* WSO2 Developers' List
>> *Subject:* wso 5.4.0-update-4
>>
>>
>>
>> Hi Chiran
>>
>>
>>
>> I have installed Wso2_5.4.0-update-4 IS on window environment with
>> SQLServer-2014. I am getting below error in carbon logs after some time:
>>
>> TID: [] [] [2018-02-12 07:23:40,553] ERROR {org.wso2.carbon.identity.appl
>> ication.authentication.framework.store.SessionDataStore} - Error while
>> removing session data from the database for nano time 1517210607139156100
>> com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near
>> '5'.
>>
>>
>>
>> Any suggestion?
>>
>>
>>
>> Thanks
>>
>> Deepak
>>
>>
>>
>>
>>
>
>
>
> --
> *Chiran Wijesekara*
>
>
> *Software Engineering Intern | WSO2*Email: chir...@wso2.com
> Mobile: +94712990173web: www.wso2.com
>
> [image: https://wso2.com/signature]
>
--
Omindu Rathnaweera
Senior Software Engineer, WSO2 Inc.
Mobile: +94 771 197 211
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
