Forum Stats

  • 3,734,166 Users
  • 2,246,899 Discussions
  • 7,857,145 Comments

Discussions

Bug? Save fails after transform edited - java closed connection error

Kresimir Bokulic
Kresimir Bokulic Member Posts: 6
edited Oct 17, 2014 11:41AM in Machine Learning

Hi,

i have this problem with saving ODM workflow after editing transform node.


In transform node I made transform edit for variable 'IMP_APPL_PA_EMP_STS_CD_REV_BIN' to bin variable, sql code as is:

case

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('011','040','070','080','090')) then 1

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('012','014','030','051','990')) then 2

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('010','013','050','061','100')) then 3

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('015','020','021','022','023','060')) then 4

when ("IMP_APPL_PA_EMP_STS_CD_REV" is null) then 1

else 3

end

Validation pass well, but after I press save I get mesage:

Unable to save TDW_RISK/Test/binn_test (java.sql.SQLRecoverableException: Closed Connection).

I figure out that when I put shorter sql case-when, example

case

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('011','040','070','080','090')) then 1

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('012','014','030','051','990')) then 2

when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('010','013','050')) then 3

else 3

end

ewerything is ok. When I add  one,two or any more 'strings' to case when example:061','100' same error happend again.

I try to do that with differen datasource in different workfolows but nothing helped.

I found workaround using SQLNode and it work but it is not best, since we have to use transform for other variables.

Any Idea why is this happenning? Any known restrictions in SQL Developer Transform node?

System: SQL Developer  Version 4.0.0.12, Database 11.2.0.2

Regards,

Kreso

Best Answer

Answers

This discussion has been closed.