[GLASSFISH-15744] jpa @DSD failure on sybase Created: 28/Jan/11  Updated: 07/Feb/11

Status: Open
Project: glassfish
Component/s: sqe-test
Affects Version/s: 3.1
Fix Version/s: None

Type: Bug Priority: Major
Reporter: sherryshen Assignee: sherryshen
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Solaris and Linux


Tags: 3_1-exclude

 Description   

jpa @DSD failure on sybase
glassfisg-3.1-b39.zip

From the comments of
http://java.net/jira/browse/GLASSFISH-15728
w.r.t @DSD based test failure, there is no equivalent way to specify "resource-type" in @DSD.
Fix would be to either use DTC on MS-SQL.

File this bug to track the setting for SyBase since tests failed with XAException,



 Comments   
Comment by sherryshen [ 28/Jan/11 ]

To reproduce the failure:
set env with referece of
http://agni-1.us.oracle.com/JSPWiki/Wiki.jsp?page=V31CoreInstruction
where db info is in workspace
appserver-sqe/build-config/sybase_datadirect.properties
To run test,
cvs co appserver-sqe/bootstrap.xml
cd $SPS_HOME
ant -f bootstrap.xml co-ejb
ant start-domain
ant sybase-setup
cd pe/ejb/jpa20/war/criteriaquerydsd
ant sybasedd all_sql

[#|2011-01-28T15:04:49.979-0800|CONFIG|glassfish3.1|org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/criteriaquerydsd/WEB-INF/classes/_pu1.connection|_ThreadID=30;_ThreadName=Thread-1;|Connected: jdbc:datadirect:sybase://jsepc11.east.sun.com:5000;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1000;DATABASENAME=cts5;MAXPOOLEDSTATEMENTS=0;PROGRAMID=0000016a;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=false;CODEPAGEOVERRIDE=;CONNECTIONRETRYCOUNT=5;ENABLEBULKLOAD=false;BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;HOSTPROCESS=0000016a;FAILOVERPRECONNECT=false;WORKSTATIONID=;RESULTSETMETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;FAILOVERGRANULARITY=nonAtomic;HOSTNAMEINCERTIFICATE=;APPLICATIONNAME=;JAVADOUBLETOSTRING=false;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;ALTERNATESERVERS=;ERRORBEHAVIOR=Exception;ENCRYPTIONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTORE=;AUTHENTICATIONMETHOD=UserIdPassword;FAILOVERMODE=connect;JDBCBEHAVIOR=1;LONGDATACACHESIZE=2048;PREPAREMETHOD=storedProcIfParam;LOADBALANCING=false;USEALTERNATEPRODUCTINFO=false;TRANSACTIONMODE=explicit;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;PACKETSIZE=0;CLIENTHOSTNAME=;SERVICEPRINCIPALNAME=;SELECTMETHOD=direct
User: dbo
Database: SQL Server Version: Adaptive Server Enterprise/15.5/EBF 17218 SMP/P/NT (IX86)/Windows 2003/ase155/2391/32-bit/OPT/Mon Nov 09 14:18:14 2009
Driver: Sybase Version: 4.2.0.017715 (F044224.U015808)|#]

[#|2011-01-28T15:04:49.986-0800|INFO|glassfish3.1|org.eclipse.persistence.session.file:/space/test1/v3/glassfish/domains/domain1/applications/criteriaquerydsd/WEB-INF/classes/_pu1|_ThreadID=30;_ThreadName=Thread-1;|
file:/space/test1/v3/glassfish/domains/domain1/applications/criteriaquerydsd/WEB-INF/classes/_pu1 login successful|#]

[#|2011-01-28T15:04:50.114-0800|WARNING|glassfish3.1|javax.enterprise.system.core.transaction.com.sun.jts.jta|
_ThreadID=185;_ThreadName=Thread-1;|
JTS5041: The resource manager is doing work outside a global transaction
javax.transaction.xa.XAException:
[DataDirect][Sybase JDBC Driver][Sybase]You must have any of the following role(s) to execute this command/procedure:
'dtm_tm_role' . Please contact a user with the appropriate role for help.

at com.ddtek.jdbcx.sybase.SybaseImplXAResource.executeXaRpc(Unknown Source)
at com.ddtek.jdbcx.sybase.SybaseImplXAResource.start(Unknown Source)
at com.ddtek.jdbcx.sybasebase.ddx.start(Unknown Source)
at com.sun.gjc.spi.XAResourceImpl.start(XAResourceImpl.java:224)
at com.sun.jts.jta.TransactionState.startAssociation(TransactionState.java:304)

More in
http://agni-1.us.oracle.com/asqe-logs/export1/v3.1/Results/build39/dbtest/server.log.dsd.sybasedd

Comment by sherryshen [ 01/Feb/11 ]

I will use this bug to track the errors in jpa @DSD tests on sybase.

E1) javax.transaction.xa.XAException:
[DataDirect][Sybase JDBC Driver][Sybase]
You must have any of the following role(s) to execute this command/procedure:
'dtm_tm_role' . Please contact a user with the appropriate role for help.

Mitesh provided feedback:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.xa/html/xa/xa22.htm
Which seems to suggest that if you are using XA data source the user must have the role.
Can you ask the DBA to grant this role for the user you are using.
It can be done using "sp_role "grant", dtm_tm_role, /user_name/"

Dennis adjusted SyBase setting.
I ran that commend using the Interactive SQL tools and for the results I got
"Authorization updated".

Sherry verified the setting.
E1) is gone. Non-XA tests passed. XA tests failed with E2).

