Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data transfer from Portal 6.0 to DB2

1 view
Skip to first unread message

syed...@yahoo.co.in

unread,
May 26, 2007, 4:26:09 AM5/26/07
to
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

pim....@interaccess.nl

unread,
Jun 20, 2007, 7:58:54 AM6/20/07
to
Nothing found yet?
I have exactly the same problem
0 new messages