Inserts gone missing from BSFN calls

johndanter

Legendary Poster
Hi folks,

I have an odd one here. THE SQL below is fired off yet I cannot see the record on the database.
The insert occurs in LotMasterUpdate. X4108

What would I be looking for in my log to see why it may have been rolled back etc.

dbsql_i.c175 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector INSERT INTO CRPDTA.F4108 (IOLOTN, IOLDSC, IOLOTS, IOMCU, IOITM, IOLITM, IOAITM, IOVEND, IOKCOO, IODOCO, IODCTO, IORLOT, IOLOTP, IOLOTG, IOMMEJ, IOSERN, IOUA01, IOUA02, IOUA03, IOUA04, IOUA05, IOUA06, IOUB01, IOUB02, IOUB03, IOUB04, IOUB05, IOUB06, IOUSER, IOPID, IOUPMJ, IOTDAY, IOJOBN, IOLRP1, IOLRP2, IOLRP3, IOLRP4, IOLRP5, IOLRP6, IOLRP7, IOLRP8, IOLRP9, IOLRP0, IOLOT1, IOLOT2, IOLOT3, IOBBDJ, IOBODJ, IODLEJ, IOOHDJ, IOSBDJ, IOU1DJ, IOU2DJ, IOU3DJ, IOU4DJ, IOU5DJ, IOCHDF, IOWPDF, IODOC1, IOLOTR, IOLOTC) VALUES ('201706120006','85200712-6737 MLET NXT,CA ',' ',' 245',5461519.000000,'5461519 ','5461519 ',167057.000000,' ',3176268.000000,'WO',' ',0.000000,'01 ',117365,' ',0,0,0,117163,0,0,0.000000,0.000000,0.000000,5.000000,0.000000,0.000000,'005747','EP31114',117163,85005.000000,'GTSAX-JDED',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',117163,117163,117163,117163,117163,117163,117163,117163,117163,117163,' ',' ',3176268.000000,'0',' ')

jdb_exet.c6601 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_InsertTable with Success (Table F4108)

Jun 12 08:50:05 53822 jdb_rq1.c5403 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_CloseTable (hRequest 313f7d28)
Jun 12 08:50:05 53844 jdb_rq1.c5518 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_CloseTable(Table = F4108)
Jun 12 08:50:05 53864 jdb_rqst.c1322 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearSequencing (hRequest 313f7d28)
Jun 12 08:50:05 53883 jdb_rqst.c1402 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearSequencing with Success
Jun 12 08:50:05 53897 jdb_rqst.c1458 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearSelection (hRequest 313f7d28)
Jun 12 08:50:05 53914 jdb_rqst.c1577 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearSelection with Success
Jun 12 08:50:05 53930 jdb_rqst.c3299 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearAggregate (hRequest 313f7d28)
Jun 12 08:50:05 54010 jdb_rqst.c3439 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearAggregate with Success
Jun 12 08:50:05 54025 jdb_rqst.c3855 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearGroupBy (hRequest 313f7d28)
Jun 12 08:50:05 54042 jdb_rqst.c4013 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearGroupBy with Success
Jun 12 08:50:05 54094 jdb_rqst.c3473 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearColumnArithmetic (hRequest 313f7d28)
Jun 12 08:50:05 54111 jdb_rqst.c3550 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearColumnArithmetic with Success
Jun 12 08:50:05 54176 jdb_rqst.c4722 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearHaving (hRequest 313f7d28)
Jun 12 08:50:05 54219 jdb_rqst.c4808 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearHaving with Success
Jun 12 08:50:05 54274 dbfreerq.c110 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector ORACLE DBFreeReq conn=305335d8 requ=36a71808 DROP [ 7]
Jun 12 08:50:05 54370 dbfreerq.c110 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector ORACLE DBFreeReq conn=305335d8 requ=36a869f8 DROP [ 6]
Jun 12 08:50:05 54414 jdb_exet.c8985 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_ClearBuffers (hRequest 313f7d28)
Jun 12 08:50:05 54433 jdb_exet.c9101 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_ClearBuffers with success.
Jun 12 08:50:05 54456 jdb_rq1.c14735 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Decremented table handle count to 11
Jun 12 08:50:05 54479 jdb_rq1.c5856 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_CloseTable(Table = F4108) with Success
Jun 12 08:50:05 54511 jdb_rq1.c5858 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_CloseTable with Success
Jun 12 08:50:05 54526 jdb_ctl.c7344 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Entering JDB_FreeBhvr (UserHandle 344bfd98)
Jun 12 08:50:05 54544 jdb_ctl.c7389 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector Exiting JDB_FreeBhvr with Success(UserHandle 344bfd98)
Jun 12 08:50:05 54568 ipcmisc.c287 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector API: ipcSawUnregisterLastBSFNV1
Jun 12 08:50:05 54586 ipcmisc.c287 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector API: ipcSawImpUnregisterLastBSFNV6
Jun 12 08:50:05 54615 ipcmisc.c287 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector ipcSawImpUnregisterLastBSFNV6: Last BSFN unregistered in entry 138.
Jun 12 08:50:05 54636 ipcmisc.c287 - 41746682/515 WRK:GTSSVCPY_3016C858_DConnector ipcSawImpUnregisterLastBSFNV6: u_bsfn_list <libC57GTS.so/N571114/N571114*libCMFGBASE.so/B3100770/B3100770CompletionsEndDoc*libCOPBASE.so/XT4111Z1/F4111EndDocument>


As to me that worked.

Thanks

John
 

Chan Rana

Legendary Poster
I see Dconnector in log so you are using either BSSV or XML to insert/update?. If yes you might want to check full log as the rollback would happen at end if there is severe error or any failure.

Chan
 

johndanter

Legendary Poster
Yes this is an E1 NER wrapped in a BSSV that calls X4108. Same code works fine when called through XML Call Object ion DC Link

Is this normal E1 behaviour to rollback DB updates/inserts if there's been an error of some kind?

And do you mean the BSSV server log?
 

Chan Rana

Legendary Poster
Yes if there is any severe error BSSV would just roll back all updates(also depends on how you have coded and design commit). You might want to look at BSSV and call object logs to track failure, if that doesn't help then try to run NER with same input thru E1.

Chan
 

johndanter

Legendary Poster
Yes it works through E1.

What does E1 use to classify a failed a call? The fact Return Value is 2 or the fact there is an error message in the COM? As I've noticed BSSVs even class a warning message as an exception.
Or is it looking at the state of the messages? Warning/Error or something else?

We tried top connect with a different user and this is has now all worked. But it would still use DConnector right?
 
Top