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 <IS_HOME>/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.


<JDBCPersistenceManager>
   ...................
   <SessionDataPersist>
      ................
      <SQL>
         <DeleteExpiredDataTask>DELETE TOP *(%d)* FROM
IDN_AUTH_SESSION_STORE WHERE TIME_CREATED &lt; ? AND TENANT_ID =
?</DeleteExpiredDataTask>
      </SQL>
   </SessionDataPersist>
</JDBCPersistenceManager>



[1] -https://github.com/wso2/carbon-identity-framework/pull/1366

Regards,
Omindu

On Thu, Feb 22, 2018 at 2:44 PM, Chiran Wijesekara <chir...@wso2.com> 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 <deepak.sin...@edifecs.com>
> wrote:
>
>> Gentle Reminder
>>
>>
>>
>> *From:* Deepak Singla
>> *Sent:* Tuesday, February 20, 2018 11:17 AM
>> *To:* 'Chiran Wijesekara' <chir...@wso2.com>
>> *Cc:* WSO2 Developers' List <dev@wso2.org>
>> *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
>> '50000'.
>>
>>
>>
>> Any suggestion?
>>
>>
>>
>> Thanks
>>
>> Deepak
>>
>>
>>
>>
>>
>
>
>
> --
> *Chiran Wijesekara*
>
>
> *Software Engineering Intern | WSO2*Email: chir...@wso2.com
> Mobile: +94712990173web: www.wso2.com
>
> [image: https://wso2.com/signature] <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

Reply via email to