Install Problem under Solaris

[Carlos_Nascimbe]

Hi,

I have a problem running an installation under this enviroment:

- 64 bits server with Solaris 10 (SunOS sundemo 5.10 Generic_125101-10 i86pc i386 i86pc)

-  WebSphere App Server 6.1 with fixpack (6.1.0.29), java IBM build 1.5.0_22-b03 20091106 solaris amd64 (SR11))

-   Oracle 10gR2 in other server (10.2.0.3.0)

-   Driver jdbc ojdbc5.jar

-  Java(TM) SE Runtime Environment (build 1.6.0_10-b33)

The DB initialization it's allright and the server connection also works ok but when I try to deploy the components I get this error several times:

[2/22/10 21:17:01:181 CLST] 0000002c ExceptionUtil E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "retrieveObjectSet" on bean "BeanId(LiveCycleES2#adobe-pof.jar#adobe_POFObjectManagerLocalEJB, null)". Exception data: java.sql.SQLException: ORA-00907: missing right parenthesis

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

Also the WAS trace is:

[2/24/10 12:39:46:688 CLST] 00000029 clientinfoplu <  prepareStatement Exit

                                 com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@3a717b68

[2/24/10 12:39:46:688 CLST] 00000029 WSJdbcPrepare 3   setString #1

[2/24/10 12:39:46:689 CLST] 00000029 InternalOracl 3   string length: 6

[2/24/10 12:39:46:689 CLST] 00000029 WSJdbcPrepare 3   setString #2

[2/24/10 12:39:46:689 CLST] 00000029 InternalOracl 3   string length: 7

[2/24/10 12:39:46:689 CLST] 00000029 WSJdbcPrepare 3   setBoolean #3

[2/24/10 12:39:46:689 CLST] 00000029 WSJdbcPrepare 3   setString #4

[2/24/10 12:39:46:690 CLST] 00000029 InternalOracl 3   string length: 33

[2/24/10 12:39:46:690 CLST] 00000029 WSJdbcPrepare 3   setInt #5

[2/24/10 12:39:46:690 CLST] 00000029 WSJdbcPrepare 3   setString #6

[2/24/10 12:39:46:690 CLST] 00000029 InternalOracl 3   string length: 12

[2/24/10 12:39:46:690 CLST] 00000029 WSJdbcPrepare 3   setInt #7

[2/24/10 12:39:46:691 CLST] 00000029 WSJdbcPrepare 3   setInt #8

[2/24/10 12:39:46:691 CLST] 00000029 LoggablePrepa 3 109: 

begin sql[WebContainer : 5] - 

SELECT A.* FROM (SELECT ROWNUM RN, B.* FROM (SELECT T0.id T00 , T0.objecttype T01 , T0.path T02 , T0.path_upper T03 , T0.object_status T04 , T0.deployment_status T05 , T0.custom_status T06 , T0.appstoreversion T07 , T0.descr T08 , T0.majorversion T09 , T0.minorversion T010 , T0.owneruserid T011 , T0.etag T012 , T0.lid T013 , T0.name T014 , T0.createdby T015 , T0.contactid T016 , T0.contactuserid T017 , T0.head T018 , T0.acl_id T019 , T0.content_impl_oid T020 , T0.update_time T021 , T0.create_time T022 , T1.oid T10 , T1.resourceid T11 , T1.name T12 , T1.namespace T13 , T1.propvalue T14 , T2.oid T20 , T2.resourceid T21 , T2.ownerid T22 , T2.owneruserid T23 , T2.type T24 , T2.depth T25 , T2.locktoken T26 , T2.expiryDate T27 , T3.oid T30 , T3.content T31 , T3.mimetype T32 , T3.contentsize T33 , T3.contenturi T34  FROM tb_rep_resource T0  LEFT OUTER JOIN tb_rep_property T1  ON (T0.id = T1.resourceid) LEFT OUTER JOIN tb_rep_lock T2  ON (T0.id = T2.resourceid) LEFT OUTER JOIN tb_rep_resourcecontent T3  ON (T0.content_impl_oid = T3.oid) INNER JOIN tb_rep_property T4  ON (T0.id = T4.resourceid AND (T4.namespace = 'System'  AND T4.name = 'PRIMARY' )) WHERE (T0.head = true  AND T0.path_upper LIKE2 'APPLICATIONS/GUIDES (SYSTEM)/1.0%' {ESCAPE '\'} AND T0.objecttype = 31  AND T0.name <> '.application' )) B) A WHERE A.RN BETWEEN 1 AND 10000

[2/24/10 12:39:46:691 CLST] 00000029 WSJdbcPrepare >  executeQuery Entry

                                 com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@3a717b68

[2/24/10 12:39:46:692 CLST] 00000029 WSRdbManagedC 3   isEnlistmentDisabled() returning:

                                 false

[2/24/10 12:39:46:692 CLST] 00000029 WSJdbcConnect 3   Local Transaction is active.

[2/24/10 12:39:46:692 CLST] 00000029 WSManagedConn 3   isEndToEndMonitoringFeatureEnabled()returns :

                                 false

[2/24/10 12:39:46:706 CLST] 00000029 WrappingFileO 3 com.ibm.ws.ffdc.WrappingFileOutputStream <init> opened FileOutputStream - /software/was_61/IBM/WebSphere/AppServer/profiles/AdobeLC/logs/ffdc/server1_exception.log

[2/24/10 12:39:46:709 CLST] 00000029 WrappingFileO 3 com.ibm.ws.ffdc.WrappingFileOutputStream close closing FileOutputStream - /software/was_61/IBM/WebSphere/AppServer/profiles/AdobeLC/logs/ffdc/server1_exception.log

[2/24/10 12:39:46:709 CLST] 00000029 WSJdbcPrepare <  executeQuery Exit

                                 SQLException

[2/24/10 12:39:46:709 CLST] 00000029 GenericDataSt >  mapExceptionHelper Entry

[2/24/10 12:39:46:709 CLST] 00000029 OracleDataSto >  findMappingClass for : Entry

                                 java.sql.SQLException: ORA-00907: missing right parenthesis

I'm attaching a step-by-step screen capture pdf, a capture of the TCP traffic between the DB and the App Server where we can see the error and the logs of WAS and ADOBE.

Thanks in advance for your help,

Carlos

[JayanKandathil · Accepted solution]

It looks like you are running on the x86 version of Solaris 10.  LiveCycle is only supported and will only work on the SPARC version of Solaris 10.

[Carlos_Nascimbe]

Thanks Jayan, you're absolutely right!

[Carlos_Nascimbe]

HI Jayan,

The potential customer is claiming that the same problem occurs under Solaris Sparc...

I'm checking the info they send me and let you know.

Regards,

Carlos

[Carlos_Nascimbe]

Just Updating:

Under Solaris SPARC using WAS 6.1 and Oracle 11g we get the same error on the final deploy of the launchpad and guides LCA's

This is the error:

[2/22/10 21:17:01:181 CLST] 0000002c ExceptionUtil E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "retrieveObjectSet" on bean "BeanId(LiveCycleES2#adobe-pof.jar#adobe_POFObjectManagerLocalEJB, null)". Exception data: java.sql.SQLException: ORA-00907: missing right parenthesis  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

I think something is wrong in the installer....

Carlos