SUP 1.2 mbo table is deleting every 1 hour

[former_member254395]

Hi Experts,

We are currently supporting for SUP 1.2 to an client. We are faing an issue like every 1 hour an MBO table "xxx" is getting deleted.

As we are using sap ecc as back-end system, we troughly checked the ECC system RFC triggers and DCN triggers. There is no delete request is generating from the ECC system.

Is there any intermediate call or automatic trigger is generateing in SUP it self..?

Please help me  with your valiable ideas to solve the issue

Thanks & Regards

Rabin D

[hemal_pandya · Accepted solution]

Pretty sure this is the same issue I resolved today. It was user error.

[Jitendra_Kansal · Accepted solution]

Would you please share some more info how did you resolved it? I am sure it will help people who are experiencing similar error.

[hemal_pandya · Accepted solution]

This was on SUP 1.2 but it may have some limited applicability to later MBO based products.

The customer reported that an MBO was losing all data once an hour during a sync that took over 15 minutes. That in turn caused other sync requests to block for that time.

I noticed from counters log (a feature in SUP 1.2 which logs a line with timestamp at various stages of activity) that the MBO was getting populated by DCN as well.

I know that in SUP 1.2 at least we discouraged populating an MBO from DCN as well as READ.

I then surmised the the READ was returning 0 records, which would cause MBO data populated by DCN. I confirmed that the Cache Invalidation Interval for the MBO was about 1 hour, which lined up right along the outagage frequency.

From the counter logs before the outage occurred I confirmed that the Cache Interval was -1 (used for MBOs to be populated by DCN only) and verified from CDB that the metadata table showed the MBO definition to have been modified on the same date that the outage started occurring.

From this it was a strightforward conclusion that "someone" had changed the cache interval by mistake and asked Customer to change it back to -1 which resolved problem

[former_member254395]

Hi Experts...!

Please share some inputs on this....

[agentry_src]

SUP 1.2 is pretty old.  Can you try to persuade your customer to upgrade?

Regards, Mike

SAP Technology RIG

[agentry_src]

I went to the Product Availability Matrix and SUP 1.2 is not even listed.  The lowest version is 1.5.5 which is out of Maintenance at the end of 2014.  This could mean that is predates the SAP acquisition of Sybase by a long time frame (possibly no longer supported by Sybase before the acquisition).

Are you sure you did not mean SUP 2.1 or 2.2?

Regards, Mike

SAP Technology RIG

[agentry_src]

Discussion successfully moved from SMP Developer Center to SAP for Mobile where SUP content resides.

SMP Developer Center is for SMP 2.3 and greater.  SUP 2.2 and earlier products remain in SAP for Mobile for historical reasons mainly.

Regards, Mike (Moderator)

SAP Technology RIG

[former_member254395]

When I checked the supstats.log file, I can see  the below log file. Here

2015-06-07 19:57:33,656|Next line read after 21 seconds at 2015-06-07 19:57:32,303:sync.endSyncConnection:-:1730:463629:32:0:0

INFO   | jvm 1    | 2015/06/07 19:04:23 | 2015-06-07 20:04:23,637|Next line read after 20 seconds at 2015-06-07 20:04:23,572:sync.endSyncConnection:-:165:17413:33:6:367

INFO   | jvm 1    | 2015/06/07 19:30:43 | Error was:java.net.SocketException: Connection reset

INFO   | jvm 1    | 2015/06/07 19:30:43 | java.net.SocketException: Connection reset

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.net.SocketInputStream.read(SocketInputStream.java:168)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.BufferedInputStream.read(BufferedInputStream.java:237)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.ObjectInputStream$PeekInputStream.peek(ObjectInputStream.java:2249)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.ObjectInputStream$BlockDataInputStream.peek(ObjectInputStream.java:2542)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.ObjectInputStream$BlockDataInputStream.peekByte(ObjectInputStream.java:2552)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1297)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at com.sybase.uep.server.stats.Main$CountersReader.socket(Main.java:1380)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at com.sybase.uep.server.stats.Main$CountersReader.run(Main.java:1249)

INFO   | jvm 1    | 2015/06/07 19:30:43 | at java.lang.Thread.run(Thread.java:619)

