Migrating Portal 6.0 database to DB2 - Websphere

This is a discussion on Migrating Portal 6.0 database to DB2 - Websphere ; I m having problem when running configwizard task for migrating portal database to db2 from cloudscape. I found thos in configtrace.log file [sqlproc] CREATE TABLE release.WSRP_PROD_LOD ( [sqlproc] WSRP_PROD_OID CHAR(18) FOR BIT DATA NOT NULL, [sqlproc] LOCALE VARCHAR(64) NOT NULL, ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Migrating Portal 6.0 database to DB2

  1. Migrating Portal 6.0 database to DB2

    I m having problem when running configwizard task for migrating portal
    database to db2 from cloudscape.

    I found thos in configtrace.log file

    [sqlproc] CREATE TABLE release.WSRP_PROD_LOD (
    [sqlproc] WSRP_PROD_OID CHAR(18) FOR BIT DATA NOT NULL,
    [sqlproc] LOCALE VARCHAR(64) NOT NULL,
    [sqlproc] TITLE VARGRAPHIC(255),
    [sqlproc] DESCRIPTION VARGRAPHIC(1024),
    [sqlproc] CONSTRAINT PK560 PRIMARY KEY (WSRP_PROD_OID, LOCALE),
    [sqlproc] CONSTRAINT FK560 FOREIGN KEY (WSRP_PROD_OID) REFERENCES
    release.WSRP_PROD (OID) ON DELETE CASCADE
    [sqlproc] )

    [sqlproc] Error during statement execution!
    [sqlproc] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT]
    SQL1216N Graphic data and graphic functions are not supported for this
    database. SQLSTATE=56031

    [sqlproc] at
    COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown
    Source)
    [sqlproc] at
    COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown
    Source)
    [sqlproc] at
    COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(Unknown
    Source)
    [sqlproc] at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown
    Source)
    [sqlproc] at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown
    Source)
    [sqlproc] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
    [sqlproc] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
    [sqlproc] at
    com.ibm.wps.config.SqlProcessorTask.executeSqlScri pt(Unknown Source)
    [sqlproc] at com.ibm.wps.config.SqlProcessorTask.execute(Unknow n
    Source)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at
    org.apache.tools.ant.taskdefs.Sequential.execute(S equential.java:117)
    [sqlproc] at com.ibm.wps.config.If.execute(Unknown Source)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at org.apache.tools.ant.Target.execute(Target.java:30 9)
    [sqlproc] at
    org.apache.tools.ant.Target.performTasks(Target.ja va:336)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTarget(Project .java:1339)
    [sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java :397)
    [sqlproc] at
    org.apache.tools.ant.taskdefs.CallTarget.execute(C allTarget.java:143)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at org.apache.tools.ant.Target.execute(Target.java:30 9)
    [sqlproc] at
    org.apache.tools.ant.Target.performTasks(Target.ja va:336)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTarget(Project .java:1339)
    [sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java :397)
    [sqlproc] at
    org.apache.tools.ant.taskdefs.CallTarget.execute(C allTarget.java:143)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at org.apache.tools.ant.Target.execute(Target.java:30 9)
    [sqlproc] at
    org.apache.tools.ant.Target.performTasks(Target.ja va:336)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTarget(Project .java:1339)
    [sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java :397)
    [sqlproc] at
    org.apache.tools.ant.taskdefs.CallTarget.execute(C allTarget.java:143)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at com.ibm.wps.config.ForTask.execute(Unknown Source)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at org.apache.tools.ant.Target.execute(Target.java:30 9)
    [sqlproc] at
    org.apache.tools.ant.Target.performTasks(Target.ja va:336)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTarget(Project .java:1339)
    [sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java :397)
    [sqlproc] at
    org.apache.tools.ant.taskdefs.CallTarget.execute(C allTarget.java:143)
    [sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
    [sqlproc] at org.apache.tools.ant.Target.execute(Target.java:30 9)
    [sqlproc] at
    org.apache.tools.ant.Target.performTasks(Target.ja va:336)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTarget(Project .java:1339)
    [sqlproc] at
    org.apache.tools.ant.Project.executeTargets(Projec t.java:1255)
    [sqlproc] at org.apache.tools.ant.Main.runBuild(Main.java:609)
    [sqlproc] at org.apache.tools.ant.Main.start(Main.java:196)
    [sqlproc] at com.ibm.wps.config.WpsConfigMain.process(Unknown
    Source)
    [sqlproc] at com.ibm.wps.config.WpsConfigMain.main(Unknown Source)
    [sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e
    Method)
    [sqlproc] at
    sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:85)
    [sqlproc] at
    sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:58)
    [sqlproc] at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:60)
    [sqlproc] at java.lang.reflect.Method.invoke(Method.java:391)
    [sqlproc] at
    com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.jav a:219)
    [sqlproc] at java.lang.Thread.run(Thread.java:570)
    [sqlproc] (ErrCode=-1216, SqlState=56031)
    [sqlproc] __________________________________________________ _______



    Please help me out to clear this problem..


    Thanks & Regs
    Anantha


  2. Re: Migrating Portal 6.0 database to DB2

    Thanks guys, I have found the solution for the above problem.

    Actually the DB has to be created with Pagesize 8k rather be 4k. then
    only its supports for the VARGRAPHIC datatypes.


+ Reply to Thread