E2) JTS5041: The resource manager is doing work outside
a global transaction javax.transaction.xa.XAException:
[DataDirect][Sybase JDBC Driver][Sybase]
Cannot start external transaction without a DTM license.

Dennis adjusted SyBase setting.
There is a configuration parameter call "enable DTM" and it was set to 0.
I changed it to a 1 and restarted Sybase to take effect.

Sherry verified the setting.
Some xa w/o @DSD tests passed.
--appserver-sqe/pe/ejb/jpa20/war/criteriaquerydsd
ant sybasedd all_sql (@DSD using XA)
--appserver-sqe/pe/transaction/xa/simple
ant sybasedd all_sql (XA only)

Some xa-tests failed with E3.

E3) java.sql.SQLNonTransientConnectionException:
[DataDirect][Sybase JDBC Driver]
A connection to the database could not be established.
The server may have reached its configured connection limit.

jpa w/o @DSD failed with E3.
--appserver-sqe/pe/ejb/ejb30/txpropagation
ant sybasedd all_ac_sql_dsd (@DSD using XA)
ant sybasedd all_ac_sql_nodsd (XA only)

Dennis's feedback:
This a trial version of Sybase ASE 15.5 so you
have limited connections.

Comment by Nazrul [ 07/Feb/11 ]

Not a stopper. Excluding from 3.1 count.

Comment from Sherry:
Error 1 and Error 2 in the bug are resolved from db setup.
Error 3 is due to db (in use) limitation
@DSD passed on SyBase with sqe jpa suite, which requires less connections.





[GLASSFISH-17007] typo in quicklook/wsit/JaxwsFromWsdl/metadata/web.xml Created: 10/Jul/11  Updated: 02/Dec/11

Status: Open
Project: glassfish
Component/s: test
Affects Version/s: 3.1.1, 4.0
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Cheng Fang Assignee: sherryshen
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

From server.log:

