View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001954SymmetricDS ProBugpublic2014-09-04 13:072015-01-20 13:23
Reporterelong Assigned Tochenson  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.6.7 
Target Version3.6.10Fixed in Version3.6.10 
Summary0001954: Extracted batch viewer missing data and showing data in wrong columns
DescriptionThe Manage->Outgoing Batches screen has a dialog to view the extracted batch data, but the dialog is missing rows and displaying values in the wrong columns. Attaching an example batch file. In this example, the first three rows are displayed as empty in the viewer, while the last row has values in the wrong columns.
TagsNo tags attached.

Activities

elong

2014-09-04 13:07

developer  

transformed-batch.csv (2,009 bytes)    
nodeid,j-001
binary,BASE64
channel,default
batch,21409
catalog,
schema,
table,LEDGERENTRY
keys
columns,TENANTID,AMOUNT,MEMO,MATTERID,ROWCHANGETIMESTAMP,CREATEDDATE,MODIFIEDDATE,DELETEDINDICATOR,VOIDINDICATOR,ACCOUNTID,CREATEDBY,MODIFIEDBY,LEGACYMATTERID,LEGACYLEDGERENTRYID
insert,"2345","0.0000","hello",,"AAAAAAAct6k=","2014-09-03 18:30:00.0","2014-09-03 18:30:00.0","0","0",,"xyOUIJt6/rs/D3T1WH4/0g==","xyOUIJt6/rs/D3T1WH4/0g==","13","3453"
catalog,
schema,
table,LEDGERHISTORYJURISADDFIELD
keys
columns,LEGACYID,TENANTID,LEGACYLEDGERENTRYID,LHMatter,LHBillNbr,LHType,LHDate,LHPrdYear,LHPrdNbr,LHCashAmt,LHFees,LHCshExp,LHNCshExp,LHSurcharge,LHTaxes1,LHTaxes2,LHTaxes3,LHInterest,LHComment,LHTimeStamp
insert,"3453","2345","3453","13","1863","3","2014-09-03 00:00:00.000","2014","9","0.0000","0.0000","0.0000","0.0000","3.0000","0.0000","0.0000","0.0000","1.0000","hello","AAAAAAAct6k="
catalog,
schema,
table,ARMATALLOCJURISADDFIELD
keys,LEGACYID,TENANTID,ARMMatter
columns,LEGACYID,TENANTID,ARMMatter,MATTERID,LEGACYMATTERID,ARMLHLink,ARMFeeBld,ARMFeeRcvd,ARMFeeAdj,ARMCshExpBld,ARMCshExpRcvd,ARMCshExpAdj,ARMNCshExpBld,ARMNCshExpRcvd,ARMNCshExpAdj,ARMSurchgBld,ARMSurchgRcvd,ARMSurchgAdj,ARMTax1Bld,ARMTax1Rcvd,ARMTax1Adj,ARMTax2Bld,ARMTax2Rcvd,ARMTax2Adj,ARMTax3Bld,ARMTax3Rcvd,ARMTax3Adj,ARMIntBld,ARMIntRcvd,ARMIntAdj,ARMBalDue,ARMPendingFlag,ARMPendFee,ARMPendCshExp,ARMPendNCshExp,ARMPendSurchg,ARMPendTax1,ARMPendTax2,ARMPendTax3,ARMPendInt,ARMTimeStamp
insert,"1863","2345","13",,"13","3453","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","3.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","1.0000","0.0000","0.0000","4.0000","N","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","AAAAAAAct6w="
catalog,
schema,
table,ARMATALLOCJURISCUSTOMFIELD
keys,LEGACYID,TENANTID,FIELDID
columns,LEGACYID,TENANTID,FIELDID,VALUE,LEGACYMATTERID
insert,"1863","2345","1","0.0000","13"
commit,21409
transformed-batch.csv (2,009 bytes)   

Issue History

Date Modified Username Field Change
2014-09-04 13:07 elong New Issue
2014-09-04 13:07 elong File Added: transformed-batch.csv
2014-10-08 17:06 chenson Assigned To => chenson
2014-10-08 17:06 chenson Status new => assigned
2014-10-08 17:07 chenson Fixed in Version => 3.6.10
2014-10-08 17:07 chenson Target Version => 3.6.10
2014-10-08 17:07 chenson Status assigned => resolved
2014-10-08 17:07 chenson Resolution open => fixed
2015-01-20 13:23 chenson Status resolved => closed