INFO   | jvm 1    | 2015/06/07 19:31:03 | 2015-06-07 20:31:03,572|Last line read at 2015-06-07 20:30:42,397:push.process:-:2

STATUS | wrapper  | 2015/06/07 19:31:13 | <-- Wrapper Stopped

STATUS | wrapper  | 2015/06/07 19:31:45 | --> Wrapper Started as Service

STATUS | wrapper  | 2015/06/07 19:31:45 | Launching a JVM...

INFO   | jvm 1    | 2015/06/07 19:31:46 | WARNING - Unable to load the Wrapper's native library 'wrapper.dll'.

INFO   | jvm 1    | 2015/06/07 19:31:46 |           The file is located on the path at the following location but

INFO   | jvm 1    | 2015/06/07 19:31:46 |           could not be loaded:

INFO   | jvm 1    | 2015/06/07 19:31:46 |             D:\Sybase\UnwiredPlatform-1_2\Servers\UnwiredServer\supstats\wrapper.dll

INFO   | jvm 1    | 2015/06/07 19:31:46 |           Please verify that the file is readable by the current user

INFO   | jvm 1    | 2015/06/07 19:31:46 |           and that the file has not been corrupted in any way.

INFO   | jvm 1    | 2015/06/07 19:31:46 |           System signals will not be handled correctly.

INFO   | jvm 1    | 2015/06/07 19:31:46 |

INFO   | jvm 1    | 2015/06/07 19:31:46 | Wrapper (Version 3.1.2) http://wrapper.tanukisoftware.org

INFO   | jvm 1    | 2015/06/07 19:31:46 |

INFO   | jvm 1    | 2015/06/07 19:31:46 | supstats version 1.1.2011.0901

INFO   | jvm 1    | 2015/06/07 19:34:21 | Warning 1004:Unknown counter:counters:lock.wait:+,lock.held:+,sync.time:+,sync.download:+,uascripts.getPlaybackTree:+,diffmanager.getPlaybackTree:+,cdbda.getAppLinkClosure:+,push.init:+,push.process:+,eis.time:+,dbutils.invoke:?,

INFO   | jvm 1    | 2015/06/07 19:34:46 | 2015-06-07 20:34:46,617|Last line read at 2015-06-07 20:34:20,649:counters:lock.wait:+,lock.held:+,sync.time:+,sync.download:+,uascripts.getPlaybackTree:+,diffmanager.getPlaybackTree:+,cdbda.getAppLinkClosure:+,push.init:+,push.process:+,eis.time:+,dbutils.invoke:?,

INFO   | jvm 1    | 2015/06/07 19:38:28 | Warning 1004:Unknown counter:UAScripts.LogLicenseDetails

INFO   | jvm 1    | 2015/06/07 19:38:28 | Warning 1004:Unknown counter:license.expirationdate:Z9ML0k43rv0=:0

INFO   | jvm 1    | 2015/06/07 19:38:28 | Warning 1004:Unknown counter:license.user:Z9ML0k43rv0=:0

INFO   | jvm 1    | 2015/06/07 19:38:36 | 2015-06-07 20:38:36,630|Next line read after 248 seconds at 2015-06-07 20:38:29,342:sync.authParams:-:79:false

INFO   | jvm 1    | 2015/06/07 19:38:44 | Warning 1004:Unknown counter:sync.read:+:

INFO   | jvm 1    | 2015/06/07 19:52:06 | 2015-06-07 20:52:06,579|Next line read after 21 seconds at 2015-06-07 20:52:06,575:sync.begin_publication_script:+

INFO   | jvm 1    | 2015/06/07 20:14:56 | 2015-06-07 21:14:56,553|Next line read after 21 seconds at 2015-06-07 21:14:55,139:sync.endSyncConnection:-:245:31063:13:0:0

INFO   | jvm 1    | 2015/06/07 20:23:17 | Warning 1005:Connection found but previous did not complete:sync.authUser:+:USD25507

INFO   | jvm 1    | 2015/06/07 20:26:36 | 2015-06-07 21:26:36,508|Next line read after 20 seconds at 2015-06-07 21:26:36,226:sync.read:+:

