| Author |
Error - INSERT into ML_USER
|
|
|
| The first time my remote synchs to my consolidated there should be an entry
into my ML_USER table. But that is not what is happening. I get an error
message and it looks like this:
E. 07/25 16:02:33. <thread 1.1>: Error: ODBC: [Oracle][ODBC][Ora]ORA-01400:
cannot insert NULL into ("MOBILINK_ADMIN"."ML_USER"."PROGRESS")
(ODBC State = HY000, Native error code = 1400)
Now you need to know that I am using an Oracle 10g consolidated with an
Oracle 08.00.5800 driver with a remote running MobiLink 7.0.0.463. I am
aware that this configuration is in no way supported. As a matter of fact I
can't think of any worse combination to be using. But I understand that the
Oracle 10 drivers won't work with ASA 7, right?
All I'm asking for here is if the 08.0.5800 driver with 10g may be causing
this error, and that I am not doing something obviously dumb. I've synched
new remotes a thousand times (although not with this configuration) and not
seen this error before. Can I expect completely unpredictable behaviour with
this setup?
Any thoughts out there? And really, no need to be kind. After posting my ASA
7 issues here I've become quite thick skinned!
Dinosaur Doug
| |
| David Fishburn 2005-07-26, 8:25 pm |
| "Doug" < doogie414removethis@
yahoo.com> wrote in
news:42e54a1b@forums
-2-dub of sybase.public.sqlanywhere.mobilink:
D> E. 07/25 16:02:33. <thread 1.1>: Error: ODBC:
D> [Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into
D> ("MOBILINK_ADMIN"."ML_USER"."PROGRESS")
D> (ODBC State = HY000, Native error code = 1400)
D>
D> Now you need to know that I am using an Oracle 10g consolidated with
D> an Oracle 08.00.5800 driver with a remote running MobiLink 7.0.0.463.
D> I am aware that this configuration is in no way supported. As a matter
D> of fact I can't think of any worse combination to be using. But I
D> understand that the Oracle 10 drivers won't work with ASA 7, right?
....
D> Dinosaur Doug
RRRoooooaaarrrr!
Given these circumstances I think an ODBC trace would be the only thing
to look at to see what is being passed.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Graham Hurst 2005-07-27, 9:24 am |
| Dinosaur Doug wrote:
> Now you need to know that I am using an Oracle 10g consolidated with an
> Oracle 08.00.5800 driver with a remote running MobiLink 7.0.0.463.
Devil's advocate question: Since you've been able to upgrade to the
latest version of Oracle, why can't you upgrade MobiLink too?
Cheers,
Graham
| |
|
| My client feels that to upgrade their 300+ remote field sites to ASA 9 would
be too costly. Instead they have chosen to replace their ASA remote
databases with Oracle 8.01 databases (already in the field) and modify the
application code. (HQ is going to 10g but the field stays at 8.01...) As a
replacement to MobiLink they will use Sonic's Message Queuing product.
This mish-mash of MobiLink and Oracle 10g is a contingency in case the
applications are not modified by the time we need to go into production
again. Our production schedule cannot be predetermined in advance hence we
need to be ready at a moments notice. We hope never to have to use this
configuration I am testing but we can never know for sure....
"Graham Hurst" < spam_guard_hurst@ian
ywhere.com> wrote in message
news:42e79692$1@foru
ms-2-dub...
> Dinosaur Doug wrote:
>
> Devil's advocate question: Since you've been able to upgrade to the
> latest version of Oracle, why can't you upgrade MobiLink too?
>
> Cheers,
>
> Graham
| |
| Graham Hurst 2005-07-27, 8:24 pm |
| Ouch!
I think it would be cheaper for them to just upgrade the MobiLink
server. Old remotes work with a newer MobiLink server.
Also, I think it would be better to change the remote app that uses
Oracle 8 to use ASA instead of changing the the remote apps that use ASA
to use Oracle 8...
Cheers,
Graham
Doug wrote:[color=darkred
]
> My client feels that to upgrade their 300+ remote field sites to ASA 9 would
> be too costly. Instead they have chosen to replace their ASA remote
> databases with Oracle 8.01 databases (already in the field) and modify the
> application code. (HQ is going to 10g but the field stays at 8.01...) As a
> replacement to MobiLink they will use Sonic's Message Queuing product.
>
> This mish-mash of MobiLink and Oracle 10g is a contingency in case the
> applications are not modified by the time we need to go into production
> again. Our production schedule cannot be predetermined in advance hence we
> need to be ready at a moments notice. We hope never to have to use this
> configuration I am testing but we can never know for sure....
>
> "Graham Hurst" < spam_guard_hurst@ian
ywhere.com> wrote in message
> news:42e79692$1@foru
ms-2-dub...
>
|
|
|
|