From Cloudscape to Oracle BUILD FAILED
Web Server forum
Back To The Forum Home!Search!Private Messaging System
Visit your User Control Panel!Register your FREE username now!Visit Our Calendar!View the Member List!Faqs!Search our Forums!

Web Server Talk Web Server Talk > Web Servers reviews > WebSphere > WebSphere Portal Server > From Cloudscape to Oracle BUILD FAILED




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    From Cloudscape to Oracle BUILD FAILED  
mamadu


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-22-04 11:15 PM

I  import my Cloudscape to Oracle.
I create all user.
My DB in UTF8 characterset.
All data imported in Oracle DB.
But i recive error:
[java]
[java] INSERT INTO WMMDBUSR.WMMDBATVAL (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBA
 DTYP_ID,WMMDBMBR_ID,COMPOSITE,TIMESTAMPV
ALUE,CONTEXT,HAS_CONTEXT) VALUES (10
 007,10014,'TIMESTAMP',4,null,TO_DATE('20
04-08-19 16:51:36', 'YYYY-MM-DD HH24
:MI:SS'),null,0)
[java]
[java] INSERT INTO WMMDBUSR.WMMDBATVAL (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBA
 DTYP_ID,WMMDBMBR_ID,COMPOSITE,TIMESTAMPV
ALUE,CONTEXT,HAS_CONTEXT) VALUES (10
 008,10015,'TIMESTAMP',5,null,TO_DATE('20
04-08-19 16:51:36', 'YYYY-MM-DD HH24
:MI:SS'),null,0)
[java]
[java] INSERT INTO WMMDBUSR.WMMDBATVAL (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBA
 DTYP_ID,WMMDBMBR_ID,COMPOSITE,TIMESTAMPV
ALUE,CONTEXT,HAS_CONTEXT) VALUES (10
 009,10014,'TIMESTAMP',5,null,TO_DATE('20
04-08-19 16:51:36', 'YYYY-MM-DD HH24
:MI:SS'),null,0)
[java]
[java] INSERT INTO WMMDBUSR.WMMDBATVAL (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBA
 DTYP_ID,WMMDBMBR_ID,COMPOSITE,TIMESTAMPV
ALUE,CONTEXT,HAS_CONTEXT) VALUES (10
 010,10015,'TIMESTAMP',6,null,TO_DATE('20
04-08-19 16:51:37', 'YYYY-MM-DD HH24
:MI:SS'),null,0)
[java]
[java] INSERT INTO WMMDBUSR.WMMDBATVAL (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBA
 DTYP_ID,WMMDBMBR_ID,COMPOSITE,TIMESTAMPV
ALUE,CONTEXT,HAS_CONTEXT) VALUES (10
 011,10014,'TIMESTAMP',6,null,TO_DATE('20
04-08-19 16:51:36', 'YYYY-MM-DD HH24
:MI:SS'),null,0)
[java]
[java] ALTER TABLE WMMDBUSR.WMMDBACMPV ADD CONSTRAINT WMMF_39 Foreign Ke
y (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE CA
SCADE
[java]

action-remove-jaas-auth-wps:
[logmsg] 2004.08.20 15:07:32.112 action-remove-jaas-auth-wps
[logmsg]   EJPC3057I Обновле&#
1085;ие конфигур
ации порталk
2;
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] JAASAuthData wpsDBAuth does not exist, no Action taken
[logmsg] 2004.08.20 15:08:25.112 action-remove-jaas-auth-wps
[logmsg]   EJPC3059I Конфигу&#
1088;ация портал
а обновлена
[logmsg]

action-remove-datasource-wps:
[logmsg] 2004.08.20 15:08:25.128 action-remove-datasource-wps
[logmsg]   EJPC3018I Удалени&#
1077; источника д
;анных "wps50DS"
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] /JDBCProvider:wps50JDBC/DataSource:wps50DS/ does not exist. No
 action taken
[logmsg] 2004.08.20 15:08:55.128 action-remove-datasource-wps
[logmsg]   EJPC3020I Источни&#
1082; данных "wps50DS" уд
072;лен
[logmsg]

action-remove-jaas-auth-wmm:
[logmsg] 2004.08.20 15:08:55.924 action-remove-jaas-auth-wmm
[logmsg]   EJPC3057I Обновле&#
1085;ие конфигур
ации порталk
2;
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] JAASAuthData wmmDBAuth does not exist, no Action taken
[logmsg] 2004.08.20 15:09:47.784 action-remove-jaas-auth-wmm
[logmsg]   EJPC3059I Конфигу&#
1088;ация портал
а обновлена
[logmsg]

action-remove-datasource-wmm:
[logmsg] 2004.08.20 15:09:47.800 action-remove-datasource-wmm
[logmsg]   EJPC3018I Удалени&#
1077; источника д
;анных "wmmDS"
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] /JDBCProvider:wps50JDBC/DataSource:wmmDS/ does not exist. No a
ction taken
[logmsg] 2004.08.20 15:10:18.206 action-remove-datasource-wmm
[logmsg]   EJPC3020I Источни&#
1082; данных "wmmDS" удk
2;лен
[logmsg]

action-remove-jdbcprovider-wps:
[logmsg] 2004.08.20 15:10:18.628 action-remove-jdbcprovider-wps
[logmsg]   EJPC3012I Удалени&#
1077; комплекса с
;вязи JDBC "wps50JDBC"
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] /Node:oracle/JDBCProvider:wps50JDBC/ does not exist. No action
 taken
[logmsg] 2004.08.20 15:10:40.128 action-remove-jdbcprovider-wps
[logmsg]   EJPC3014I Комплек&#
1089; связи JDBC "wps50JDBC" уд
072;лен
[logmsg]

action-create-jdbcprovider-wps:
[logmsg] 2004.08.20 15:10:40.565 action-create-jdbcprovider-wps
[logmsg]   EJPC3069I Создани&#
1077; комплекса с
;вязи JDBC "wps50JDBC"
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] JDBCProvider wps50JDBC does exist, no Action taken
[logmsg] 2004.08.20 15:11:12.018 action-create-jdbcprovider-wps
[logmsg]   EJPC3011I Комплек&#
1089; связи JDBC "wps50JDBC" со
079;дан
[logmsg]

action-create-jaas-auth-wps:
[logmsg] 2004.08.20 15:11:12.518 action-create-jaas-auth-wps
[logmsg]   EJPC3057I Обновле&#
1085;ие конфигур
ации порталk
2;
[logmsg]
[wsadmin] WASX7357I: By request, this scripting client is not connected 
to any server process. Certain configuration and application operations will
 be available in local mode.
[wsadmin] ERROR: /Cell:oracle/Security:/ is missing.

BUILD FAILED

 C:\WebSphere\PortalServer\config\wpconfi
g.xml:92: Java returned: 1

Total time: 45 minutes 25 seconds




[ Post a follow-up to this message ]



    Re: From Cloudscape to Oracle BUILD FAILED  
fang


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-27-04 11:29 PM

Did you create the databases and users in Oracle before you run portal
scripts?

"mamadu" <mamadu@ru.ru> wrote in message
news:1583193215.1093006036550.JavaMail.wasadmin@swg3ws006...
> I  import my Cloudscape to Oracle.
> I create all user.
> My DB in UTF8 characterset.
> All data imported in Oracle DB.
> But i recive error:
>     [java]
>      [java] INSERT INTO WMMDBUSR.WMMDBATVAL
 (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALU
E,CONTEXT,HAS_CONTEXT) VALUES
 (10007,10014,'TIMESTAMP',4,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
HH24:MI:SS'),null,0)
>      [java]
>      [java] INSERT INTO WMMDBUSR.WMMDBATVAL
 (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALU
E,CONTEXT,HAS_CONTEXT) VALUES
 (10008,10015,'TIMESTAMP',5,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
HH24:MI:SS'),null,0)
>      [java]
>      [java] INSERT INTO WMMDBUSR.WMMDBATVAL
 (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALU
E,CONTEXT,HAS_CONTEXT) VALUES
 (10009,10014,'TIMESTAMP',5,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
HH24:MI:SS'),null,0)
>      [java]
>      [java] INSERT INTO WMMDBUSR.WMMDBATVAL
 (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALU
E,CONTEXT,HAS_CONTEXT) VALUES
 (10010,10015,'TIMESTAMP',6,null,TO_DATE(
'2004-08-19 16:51:37', 'YYYY-MM-DD
HH24:MI:SS'),null,0)
>      [java]
>      [java] INSERT INTO WMMDBUSR.WMMDBATVAL
 (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALU
E,CONTEXT,HAS_CONTEXT) VALUES
 (10011,10014,'TIMESTAMP',6,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
HH24:MI:SS'),null,0)
>      [java]
>      [java] ALTER TABLE WMMDBUSR.WMMDBACMPV ADD CONSTRAINT WMMF_39 Foreign[/vb
col]
Key (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE
CASCADE[vbcol=seagreen]
>      [java]
>
> action-remove-jaas-auth-wps:
>    [logmsg] 2004.08.20 15:07:32.112 action-remove-jaas-auth-wps
>    [logmsg]   EJPC3057I
Обновление
конфигураци
;и портала
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] JAASAuthData wpsDBAuth does not exist, no Action taken
>    [logmsg] 2004.08.20 15:08:25.112 action-remove-jaas-auth-wps
>    [logmsg]   EJPC3059I
Конфигураци
;я портала
обновлена
>    [logmsg]
>
> action-remove-datasource-wps:
>    [logmsg] 2004.08.20 15:08:25.128 action-remove-datasource-wps
>    [logmsg]   EJPC3018I
Удаление
источника
данных "wps50DS"
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] /JDBCProvider:wps50JDBC/DataSource:wps50DS/ does not exist. No[/vb
col]
action taken[vbcol=seagreen]
>    [logmsg] 2004.08.20 15:08:55.128 action-remove-datasource-wps
>    [logmsg]   EJPC3020I
Источник
данных "wps50DS"
удален
>    [logmsg]
>
> action-remove-jaas-auth-wmm:
>    [logmsg] 2004.08.20 15:08:55.924 action-remove-jaas-auth-wmm
>    [logmsg]   EJPC3057I
Обновление
конфигураци
;и портала
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] JAASAuthData wmmDBAuth does not exist, no Action taken
>    [logmsg] 2004.08.20 15:09:47.784 action-remove-jaas-auth-wmm
>    [logmsg]   EJPC3059I
Конфигураци
;я портала
обновлена
>    [logmsg]
>
> action-remove-datasource-wmm:
>    [logmsg] 2004.08.20 15:09:47.800 action-remove-datasource-wmm
>    [logmsg]   EJPC3018I
Удаление
источника
данных "wmmDS"
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] /JDBCProvider:wps50JDBC/DataSource:wmmDS/ does not exist. No[/vbco
l]
action taken[vbcol=seagreen]
>    [logmsg] 2004.08.20 15:10:18.206 action-remove-datasource-wmm
>    [logmsg]   EJPC3020I
Источник
данных "wmmDS"
удален
>    [logmsg]
>
> action-remove-jdbcprovider-wps:
>    [logmsg] 2004.08.20 15:10:18.628 action-remove-jdbcprovider-wps
>    [logmsg]   EJPC3012I
Удаление
комплекса
связи JDBC "wps50JDBC"
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] /Node:oracle/JDBCProvider:wps50JDBC/ does not exist. No action[/vb
col]
taken[vbcol=seagreen]
>    [logmsg] 2004.08.20 15:10:40.128 action-remove-jdbcprovider-wps
>    [logmsg]   EJPC3014I
Комплекс
связи JDBC "wps50JDBC"
удален
>    [logmsg]
>
> action-create-jdbcprovider-wps:
>    [logmsg] 2004.08.20 15:10:40.565 action-create-jdbcprovider-wps
>    [logmsg]   EJPC3069I
Создание
комплекса
связи JDBC "wps50JDBC"
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] JDBCProvider wps50JDBC does exist, no Action taken
>    [logmsg] 2004.08.20 15:11:12.018 action-create-jdbcprovider-wps
>    [logmsg]   EJPC3011I
Комплекс
связи JDBC "wps50JDBC"
создан
>    [logmsg]
>
> action-create-jaas-auth-wps:
>    [logmsg] 2004.08.20 15:11:12.518 action-create-jaas-auth-wps
>    [logmsg]   EJPC3057I
Обновление
конфигураци
;и портала
>    [logmsg]
>   [wsadmin] WASX7357I: By request, this scripting client is not connected[/vbc
ol]
to any server process. Certain configuration and application operations will
be available in local mode.[vbcol=seagreen]
>   [wsadmin] ERROR: /Cell:oracle/Security:/ is missing.
>
> BUILD FAILED
>
>  C:\WebSphere\PortalServer\config\wpconfi
g.xml:92: Java returned: 1
>
> Total time: 45 minutes 25 seconds
>
>
>
>




[ Post a follow-up to this message ]



    Re: From Cloudscape to Oracle BUILD FAILED  
Farhan Thawar


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-27-04 11:29 PM

What version of Oracle are you using?  For Oracle 9.2.0.4 I needed the
following:

1.  Oracle db must be configured with the JServer option
2.  All the portal users needed SELECT privledges on
DBA_PENDING_TRANSACTIONS
3.  I increased the default number of cursors
4.  The databased needed to be UTF-8

Farhan

On Thu, 26 Aug 2004 12:32:26 -0400, "fang" <do@not.mail.com> wrote:

>Did you create the databases and users in Oracle before you run portal
>scripts?
>
>"mamadu" <mamadu@ru.ru> wrote in message
>news:1583193215.1093006036550.JavaMail.wasadmin@swg3ws006... 
> (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVAL
U
>E,CONTEXT,HAS_CONTEXT) VALUES
> (10007,10014,'TIMESTAMP',4,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
>HH24:MI:SS'),null,0) 
> (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVAL
U
>E,CONTEXT,HAS_CONTEXT) VALUES
> (10008,10015,'TIMESTAMP',5,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
>HH24:MI:SS'),null,0) 
> (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVAL
U
>E,CONTEXT,HAS_CONTEXT) VALUES
> (10009,10014,'TIMESTAMP',5,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
>HH24:MI:SS'),null,0) 
> (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVAL
U
>E,CONTEXT,HAS_CONTEXT) VALUES
> (10010,10015,'TIMESTAMP',6,null,TO_DATE(
'2004-08-19 16:51:37', 'YYYY-MM-DD
>HH24:MI:SS'),null,0) 
> (WMMDBATVAL_ID,WMMDBATR_ID,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVAL
U
>E,CONTEXT,HAS_CONTEXT) VALUES
> (10011,10014,'TIMESTAMP',6,null,TO_DATE(
'2004-08-19 16:51:36', 'YYYY-MM-DD
>HH24:MI:SS'),null,0) 
>Key (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE
>CASCADE 
>Обновление
>конфигурацl
0
>;и портала 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>Конфигурацl
0
>;я портала
>обновлена 
>Удаление
>источника
>данных "wps50DS" 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>action taken 
>Источник
>данных "wps50DS"
>удален 
>Обновление
>конфигурацl
0
>;и портала 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>Конфигурацl
0
>;я портала
>обновлена 
>Удаление
>источника
>данных "wmmDS" 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>action taken 
>Источник
>данных "wmmDS"
>удален 
>Удаление
>комплекса
>связи JDBC "wps50JDBC" 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>taken 
>Комплекс
>связи JDBC "wps50JDBC"
>удален 
>Создание
>комплекса
>связи JDBC "wps50JDBC" 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>Комплекс
>связи JDBC "wps50JDBC"
>создан 
>Обновление
>конфигурацl
0
>;и портала 
>to any server process. Certain configuration and application operations wil
l
>be available in local mode. 
>
>




[ Post a follow-up to this message ]



    Sponsored Links  




 



   All times are GMT. The time now is 09:29 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 
Apache Server MySQL for Windows Sendmail
Red Hat Networking SuSe Linux Debian Linux
FreeBSD administration Sun Solaris administration Unix Shell programming
WebSphere Portal Server Exchange 2000 administration PostgreSQL administration
Linux Security Computer Security Firewalls

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register