Execute Edit on Informix gives this exception :
java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ol_informix1210) failed.
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1630)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:259)
at \\...\\ .\\हिñçêČάй語简�?한\\.Q⡋ꃅ⠆ꇁ class break.e(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⢣ꌣᡥ᠗ do.IH(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⢣ꌣᡥ᠗ do.am(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⢣ꌣᡥ᠗ do.getConnection(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.E0 ꁥꐺ.getConnection(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.E0 ꁥꐺ.run(Unknown Source)
Caused by: com.informix.asf.IfxASFException: Attempt to connect to database server (ol_informix1210) failed.
at com.informix.util.IfxErrMsg.getLocIfxASFException(IfxErrMsg.java:815)
at com.informix.asf.Connection.establishConnection(Connection.java:1798)
at com.informix.asf.Connection.<init>(Connection.java:396)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1267)
... 11 more
15.0.0-beta-1 = works
15.0.0-beta-10 = works
15.0.0-beta-20 = works
15.0.0-beta-30 = works
15.0.0-beta-33 = works
15.0.0-beta-34 = works
15.0.0-beta-35 = fails
15.0.0-beta-37 = fails
15.0.0-beta-41 = fails
15.0.0-rc-1 = fails
Difference between beta-34 and beta-35 is below (Note the new JDBC driver) :
ADS 15.0.0-beta-35 |
When we right click on Date/Date and Time Dimension in Filter Deck Measure(None) is displayed. |
Top N Filter should not persist filter values but recalculate upon rebuild |
Informix JDBC Driver 4.10.JC1,March 2013 |
Fix localized text in dashboard worksheet ID - For "Measure Names" color/shape legend, do not use localized field name - Since date grouping names are localized, use underlying field name instead of label name |
Revert the fix to so the following issues are fixed: In filter card unchecked values are automatically get checked after refresh for "Date and time" datatype field if Top N is applied. filter card shows wrong behaviour when we apply topN filter and then refresh the sheet or duplicate the sheet. |
ADS 15.0.0-beta-34 |
Difference between beta-34 and beta-35 is below (Note the new JDBC driver) :
ADS 15.0.0-beta-35 |
When we right click on Date/Date and Time Dimension in Filter Deck Measure(None) is displayed. |
Top N Filter should not persist filter values but recalculate upon rebuild |
Informix JDBC Driver 4.10.JC1,March 2013 |
Fix localized text in dashboard worksheet ID - For "Measure Names" color/shape legend, do not use localized field name - Since date grouping names are localized, use underlying field name instead of label name |
Revert the fix to so the following issues are fixed: In filter card unchecked values are automatically get checked after refresh for "Date and time" datatype field if Top N is applied. filter card shows wrong behaviour when we apply topN filter and then refresh the sheet or duplicate the sheet. |
ADS 15.0.0-beta-34 |
I can reproduce with the binary 15.0.0, but I can't reproduce with 15.0.0 development environment, so the issue could be related to the new JDBC driver and obfuscation.
I can reproduce with the binary 15.0.0, but I can't reproduce with 15.0.0 development environment, so the issue could be related to the new JDBC driver and obfuscation.
I've removed obfuscation from the calling class and that solves the issue.
I've removed obfuscation from the calling class and that solves the issue.
I've also updated the Informix JDBC driver version from 4.10-jc1 to 4.10-jc4
I've also updated the Informix JDBC driver version from 4.10-jc1 to 4.10-jc4
Verified in ADS v15.0.3-6. I was not able to reproduce the issue at all previously since I was using the Informix driver which Ivan had sent me and was replacing it with in the Drivers Folder. I used the default Informix driver and was able to reproduce in the versions which Niels had mentioned.
Now in ADS v15.0.3-6 the issue with Execute Edit is resolved
Verified in ADS v15.0.3-6. I was not able to reproduce the issue at all previously since I was using the Informix driver which Ivan had sent me and was replacing it with in the Drivers Folder. I used the default Informix driver and was able to reproduce in the versions which Niels had mentioned.
Now in ADS v15.0.3-6 the issue with Execute Edit is resolved
Select table from Schema Tree -> Right click and Edit Table Data (Top 1000) gives the initial error in 15.0.7
Select table from Schema Tree -> Right click and Edit Table Data (Top 1000) gives the initial error in 15.0.7
Verified below places in ADS v15.0.7-1.
1. Servers Tab - right click and edit table data
2. Projects tab - right click and edit table data
3. Execute Select query and click on Execute Edit icon in query analyzer
4. Connect to Query Builder, add a table and click on Execute Edit
Verified below places in ADS v15.0.7-1.
1. Servers Tab - right click and edit table data
2. Projects tab - right click and edit table data
3. Execute Select query and click on Execute Edit icon in query analyzer
4. Connect to Query Builder, add a table and click on Execute Edit
Verified in Patch ADS 15.0.7 and Aqua Data Studio 15.0.7-2
Works fine and no exception in logs.
Verified in Patch ADS 15.0.7 and Aqua Data Studio 15.0.7-2
Works fine and no exception in logs.
Issue #12494 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 15.0.7-1,15.0.3-5,15.0.3-4 |
No time estimate |
15.0.0-beta-1 = works
15.0.0-beta-10 = works
15.0.0-beta-20 = works
15.0.0-beta-30 = works
15.0.0-beta-33 = works
15.0.0-beta-34 = works
15.0.0-beta-35 = fails
15.0.0-beta-37 = fails
15.0.0-beta-41 = fails
15.0.0-rc-1 = fails