This content has been marked as final. Show 7 replies
when does the error happen? during sync upload, sync download, or during mgp compose?
does the number at the end (the 4097) change?
We sometimes get a similar stringindexout of bounds exception when a user has had a number of failed sync sessions on the client (normally things like comms problems, or server busy), and this builds up the length of the error message upload string to the point that it becomes too big for the server recieving table. If this is the problem, the client send file will need to be cleared down and you will need to do some dummy updates to the client data to recover it
It seems to happen at the upload sync.
The number doesn't change at the end, it stays at 4097.
If i do a reinstall of the webtogo client application and try to reinstall it,
I also get the same error message.
I found the problem:
a specific column has Varchar2 length 4000, for some records the length of the data for that column is greater then 3960 and then it seems that the synchronisation can't upload the records.
I have updated the records to a smaller length and then it works fine.
Hi,1 person found this helpful
Your error is exactly like the Bug 5225331 "CONS-9025 DATA SIZE BIGGER THAN MAX ( TYPE 4162)",
"ERROR",2000,"05/31/2006 16:25:40","An internal error has occurred. 4097"
Sync session exception stack trace:
at oracle.lite.sync.okrl4p_tField_MD.object2ByteArray(Unknown Source)
at oracle.lite.sync.OKRL4PRecord.getData(Unknown Source)
at oracle.lite.sync.HeliosSession.sendPayload(Unknown Source)
at oracle.lite.sync.HeliosSession.sendSubData(Unknown Source)
at oracle.lite.sync.HeliosSession.downloadSubs(Unknown Source)
at oracle.lite.sync.HeliosSession.startSession(Unknown Source)
at oracle.lite.sync.resume.Client$1.run(Unknown Source)
at oracle.lite.sync.resume.ThreadPool$PoolTask.run(Unknown Source)
The Bug is fixed in 10.3.0.1 + the last one-off patch number: 7453858
What Oracle Lite 10G release are you using?
I am using Oracle Web-to-Go Version 10.2.0.2.0.
Thanks for the reply.
It will be good if we once update Oracle Web-to-go if the problem occurs more often.
Hi, The buffer has a size of 4096, which is fine fo varchar2 type, but UTF8 can grow up to a potential size of 3*4096.
In your case (wihtout any patch) you can be limited to 4096/3 = 1364 characters.
You can also open an Service Request to the Oracle support Throught Metalink to ask for a patch on 10.2.0.2.1.0 (it will be necessary to apply the mini patch 10.2.0.2.1) as all the patches are now
only for 10.2.0.2.1
If we get the problem at some customers of us,
we will indeed need to upgrade and install the patches.