HI,
I can't save a "empty" (NULL) value by a selectitem from >>valuesmanger<<. In a Listgrid it works as desired. (same column)
it is the field: ctiscxlstsrsninfrsncd. Old Value "LEGL" -> new value NULL
DSRequest from listgrid: (update is performed)
Response (without ctiscxlstsrsninfrsncd = right ):
Corresponding SQL = right (ctiscxlstsrsninfrsncd=NULL)
DSRequest -update- from valuesmanger: (update isn't performed)
Response: (with field ctiscxlstsrsninfrsncd = wrong ):
Corresponding SQL - wrong (where is ctiscxlstsrsninfrsncd=NULL???)
What's going wrong?
I used:
SC_SNAPSHOT-2011-01-05/PowerEdition Deployment (built 2011-01-05)
GWT 2.1
thanks,
timo
P.S.: A few values I had to remove from security.
I can't save a "empty" (NULL) value by a selectitem from >>valuesmanger<<. In a Listgrid it works as desired. (same column)
it is the field: ctiscxlstsrsninfrsncd. Old Value "LEGL" -> new value NULL
DSRequest from listgrid: (update is performed)
Code:
{
"actionURL":"http://127.0.0.1:8888/payapplXMLCreator/payapplxmlcreator/sc/IDACall",
"showPrompt":true,
"transport":"xmlHttpRequest",
"promptStyle":"cursor",
"bypassCache":true,
"data":{
"criteria":{
"pkid":6
},
"values":{
"pkid":6,
"ctiscxlstsrsninfrsncd":null
},
"operationConfig":{
"dataSource":"DStxCamt029",
"repo":null,
"operationType":"update"
},
"componentId":"B2B_TX_camt_029_SCF_isc_OID_36",
"appID":"builtinApplication",
"operation":"DStxCamt029_update",
"oldValues":{
"fkbhid":858,
"ctistxcxlsts":"RJCT",
"client":"BG",
"useridCreator":"fffff",
"ctisorgnltxrefpmttpinfsvclvlcd":"SEPA",
"technicalfieldlastupdate":"2011-01-13T22:12:47",
"userdefinedfields5":false,
"technicalfieldcreated":"2011-01-13T19:48:36",
"ctisorgnltxrefintrbksttlmdt":"2010-09-25",
"ctiscxlstsrsninforgtrnm":"ddd",
"SCHEMATYP":"EBA",
"ctisorgnlendtoendid":"OriginEndtoEndID",
"ctiscxlstsid":"EBASCF1009202128GH000002RI000001",
"technicalfieldautocreated":false,
"error":false,
"ctisorgnltxid":"OriginTransactionID",
"ctisorgnlgrpinforgnlmsgid":"OriginMessageID",
"ctisorgnltxrefsttlminfsttlmmtd":"CLRG",
"ctiscxlstsrsninfrsncd":"CUST",
"environment":"Test",
"ctisorgnlgrpinforgnlmsgnmid":"pacs.008",
"pkid":6,
"archive":false,
"ftype":"SCF"
}
}
}
Code:
[
{
queueStatus:0,
isDSResponse:true,
invalidateCache:false,
status:0,
data:[
{
fkbhid:858,
ctistxcxlsts:"RJCT",
client:"BG",
ctisorgnltxrefpmttpinfsvclvlcd:"SEPA",
technicalfieldlastupdate:new Date(1294956770000),
userdefinedfields5:false,
technicalfieldcreated:new Date(1294948116000),
ctisorgnltxrefintrbksttlmdt:new Date(1285365600000),
ctiscxlstsrsninforgtrnm:"ddd",
SCHEMATYP:"EBA",
ctisorgnlendtoendid:"OriginEndtoEndID",
technicalfieldautocreated:false,
error:false,
ctisorgnltxid:"OriginTransactionID",
ctisorgnlgrpinforgnlmsgid:"OriginMessageID",
ctisorgnltxrefsttlminfsttlmmtd:"CLRG",
environment:"Test",
ctisorgnlgrpinforgnlmsgnmid:"pacs.008",
pkid:6,
archive:false,
ftype:"SCF"
}
]
}
]
Code:
=== 2011-01-13 23:12:50,823 [0-20] INFO SQLDriver - [builtinApplication.DStxCamt029_update] Executing SQL update on 'mainDataBase': UPDATE payappl.tx_camt_029 SET useridLastupdate='NB00080T', ctiscxlstsrsninfrsncd=NULL, technicalfieldlastupdate='20110113 23:12:50' WHERE (tx_camt_029.pkid='6')
Code:
{
"actionURL":"http://127.0.0.1:8888/payapplXMLCreator/payapplxmlcreator/sc/IDACall",
"showPrompt":true,
"prompt":"Saving form...",
"transport":"xmlHttpRequest",
"promptStyle":"cursor",
"bypassCache":true,
"data":{
"criteria":{
"pkid":6
},
"values":{
"fkbhid":858,
"ctistxcxlsts":"RJCT",
"client":"BG",
"ctisorgnltxrefpmttpinfsvclvlcd":"SEPA",
"technicalfieldlastupdate":"2011-01-13T21:55:42",
"technicalfieldcreated":"2011-01-13T19:48:36",
"userdefinedfields5":false,
"ctisorgnltxrefintrbksttlmdt":"2010-09-25",
"ctisorgnlendtoendid":"OriginEndtoEndID",
"ctiscxlstsrsninforgtrnm":"ddd",
"SCHEMATYP":"EBA",
"ctiscxlstsid":"EBASCF1009202128GH000002RI000001",
"technicalfieldautocreated":false,
"error":"false",
"ctisorgnltxid":"OriginTransactionID",
"ctisorgnlgrpinforgnlmsgid":"OriginMessageID",
"ctisorgnltxrefsttlminfsttlmmtd":"CLRG",
"ctiscxlstsrsninfrsncd":null,
"environment":"Test",
"pkid":6,
"ctisorgnlgrpinforgnlmsgnmid":"pacs.008",
"archive":false,
"ftype":"SCF"
},
"operationConfig":{
"dataSource":"DStxCamt029",
"repo":null,
"operationType":"update"
},
"componentId":"isc_ValuesManager_0",
"appID":"builtinApplication",
"operation":"DStxCamt029_update",
"oldValues":{
"fkbhid":858,
"ctistxcxlsts":"RJCT",
"client":"BG",
"ctisorgnltxrefpmttpinfsvclvlcd":"SEPA",
"technicalfieldlastupdate":"2011-01-13T21:55:42",
"technicalfieldcreated":"2011-01-13T19:48:36",
"userdefinedfields5":false,
"ctisorgnltxrefintrbksttlmdt":"2010-09-25",
"ctisorgnlendtoendid":"OriginEndtoEndID",
"ctiscxlstsrsninforgtrnm":"ddd",
"SCHEMATYP":"EBA",
"ctiscxlstsid":"EBASCF1009202128GH000002RI000001",
"technicalfieldautocreated":false,
"error":false,
"ctisorgnltxid":"OriginTransactionID",
"ctisorgnlgrpinforgnlmsgid":"OriginMessageID",
"ctisorgnltxrefsttlminfsttlmmtd":"CLRG",
"ctiscxlstsrsninfrsncd":"LEGL",
"environment":"Test",
"pkid":6,
"ctisorgnlgrpinforgnlmsgnmid":"pacs.008",
"archive":false,
"ftype":"SCF"
}
}
}
Code:
[
{
queueStatus:0,
isDSResponse:true,
invalidateCache:false,
status:0,
data:[
{
fkbhid:858,
ctistxcxlsts:"RJCT",
client:"BG",
useridCreator:"NB00080T",
ctisorgnltxrefpmttpinfsvclvlcd:"SEPA",
technicalfieldlastupdate:new Date(1294956457000),
userdefinedfields5:false,
technicalfieldcreated:new Date(1294948116000),
ctisorgnltxrefintrbksttlmdt:new Date(1285365600000),
ctiscxlstsrsninforgtrnm:"ddd",
SCHEMATYP:"EBA",
ctisorgnlendtoendid:"OriginEndtoEndID",
technicalfieldautocreated:false,
error:false,
ctisorgnltxid:"OriginTransactionID",
ctisorgnlgrpinforgnlmsgid:"OriginMessageID",
ctisorgnltxrefsttlminfsttlmmtd:"CLRG",
ctiscxlstsrsninfrsncd:"LEGL",
environment:"Test",
ctisorgnlgrpinforgnlmsgnmid:"pacs.008",
pkid:6,
archive:false,
ftype:"SCF"
}
]
}
]
Code:
=== 2011-01-13 23:07:37,916 [0-16] INFO SQLDriver - [builtinApplication.DSB2BBH_update] Executing SQL update on 'mainDataBase': UPDATE payappl.B2B_BH SET fkbhid=877, useridLastupdate='NB00080T', msgid='EBASCF1009202128GH000002', technicalfieldautocreated='false', bhtyp='camt_029', client='BG', useridCreator='NB00080T', technicalfieldlastupdate='20110113 23:07:37', conf='RJCR', technicalfieldcreated='20110113 20:48:36', credttm='20100920 19:28:00', bhversion='2010', instdagtfininstnidbic='HYVEDEM0', environment='Test', technicalfieldtxcounter=0, archive='false', ftype='SCF', instgagtfininstnidbic='ZYDOFRP0', SCHEMATYP='EBA', nboftxs=0 WHERE (B2B_BH.pkid='858')
I used:
SC_SNAPSHOT-2011-01-05/PowerEdition Deployment (built 2011-01-05)
GWT 2.1
thanks,
timo
P.S.: A few values I had to remove from security.