INFO   | jvm 1    | 2015/06/07 20:47:36 | 2015-06-07 21:47:36,458|Next line read after 25 seconds at 2015-06-07 21:47:36,353:sync.endSyncConnection:-:196:1074742:33:0:0

INFO   | jvm 1    | 2015/06/07 21:07:56 | 2015-06-07 22:07:56,472|Last line read at 2015-06-07 22:07:30,823:sync.endSyncConnection:-:148:101260:33:0:0

INFO   | jvm 1    | 2015/06/07 21:27:46 | 2015-06-07 22:27:46,395|Next line read after 1215 seconds at 2015-06-07 22:27:46,388:sync.playback:+:NotificationHeader:10387

INFO   | jvm 1    | 2015/06/07 21:30:36 | 2015-06-07 22:30:36,385|Last line read at 2015-06-07 22:30:06,539:sync.endSyncConnection:-:43:1795788:5:0:0

INFO   | jvm 1    | 2015/06/07 21:37:06 | 2015-06-07 22:37:06,360|Next line read after 419 seconds at 2015-06-07 22:37:06,282:sync.read:+:

INFO   | jvm 1    | 2015/06/07 21:38:00 | Error was:java.net.SocketException: Connection reset

INFO   | jvm 1    | 2015/06/07 21:38:00 | java.net.SocketException: Connection reset

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.net.SocketInputStream.read(SocketInputStream.java:168)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.BufferedInputStream.read(BufferedInputStream.java:237)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.ObjectInputStream$PeekInputStream.peek(ObjectInputStream.java:2249)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.ObjectInputStream$BlockDataInputStream.peek(ObjectInputStream.java:2542)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.ObjectInputStream$BlockDataInputStream.peekByte(ObjectInputStream.java:2552)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1297)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at com.sybase.uep.server.stats.Main$CountersReader.socket(Main.java:1380)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at com.sybase.uep.server.stats.Main$CountersReader.run(Main.java:1249)

INFO   | jvm 1    | 2015/06/07 21:38:00 | at java.lang.Thread.run(Thread.java:619)

INFO   | jvm 1    | 2015/06/07 21:38:26 | 2015-06-07 22:38:26,355|Last line read at 2015-06-07 22:37:56,958:sync.endSyncConnection:-:12:1884152:-1:0:0

INFO   | jvm 1    | 2015/06/07 21:40:36 | 2015-06-07 22:40:36,353|Next line read after 159 seconds at 2015-06-07 22:40:36,139:counters:lock.wait:+,lock.held:+,sync.time:+,sync.download:+,uascripts.getPlaybackTree:+,diffmanager.getPlaybackTree:+,cdbda.getAppLinkClosure:+,push.init:+,push.process:+,eis.time:+,dbutils.invoke:?,

INFO   | jvm 1    | 2015/06/07 21:40:56 | 2015-06-07 22:40:56,354|Last line read at 2015-06-07 22:40:36,139:counters:lock.wait:+,lock.held:+,sync.time:+,sync.download:+,uascripts.getPlaybackTree:+,diffmanager.getPlaybackTree:+,cdbda.getAppLinkClosure:+,push.init:+,push.process:+,eis.time:+,dbutils.invoke:?,

INFO   | jvm 1    | 2015/06/07 21:45:56 | 2015-06-07 22:45:56,385|Next line read after 320 seconds at 2015-06-07 22:45:56,331:cdb_lock.write.wait:-:ASOHeader:10363:47596991:208

INFO   | jvm 1    | 2015/06/07 22:17:16 | 2015-06-07 23:17:16,332|Last line read at 2015-06-07 23:16:53,935:sync.endSyncConnection:-:13:1402:1:0:0

INFO   | jvm 1    | 2015/06/07 22:17:26 | 2015-06-07 23:17:26,332|Next line read after 31 seconds at 2015-06-07 23:17:25,256:eis.jco:+:

INFO   | jvm 1    | 2015/06/07 22:23:46 | 2015-06-07 23:23:46,315|Next line read after 20 seconds at 2015-06-07 23:23:45,711:sync.endSyncConnection:-:12:5403:1:0:0

INFO   | jvm 1    | 2015/06/07 22:30:26 | 2015-06-07 23:30:26,291|Next line read after 23 seconds at 2015-06-07 23:30:26,286:sync.playback:+:IndirectTimePlanning:10354

