You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Manjula Kutty (JIRA)" <ji...@apache.org> on 2006/12/14 23:30:21 UTC

[jira] Created: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
--------------------------------------------------------------------------------

                 Key: DERBY-2177
                 URL: http://issues.apache.org/jira/browse/DERBY-2177
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.2.2.0
         Environment: OS: ZOS
jvm : Ibm 15 (SR3)
            Reporter: Manjula Kutty


Here is the diff for the test failure

*** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
385 del
< ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
rmat for type INTEGER.' was thrown while evaluating an expression.
386 del
< ERROR 22018: Invalid character string format for type INTEGER.
386a385,386
> ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
d place on line 1.' was thrown while evaluating an expression.
> ERROR XIE0E: Read endOfFile at unexpected place on line 1.
409 del
< ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
rmat for type INTEGER.' was thrown while evaluating an expression.
410 del
< ERROR 22018: Invalid character string format for type INTEGER.
410a409,410
> ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
d place on line 1.' was thrown while evaluating an expression.
> ERROR XIE0E: Read endOfFile at unexpected place on line 1.
Test Failed.
*** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Closed: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Manjula Kutty (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Manjula Kutty closed DERBY-2177.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.1.5

The issue didn't show up in the recent tests ran on the Zos with derby build number 576651 

> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: https://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>             Fix For: 10.3.1.5
>
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Manjula Kutty (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-2177?page=comments#action_12458923 ] 
            
Manjula Kutty commented on DERBY-2177:
--------------------------------------

This test ibm142 also on the same platform

> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: http://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Rajesh Kartha (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-2177?page=comments#action_12458639 ] 
            
Rajesh Kartha commented on DERBY-2177:
--------------------------------------

Can you also post which SQL  statements are throwing this error. 

> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: http://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali updated DERBY-2177:
----------------------------------

    Component/s: Regression Test Failure

> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: https://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Reopened: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden reopened DERBY-2177:
-----------------------------------


reopen to close CNR


> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: https://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>             Fix For: 10.3.1.5
>
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden closed DERBY-2177.
---------------------------------

    Resolution: Cannot Reproduce

> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: https://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>             Fix For: 10.3.1.5
>
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2177) derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)

Posted by "Manjula Kutty (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-2177?page=comments#action_12458922 ] 
            
Manjula Kutty commented on DERBY-2177:
--------------------------------------

ij> create table Alt1 ( Account int,
                        Fname   char(30),
                        Lname   char(30),
                        Company varchar(35),
                        Address varchar(40),
                        City    varchar(20),
                        State   char(5),
                        Zip     char(10),
                        Payment decimal(8,2),
                        Balance decimal(8,2));
0 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALT1' , 'extin/Alt1.asc' ,
                                      null, null, null, 0) ;
ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpected
place on line 1.' was thrown while evaluating an expression.
ERROR XIE0E: Read endOfFile at unexpected place on line 1

When I compared the file extin/Alt1.asc to the one in the trunk at testData\ImportExport\Alt1.asc, the former had only binary values but the later has some meaningful text.  



> derbyall/derbyall.fail:tools/importExportThruIJ.sql fails on zOs with ibm15SR(3)
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2177
>                 URL: http://issues.apache.org/jira/browse/DERBY-2177
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.2.2.0
>         Environment: OS: ZOS
> jvm : Ibm 15 (SR3)
>            Reporter: Manjula Kutty
>
> Here is the diff for the test failure
> *** Start: importExportThruIJ jdk1.5.0 2006-12-14 15:21:43 ***
> 385 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 386 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 386a385,386
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> 409 del
> < ERROR 38000: The exception 'java.sql.SQLException: Invalid character string fo
> rmat for type INTEGER.' was thrown while evaluating an expression.
> 410 del
> < ERROR 22018: Invalid character string format for type INTEGER.
> 410a409,410
> > ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpecte
> d place on line 1.' was thrown while evaluating an expression.
> > ERROR XIE0E: Read endOfFile at unexpected place on line 1.
> Test Failed.
> *** End:   importExportThruIJ jdk1.5.0 2006-12-14 15:22:21 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira