Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf.
Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below.
Best regards,
Mogens
Mogens,
In deed, Oracle9i Lite has over 10'000 posted
messages on OTN, which makes it #3 of all Oracle Products. This outstanding
number of messages produces a lot of work for us, which is why you might
experience slower than expected turn around for certain postings. We apologize
for the delay but you can rest assured that we do everything in our power
to resolve your issues.
It looks like data does not get applied to the Oracle Lite (PROCESSING) database.
Client changes are sent to the Mobile Server (SENDING). The client also
received data from the server (RECEIVING). It might be that replication
never finishes (commits) the transaction (since it hangs), which is why
MGP might not pick up the changes and apply them to the Oracle database.
COMPOSING client data
SENDING client data to the Mobile
Server
RECEIVING data from the server
PROCESSING (apply) data to the client
database
The PK change in one of your application
table might actually be the culprit. Please follow the procedure below and
let me know if you have further questions.
1. Drop the application
from Control Center
2. Drop the client database(s)
3. Publish the application into Mobile Server
4. Provision the application
5. Execute sync
We recommend to use Oracle9i Lite
5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows).
-- martin
Saira Somani wrote:
Mogens, Thank you kindly for forwarding my questions to the head honcho. I would be extremely pleased if he responded but not offended if he didn't.Funny enough, we are currently using Lite with Intermec 700 handhelds (StrongARM chipset) running Pocket PC (Windows CE) in hospitals to manage supply carts. Interesting business. So since I have inherited administration of this software, I not an expert yet, but quickly finding out where documentation and logging is sparse. I find that it is quite difficult to figure out where a problem has occurred. Take for example the MSYNC process on the client which synchronizes with the repository on the 8i server. Every time the client syncs, the client tells me it is successful, even though it isn't. Secondly, there is processing that is performed on synchronization - I know for a fact that there is data to be "processed", yet this client never fulfills that request to "process" the data and as a result, changes are not reflected in the repository. Then take migration. I wanted to upgrade from 5.0.1.X.0 to 5.0.2.X.0 - and I found out that I cannot even log into the administrative console. And that would be fine, if there was documentation that told me this is possible (maybe I missed that PDF, I don't know - too much information, too little time). And how about documentation on the tracing. Especially interpretation of the log/trace files - there is no guideline to explain to me what I can expect from the logging/tracing (again, maybe it's me for missing that PDF but I have searched for many months with little success). I think it is a good product with many bugs and I think it can be used very effectively if administered/configured optimally. I just think that there isn't enough expertise out there yet to assist those who have decided to go with this product. From an administrative standpoint, I find it difficult to grasp how and where errors are occurring. Even more difficult is trying to figure out a pattern to the errors. They are sporadic, inconsistent, and show no symptoms. Alerts for MGP failing are non-existent - don't know when it will go down and when it does, I can't explain why. Overall, I can see it having success in the right environment and with a stable release. Hope this helped but didn't offend any. Thanks again, Saira -----Original Message----- Nørgaard Sent: February 6, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote:Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responsesyet.I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using this product :-) ---------------------------------------------------------------------------- RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC - records to process yet PROCESSING does not occur We have changed records on the client in offline mode and now want to syncronize with the server. There are records to be processed - yet, in MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING. As a result, our records on the server are not updated. MGP is running, and when we retry, we allow for complete cycles to occur before ournextattempt. After trying about 20 times (no kidding), the PROCCESSING bar on the MSYNC screen works. This is unacceptable and not to mention unreliable. Please help. Please also see my previous message on a related issue. Perhaps you can see a connection, I can't as yet. Thanks, Saira ---------------------------------------------------------------------------- RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC sticks on PROCESSING bar Recently we made a change to a table in our repository in 8i - changedaprimary key. After this, the application was republished in Oracle 9i Lite and all client databases (Pocket PC Strong ARM) were refreshed (i.e. database was removed from the client and sync'd 3 times before usage). We have noticed that now, after the change, during the MSYNC process, that status bar hangs on the PROCESSING phase of MSYNC. The only way to rid this is by warm booting the PDA and trying it multiple times until it is successful (which sometimes it is and sometimes isn't). However, even when the PROCESSING bar has not completed until the end, the data>from the PDA is sent but this is unreliable as all the MSYNC processesare not complete. This is inefficient. Any suggestions? Saira Somani IT Support/Analyst Hospital Logistics Inc.