How to Resolve the error ‘Sorry, your account information is invalid. Please contact the system administrator(PTYREL)’.

One of iBizSoft iStore implementations came across this error . This error is due to the Bug 7560011 ERROR ON CREATING AN ACCOUNT: PTYREL.

As per the bug, it is caused due to the time stamp difference between Java Layer and DB Layer. i.e DB’s relationship.start_date against java.lang.System.currentTimeMillis()

Typically, this happens when there are multiple nodes of DB tier and Apps tier.

One of the solution is to apply the patch 4490845. Issue may recur if the time difference keeps increasing. Alternative solution is to decompile the IBEUtil.class file and fix the getSysdate method that retrieves the DB sysdate only once and later calls to this method just use the stored difference to calculate the DB sysdate as follows

System.currentTimeMillis() + timediff

When  you bounce Apache the difference between this result and the DB sysdate is zero, but for some reason it starts increasing over time.

Please contact support@ibizsoftinc.com for further information.