WebSphere Portal Server - Data transfer from Portal 6.0 to DB2

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Portal Server > June 2007 > Data transfer from Portal 6.0 to DB2





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 Data transfer from Portal 6.0 to DB2

2007-05-26, 7:22 am

We're trying to transfer data from Portal database to DB2,but we are getting the following error:

[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_SQLException(Unknown Source)
[sqlproc] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
[sqlproc] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_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.executeSqlScript(Unknown
Source)
[sqlproc] at com.ibm.wps.config.SqlProcessorTask.execute(Unknown Source)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.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:309)
[sqlproc] at org.apache.tools.ant.Target.performTasks(Target.java: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(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at org.apache.tools.ant.Target.performTasks(Target.java: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(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at org.apache.tools.ant.Target.performTasks(Target.java: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(CallTarget.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:309)
[sqlproc] at org.apache.tools.ant.Target.performTasks(Target.java: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(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at org.apache.tools.ant.Project.executeTargets(Project.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(Native Method)
[sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
[sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
[sqlproc] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
[sqlproc] at java.lang.reflect.Method.invoke(Method.java:391)
[sqlproc] at com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219)
[sqlproc] at java.lang.Thread.run(Thread.java:570)
[sqlproc] (ErrCode=-1216, SqlState=56031)

BUILD FAILED
file:../config/actions/db_cfg.xml:348: ERROR: Error during the execution of the
sql files.

Has anyone else seen this error?
How to resolve this error?

Thanks

2007-06-20, 7:24 am

Nothing found yet?
I have exactly the same problem
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com