snestola Absent Member.
Absent Member.
280 views

UPDATE statement problem of jdbc driver


Hi all, I've a SLES10 SP3 with edir 885 and IDM 361
I have a lot of drivers running jdbc statement without problems, but
one of them has problems on a procedure.
This jdbc driver must perform the INSERT and UPDATE statement on a view
Oracle 10 and then upgrade 7 tables.
The INSERT statement works without problems while the UPDATE don't work
block the driver.
If I run the command manually on the tables works properly .

Attached the log

Any ideas? Thanks in advance

Silvia


01/03/12 15:50:43.809]:SIPERT PT:SELECT A.PK_UT_CODE, A.PASSWORD,
A.ACCOUNT, A.FLAG_ST, A.DATA_SCAD, A.DIP_CODE, A.DIP_DESCR,
A.DIP_LINGUA, A.CS_CODE, A.TIPO, A.FLTIPOXX, A.IS_DEFA, A.FLTIPORI FROM
SCUDO.VISTAIAMSIPERT A ORDER BY A.PK_UT_CODE ASC
[01/03/12 15:50:44.236]:SIPERT ST:Start transaction.
[01/03/12 15:50:44.240]:SIPERT ST:Processing events for transaction.
[01/03/12 15:50:44.243]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify cached-time="20120103145044.200Z" class-name="User"
event-id="colidmserver#20120103145044#1#1"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
timestamp="1325602244#2">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<modify-attr attr-name="company">
<remove-value>
<value timestamp="1325601233#25" type="string">AU</value>
</remove-value>
<add-value>
<value timestamp="1325602244#2" type="string">GME</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[01/03/12 15:50:44.259]:SIPERT ST:No event transformation policies.
[01/03/12 15:50:44.260]:SIPERT ST:Subscriber processing modify for
\DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.261]:SIPERT ST:Applying command transformation
policies.
[01/03/12 15:50:44.262]:SIPERT ST:Applying policy:
%+C%14CDisableUser%-C.
[01/03/12 15:50:44.262]:SIPERT ST: Applying to modify #1.
[01/03/12 15:50:44.263]:SIPERT ST: Evaluating selection criteria for
rule 'DisableUser'.
[01/03/12 15:50:44.264]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.265]:SIPERT ST: (if-op-attr 'Login Disabled'
changing-to "TRUE") = FALSE.
[01/03/12 15:50:44.266]:SIPERT ST: Rule rejected.
[01/03/12 15:50:44.267]:SIPERT ST: Evaluating selection criteria for
rule 'EnableUser'.
[01/03/12 15:50:44.268]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.269]:SIPERT ST: (if-op-attr 'Login Disabled'
changing-to "FALSE") = FALSE.
[01/03/12 15:50:44.270]:SIPERT ST: Rule rejected.
[01/03/12 15:50:44.271]:SIPERT ST:Policy returned:
[01/03/12 15:50:44.271]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify cached-time="20120103145044.200Z" class-name="User"
event-id="colidmserver#20120103145044#1#1"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
timestamp="1325602244#2">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<modify-attr attr-name="company">
<remove-value>
<value timestamp="1325601233#25" type="string">AU</value>
</remove-value>
<add-value>
<value timestamp="1325602244#2" type="string">GME</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[01/03/12 15:50:44.276]:SIPERT ST:Applying policy:
%+C%14CDisableOnDelete%-C.
[01/03/12 15:50:44.276]:SIPERT ST: Applying to modify #1.
[01/03/12 15:50:44.276]:SIPERT ST: Evaluating selection criteria for
rule 'DisableOnDelete'.
[01/03/12 15:50:44.277]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.277]:SIPERT ST: (if-operation equal "delete") =
FALSE.
[01/03/12 15:50:44.277]:SIPERT ST: Rule rejected.
[01/03/12 15:50:44.277]:SIPERT ST:Policy returned:
[01/03/12 15:50:44.277]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify cached-time="20120103145044.200Z" class-name="User"
event-id="colidmserver#20120103145044#1#1"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
timestamp="1325602244#2">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<modify-attr attr-name="company">
<remove-value>
<value timestamp="1325601233#25" type="string">AU</value>
</remove-value>
<add-value>
<value timestamp="1325602244#2" type="string">GME</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[01/03/12 15:50:44.280]:SIPERT ST:Applying policy:
%+C%14CDisableAndEnableOnRename%-C.
[01/03/12 15:50:44.280]:SIPERT ST: Applying to modify #1.
[01/03/12 15:50:44.280]:SIPERT ST: Evaluating selection criteria for
rule 'DisableOldCN and EnableNewCN on Rename'.
[01/03/12 15:50:44.280]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.281]:SIPERT ST: (if-operation equal "rename") =
FALSE.
[01/03/12 15:50:44.281]:SIPERT ST: Rule rejected.
[01/03/12 15:50:44.281]:SIPERT ST:Policy returned:
[01/03/12 15:50:44.282]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify cached-time="20120103145044.200Z" class-name="User"
event-id="colidmserver#20120103145044#1#1"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
timestamp="1325602244#2">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<modify-attr attr-name="company">
<remove-value>
<value timestamp="1325601233#25" type="string">AU</value>
</remove-value>
<add-value>
<value timestamp="1325602244#2" type="string">GME</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[01/03/12 15:50:44.286]:SIPERT ST:Applying policy: %+C%14CGestione
Modifiche SIPERT%-C.
[01/03/12 15:50:44.286]:SIPERT ST: Applying to modify #1.
[01/03/12 15:50:44.286]:SIPERT ST: Evaluating selection criteria for
rule 'Variabili Locali'.
[01/03/12 15:50:44.287]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.287]:SIPERT ST: (if-operation equal "modify") =
TRUE.
[01/03/12 15:50:44.288]:SIPERT ST: Rule selected.
[01/03/12 15:50:44.288]:SIPERT ST: Applying rule 'Variabili
Locali'.
[01/03/12 15:50:44.289]:SIPERT ST: Action:
do-set-local-variable("csCode",scope="policy","5").
[01/03/12 15:50:44.289]:SIPERT ST: arg-string("5")
[01/03/12 15:50:44.290]:SIPERT ST: token-text("5")
[01/03/12 15:50:44.290]:SIPERT ST: Arg Value: "5".
[01/03/12 15:50:44.291]:SIPERT ST: Action:
do-set-local-variable("tipo",scope="policy",token-src-attr("SipertTipo")).
[01/03/12 15:50:44.291]:SIPERT ST:
arg-string(token-src-attr("SipertTipo"))
[01/03/12 15:50:44.292]:SIPERT ST:
token-src-attr("SipertTipo")
[01/03/12 15:50:44.292]:SIPERT ST: Query from policy
[01/03/12 15:50:44.293]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SipertTipo"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.294]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.294]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.301]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.302]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="SipertTipo">
<value timestamp="1325601233#44" type="string">U</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.304]:SIPERT ST: Token Value: "U".
[01/03/12 15:50:44.305]:SIPERT ST: Arg Value: "U".
[01/03/12 15:50:44.305]:SIPERT ST: Action:
do-set-local-variable("dipDescr",scope="policy",token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
"+token-src-attr("Given Name")))).
[01/03/12 15:50:44.306]:SIPERT ST:
arg-string(token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
"+token-src-attr("Given Name"))))
[01/03/12 15:50:44.307]:SIPERT ST:
token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
"+token-src-attr("Given Name")))
[01/03/12 15:50:44.308]:SIPERT ST:
token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
"+token-src-attr("Given Name")))
[01/03/12 15:50:44.308]:SIPERT ST:
token-upper-case(token-src-attr("Surname")+" "+token-src-attr("Given
Name"))
[01/03/12 15:50:44.309]:SIPERT ST:
token-upper-case(token-src-attr("Surname")+" "+token-src-attr("Given
Name"))
[01/03/12 15:50:44.310]:SIPERT ST:
token-src-attr("Surname")
[01/03/12 15:50:44.310]:SIPERT ST: Query from
policy
[01/03/12 15:50:44.310]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="Surname"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.312]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.313]:SIPERT ST: Performing
operation query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.315]:SIPERT ST: Query from policy
result
[01/03/12 15:50:44.315]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="Surname">
<value timestamp="1325601233#15" type="string">Test </value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.318]:SIPERT ST: Token Value:
"Test ".
[01/03/12 15:50:44.335]:SIPERT ST: token-text(" ")
[01/03/12 15:50:44.336]:SIPERT ST:
token-src-attr("Given Name")
[01/03/12 15:50:44.336]:SIPERT ST: Query from
policy
[01/03/12 15:50:44.337]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="Given Name"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.339]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.340]:SIPERT ST: Performing
operation query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.342]:SIPERT ST: Query from policy
result
[01/03/12 15:50:44.342]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="Given Name">
<value timestamp="1325601233#16"
type="string">Sipert31</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.346]:SIPERT ST: Token Value:
"Sipert31".
[01/03/12 15:50:44.347]:SIPERT ST: Arg Value: "Test
Sipert31".
[01/03/12 15:50:44.347]:SIPERT ST: Token Value: "TEST
SIPERT31".
[01/03/12 15:50:44.347]:SIPERT ST: Arg Value: "TEST
SIPERT31".
[01/03/12 15:50:44.348]:SIPERT ST: Token Value: "TEST
SIPERT31".
[01/03/12 15:50:44.349]:SIPERT ST: Arg Value: "TEST
SIPERT31".
[01/03/12 15:50:44.349]:SIPERT ST: Action:
do-set-local-variable("dipLingua",scope="policy",token-src-attr("SiperDipLingua")).
[01/03/12 15:50:44.350]:SIPERT ST:
arg-string(token-src-attr("SiperDipLingua"))
[01/03/12 15:50:44.350]:SIPERT ST:
token-src-attr("SiperDipLingua")
[01/03/12 15:50:44.359]:SIPERT ST: Query from policy
[01/03/12 15:50:44.359]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SiperDipLingua"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.362]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.362]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.364]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.365]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="SiperDipLingua">
<value timestamp="1325601233#41" type="string">I</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.367]:SIPERT ST: Token Value: "I".
[01/03/12 15:50:44.367]:SIPERT ST: Arg Value: "I".
[01/03/12 15:50:44.367]:SIPERT ST: Action:
do-set-local-variable("password",scope="policy",token-src-attr("SipertPassword")).
[01/03/12 15:50:44.368]:SIPERT ST:
arg-string(token-src-attr("SipertPassword"))
[01/03/12 15:50:44.368]:SIPERT ST:
token-src-attr("SipertPassword")
[01/03/12 15:50:44.368]:SIPERT ST: Query from policy
[01/03/12 15:50:44.368]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SipertPassword"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.369]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.369]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.371]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.371]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="SipertPassword">
<value timestamp="1325601233#39"
type="string">Password1</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.372]:SIPERT ST: Token Value:
"Password1".
[01/03/12 15:50:44.373]:SIPERT ST: Arg Value: "Password1".
[01/03/12 15:50:44.373]:SIPERT ST: Action:
do-set-local-variable("fltipoxx",scope="policy","U").
[01/03/12 15:50:44.373]:SIPERT ST: arg-string("U")
[01/03/12 15:50:44.373]:SIPERT ST: token-text("U")
[01/03/12 15:50:44.373]:SIPERT ST: Arg Value: "U".
[01/03/12 15:50:44.373]:SIPERT ST: Action:
do-set-local-variable("account",scope="policy",token-upper-case(token-src-attr("CN",class-name="User"))).
[01/03/12 15:50:44.374]:SIPERT ST:
arg-string(token-upper-case(token-src-attr("CN",class-name="User")))
[01/03/12 15:50:44.374]:SIPERT ST:
token-upper-case(token-src-attr("CN",class-name="User"))
[01/03/12 15:50:44.374]:SIPERT ST:
token-upper-case(token-src-attr("CN",class-name="User"))
[01/03/12 15:50:44.374]:SIPERT ST:
token-src-attr("CN",class-name="User")
[01/03/12 15:50:44.375]:SIPERT ST: Query from policy
[01/03/12 15:50:44.375]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="CN"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.376]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.376]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.378]:SIPERT ST: Query from policy
result
[01/03/12 15:50:44.378]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="CN">
<value naming="true" timestamp="1325601233#4"
type="string">a001031</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.380]:SIPERT ST: Token Value:
"a001031".
[01/03/12 15:50:44.380]:SIPERT ST: Arg Value: "a001031".
[01/03/12 15:50:44.380]:SIPERT ST: Token Value: "A001031".
[01/03/12 15:50:44.380]:SIPERT ST: Arg Value: "A001031".
[01/03/12 15:50:44.380]:SIPERT ST: Action:
do-set-local-variable("isdefa",scope="policy","S").
[01/03/12 15:50:44.381]:SIPERT ST: arg-string("S")
[01/03/12 15:50:44.381]:SIPERT ST: token-text("S")
[01/03/12 15:50:44.381]:SIPERT ST: Arg Value: "S".
[01/03/12 15:50:44.381]:SIPERT ST: Action:
do-set-local-variable("dipfitti",scope="policy","DIPFITTI").
[01/03/12 15:50:44.381]:SIPERT ST: arg-string("DIPFITTI")
[01/03/12 15:50:44.381]:SIPERT ST: token-text("DIPFITTI")
[01/03/12 15:50:44.382]:SIPERT ST: Arg Value: "DIPFITTI".
[01/03/12 15:50:44.382]:SIPERT ST: Action:
do-set-local-variable("fltipori",scope="policy","F").
[01/03/12 15:50:44.382]:SIPERT ST: arg-string("F")
[01/03/12 15:50:44.382]:SIPERT ST: token-text("F")
[01/03/12 15:50:44.382]:SIPERT ST: Arg Value: "F".
[01/03/12 15:50:44.383]:SIPERT ST: Action:
do-set-local-variable("password_substring",scope="policy",token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))).
[01/03/12 15:50:44.384]:SIPERT ST:
arg-string(token-substring(length="6",token-src-attr("SipertPassword",class-name="User")))
[01/03/12 15:50:44.385]:SIPERT ST:
token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))
[01/03/12 15:50:44.385]:SIPERT ST:
token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))
[01/03/12 15:50:44.386]:SIPERT ST:
token-src-attr("SipertPassword",class-name="User")
[01/03/12 15:50:44.386]:SIPERT ST: Token Value:
"Password1".
[01/03/12 15:50:44.387]:SIPERT ST: Arg Value:
"Password1".
[01/03/12 15:50:44.387]:SIPERT ST: Token Value: "Passwo".
[01/03/12 15:50:44.388]:SIPERT ST: Arg Value: "Passwo".
[01/03/12 15:50:44.388]:SIPERT ST: Action:
do-set-local-variable("flagST",scope="policy",token-src-attr("SipertFlagSt")).
[01/03/12 15:50:44.390]:SIPERT ST:
arg-string(token-src-attr("SipertFlagSt"))
[01/03/12 15:50:44.390]:SIPERT ST:
token-src-attr("SipertFlagSt")
[01/03/12 15:50:44.391]:SIPERT ST: Query from policy
[01/03/12 15:50:44.391]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SipertFlagSt"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.393]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.393]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.395]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.395]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.397]:SIPERT ST: Token Value: "".
[01/03/12 15:50:44.398]:SIPERT ST: Arg Value: "".
[01/03/12 15:50:44.398]:SIPERT ST: Action:
do-set-local-variable("vDataScad",scope="policy",token-src-attr("SipertDataScadNum")).
[01/03/12 15:50:44.399]:SIPERT ST:
arg-string(token-src-attr("SipertDataScadNum"))
[01/03/12 15:50:44.399]:SIPERT ST:
token-src-attr("SipertDataScadNum")
[01/03/12 15:50:44.400]:SIPERT ST: Query from policy
[01/03/12 15:50:44.400]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SipertDataScadNum"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.404]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.407]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.409]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.409]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<attr attr-name="SipertDataScadNum">
<value timestamp="1325601233#46"
type="string">20371231000000000000000</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.413]:SIPERT ST: Token Value:
"20371231000000000000000".
[01/03/12 15:50:44.413]:SIPERT ST: Arg Value:
"20371231000000000000000".
[01/03/12 15:50:44.413]:SIPERT ST: Action:
do-set-local-variable("sipertCN",scope="policy",token-src-attr("CN")).
[01/03/12 15:50:44.414]:SIPERT ST:
arg-string(token-src-attr("CN"))
[01/03/12 15:50:44.414]:SIPERT ST: token-src-attr("CN")
[01/03/12 15:50:44.414]:SIPERT ST: Token Value: "a001031".
[01/03/12 15:50:44.414]:SIPERT ST: Arg Value: "a001031".
[01/03/12 15:50:44.415]:SIPERT ST: Action:
do-set-local-variable("sipertUtRoleCS",scope="policy",token-src-attr("SipertUtRoleCs")).
[01/03/12 15:50:44.415]:SIPERT ST:
arg-string(token-src-attr("SipertUtRoleCs"))
[01/03/12 15:50:44.415]:SIPERT ST:
token-src-attr("SipertUtRoleCs")
[01/03/12 15:50:44.415]:SIPERT ST: Query from policy
[01/03/12 15:50:44.416]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
scope="entry">
<read-attr attr-name="SipertUtRoleCs"/>
</query>
</input>
</nds>
[01/03/12 15:50:44.416]:SIPERT ST: Pumping XDS to
eDirectory.
[01/03/12 15:50:44.417]:SIPERT ST: Performing operation
query for \DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.418]:SIPERT ST: Query from policy result
[01/03/12 15:50:44.418]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
<association
state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
</instance>
<status level="success"></status>
</output>
</nds>
[01/03/12 15:50:44.420]:SIPERT ST: Token Value: "".
[01/03/12 15:50:44.420]:SIPERT ST: Arg Value: "".
[01/03/12 15:50:44.420]:SIPERT ST: Action: do-if().
[01/03/12 15:50:44.420]:SIPERT ST: Evaluating conditions.
[01/03/12 15:50:44.420]:SIPERT ST: (if-op-attr 'company'
changing-to "GSE") = FALSE.
[01/03/12 15:50:44.421]:SIPERT ST: Performing else actions.
[01/03/12 15:50:44.421]:SIPERT ST: Action: do-if().
[01/03/12 15:50:44.421]:SIPERT ST: Evaluating conditions.
[01/03/12 15:50:44.421]:SIPERT ST: (if-op-attr 'company'
changing-to "AU") = FALSE.
[01/03/12 15:50:44.421]:SIPERT ST: Performing else actions.
[01/03/12 15:50:44.422]:SIPERT ST: Action: do-if().
[01/03/12 15:50:44.422]:SIPERT ST: Evaluating
conditions.
[01/03/12 15:50:44.422]:SIPERT ST: (if-op-attr
'company' changing-to "GME") = TRUE.
[01/03/12 15:50:44.422]:SIPERT ST: Performing if
actions.
[01/03/12 15:50:44.422]:SIPERT ST: Action:
do-set-local-variable("initDipCode",scope="policy","20003").
[01/03/12 15:50:44.440]:SIPERT ST:
arg-string("20003")
[01/03/12 15:50:44.440]:SIPERT ST:
token-text("20003")
[01/03/12 15:50:44.440]:SIPERT ST: Arg Value:
"20003".
[01/03/12 15:50:44.441]:SIPERT ST: Action: do-if().
[01/03/12 15:50:44.441]:SIPERT ST: Evaluating conditions.
[01/03/12 15:50:44.441]:SIPERT ST: (if-op-attr 'company'
changing) = TRUE.
[01/03/12 15:50:44.441]:SIPERT ST: (if-local-variable
'initDipCode' available) = TRUE.
[01/03/12 15:50:44.442]:SIPERT ST: Performing if actions.
[01/03/12 15:50:44.442]:SIPERT ST: Action:
do-set-local-variable("dipCode",scope="policy",token-local-variable("initDipCode")+token-substring(length="6",start="1",token-src-attr("CN"))).
[01/03/12 15:50:44.443]:SIPERT ST:
arg-string(token-local-variable("initDipCode")+token-substring(length="6",start="1",token-src-attr("CN")))
[01/03/12 15:50:44.444]:SIPERT ST:
token-local-variable("initDipCode")
[01/03/12 15:50:44.445]:SIPERT ST: Token Value:
"20003".
[01/03/12 15:50:44.445]:SIPERT ST:
token-substring(length="6",start="1",token-src-attr("CN"))
[01/03/12 15:50:44.446]:SIPERT ST:
token-substring(length="6",start="1",token-src-attr("CN"))
[01/03/12 15:50:44.446]:SIPERT ST:
token-src-attr("CN")
[01/03/12 15:50:44.447]:SIPERT ST: Token Value:
"a001031".
[01/03/12 15:50:44.447]:SIPERT ST: Arg Value:
"a001031".
[01/03/12 15:50:44.447]:SIPERT ST: Token Value:
"001031".
[01/03/12 15:50:44.448]:SIPERT ST: Arg Value:
"20003001031".
[01/03/12 15:50:44.448]:SIPERT ST: Action:
do-set-src-attr-value("SipertDipCode",token-local-variable("dipCode")).
[01/03/12 15:50:44.449]:SIPERT ST:
arg-string(token-local-variable("dipCode"))
[01/03/12 15:50:44.450]:SIPERT ST:
token-local-variable("dipCode")
[01/03/12 15:50:44.450]:SIPERT ST: Token Value:
"20003001031".
[01/03/12 15:50:44.451]:SIPERT ST: Arg Value:
"20003001031".
[01/03/12 15:50:44.451]:SIPERT ST: Evaluating selection criteria for
rule 'UPDATE MULTIPLE'.
[01/03/12 15:50:44.452]:SIPERT ST: (if-operation equal "modify") =
TRUE.
[01/03/12 15:50:44.452]:SIPERT ST: (if-class-name equal "User") =
TRUE.
[01/03/12 15:50:44.452]:SIPERT ST: Rule selected.
[01/03/12 15:50:44.453]:SIPERT ST: Applying rule 'UPDATE MULTIPLE'.
[01/03/12 15:50:44.453]:SIPERT ST: Action:
do-append-xml-element("jdbc:statement","/nds/input").
[01/03/12 15:50:44.454]:SIPERT ST: Action:
do-set-xml-attr("jdbc:type","/nds/input/jdbc:statement","update").
[01/03/12 15:50:44.454]:SIPERT ST: arg-string("update")
[01/03/12 15:50:44.454]:SIPERT ST: token-text("update")
[01/03/12 15:50:44.454]:SIPERT ST: Arg Value: "update".
[01/03/12 15:50:44.471]:SIPERT ST: Action:
do-set-xml-attr("jdbc:transaction-type","/nds/input/jdbc:statement","manual").
[01/03/12 15:50:44.472]:SIPERT ST: arg-string("manual")
[01/03/12 15:50:44.472]:SIPERT ST: token-text("manual")
[01/03/12 15:50:44.472]:SIPERT ST: Arg Value: "manual".
[01/03/12 15:50:44.473]:SIPERT ST: Action:
do-set-xml-attr("jdbc:transaction-id","/nds/input/jdbc:statement","4").
[01/03/12 15:50:44.474]:SIPERT ST: arg-string("4")
[01/03/12 15:50:44.474]:SIPERT ST: token-text("4")
[01/03/12 15:50:44.474]:SIPERT ST: Arg Value: "4".
[01/03/12 15:50:44.474]:SIPERT ST: Action:
do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
[01/03/12 15:50:44.475]:SIPERT ST: Action:
do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
[01/03/12 15:50:44.475]:SIPERT ST: Action:
do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
[01/03/12 15:50:44.475]:SIPERT ST: Action:
do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
[01/03/12 15:50:44.476]:SIPERT ST: Action:
do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[1]","UPDATE
SCUDO.DIPENDENTI SET "+"DIP_CODE =
'"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
'"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
'"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
'"+token-substring(length="6",start="1",token-local-variable("sipertCN"))+"'").
[01/03/12 15:50:44.477]:SIPERT ST: arg-string("UPDATE
SCUDO.DIPENDENTI SET "+"DIP_CODE =
'"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
'"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
'"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
'"+token-substring(length="6",start="1",token-local-variable("sipertCN"))+"'")
[01/03/12 15:50:44.477]:SIPERT ST: token-text("UPDATE
SCUDO.DIPENDENTI SET ")
[01/03/12 15:50:44.478]:SIPERT ST: token-text("DIP_CODE = '")
[01/03/12 15:50:44.478]:SIPERT ST:
token-local-variable("dipCode")
[01/03/12 15:50:44.478]:SIPERT ST: Token Value:
"20003001031".
[01/03/12 15:50:44.478]:SIPERT ST: token-text("', ")
[01/03/12 15:50:44.478]:SIPERT ST: token-text("DIP_DESCR =
'")
[01/03/12 15:50:44.478]:SIPERT ST:
token-local-variable("dipDescr")
[01/03/12 15:50:44.479]:SIPERT ST: Token Value: "TEST
SIPERT31".
[01/03/12 15:50:44.479]:SIPERT ST: token-text("', ")
[01/03/12 15:50:44.479]:SIPERT ST: token-text("DIP_LINGUA =
'")
[01/03/12 15:50:44.479]:SIPERT ST:
token-local-variable("dipLingua")
[01/03/12 15:50:44.479]:SIPERT ST: Token Value: "I".
[01/03/12 15:50:44.479]:SIPERT ST: token-text("' ")
[01/03/12 15:50:44.479]:SIPERT ST: token-text("WHERE
substr(DIP_CODE,6) = '")
[01/03/12 15:50:44.480]:SIPERT ST:
token-substring(length="6",start="1",token-local-variable("sipertCN"))
[01/03/12 15:50:44.480]:SIPERT ST:
token-substring(length="6",start="1",token-local-variable("sipertCN"))
[01/03/12 15:50:44.480]:SIPERT ST:
token-local-variable("sipertCN")
[01/03/12 15:50:44.480]:SIPERT ST: Token Value:
"a001031".
[01/03/12 15:50:44.480]:SIPERT ST: Arg Value: "a001031".
[01/03/12 15:50:44.481]:SIPERT ST: Token Value: "001031".
[01/03/12 15:50:44.481]:SIPERT ST: token-text("'")
[01/03/12 15:50:44.481]:SIPERT ST: Arg Value: "UPDATE
SCUDO.DIPENDENTI SET DIP_CODE = '20003001031', DIP_DESCR = 'TEST
SIPERT31', DIP_LINGUA = 'I' WHERE substr(DIP_CODE,6) = '001031'".
[01/03/12 15:50:44.482]:SIPERT ST: Action:
do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[2]","UPDATE
SCUDO.DIPENDENTI_PER_C_S_UPD SET "+"DIP_CODE =
'"+token-local-variable("dipCode")+"' ,TIPO =
'"+token-local-variable("tipo")+"', CS_CODE =
'"+token-local-variable("csCode")+"'"+" WHERE UPPER(UT_CODE) =
UPPER('"+token-local-variable("sipertCN")+"') ").
[01/03/12 15:50:44.484]:SIPERT ST: arg-string("UPDATE
SCUDO.DIPENDENTI_PER_C_S_UPD SET "+"DIP_CODE =
'"+token-local-variable("dipCode")+"' ,TIPO =
'"+token-local-variable("tipo")+"', CS_CODE =
'"+token-local-variable("csCode")+"'"+" WHERE UPPER(UT_CODE) =
UPPER('"+token-local-variable("sipertCN")+"') ")
[01/03/12 15:50:44.486]:SIPERT ST: token-text("UPDATE
SCUDO.DIPENDENTI_PER_C_S_UPD SET ")
[01/03/12 15:50:44.486]:SIPERT ST: token-text("DIP_CODE = '")
[01/03/12 15:50:44.486]:SIPERT ST:
token-local-variable("dipCode")
[01/03/12 15:50:44.511]:SIPERT ST: Token Value:
"20003001031".
[01/03/12 15:50:44.512]:SIPERT ST: token-text("' ,TIPO = '")
[01/03/12 15:50:44.512]:SIPERT ST:
token-local-variable("tipo")
[01/03/12 15:50:44.513]:SIPERT ST: Token Value: "U".
[01/03/12 15:50:44.513]:SIPERT ST: token-text("', CS_CODE =
'")
[01/03/12 15:50:44.513]:SIPERT ST:
token-local-variable("csCode")
[01/03/12 15:50:44.514]:SIPERT ST: Token Value: "5".
[01/03/12 15:50:44.514]:SIPERT ST: token-text("'")
[01/03/12 15:50:44.514]:SIPERT ST: token-text(" WHERE
UPPER(UT_CODE) = UPPER('")
[01/03/12 15:50:44.515]:SIPERT ST:
token-local-variable("sipertCN")
[01/03/12 15:50:44.515]:SIPERT ST: Token Value: "a001031".
[01/03/12 15:50:44.516]:SIPERT ST: token-text("') ")
[01/03/12 15:50:44.516]:SIPERT ST: Arg Value: "UPDATE
SCUDO.DIPENDENTI_PER_C_S_UPD SET DIP_CODE = '20003001031' ,TIPO = 'U',
CS_CODE = '5' WHERE UPPER(UT_CODE) = UPPER('a001031') ".
[01/03/12 15:50:44.517]:SIPERT ST: Action:
do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[3]"," UPDATE
SCUDO.PASSWORD_UPD SET "+"PASSWORD=
'"+token-local-variable("password_substring")+"', "+"DATA_VAR = SYSDATE
"+", "+"FLAG_ST = '"+token-local-variable("flagST")+"' "+"WHERE
UPPER(UT_CODE) = UPPER('"+token-local-variable("sipertCN")+"')").
[01/03/12 15:50:44.519]:SIPERT ST: arg-string(" UPDATE
SCUDO.PASSWORD_UPD SET "+"PASSWORD=
'"+token-local-variable("password_substring")+"', "+"DATA_VAR = SYSDATE
"+", "+"FLAG_ST = '"+token-local-variable("flagST")+"' "+"WHERE
UPPER(UT_CODE) = UPPER('"+token-local-variable("sipertCN")+"')")
[01/03/12 15:50:44.521]:SIPERT ST: token-text(" UPDATE
SCUDO.PASSWORD_UPD SET ")
[01/03/12 15:50:44.521]:SIPERT ST: token-text("PASSWORD= '")
[01/03/12 15:50:44.522]:SIPERT ST:
token-local-variable("password_substring")
[01/03/12 15:50:44.522]:SIPERT ST: Token Value: "Passwo".
[01/03/12 15:50:44.522]:SIPERT ST: token-text("', ")
[01/03/12 15:50:44.523]:SIPERT ST: token-text("DATA_VAR =
SYSDATE ")
[01/03/12 15:50:44.523]:SIPERT ST: token-text(", ")
[01/03/12 15:50:44.523]:SIPERT ST: token-text("FLAG_ST = '")
[01/03/12 15:50:44.524]:SIPERT ST:
token-local-variable("flagST")
[01/03/12 15:50:44.524]:SIPERT ST: Token Value: "".
[01/03/12 15:50:44.524]:SIPERT ST: token-text("' ")
[01/03/12 15:50:44.525]:SIPERT ST: token-text("WHERE
UPPER(UT_CODE) = UPPER('")
[01/03/12 15:50:44.525]:SIPERT ST:
token-local-variable("sipertCN")
[01/03/12 15:50:44.526]:SIPERT ST: Token Value: "a001031".
[01/03/12 15:50:44.526]:SIPERT ST: token-text("')")
[01/03/12 15:50:44.526]:SIPERT ST: Arg Value: " UPDATE
SCUDO.PASSWORD_UPD SET PASSWORD= 'Passwo', DATA_VAR = SYSDATE , FLAG_ST
= '' WHERE UPPER(UT_CODE) = UPPER('a001031')".
[01/03/12 15:50:44.535]:SIPERT ST: Action:
do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[4]","UPDATE
SCUDO.UTENTI_UPD SET "+"UT_CODE_DESCR =
'"+token-local-variable("dipDescr")+"', FLTIPOXX =
'"+token-local-variable("fltipoxx")+"', CS_CODE =
'"+token-local-variable("csCode")+"', "+"DATA_SCAD =
TO_DATE('"+token-substring(length="8",token-local-variable("vDataScad"))+"',
'YYYYMMDD') "+"WHERE UPPER(UT_CODE) =
UPPER('"+token-local-variable("sipertCN")+"')").
[01/03/12 15:50:44.538]:SIPERT ST: arg-string("UPDATE
SCUDO.UTENTI_UPD SET "+"UT_CODE_DESCR =
'"+token-local-variable("dipDescr")+"', FLTIPOXX =
'"+token-local-variable("fltipoxx")+"', CS_CODE =
'"+token-local-variable("csCode")+"', "+"DATA_SCAD =
TO_DATE('"+token-substring(length="8",token-local-variable("vDataScad"))+"',
'YYYYMMDD') "+"WHERE UPPER(UT_CODE) =
UPPER('"+token-local-variable("sipertCN")+"')")
[01/03/12 15:50:44.540]:SIPERT ST: token-text("UPDATE
SCUDO.UTENTI_UPD SET ")
[01/03/12 15:50:44.540]:SIPERT ST: token-text("UT_CODE_DESCR =
'")
[01/03/12 15:50:44.541]:SIPERT ST:
token-local-variable("dipDescr")
[01/03/12 15:50:44.541]:SIPERT ST: Token Value: "TEST
SIPERT31".
[01/03/12 15:50:44.541]:SIPERT ST: token-text("', FLTIPOXX =
'")
[01/03/12 15:50:44.541]:SIPERT ST:
token-local-variable("fltipoxx")
[01/03/12 15:50:44.542]:SIPERT ST: Token Value: "U".
[01/03/12 15:50:44.542]:SIPERT ST: token-text("', CS_CODE =
'")
[01/03/12 15:50:44.542]:SIPERT ST:
token-local-variable("csCode")
[01/03/12 15:50:44.542]:SIPERT ST: Token Value: "5".
[01/03/12 15:50:44.542]:SIPERT ST: token-text("', ")
[01/03/12 15:50:44.543]:SIPERT ST: token-text("DATA_SCAD =
TO_DATE('")
[01/03/12 15:50:44.543]:SIPERT ST:
token-substring(length="8",token-local-variable("vDataScad"))
[01/03/12 15:50:44.543]:SIPERT ST:
token-substring(length="8",token-local-variable("vDataScad"))
[01/03/12 15:50:44.544]:SIPERT ST:
token-local-variable("vDataScad")
[01/03/12 15:50:44.551]:SIPERT ST: Token Value:
"20371231000000000000000".
[01/03/12 15:50:44.551]:SIPERT ST: Arg Value:
"20371231000000000000000".
[01/03/12 15:50:44.551]:SIPERT ST: Token Value: "20371231".
[01/03/12 15:50:44.552]:SIPERT ST: token-text("', 'YYYYMMDD')
")
[01/03/12 15:50:44.552]:SIPERT ST: token-text("WHERE
UPPER(UT_CODE) = UPPER('")
[01/03/12 15:50:44.552]:SIPERT ST:
token-local-variable("sipertCN")
[01/03/12 15:50:44.552]:SIPERT ST: Token Value: "a001031".
[01/03/12 15:50:44.552]:SIPERT ST: token-text("')")
[01/03/12 15:50:44.553]:SIPERT ST: Arg Value: "UPDATE
SCUDO.UTENTI_UPD SET UT_CODE_DESCR = 'TEST SIPERT31', FLTIPOXX = 'U',
CS_CODE = '5', DATA_SCAD = TO_DATE('20371231', 'YYYYMMDD') WHERE
UPPER(UT_CODE) = UPPER('a001031')".
[01/03/12 15:50:44.554]:SIPERT ST: Direct command from policy
[01/03/12 15:50:44.554]:SIPERT ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.0.4294">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify class-name="User"
dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
event-id="colidmserver#20120103145044#1#1">

<association>PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
<modify-attr attr-name="SipertDipCode">
<remove-all-values/>
<add-value>
<value>20003001031</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[01/03/12 15:50:44.563]:SIPERT ST: Pumping XDS to eDirectory.
[01/03/12 15:50:44.566]:SIPERT ST: Performing operation modify for
\DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.587]:SIPERT ST: Modifying entry
\DEMOGSE\gsecoll\AU\Interni\a001031.
[01/03/12 15:50:44.597]:SIPERT ST: Processing returned document.
[01/03/12 15:50:44.598]:SIPERT ST: Processing operation <status> for
Labels (1)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: UPDATE statement problem of jdbc driver

You can't actually run an insert or an update on a view. When you do the view must have an INSTEAD OF trigger on it that answers for the type of
operation (INSERT or UPDATE). Looks like your trace was cutoff right before the error is returned but I suspect the INSTEAD OF trigger is only
looking at INSERTS and not UPDATES.



On 1/3/2012 9:26 AM, snestola wrote:
>
> Hi all, I've a SLES10 SP3 with edir 885 and IDM 361
> I have a lot of drivers running jdbc statement without problems, but
> one of them has problems on a procedure.
> This jdbc driver must perform the INSERT and UPDATE statement on a view
> Oracle 10 and then upgrade 7 tables.
> The INSERT statement works without problems while the UPDATE don't work
> block the driver.
> If I run the command manually on the tables works properly .
>
> Attached the log
>
> Any ideas? Thanks in advance
>
> Silvia
>
>
> 01/03/12 15:50:43.809]:SIPERT PT:SELECT A.PK_UT_CODE, A.PASSWORD,
> A.ACCOUNT, A.FLAG_ST, A.DATA_SCAD, A.DIP_CODE, A.DIP_DESCR,
> A.DIP_LINGUA, A.CS_CODE, A.TIPO, A.FLTIPOXX, A.IS_DEFA, A.FLTIPORI FROM
> SCUDO.VISTAIAMSIPERT A ORDER BY A.PK_UT_CODE ASC
> [01/03/12 15:50:44.236]:SIPERT ST:Start transaction.
> [01/03/12 15:50:44.240]:SIPERT ST:Processing events for transaction.
> [01/03/12 15:50:44.243]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <modify cached-time="20120103145044.200Z" class-name="User"
> event-id="colidmserver#20120103145044#1#1"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
> timestamp="1325602244#2">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <modify-attr attr-name="company">
> <remove-value>
> <value timestamp="1325601233#25" type="string">AU</value>
> </remove-value>
> <add-value>
> <value timestamp="1325602244#2" type="string">GME</value>
> </add-value>
> </modify-attr>
> </modify>
> </input>
> </nds>
> [01/03/12 15:50:44.259]:SIPERT ST:No event transformation policies.
> [01/03/12 15:50:44.260]:SIPERT ST:Subscriber processing modify for
> \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.261]:SIPERT ST:Applying command transformation
> policies.
> [01/03/12 15:50:44.262]:SIPERT ST:Applying policy:
> %+C%14CDisableUser%-C.
> [01/03/12 15:50:44.262]:SIPERT ST: Applying to modify #1.
> [01/03/12 15:50:44.263]:SIPERT ST: Evaluating selection criteria for
> rule 'DisableUser'.
> [01/03/12 15:50:44.264]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.265]:SIPERT ST: (if-op-attr 'Login Disabled'
> changing-to "TRUE") = FALSE.
> [01/03/12 15:50:44.266]:SIPERT ST: Rule rejected.
> [01/03/12 15:50:44.267]:SIPERT ST: Evaluating selection criteria for
> rule 'EnableUser'.
> [01/03/12 15:50:44.268]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.269]:SIPERT ST: (if-op-attr 'Login Disabled'
> changing-to "FALSE") = FALSE.
> [01/03/12 15:50:44.270]:SIPERT ST: Rule rejected.
> [01/03/12 15:50:44.271]:SIPERT ST:Policy returned:
> [01/03/12 15:50:44.271]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <modify cached-time="20120103145044.200Z" class-name="User"
> event-id="colidmserver#20120103145044#1#1"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
> timestamp="1325602244#2">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <modify-attr attr-name="company">
> <remove-value>
> <value timestamp="1325601233#25" type="string">AU</value>
> </remove-value>
> <add-value>
> <value timestamp="1325602244#2" type="string">GME</value>
> </add-value>
> </modify-attr>
> </modify>
> </input>
> </nds>
> [01/03/12 15:50:44.276]:SIPERT ST:Applying policy:
> %+C%14CDisableOnDelete%-C.
> [01/03/12 15:50:44.276]:SIPERT ST: Applying to modify #1.
> [01/03/12 15:50:44.276]:SIPERT ST: Evaluating selection criteria for
> rule 'DisableOnDelete'.
> [01/03/12 15:50:44.277]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.277]:SIPERT ST: (if-operation equal "delete") =
> FALSE.
> [01/03/12 15:50:44.277]:SIPERT ST: Rule rejected.
> [01/03/12 15:50:44.277]:SIPERT ST:Policy returned:
> [01/03/12 15:50:44.277]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <modify cached-time="20120103145044.200Z" class-name="User"
> event-id="colidmserver#20120103145044#1#1"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
> timestamp="1325602244#2">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <modify-attr attr-name="company">
> <remove-value>
> <value timestamp="1325601233#25" type="string">AU</value>
> </remove-value>
> <add-value>
> <value timestamp="1325602244#2" type="string">GME</value>
> </add-value>
> </modify-attr>
> </modify>
> </input>
> </nds>
> [01/03/12 15:50:44.280]:SIPERT ST:Applying policy:
> %+C%14CDisableAndEnableOnRename%-C.
> [01/03/12 15:50:44.280]:SIPERT ST: Applying to modify #1.
> [01/03/12 15:50:44.280]:SIPERT ST: Evaluating selection criteria for
> rule 'DisableOldCN and EnableNewCN on Rename'.
> [01/03/12 15:50:44.280]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.281]:SIPERT ST: (if-operation equal "rename") =
> FALSE.
> [01/03/12 15:50:44.281]:SIPERT ST: Rule rejected.
> [01/03/12 15:50:44.281]:SIPERT ST:Policy returned:
> [01/03/12 15:50:44.282]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <modify cached-time="20120103145044.200Z" class-name="User"
> event-id="colidmserver#20120103145044#1#1"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057"
> timestamp="1325602244#2">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <modify-attr attr-name="company">
> <remove-value>
> <value timestamp="1325601233#25" type="string">AU</value>
> </remove-value>
> <add-value>
> <value timestamp="1325602244#2" type="string">GME</value>
> </add-value>
> </modify-attr>
> </modify>
> </input>
> </nds>
> [01/03/12 15:50:44.286]:SIPERT ST:Applying policy: %+C%14CGestione
> Modifiche SIPERT%-C.
> [01/03/12 15:50:44.286]:SIPERT ST: Applying to modify #1.
> [01/03/12 15:50:44.286]:SIPERT ST: Evaluating selection criteria for
> rule 'Variabili Locali'.
> [01/03/12 15:50:44.287]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.287]:SIPERT ST: (if-operation equal "modify") =
> TRUE.
> [01/03/12 15:50:44.288]:SIPERT ST: Rule selected.
> [01/03/12 15:50:44.288]:SIPERT ST: Applying rule 'Variabili
> Locali'.
> [01/03/12 15:50:44.289]:SIPERT ST: Action:
> do-set-local-variable("csCode",scope="policy","5").
> [01/03/12 15:50:44.289]:SIPERT ST: arg-string("5")
> [01/03/12 15:50:44.290]:SIPERT ST: token-text("5")
> [01/03/12 15:50:44.290]:SIPERT ST: Arg Value: "5".
> [01/03/12 15:50:44.291]:SIPERT ST: Action:
> do-set-local-variable("tipo",scope="policy",token-src-attr("SipertTipo")).
> [01/03/12 15:50:44.291]:SIPERT ST:
> arg-string(token-src-attr("SipertTipo"))
> [01/03/12 15:50:44.292]:SIPERT ST:
> token-src-attr("SipertTipo")
> [01/03/12 15:50:44.292]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.293]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SipertTipo"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.294]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.294]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.301]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.302]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="SipertTipo">
> <value timestamp="1325601233#44" type="string">U</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.304]:SIPERT ST: Token Value: "U".
> [01/03/12 15:50:44.305]:SIPERT ST: Arg Value: "U".
> [01/03/12 15:50:44.305]:SIPERT ST: Action:
> do-set-local-variable("dipDescr",scope="policy",token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
> "+token-src-attr("Given Name")))).
> [01/03/12 15:50:44.306]:SIPERT ST:
> arg-string(token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
> "+token-src-attr("Given Name"))))
> [01/03/12 15:50:44.307]:SIPERT ST:
> token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
> "+token-src-attr("Given Name")))
> [01/03/12 15:50:44.308]:SIPERT ST:
> token-replace-all("'","''",token-upper-case(token-src-attr("Surname")+"
> "+token-src-attr("Given Name")))
> [01/03/12 15:50:44.308]:SIPERT ST:
> token-upper-case(token-src-attr("Surname")+" "+token-src-attr("Given
> Name"))
> [01/03/12 15:50:44.309]:SIPERT ST:
> token-upper-case(token-src-attr("Surname")+" "+token-src-attr("Given
> Name"))
> [01/03/12 15:50:44.310]:SIPERT ST:
> token-src-attr("Surname")
> [01/03/12 15:50:44.310]:SIPERT ST: Query from
> policy
> [01/03/12 15:50:44.310]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="Surname"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.312]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.313]:SIPERT ST: Performing
> operation query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.315]:SIPERT ST: Query from policy
> result
> [01/03/12 15:50:44.315]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="Surname">
> <value timestamp="1325601233#15" type="string">Test</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.318]:SIPERT ST: Token Value:
> "Test ".
> [01/03/12 15:50:44.335]:SIPERT ST: token-text(" ")
> [01/03/12 15:50:44.336]:SIPERT ST:
> token-src-attr("Given Name")
> [01/03/12 15:50:44.336]:SIPERT ST: Query from
> policy
> [01/03/12 15:50:44.337]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="Given Name"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.339]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.340]:SIPERT ST: Performing
> operation query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.342]:SIPERT ST: Query from policy
> result
> [01/03/12 15:50:44.342]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="Given Name">
> <value timestamp="1325601233#16"
> type="string">Sipert31</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.346]:SIPERT ST: Token Value:
> "Sipert31".
> [01/03/12 15:50:44.347]:SIPERT ST: Arg Value: "Test
> Sipert31".
> [01/03/12 15:50:44.347]:SIPERT ST: Token Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.347]:SIPERT ST: Arg Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.348]:SIPERT ST: Token Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.349]:SIPERT ST: Arg Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.349]:SIPERT ST: Action:
> do-set-local-variable("dipLingua",scope="policy",token-src-attr("SiperDipLingua")).
> [01/03/12 15:50:44.350]:SIPERT ST:
> arg-string(token-src-attr("SiperDipLingua"))
> [01/03/12 15:50:44.350]:SIPERT ST:
> token-src-attr("SiperDipLingua")
> [01/03/12 15:50:44.359]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.359]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SiperDipLingua"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.362]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.362]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.364]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.365]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="SiperDipLingua">
> <value timestamp="1325601233#41" type="string">I</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.367]:SIPERT ST: Token Value: "I".
> [01/03/12 15:50:44.367]:SIPERT ST: Arg Value: "I".
> [01/03/12 15:50:44.367]:SIPERT ST: Action:
> do-set-local-variable("password",scope="policy",token-src-attr("SipertPassword")).
> [01/03/12 15:50:44.368]:SIPERT ST:
> arg-string(token-src-attr("SipertPassword"))
> [01/03/12 15:50:44.368]:SIPERT ST:
> token-src-attr("SipertPassword")
> [01/03/12 15:50:44.368]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.368]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SipertPassword"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.369]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.369]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.371]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.371]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="SipertPassword">
> <value timestamp="1325601233#39"
> type="string">Password1</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.372]:SIPERT ST: Token Value:
> "Password1".
> [01/03/12 15:50:44.373]:SIPERT ST: Arg Value: "Password1".
> [01/03/12 15:50:44.373]:SIPERT ST: Action:
> do-set-local-variable("fltipoxx",scope="policy","U").
> [01/03/12 15:50:44.373]:SIPERT ST: arg-string("U")
> [01/03/12 15:50:44.373]:SIPERT ST: token-text("U")
> [01/03/12 15:50:44.373]:SIPERT ST: Arg Value: "U".
> [01/03/12 15:50:44.373]:SIPERT ST: Action:
> do-set-local-variable("account",scope="policy",token-upper-case(token-src-attr("CN",class-name="User"))).
> [01/03/12 15:50:44.374]:SIPERT ST:
> arg-string(token-upper-case(token-src-attr("CN",class-name="User")))
> [01/03/12 15:50:44.374]:SIPERT ST:
> token-upper-case(token-src-attr("CN",class-name="User"))
> [01/03/12 15:50:44.374]:SIPERT ST:
> token-upper-case(token-src-attr("CN",class-name="User"))
> [01/03/12 15:50:44.374]:SIPERT ST:
> token-src-attr("CN",class-name="User")
> [01/03/12 15:50:44.375]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.375]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="CN"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.376]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.376]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.378]:SIPERT ST: Query from policy
> result
> [01/03/12 15:50:44.378]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="CN">
> <value naming="true" timestamp="1325601233#4"
> type="string">a001031</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.380]:SIPERT ST: Token Value:
> "a001031".
> [01/03/12 15:50:44.380]:SIPERT ST: Arg Value: "a001031".
> [01/03/12 15:50:44.380]:SIPERT ST: Token Value: "A001031".
> [01/03/12 15:50:44.380]:SIPERT ST: Arg Value: "A001031".
> [01/03/12 15:50:44.380]:SIPERT ST: Action:
> do-set-local-variable("isdefa",scope="policy","S").
> [01/03/12 15:50:44.381]:SIPERT ST: arg-string("S")
> [01/03/12 15:50:44.381]:SIPERT ST: token-text("S")
> [01/03/12 15:50:44.381]:SIPERT ST: Arg Value: "S".
> [01/03/12 15:50:44.381]:SIPERT ST: Action:
> do-set-local-variable("dipfitti",scope="policy","DIPFITTI").
> [01/03/12 15:50:44.381]:SIPERT ST: arg-string("DIPFITTI")
> [01/03/12 15:50:44.381]:SIPERT ST: token-text("DIPFITTI")
> [01/03/12 15:50:44.382]:SIPERT ST: Arg Value: "DIPFITTI".
> [01/03/12 15:50:44.382]:SIPERT ST: Action:
> do-set-local-variable("fltipori",scope="policy","F").
> [01/03/12 15:50:44.382]:SIPERT ST: arg-string("F")
> [01/03/12 15:50:44.382]:SIPERT ST: token-text("F")
> [01/03/12 15:50:44.382]:SIPERT ST: Arg Value: "F".
> [01/03/12 15:50:44.383]:SIPERT ST: Action:
> do-set-local-variable("password_substring",scope="policy",token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))).
> [01/03/12 15:50:44.384]:SIPERT ST:
> arg-string(token-substring(length="6",token-src-attr("SipertPassword",class-name="User")))
> [01/03/12 15:50:44.385]:SIPERT ST:
> token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))
> [01/03/12 15:50:44.385]:SIPERT ST:
> token-substring(length="6",token-src-attr("SipertPassword",class-name="User"))
> [01/03/12 15:50:44.386]:SIPERT ST:
> token-src-attr("SipertPassword",class-name="User")
> [01/03/12 15:50:44.386]:SIPERT ST: Token Value:
> "Password1".
> [01/03/12 15:50:44.387]:SIPERT ST: Arg Value:
> "Password1".
> [01/03/12 15:50:44.387]:SIPERT ST: Token Value: "Passwo".
> [01/03/12 15:50:44.388]:SIPERT ST: Arg Value: "Passwo".
> [01/03/12 15:50:44.388]:SIPERT ST: Action:
> do-set-local-variable("flagST",scope="policy",token-src-attr("SipertFlagSt")).
> [01/03/12 15:50:44.390]:SIPERT ST:
> arg-string(token-src-attr("SipertFlagSt"))
> [01/03/12 15:50:44.390]:SIPERT ST:
> token-src-attr("SipertFlagSt")
> [01/03/12 15:50:44.391]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.391]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SipertFlagSt"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.393]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.393]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.395]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.395]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.397]:SIPERT ST: Token Value: "".
> [01/03/12 15:50:44.398]:SIPERT ST: Arg Value: "".
> [01/03/12 15:50:44.398]:SIPERT ST: Action:
> do-set-local-variable("vDataScad",scope="policy",token-src-attr("SipertDataScadNum")).
> [01/03/12 15:50:44.399]:SIPERT ST:
> arg-string(token-src-attr("SipertDataScadNum"))
> [01/03/12 15:50:44.399]:SIPERT ST:
> token-src-attr("SipertDataScadNum")
> [01/03/12 15:50:44.400]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.400]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SipertDataScadNum"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.404]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.407]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.409]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.409]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <attr attr-name="SipertDataScadNum">
> <value timestamp="1325601233#46"
> type="string">20371231000000000000000</value>
> </attr>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.413]:SIPERT ST: Token Value:
> "20371231000000000000000".
> [01/03/12 15:50:44.413]:SIPERT ST: Arg Value:
> "20371231000000000000000".
> [01/03/12 15:50:44.413]:SIPERT ST: Action:
> do-set-local-variable("sipertCN",scope="policy",token-src-attr("CN")).
> [01/03/12 15:50:44.414]:SIPERT ST:
> arg-string(token-src-attr("CN"))
> [01/03/12 15:50:44.414]:SIPERT ST: token-src-attr("CN")
> [01/03/12 15:50:44.414]:SIPERT ST: Token Value: "a001031".
> [01/03/12 15:50:44.414]:SIPERT ST: Arg Value: "a001031".
> [01/03/12 15:50:44.415]:SIPERT ST: Action:
> do-set-local-variable("sipertUtRoleCS",scope="policy",token-src-attr("SipertUtRoleCs")).
> [01/03/12 15:50:44.415]:SIPERT ST:
> arg-string(token-src-attr("SipertUtRoleCs"))
> [01/03/12 15:50:44.415]:SIPERT ST:
> token-src-attr("SipertUtRoleCs")
> [01/03/12 15:50:44.415]:SIPERT ST: Query from policy
> [01/03/12 15:50:44.416]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <query class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> scope="entry">
> <read-attr attr-name="SipertUtRoleCs"/>
> </query>
> </input>
> </nds>
> [01/03/12 15:50:44.416]:SIPERT ST: Pumping XDS to
> eDirectory.
> [01/03/12 15:50:44.417]:SIPERT ST: Performing operation
> query for \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.418]:SIPERT ST: Query from policy result
> [01/03/12 15:50:44.418]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <output>
> <instance class-name="User"
> qualified-src-dn="O=gsecoll\OU=AU\OU=Interni\CN=a001031"
> src-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" src-entry-id="56057">
> <association
> state="associated">PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> </instance>
> <status level="success"></status>
> </output>
> </nds>
> [01/03/12 15:50:44.420]:SIPERT ST: Token Value: "".
> [01/03/12 15:50:44.420]:SIPERT ST: Arg Value: "".
> [01/03/12 15:50:44.420]:SIPERT ST: Action: do-if().
> [01/03/12 15:50:44.420]:SIPERT ST: Evaluating conditions.
> [01/03/12 15:50:44.420]:SIPERT ST: (if-op-attr 'company'
> changing-to "GSE") = FALSE.
> [01/03/12 15:50:44.421]:SIPERT ST: Performing else actions.
> [01/03/12 15:50:44.421]:SIPERT ST: Action: do-if().
> [01/03/12 15:50:44.421]:SIPERT ST: Evaluating conditions.
> [01/03/12 15:50:44.421]:SIPERT ST: (if-op-attr 'company'
> changing-to "AU") = FALSE.
> [01/03/12 15:50:44.421]:SIPERT ST: Performing else actions.
> [01/03/12 15:50:44.422]:SIPERT ST: Action: do-if().
> [01/03/12 15:50:44.422]:SIPERT ST: Evaluating
> conditions.
> [01/03/12 15:50:44.422]:SIPERT ST: (if-op-attr
> 'company' changing-to "GME") = TRUE.
> [01/03/12 15:50:44.422]:SIPERT ST: Performing if
> actions.
> [01/03/12 15:50:44.422]:SIPERT ST: Action:
> do-set-local-variable("initDipCode",scope="policy","20003").
> [01/03/12 15:50:44.440]:SIPERT ST:
> arg-string("20003")
> [01/03/12 15:50:44.440]:SIPERT ST:
> token-text("20003")
> [01/03/12 15:50:44.440]:SIPERT ST: Arg Value:
> "20003".
> [01/03/12 15:50:44.441]:SIPERT ST: Action: do-if().
> [01/03/12 15:50:44.441]:SIPERT ST: Evaluating conditions.
> [01/03/12 15:50:44.441]:SIPERT ST: (if-op-attr 'company'
> changing) = TRUE.
> [01/03/12 15:50:44.441]:SIPERT ST: (if-local-variable
> 'initDipCode' available) = TRUE.
> [01/03/12 15:50:44.442]:SIPERT ST: Performing if actions.
> [01/03/12 15:50:44.442]:SIPERT ST: Action:
> do-set-local-variable("dipCode",scope="policy",token-local-variable("initDipCode")+token-substring(length="6",start="1",token-src-attr("CN"))).
> [01/03/12 15:50:44.443]:SIPERT ST:
> arg-string(token-local-variable("initDipCode")+token-substring(length="6",start="1",token-src-attr("CN")))
> [01/03/12 15:50:44.444]:SIPERT ST:
> token-local-variable("initDipCode")
> [01/03/12 15:50:44.445]:SIPERT ST: Token Value:
> "20003".
> [01/03/12 15:50:44.445]:SIPERT ST:
> token-substring(length="6",start="1",token-src-attr("CN"))
> [01/03/12 15:50:44.446]:SIPERT ST:
> token-substring(length="6",start="1",token-src-attr("CN"))
> [01/03/12 15:50:44.446]:SIPERT ST:
> token-src-attr("CN")
> [01/03/12 15:50:44.447]:SIPERT ST: Token Value:
> "a001031".
> [01/03/12 15:50:44.447]:SIPERT ST: Arg Value:
> "a001031".
> [01/03/12 15:50:44.447]:SIPERT ST: Token Value:
> "001031".
> [01/03/12 15:50:44.448]:SIPERT ST: Arg Value:
> "20003001031".
> [01/03/12 15:50:44.448]:SIPERT ST: Action:
> do-set-src-attr-value("SipertDipCode",token-local-variable("dipCode")).
> [01/03/12 15:50:44.449]:SIPERT ST:
> arg-string(token-local-variable("dipCode"))
> [01/03/12 15:50:44.450]:SIPERT ST:
> token-local-variable("dipCode")
> [01/03/12 15:50:44.450]:SIPERT ST: Token Value:
> "20003001031".
> [01/03/12 15:50:44.451]:SIPERT ST: Arg Value:
> "20003001031".
> [01/03/12 15:50:44.451]:SIPERT ST: Evaluating selection criteria for
> rule 'UPDATE MULTIPLE'.
> [01/03/12 15:50:44.452]:SIPERT ST: (if-operation equal "modify") =
> TRUE.
> [01/03/12 15:50:44.452]:SIPERT ST: (if-class-name equal "User") =
> TRUE.
> [01/03/12 15:50:44.452]:SIPERT ST: Rule selected.
> [01/03/12 15:50:44.453]:SIPERT ST: Applying rule 'UPDATE MULTIPLE'.
> [01/03/12 15:50:44.453]:SIPERT ST: Action:
> do-append-xml-element("jdbc:statement","/nds/input").
> [01/03/12 15:50:44.454]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:type","/nds/input/jdbc:statement","update").
> [01/03/12 15:50:44.454]:SIPERT ST: arg-string("update")
> [01/03/12 15:50:44.454]:SIPERT ST: token-text("update")
> [01/03/12 15:50:44.454]:SIPERT ST: Arg Value: "update".
> [01/03/12 15:50:44.471]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:transaction-type","/nds/input/jdbc:statement","manual").
> [01/03/12 15:50:44.472]:SIPERT ST: arg-string("manual")
> [01/03/12 15:50:44.472]:SIPERT ST: token-text("manual")
> [01/03/12 15:50:44.472]:SIPERT ST: Arg Value: "manual".
> [01/03/12 15:50:44.473]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:transaction-id","/nds/input/jdbc:statement","4").
> [01/03/12 15:50:44.474]:SIPERT ST: arg-string("4")
> [01/03/12 15:50:44.474]:SIPERT ST: token-text("4")
> [01/03/12 15:50:44.474]:SIPERT ST: Arg Value: "4".
> [01/03/12 15:50:44.474]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
> [01/03/12 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
> [01/03/12 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
> [01/03/12 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement").
> [01/03/12 15:50:44.476]:SIPERT ST: Action:
> do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[1]","UPDATE
> SCUDO.DIPENDENTI SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
> '"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
> '"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
> '"+token-substring(length="6",start="1",token-local-variable("sipertCN"))+"'").
> [01/03/12 15:50:44.477]:SIPERT ST: arg-string("UPDATE
> SCUDO.DIPENDENTI SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
> '"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
> '"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
> '"+token-substring(length="6",start="1",token-local-variable("sipertCN"))+"'")
> [01/03/12 15:50:44.477]:SIPERT ST: token-text("UPDATE
> SCUDO.DIPENDENTI SET ")
> [01/03/12 15:50:44.478]:SIPERT ST: token-text("DIP_CODE = '")
> [01/03/12 15:50:44.478]:SIPERT ST:
> token-local-variable("dipCode")
> [01/03/12 15:50:44.478]:SIPERT ST: Token Value:
> "20003001031".
> [01/03/12 15:50:44.478]:SIPERT ST: token-text("', ")
> [01/03/12 15:50:44.478]:SIPERT ST: token-text("DIP_DESCR =
> '")
> [01/03/12 15:50:44.478]:SIPERT ST:
> token-local-variable("dipDescr")
> [01/03/12 15:50:44.479]:SIPERT ST: Token Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.479]:SIPERT ST: token-text("', ")
> [01/03/12 15:50:44.479]:SIPERT ST: token-text("DIP_LINGUA =
> '")
> [01/03/12 15:50:44.479]:SIPERT ST:
> token-local-variable("dipLingua")
> [01/03/12 15:50:44.479]:SIPERT ST: Token Value: "I".
> [01/03/12 15:50:44.479]:SIPERT ST: token-text("' ")
> [01/03/12 15:50:44.479]:SIPERT ST: token-text("WHERE
> substr(DIP_CODE,6) = '")
> [01/03/12 15:50:44.480]:SIPERT ST:
> token-substring(length="6",start="1",token-local-variable("sipertCN"))
> [01/03/12 15:50:44.480]:SIPERT ST:
> token-substring(length="6",start="1",token-local-variable("sipertCN"))
> [01/03/12 15:50:44.480]:SIPERT ST:
> token-local-variable("sipertCN")
> [01/03/12 15:50:44.480]:SIPERT ST: Token Value:
> "a001031".
> [01/03/12 15:50:44.480]:SIPERT ST: Arg Value: "a001031".
> [01/03/12 15:50:44.481]:SIPERT ST: Token Value: "001031".
> [01/03/12 15:50:44.481]:SIPERT ST: token-text("'")
> [01/03/12 15:50:44.481]:SIPERT ST: Arg Value: "UPDATE
> SCUDO.DIPENDENTI SET DIP_CODE = '20003001031', DIP_DESCR = 'TEST
> SIPERT31', DIP_LINGUA = 'I' WHERE substr(DIP_CODE,6) = '001031'".
> [01/03/12 15:50:44.482]:SIPERT ST: Action:
> do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[2]","UPDATE
> SCUDO.DIPENDENTI_PER_C_S_UPD SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"' ,TIPO =
> '"+token-local-variable("tipo")+"', CS_CODE =
> '"+token-local-variable("csCode")+"'"+" WHERE UPPER(UT_CODE) =
> UPPER('"+token-local-variable("sipertCN")+"') ").
> [01/03/12 15:50:44.484]:SIPERT ST: arg-string("UPDATE
> SCUDO.DIPENDENTI_PER_C_S_UPD SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"' ,TIPO =
> '"+token-local-variable("tipo")+"', CS_CODE =
> '"+token-local-variable("csCode")+"'"+" WHERE UPPER(UT_CODE) =
> UPPER('"+token-local-variable("sipertCN")+"') ")
> [01/03/12 15:50:44.486]:SIPERT ST: token-text("UPDATE
> SCUDO.DIPENDENTI_PER_C_S_UPD SET ")
> [01/03/12 15:50:44.486]:SIPERT ST: token-text("DIP_CODE = '")
> [01/03/12 15:50:44.486]:SIPERT ST:
> token-local-variable("dipCode")
> [01/03/12 15:50:44.511]:SIPERT ST: Token Value:
> "20003001031".
> [01/03/12 15:50:44.512]:SIPERT ST: token-text("' ,TIPO = '")
> [01/03/12 15:50:44.512]:SIPERT ST:
> token-local-variable("tipo")
> [01/03/12 15:50:44.513]:SIPERT ST: Token Value: "U".
> [01/03/12 15:50:44.513]:SIPERT ST: token-text("', CS_CODE =
> '")
> [01/03/12 15:50:44.513]:SIPERT ST:
> token-local-variable("csCode")
> [01/03/12 15:50:44.514]:SIPERT ST: Token Value: "5".
> [01/03/12 15:50:44.514]:SIPERT ST: token-text("'")
> [01/03/12 15:50:44.514]:SIPERT ST: token-text(" WHERE
> UPPER(UT_CODE) = UPPER('")
> [01/03/12 15:50:44.515]:SIPERT ST:
> token-local-variable("sipertCN")
> [01/03/12 15:50:44.515]:SIPERT ST: Token Value: "a001031".
> [01/03/12 15:50:44.516]:SIPERT ST: token-text("') ")
> [01/03/12 15:50:44.516]:SIPERT ST: Arg Value: "UPDATE
> SCUDO.DIPENDENTI_PER_C_S_UPD SET DIP_CODE = '20003001031' ,TIPO = 'U',
> CS_CODE = '5' WHERE UPPER(UT_CODE) = UPPER('a001031') ".
> [01/03/12 15:50:44.517]:SIPERT ST: Action:
> do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[3]"," UPDATE
> SCUDO.PASSWORD_UPD SET "+"PASSWORD=
> '"+token-local-variable("password_substring")+"', "+"DATA_VAR = SYSDATE
> "+", "+"FLAG_ST = '"+token-local-variable("flagST")+"' "+"WHERE
> UPPER(UT_CODE) = UPPER('"+token-local-variable("sipertCN")+"')").
> [01/03/12 15:50:44.519]:SIPERT ST: arg-string(" UPDATE
> SCUDO.PASSWORD_UPD SET "+"PASSWORD=
> '"+token-local-variable("password_substring")+"', "+"DATA_VAR = SYSDATE
> "+", "+"FLAG_ST = '"+token-local-variable("flagST")+"' "+"WHERE
> UPPER(UT_CODE) = UPPER('"+token-local-variable("sipertCN")+"')")
> [01/03/12 15:50:44.521]:SIPERT ST: token-text(" UPDATE
> SCUDO.PASSWORD_UPD SET ")
> [01/03/12 15:50:44.521]:SIPERT ST: token-text("PASSWORD= '")
> [01/03/12 15:50:44.522]:SIPERT ST:
> token-local-variable("password_substring")
> [01/03/12 15:50:44.522]:SIPERT ST: Token Value: "Passwo".
> [01/03/12 15:50:44.522]:SIPERT ST: token-text("', ")
> [01/03/12 15:50:44.523]:SIPERT ST: token-text("DATA_VAR =
> SYSDATE ")
> [01/03/12 15:50:44.523]:SIPERT ST: token-text(", ")
> [01/03/12 15:50:44.523]:SIPERT ST: token-text("FLAG_ST = '")
> [01/03/12 15:50:44.524]:SIPERT ST:
> token-local-variable("flagST")
> [01/03/12 15:50:44.524]:SIPERT ST: Token Value: "".
> [01/03/12 15:50:44.524]:SIPERT ST: token-text("' ")
> [01/03/12 15:50:44.525]:SIPERT ST: token-text("WHERE
> UPPER(UT_CODE) = UPPER('")
> [01/03/12 15:50:44.525]:SIPERT ST:
> token-local-variable("sipertCN")
> [01/03/12 15:50:44.526]:SIPERT ST: Token Value: "a001031".
> [01/03/12 15:50:44.526]:SIPERT ST: token-text("')")
> [01/03/12 15:50:44.526]:SIPERT ST: Arg Value: " UPDATE
> SCUDO.PASSWORD_UPD SET PASSWORD= 'Passwo', DATA_VAR = SYSDATE , FLAG_ST
> = '' WHERE UPPER(UT_CODE) = UPPER('a001031')".
> [01/03/12 15:50:44.535]:SIPERT ST: Action:
> do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[4]","UPDATE
> SCUDO.UTENTI_UPD SET "+"UT_CODE_DESCR =
> '"+token-local-variable("dipDescr")+"', FLTIPOXX =
> '"+token-local-variable("fltipoxx")+"', CS_CODE =
> '"+token-local-variable("csCode")+"', "+"DATA_SCAD =
> TO_DATE('"+token-substring(length="8",token-local-variable("vDataScad"))+"',
> 'YYYYMMDD') "+"WHERE UPPER(UT_CODE) =
> UPPER('"+token-local-variable("sipertCN")+"')").
> [01/03/12 15:50:44.538]:SIPERT ST: arg-string("UPDATE
> SCUDO.UTENTI_UPD SET "+"UT_CODE_DESCR =
> '"+token-local-variable("dipDescr")+"', FLTIPOXX =
> '"+token-local-variable("fltipoxx")+"', CS_CODE =
> '"+token-local-variable("csCode")+"', "+"DATA_SCAD =
> TO_DATE('"+token-substring(length="8",token-local-variable("vDataScad"))+"',
> 'YYYYMMDD') "+"WHERE UPPER(UT_CODE) =
> UPPER('"+token-local-variable("sipertCN")+"')")
> [01/03/12 15:50:44.540]:SIPERT ST: token-text("UPDATE
> SCUDO.UTENTI_UPD SET ")
> [01/03/12 15:50:44.540]:SIPERT ST: token-text("UT_CODE_DESCR =
> '")
> [01/03/12 15:50:44.541]:SIPERT ST:
> token-local-variable("dipDescr")
> [01/03/12 15:50:44.541]:SIPERT ST: Token Value: "TEST
> SIPERT31".
> [01/03/12 15:50:44.541]:SIPERT ST: token-text("', FLTIPOXX =
> '")
> [01/03/12 15:50:44.541]:SIPERT ST:
> token-local-variable("fltipoxx")
> [01/03/12 15:50:44.542]:SIPERT ST: Token Value: "U".
> [01/03/12 15:50:44.542]:SIPERT ST: token-text("', CS_CODE =
> '")
> [01/03/12 15:50:44.542]:SIPERT ST:
> token-local-variable("csCode")
> [01/03/12 15:50:44.542]:SIPERT ST: Token Value: "5".
> [01/03/12 15:50:44.542]:SIPERT ST: token-text("', ")
> [01/03/12 15:50:44.543]:SIPERT ST: token-text("DATA_SCAD =
> TO_DATE('")
> [01/03/12 15:50:44.543]:SIPERT ST:
> token-substring(length="8",token-local-variable("vDataScad"))
> [01/03/12 15:50:44.543]:SIPERT ST:
> token-substring(length="8",token-local-variable("vDataScad"))
> [01/03/12 15:50:44.544]:SIPERT ST:
> token-local-variable("vDataScad")
> [01/03/12 15:50:44.551]:SIPERT ST: Token Value:
> "20371231000000000000000".
> [01/03/12 15:50:44.551]:SIPERT ST: Arg Value:
> "20371231000000000000000".
> [01/03/12 15:50:44.551]:SIPERT ST: Token Value: "20371231".
> [01/03/12 15:50:44.552]:SIPERT ST: token-text("', 'YYYYMMDD')
> ")
> [01/03/12 15:50:44.552]:SIPERT ST: token-text("WHERE
> UPPER(UT_CODE) = UPPER('")
> [01/03/12 15:50:44.552]:SIPERT ST:
> token-local-variable("sipertCN")
> [01/03/12 15:50:44.552]:SIPERT ST: Token Value: "a001031".
> [01/03/12 15:50:44.552]:SIPERT ST: token-text("')")
> [01/03/12 15:50:44.553]:SIPERT ST: Arg Value: "UPDATE
> SCUDO.UTENTI_UPD SET UT_CODE_DESCR = 'TEST SIPERT31', FLTIPOXX = 'U',
> CS_CODE = '5', DATA_SCAD = TO_DATE('20371231', 'YYYYMMDD') WHERE
> UPPER(UT_CODE) = UPPER('a001031')".
> [01/03/12 15:50:44.554]:SIPERT ST: Direct command from policy
> [01/03/12 15:50:44.554]:SIPERT ST:
> <nds dtdversion="3.5" ndsversion="8.x">
> <source>
> <product version="3.6.0.4294">DirXML</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <modify class-name="User"
> dest-dn="\DEMOGSE\gsecoll\AU\Interni\a001031" dest-entry-id="56057"
> event-id="colidmserver#20120103145044#1#1">
>
> <association>PK_UT_CODE=A001031,table=VISTAIAMSIPERT,schema=SCUDO</association>
> <modify-attr attr-name="SipertDipCode">
> <remove-all-values/>
> <add-value>
> <value>20003001031</value>
> </add-value>
> </modify-attr>
> </modify>
> </input>
> </nds>
> [01/03/12 15:50:44.563]:SIPERT ST: Pumping XDS to eDirectory.
> [01/03/12 15:50:44.566]:SIPERT ST: Performing operation modify for
> \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.587]:SIPERT ST: Modifying entry
> \DEMOGSE\gsecoll\AU\Interni\a001031.
> [01/03/12 15:50:44.597]:SIPERT ST: Processing returned document.
> [01/03/12 15:50:44.598]:SIPERT ST: Processing operation<status> for


0 Likes
Knowledge Partner
Knowledge Partner

Re: UPDATE statement problem of jdbc driver

On Tue, 03 Jan 2012 15:26:04 +0000, snestola wrote:

> Hi all, I've a SLES10 SP3 with edir 885 and IDM 361 I have a lot of
> drivers running jdbc statement without problems, but one of them has
> problems on a procedure. This jdbc driver must perform the INSERT and
> UPDATE statement on a view Oracle 10 and then upgrade 7 tables.
> The INSERT statement works without problems while the UPDATE don't work
> block the driver.


Hm. This looks to me like it should work, but I'm not an expert on the
JDBC driver.


> Any ideas? Thanks in advance


In looking at the trace, it looks like the jdbc:statement elements should
be added to the doc, but it looks like your trace is cut off, because we
never see the end of the "UPDATE MULTIPLE" rule.

Here's the rule being executed:

> 15:50:44.453]:SIPERT ST: Applying rule 'UPDATE MULTIPLE'. [01/03/12
> 15:50:44.453]:SIPERT ST: Action:
> do-append-xml-element("jdbc:statement","/nds/input"). [01/03/12
> 15:50:44.454]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:type","/nds/input/jdbc:statement","update").
> [01/03/12 15:50:44.454]:SIPERT ST: arg-string("update") [01/03/12
> 15:50:44.454]:SIPERT ST: token-text("update") [01/03/12
> 15:50:44.454]:SIPERT ST: Arg Value: "update". [01/03/12
> 15:50:44.471]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:transaction-type","/nds/input/

jdbc:statement","manual").
> [01/03/12 15:50:44.472]:SIPERT ST: arg-string("manual") [01/03/12
> 15:50:44.472]:SIPERT ST: token-text("manual") [01/03/12
> 15:50:44.472]:SIPERT ST: Arg Value: "manual". [01/03/12
> 15:50:44.473]:SIPERT ST: Action:
> do-set-xml-attr("jdbc:transaction-id","/nds/input/jdbc:statement","4").
> [01/03/12 15:50:44.474]:SIPERT ST: arg-string("4") [01/03/12
> 15:50:44.474]:SIPERT ST: token-text("4") [01/03/12
> 15:50:44.474]:SIPERT ST: Arg Value: "4". [01/03/12
> 15:50:44.474]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement"). [01/03/12
> 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement"). [01/03/12
> 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement"). [01/03/12
> 15:50:44.475]:SIPERT ST: Action:
> do-append-xml-element("jdbc:sql","/nds/input/jdbc:statement"). [01/03/12
> 15:50:44.476]:SIPERT ST: Action:
> do-append-xml-text("/nds/input/jdbc:statement/jdbc:sql[1]","UPDATE
> SCUDO.DIPENDENTI SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
> '"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
> '"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
> '"+token-substring(length="6",start="1",token-local-variable

("sipertCN"))+"'").
> [01/03/12 15:50:44.477]:SIPERT ST: arg-string("UPDATE
> SCUDO.DIPENDENTI SET "+"DIP_CODE =
> '"+token-local-variable("dipCode")+"', "+"DIP_DESCR =
> '"+token-local-variable("dipDescr")+"', "+"DIP_LINGUA =
> '"+token-local-variable("dipLingua")+"' "+"WHERE substr(DIP_CODE,6) =
> '"+token-substring(length="6",start="1",token-local-variable

("sipertCN"))+"'")

If I'm reading this right, you're trying to build a jdbc:statement node
with four jdbc:sql nodes underneath it, each containing an SQL statement
to be executed in the database. I've done something like that before, and
it's worked for me, so it's possible. But my code is a bit different, so
I don't know if the difference matters. I did it with something like this:

<rule>
<description>Update Account</description>
<conditions>
<and>
<if-operation mode="case" op="equal">modify</if-operation>
<if-class-name mode="nocase" op="equal">User</if-class-name>
</and>
</conditions>
<actions>
<do-append-xml-element expression="/nds/input" name="jdbc:statement"/>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:type">
<arg-string>
<token-text xml:space="preserve">update</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-type">
<arg-string>
<token-text xml:space="preserve">manual</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-id">
<arg-string>
<token-text xml:space="preserve">2</token-text>
</arg-string>
</do-set-xml-attr>
<do-if>
<arg-conditions>
<and>
<if-op-attr mode="regex" name="first_names" op="changing-to">.+</if-
op-attr>
</and>
</arg-conditions>
<arg-actions>
<do-append-xml-element expression="/nds/input/jdbc:statement"
name="jdbc:sql"/>
<do-append-xml-text expression="/nds/input/jdbc:statement/jdbc:sql
[last()]">
<arg-string>
<token-text xml:space="preserve">update users set first_names = '</
token-text>
<token-op-attr name="first_names"/>
<token-text xml:space="preserve">' where id = '</token-text>
<token-src-name/>
<token-text xml:space="preserve">'</token-text>
</arg-string>
</do-append-xml-text>
</arg-actions>
<arg-actions/>
</do-if>
<do-if>
<arg-conditions>
<and>
<if-op-attr mode="regex" name="last_name" op="changing-to">.+</if-op-
attr>
</and>
</arg-conditions>
<arg-actions>
<do-append-xml-element expression="/nds/input/jdbc:statement"
name="jdbc:sql"/>
<do-append-xml-text expression="/nds/input/jdbc:statement/jdbc:sql
[last()]">
<arg-string>
<token-text xml:space="preserve">update users set last_name = '</
token-text>
<token-op-attr name="last_name"/>
<token-text xml:space="preserve">' where id = '</token-text>
<token-src-name/>
<token-text xml:space="preserve">'</token-text>
</arg-string>
</do-append-xml-text>
</arg-actions>
<arg-actions/>
</do-if>
<do-strip-xpath expression="self::modify"/>
</actions>
</rule>

The difference here being that your code seems to be adding four jdbc:sql
nodes, then referencing them directly, where I'm just appending jdbc:sql
nodes as needed, then using the [last()] notation to update the correct
one. I don't think that should matter, but I'd need to see the rest of
your trace to see what your rule actually does to the document.


--
--------------------------------------------------------------------------
David Gersic dgersic_@_niu.edu
Knowledge Partner http://forums.novell.com

Please post questions in the forums. No support provided via email.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.