|
Home > Archive > SQL Anywhere Mobile > April 2005 > SqlCode 0 Error in the from Oracle Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SqlCode 0 Error in the from Oracle Server
|
|
|
| Hi,
We are Currently using the ASA 9.0.1.1899 version.
Synchronization process is between ASA to Oracle. when we
try to Sync. Some time server will retrun an Error SQLCODE 0
from Oracle Server. When we restart the mobilink server.then
synchronization thru. What might be the problem. Oracle is
running in the Win2k system. Oracle 9i.
Expecting the Response.
Cheers,
Chris
| |
| Greg Fenton 2005-03-30, 9:43 am |
| Chris wrote:
> We are Currently using the ASA 9.0.1.1899 version.
> Synchronization process is between ASA to Oracle. when we
> try to Sync. Some time server will retrun an Error SQLCODE 0
> from Oracle Server.
Can you start the ML server with the parameters "-v+ -o
c:\some_path\ml_cons
ole.txt" and post any error messages from
ml_console.txt (or post the whole thing) after you hit the above error?
We are looking to see the *exact* error messages that ML logs.
Thanks,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| hi,
We are already using that option to run the script. it is
creating that files. We got that error only when that log
file reaching above 500MB in size. we are not able to open
it. So we thought that error might be coz of this file size
get incresing like this. so we have used the option -on 100M
in the dbmlsrv9 command. now it is creating the file with an
extension .old for every 100MB. will it solve our problem by
using this -on option. or it is not relevant to that SQLCODE
0 error.
If we want to delete that old files means what shall we do
for that. is there any option is there to delete that files
instead of renaming since the memory is used widely.
help me to solve this issue asap.
with regds,
Chris
> Chris wrote:
>
> Can you start the ML server with the parameters "-v+ -o
> c:\some_path\ml_cons
ole.txt" and post any error messages
> from ml_console.txt (or post the whole thing) after you
> hit the above error?
>
> We are looking to see the *exact* error messages that ML
> logs.
>
> Thanks,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Greg Fenton 2005-03-30, 9:43 am |
| Chris wrote:
> We got that error only when that log
> file reaching above 500MB in size. we are not able to open
> it.
You could use a tool like "tail" to extract the last NNN number of lines
from the log file:
tail -10000 ml_console.txt > tail.txt
Tail is a Unix command, but is available for most platforms including Win32:
http://unxutils.sourceforge.net/
or
http://tailforwin32.sourceforge.net/
> If we want to delete that old files means what shall we do
> for that. is there any option is there to delete that files
> instead of renaming since the memory is used widely.
With -on 100MB, once the ml_console.txt gets to 100MB, it gets renamed
to ml_console.old and a new ml_console.txt is created. If there is
already a file called ml_console.old, then that file gets deleted. So
at most you will have 200MB of log files on disk, the current
ml_console.txt and the one that was previously renamed to
ml_console.old. If 200MB is still too much disk, then lower the
parameter to -on.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| I have attached the Mobilink log file( from the Mobilink
server) at the time we encountered an SQL code 0 error .
The front end window showed a SQL code 0 error and a
Synchronisation Failed message.
thanks
Chris
> Chris wrote:
>
> You could use a tool like "tail" to extract the last NNN
> number of lines from the log file:
>
> tail -10000 ml_console.txt > tail.txt
>
> Tail is a Unix command, but is available for most
> platforms including Win32:
>
> http://unxutils.sourceforge.net/
> or
> http://tailforwin32.sourceforge.net/
>
>
> widely.
>
> With -on 100MB, once the ml_console.txt gets to 100MB, it
> gets renamed to ml_console.old and a new ml_console.txt
> is created. If there is already a file called
> ml_console.old, then that file gets deleted. So at most
> you will have 200MB of log files on disk, the current
> ml_console.txt and the one that was previously renamed to
> ml_console.old. If 200MB is still too much disk, then
> lower the parameter to -on.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Greg Fenton 2005-04-06, 7:02 am |
| Chris wrote:
> I have attached the Mobilink log file( from the Mobilink
> server) at the time we encountered an SQL code 0 error .
>
I don't see any error text in this log. The only thing I see is that a
ROLLBACK occurs just at the end of the end_synchronization script:
> I. 04/04 20:15:56. <1.5> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]: end_synchronization <connection>
> call Sp_DeleteSceneWayPt(
)
> I. 04/04 20:15:56. <1.5> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]: Translated SQL:
> call Sp_DeleteSceneWayPt(
)
> I. 04/04 20:15:58. <1.5> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]: ROLLBACK Transaction: end_synchronization[
/color]
But you can see that even here all of the lines are prefixed with "I."
and not "E." or even "W." (info, error, warning respectively).
Can you show us the code of sp_DeleteSceneWayPt(
) ?
[color=darkred]
> The front end window showed a SQL code 0 error and a
> Synchronisation Failed message.
What is the "front end window" ? Where is it getting the SQL code from?
In ASA, a SQLE_NOERROR == 0, so if this is an ASA SQL code, this is
not indicating an error (in fact, just the opposite).
What is the exact text of the "Synchronization Failed" message?
Can you also post the output from dbmlsync (again, -v+ -o sync.out)?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Hi,
Create PROCEDURE Sp_DeleteSceneWayPt
as
DELETE FROM
EFBC_CfbWpi_Waypoint
_Info
WHERE
Upper(CFBWPI_WAYPOIN
T_TYPE) LIKE 'SCENE'
this is the contend of that procedure. we are just deleting
the record after completing the synchronization.
Front end means DBMLSYNC.exe output we are showing in the
List box just like the normal sync window. in that we got
the error like Server returns SQL CODE 0 Error.
Prevoiusly we thousgt due to the log file get more than 500
to 600 MB. it was thrown. now we are restrcted it to 25MB.
even now also it is throwing this error. we could'nt find
any error message related to that in the Server log files.
Kindly help me to solve this issue.
With regds,
Chris.
> Chris wrote:
>
> I don't see any error text in this log. The only thing I
> see is that a ROLLBACK occurs just at the end of the
> end_synchronization script:
>
> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]:
> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]: Translated
> [EFB96eba81789ed4eef
962bc4f5f8e1b62e#N10
7X]: ROLLBACK
> Transaction: end_synchronization
>
> But you can see that even here all of the lines are
> prefixed with "I." and not "E." or even "W." (info, error,
> warning respectively).
>
> Can you show us the code of sp_DeleteSceneWayPt(
) ?
>
>
> What is the "front end window" ? Where is it getting the
> SQL code from?
> In ASA, a SQLE_NOERROR == 0, so if this is an ASA SQL
> code, this is not indicating an error (in fact, just the
> opposite).
>
> What is the exact text of the "Synchronization Failed"
> message?
>
> Can you also post the output from dbmlsync (again, -v+ -o
> sync.out)?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Greg Fenton 2005-04-06, 8:03 pm |
| Chris wrote:
> Kindly help me to solve this issue.
As I asked in my previous post, can you post the dbmlsync log file (-v+
-o sync.out) so we can see the exact error message on the remote?
The ML server shows a ROLLBACK at the end of synchronization, but I
don't see any reason for that ROLLBACK.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Thanks for the response.
Again 0Now Only we got that error. here is the output of the
dbmlsync Log file.
I couldn't get any fruit full info from this file. Help me
to find the problem.
with regds.
Chris
I. 04/19 12:26:39. Synchronization Started
I. 04/19 12:26:39. Adaptive Server Anywhere MobiLink
Synchronization Version 9.0.1.1922
I. 04/19 12:26:39.
I. 04/19 12:26:39. Copyright =a9 1989-2004 Sybase, Inc.
Portions Copyright =a9 2002-2004,
iAnywhere Solutions, Inc.
I. 04/19 12:26:39. All rights reserved. All unpublished
rights reserved.
I. 04/19 12:26:39.
I. 04/19 12:26:39. This software contains confidential and
trade secret information of
I. 04/19 12:26:39. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/19 12:26:39. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/19 12:26:39. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/19 12:26:39. other written agreement specifying the
Government's rights to use the
I. 04/19 12:26:39. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/19 12:26:39.
I. 04/19 12:26:39. iAnywhere Solutions, Inc., One Sybase
Drive, Dublin, CA 94568, USA
I. 04/19 12:26:39.
I. 04/19 12:26:40. Begin synchronizing
'EFBDATA306a58035ee3
4a41a71ea4d75cc125cb
1' for MobiLink user
'EFB306a58035ee34a41
a71ea4d75cc125cb1#N1
07X'
I. 04/19 12:26:40. Log scan starting at offset 0290700987
I. 04/19 12:26:40. Processing transaction logs from
directory " D:\WORKING\DESIGN\EF
B\BIN\Database\"
I. 04/19 12:26:40. Processing transactions from active
transaction log
I. 04/19 12:26:40. Hovering at end of active log
I. 04/19 12:26:40. Connecting to MobiLink server at
'host=3dDevrack13' using 'dbmlsock9.dll'
I. 04/19 12:26:41. Uploading header
I. 04/19 12:26:41. Begin upload
I. 04/19 12:26:41. Uploading table operations
I. 04/19 12:26:41. Log scan ended at offset 0290701262
I. 04/19 12:26:41. Waiting for MobiLink to apply upload
I. 04/19 12:27:10. The user authentication value is 1000.
I. 04/19 12:27:10. COMMIT
I. 04/19 12:27:10. Download stream: received 5 bytes from
MobiLink Server.
E. 04/19 12:27:10. SQLCODE from MobiLink server is: 0
I. 04/19 12:27:10. ROLLBACK
I. 04/19 12:27:10. Download stream processing failed
I. 04/19 12:27:10. End synchronizing
'EFBDOC306a58035ee34
a41a71ea4d75cc125cb1
' for MobiLink user
'EFB306a58035ee34a41
a71ea4d75cc125cb1#N1
07X'
I. 04/19 12:27:10. Disconnecting from MobiLink server
I. 04/19 12:27:10. Synchronization completed
I. 04/19 12:27:10. Begin synchronizing
'EFBDOC306a58035ee34
a41a71ea4d75cc125cb1
' for MobiLink user
'EFB306a58035ee34a41
a71ea4d75cc125cb1#N1
07X'
I. 04/19 12:27:10. Processing transaction logs from
directory " D:\WORKING\DESIGN\EF
B\BIN\Database\"
I. 04/19 12:27:10. Deleted old log file
" D:\WORKING\DESIGN\EF
B\BIN\Database\05031
7AA.LOG"
I. 04/19 12:27:10. Deleted old log file
" D:\WORKING\DESIGN\EF
B\BIN\Database\05041
1AA.LOG"
I. 04/19 12:27:10. Deleted old log file
" D:\WORKING\DESIGN\EF
B\BIN\Database\05041
4AA.LOG"
I. 04/19 12:27:10. Deleted old log file
" D:\WORKING\DESIGN\EF
B\BIN\Database\05041
4AB.LOG"
I. 04/19 12:27:10. Deleted old log file
" D:\WORKING\DESIGN\EF
B\BIN\Database\05041
9AA.LOG"
I. 04/19 12:27:10. Processing transactions from active
transaction log
I. 04/19 12:27:10. Connecting to MobiLink server at
'host=3dDevrack13' using 'dbmlsock9.dll'
I. 04/19 12:27:11. Uploading header
I. 04/19 12:27:11. Begin upload
I. 04/19 12:27:11. Uploading table operations
I. 04/19 12:27:11. Log scan ended at offset 0290701838
I. 04/19 12:27:11. Waiting for MobiLink to apply upload
I. 04/19 12:27:31. The user authentication value is 1000.
I. 04/19 12:27:31. COMMIT
I. 04/19 12:27:31. Download stream: received 5 bytes from
MobiLink Server.
E. 04/19 12:27:31. SQLCODE from MobiLink server is: 0
I. 04/19 12:27:31. ROLLBACK
I. 04/19 12:27:31. Download stream processing failed
I. 04/19 12:27:31. End synchronizing
'EFBDOC306a58035ee34
a41a71ea4d75cc125cb1
' for MobiLink user
'EFB306a58035ee34a41
a71ea4d75cc125cb1#N1
07X'
I. 04/19 12:27:31. Disconnecting from MobiLink server
I. 04/19 12:27:33. Synchronization completed
> Chris wrote:
>
> As I asked in my previous post, can you post the dbmlsync
> log file (-v+ -o sync.out) so we can see the exact error
> message on the remote?
>
> The ML server shows a ROLLBACK at the end of
> synchronization, but I don't see any reason for that
> ROLLBACK.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Graham Hurst 2005-04-20, 11:24 am |
| In order to investigate this we need you to submit a reproducible to
Tech Suppport.
Cheers,
Graham
| |
|
| Thanks Graham ,
Can you pls give us more details about how we do this
submission and what are all to be submitted.
Thanks
Chris
> In order to investigate this we need you to submit a
> reproducible to Tech Suppport.
>
> Cheers,
>
> Graham
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-21, 9:24 am |
| You'll probably need to contact Technical Support to get this issue
resolved. Within North America, you can reach Technical Support
by calling 1-800-8SYBASE. If you are located outside of North
America, you can find the contact information for your local Sybase
Support Center by going to the Sybase home page at
http://www.sybase.com, clicking on the "Support" link at the top of
the page, and then choosing "Support Centers" from the left hand
frame.
You can always report a bug for free by visiting CaseXpress at
http://casexpress.sybase.com/cx/cx.stm. When submitting calls
through CaseXpress, please make sure to give an accurate description
of the steps you take to reproduce the bug, and include any
files that may be needed (database, source code) to reproduce the
problem.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<Chris> wrote in message news:4267b81f.4de0.1681692777@sybase.com...[color=darkred]
> Thanks Graham ,
>
> Can you pls give us more details about how we do this
> submission and what are all to be submitted.
>
> Thanks
> Chris
>
>
|
|
|
|
|