|
Home > Archive > WebSphere Portal Server > August 2004 > From Cloudscape to Oracle BUILD FAILED
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
From Cloudscape to Oracle BUILD FAILED
|
|
| mamadu 2004-08-22, 6: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,WMMDBADTYP_ID
,WMMDBMBR_ID,COMPOSITE,TIMESTAMPVALUE,CO
NTEXT,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,TIMESTAMPVALUE,CO
NTEXT,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,TIMESTAMPVALUE,CO
NTEXT,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,TIMESTAMPVALUE,CO
NTEXT,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,TIMESTAMPVALUE,CO
NTEXT,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 Key (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE CASCADE
[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 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 Конфигурация портала обновлена
[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 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 Источник данных "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 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 Конфигурация портала обновлена
[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 to any server process. Certain configuration and application operations will be available in local mode.
[wsadmin] /JDBCProvider:wps50JDBC/DataSource:wmmDS/ does not exist. No action taken
[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 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 Комплекс связи 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 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 Комплекс связи 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 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
| |
|
| 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
Key (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE
CASCADE
> [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
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
Конфигураци
;я портала
обновлена
> [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
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
Источник
данных "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
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
Конфигураци
;я портала
обновлена
> [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
to any server process. Certain configuration and application operations will
be available in local mode.
> [wsadmin] /JDBCProvider:wps50JDBC/DataSource:wmmDS/ does not exist. No
action taken
> [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
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
Комплекс
связи 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
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
Комплекс
связи 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
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
>
>
>
>
| |
| Farhan Thawar 2004-08-27, 6: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,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)
> (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)
> (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)
> (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)
> (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)
>Key (COMPOSITE_ID) REFERENCES WMMDBUSR.WMMDBACMPV (WMMDBACMPV_ID) ON DELETE
>CASCADE
>Обновление
>конфигураци
>;и портала
>to any server process. Certain configuration and application operations will
>be available in local mode.
>Конфигураци
>;я портала
>обновлена
>Удаление
>источника
>данных "wps50DS"
>to any server process. Certain configuration and application operations will
>be available in local mode.
>action taken
>Источник
>данных "wps50DS"
>удален
>Обновление
>конфигураци
>;и портала
>to any server process. Certain configuration and application operations will
>be available in local mode.
>Конфигураци
>;я портала
>обновлена
>Удаление
>источника
>данных "wmmDS"
>to any server process. Certain configuration and application operations will
>be available in local mode.
>action taken
>Источник
>данных "wmmDS"
>удален
>Удаление
>комплекса
>связи JDBC "wps50JDBC"
>to any server process. Certain configuration and application operations will
>be available in local mode.
>taken
>Комплекс
>связи JDBC "wps50JDBC"
>удален
>Создание
>комплекса
>связи JDBC "wps50JDBC"
>to any server process. Certain configuration and application operations will
>be available in local mode.
>Комплекс
>связи JDBC "wps50JDBC"
>создан
>Обновление
>конфигураци
>;и портала
>to any server process. Certain configuration and application operations will
>be available in local mode.
>
>
|
|
|
|
|