[#|2011-07-10T09:54:28.359-0400|WARNING|glassfish3.1.1|javax.enterprise.system.tools.deployment.org.glassfish.deployment.common|_ThreadID=18;_ThreadName=Thread-2;|DPL8007: Unsupported deployment descriptors element mlns value http://java.sun.com/xml/ns/j2ee|#]

quicklook/wsit/JaxwsFromWsdl/metadata/web.xml has the wrong attr name (shoule be xmlns?):

<web-app version="2.4" mlns="http://java.sun.com/xml/ns/j2ee">
<display-name>JaxwsFromWsdl</display-name>
<description>JaxwsFromWsdl</description>



 Comments   
Comment by Justin Lee [ 01/Aug/11 ]

Not sure why this is assigned to me. I don't know anything about it.

Comment by Justin Lee [ 01/Aug/11 ]

You made the last change to this. Do you know what should happen here or know who does?

Comment by Cheng Fang [ 01/Aug/11 ]

I chose owner automatic, and happens to be you.





[GLASSFISH-9608] cmpToStatefulLocal test failures on PostgreSQL DB Created: 19/Sep/09  Updated: 06/Mar/12

Status: Open
Project: glassfish
Component/s: sqe-test
Affects Version/s: V3
Fix Version/s: not determined

Type: Bug Priority: Minor
Reporter: sherryshen Assignee: sherryshen
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Operating System: All
Platform: All


Attachments: HTML File cmpToStatefulLocal_mysql     HTML File cmpToStatefulLocal_postgres     HTML File runAsStateless_mysql     HTML File runAsStateless_postgres    
Issuezilla Id: 9,608

 Description   

glassfish-v3-b64.zip
cmpToStatefulLocal test failures are shown on PostgreSQL DB.
The same tests passed on Derby, MySQL and Oracle.

To reproduce the issue:
do "ant postgres all" in
appserver-sqe/pe/ejb/cmp/addressBook/cmpToStatefulLocal

The clinet output on postgres, not users are shown on test 6.
runclient-common:
[echo] Executing appclient at
/space/test1/SRC/c10/appserver-sqe/pe/ejb/cmp/addressBook/cmpToStatefulLocal
[echo] WS HOME appserver-sqe
[echo] Sep 19, 2009 4:45:43 PM
com.sun.enterprise.transaction.JavaEETransactionManagerSimplified initDelegates
[echo] INFO: Using
com.sun.enterprise.transaction.jts.JavaEETransactionManagerJTSDelegate as the
delegate
[echo] testSuitdID=CMP-addressBook-cmpToStatefulLocal
[echo] .... 1. init
[echo] Looked AddressBook home!!
[echo] Loop run number: 0
[echo] .... 2. Constructor
[echo] Constructor addressBookName-> SunAddressBook, owner-> SunOwner
[echo] addressBook create successful from CMP
[echo] ....3. disconnect
[echo] ....3. connect
[echo] ....5. add
[echo] add..........
[echo] ....6. get
[echo] get..........
[echo] ....7. update

The clinet output on mysql, users are shown on test 6.
runclient-common:
[echo] Executing appclient at
/space/test1/SRC/c10/appserver-sqe/pe/ejb/cmp/addressBook/cmpToStatefulLocal
[echo] WS HOME appserver-sqe
[echo] Sep 19, 2009 4:52:20 PM
com.sun.enterprise.transaction.JavaEETransactionManagerSimplified initDelegates
[echo] INFO: Using
com.sun.enterprise.transaction.jts.JavaEETransactionManagerJTSDelegate as the
delegate
[echo] testSuitdID=CMP-addressBook-cmpToStatefulLocal
[echo] .... 1. init
[echo] Looked AddressBook home!!
[echo] Loop run number: 0
[echo] .... 2. Constructor
[echo] Constructor addressBookName-> SunAddressBook, owner-> SunOwner
[echo] addressBook create successful from CMP
[echo] ....3. disconnect
[echo] ....3. connect
[echo] ....5. add
[echo] ....6. get
[echo] UserName: Jeanfrancois Arcand
[echo] UserName: Jeanfrancois Arcand
[echo] UserName: Carla Mott
[echo] UserName: Jeanfrancois Arcand
[echo] Email: Shawinigan
[echo] Address: jeanfrancois.arcand@eng.sun.com
[echo] HomePhone: 000-999-3425
[echo] BusinessPhone: 000-999-ITALIA
[echo] ....7. update



 Comments   
Comment by sherryshen [ 19/Sep/09 ]

Created an attachment (id=3248)
cmpToStatefulLocal client output to show failures on posgres

Comment by sherryshen [ 19/Sep/09 ]

Created an attachment (id=3249)
cmpToStatefulLocal client output to show tests pass on mysql

Comment by sherryshen [ 19/Sep/09 ]

Another bmp suite has similar failures.
To reproduce the issue:
do "ant postgres all" in
appserver-sqe/pe/ejb/cmp/addressBook/runAsStateless

Comment by sherryshen [ 19/Sep/09 ]

Created an attachment (id=3250)
runAsStateless client output to show test failure on postgres

Comment by sherryshen [ 19/Sep/09 ]

Created an attachment (id=3251)
runAsStateless client output to show test pass

Comment by Mitesh Meswani [ 21/Sep/09 ]

Can you please check server.log to see what went wrong.

Comment by Mitesh Meswani [ 04/Nov/09 ]

The test is complex and and not well written. The actual exception why test
fails is not reported. After discussing with Sherry, reassigning to SQE to
analyze further.

Considering that all other tests pass on PostgreSQL, this is more likely a test
issue.

Comment by sherryshen [ 17/Nov/09 ]

will look into it.

Comment by Tom Mueller [ 06/Mar/12 ]

Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.





[GLASSFISH-9817] addressBook-runAsStateless failures on SybaseDD Created: 28/Sep/09  Updated: 06/Mar/12

Status: Open
Project: glassfish
Component/s: sqe-test
Affects Version/s: V3
Fix Version/s: not determined

Type: Bug Priority: Minor
Reporter: sherryshen Assignee: sherryshen
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Operating System: All
Platform: All


Issuezilla Id: 9,817

 Description   

v3 b64 promoted, glassfish-v3-b64.zip

To reproduce the issue:
do "ant sybasedd all" in
appserver-sqe/pe/ejb/cmp/addressBook/runAsStateless

Client output shows:
[echo] testSuitdID=BMP-addressBook-runAsStateless
[echo] 1. init -------
[echo] init done, run tests...
[echo] 2. StorageStatelessClient ------
[echo] 3. run -------
[echo] ...disconnect
[echo] ...connect
[echo] ...deleteInvalidValue
[echo] ...add
[echo] ...get
[echo] get..........
[echo] com.sun.ejte.j2ee.addressBook.runAsDelegation.storage.StorageException:
get:String No RowSet's element associated with element: TYPE='test_1'
[echo] ...update
[echo] update..........
[echo] com.sun.ejte.j2ee.addressBook.runAsDelegation.storage.StorageException:
get:String No RowSet's element associated with element: TYPE='test_3'
[echo] ...getRowSet
[echo] Test result: resulSetNumber: 0iterator: 0[]
[echo] ------------------------------------
[echo] []
......
[echo] - BMP-addressBook-runAsStateless-get: FAIL -
......

In comparing with Derby run:
testSuitdID=BMP-addressBook-runAsStateless
1. init -------
init done, run tests...
2. StorageStatelessClient ------
3. run -------
...disconnect
...connect
...deleteInvalidValue
...add
...get
Test result: value_1
Test result: value_2
Test result: value_3
...update
Test result: Va savoir si ca fonctionne
...getRowSet
Test result: resulSetNumber: 1iterator: 0[TYPE, VALUE]
------------------------------------
[[test_3, Va savoir si ca fonctionne]]



 Comments   
Comment by Mitesh Meswani [ 04/Nov/09 ]

The test is complex and and not well written. The actual exception why test
fails is not reported. After discussing with Sherry, reassigning to SQE to
analyze further.

Considering that all other tests pass on Sybase, this is more likely a test issue.

Comment by Mitesh Meswani [ 04/Nov/09 ]

Changing to correct subcomponent...

Comment by sherryshen [ 17/Nov/09 ]

will look into it.

Comment by Tom Mueller [ 06/Mar/12 ]

Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.





Generated at Sat Apr 25 06:46:54 UTC 2015 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.