INFO   | jvm 1    | 2015/06/07 22:31:06 | 2015-06-07 23:31:06,292|Last line read at 2015-06-07 23:30:38,137:sync.endSyncConnection:-:10:2380:7:2:537080

INFO   | jvm 1    | 2015/06/07 22:31:16 | 2015-06-07 23:31:16,292|Next line read after 37 seconds at 2015-06-07 23:31:16,128:cdbda.getAppLinkClosure:-:10

INFO   | jvm 1    | 2015/06/07 22:31:46 | 2015-06-07 23:31:46,293|Next line read after 25 seconds at 2015-06-07 23:31:45,241:sync.endSyncConnection:-:389:445:7:0:0

INFO   | jvm 1    | 2015/06/07 22:32:06 | 2015-06-07 23:32:06,294|Last line read at 2015-06-07 23:31:45,241:sync.endSyncConnection:-:389:445:7:0:0

INFO   | jvm 1    | 2015/06/07 22:32:16 | 2015-06-07 23:32:16,294|Next line read after 29 seconds at 2015-06-07 23:32:15,126:eis.jco:+:

INFO   | jvm 1    | 2015/06/07 22:35:06 | 2015-06-07 23:35:06,301|Next line read after 21 seconds at 2015-06-07 23:35:06,299:sync.read:+:

INFO   | jvm 1    | 2015/06/07 22:35:36 | 2015-06-07 23:35:36,302|Last line read at 2015-06-07 23:35:06,388:playback_lock.write.wait:+:ApplicationRelease:10371:47597302

INFO   | jvm 1    | 2015/06/07 22:35:56 | 2015-06-07 23:35:56,301|Next line read after 42 seconds at 2015-06-07 23:35:49,118:push.process:-:38

INFO   | jvm 1    | 2015/06/07 22:36:26 | 2015-06-07 23:36:26,299|Last line read at 2015-06-07 23:36:00,892:sync.endSyncConnection:-:11:835:12:0:0

INFO   | jvm 1    | 2015/06/07 22:36:36 | 2015-06-07 23:36:36,299|Next line read after 30 seconds at 2015-06-07 23:36:31,796:playback_lock.write.wait:+:ApplicationRelease:10371:47597302

INFO   | jvm 1    | 2015/06/07 22:37:16 | 2015-06-07 23:37:16,296|Last line read at 2015-06-07 23:36:51,507:sync.endSyncConnection:-:12:1953:13:4:329264

INFO   | jvm 1    | 2015/06/07 22:37:26 | 2015-06-07 23:37:26,295|Next line read after 31 seconds at 2015-06-07 23:37:22,957:push.process:-:49

INFO   | jvm 1    | 2015/06/07 22:37:56 | 2015-06-07 23:37:56,293|Next line read after 20 seconds at 2015-06-07 23:37:56,240:sync.authParams:-:6:false

INFO   | jvm 1    | 2015/06/07 22:38:56 | 2015-06-07 23:38:56,290|Last line read at 2015-06-07 23:38:33,207:push.process:-:50

INFO   | jvm 1    | 2015/06/07 22:39:06 | 2015-06-07 23:39:06,289|Next line read after 31 seconds at 2015-06-07 23:39:04,323:playback_lock.write.wait:+:ApplicationRelease:10371:47597302

INFO   | jvm 1    | 2015/06/07 22:39:26 | 2015-06-07 23:39:26,288|Next line read after 21 seconds at 2015-06-07 23:39:26,002:push.process:-:1

INFO   | jvm 1    | 2015/06/07 22:39:56 | 2015-06-07 23:39:56,286|Next line read after 21 seconds at 2015-06-07 23:39:50,635:playback_lock.write.wait:+:ApplicationRelease:10371:47597302

INFO   | jvm 1    | 2015/06/07 22:45:16 | 2015-06-07 23:45:16,265|Next line read after 25 seconds at 2015-06-07 23:45:14,059:sync.endSyncConnection:-:17:3367:1:0:0

INFO   | jvm 1    | 2015/06/07 22:47:26 | 2015-06-07 23:47:26,257|Last line read at 2015-06-07 23:47:06,163:push.process:-:45