Data transfer from Portal 6.0 to DB2
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > WebSphere > WebSphere Portal Server > Data transfer from Portal 6.0 to DB2




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

    Data transfer from Portal 6.0 to DB2  


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


 
05-26-07 12:22 PM

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][D
B2/NT] SQL1216N  Graphic data and graphic functions are not supported for th
is database.  SQLSTATE=56031

[sqlproc]     at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLExc
eption(Unknown Source)
[sqlproc]     at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLExc
eption(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 Sour
ce)
[sqlproc]     at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Sourc
e)
[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(Un
known
Source)
[sqlproc]     at com.ibm.wps.config.SqlProcessorTask.execute(Unknown Sou
rce)
[sqlproc]     at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc]     at org.apache.tools.ant.taskdefs.Sequential.execute(Sequen
tial.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:33
6)
[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(CallTa
rget.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:33
6)
[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(CallTa
rget.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:33
6)
[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(CallTa
rget.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:33
6)
[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(CallTa
rget.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:33
6)
[sqlproc]     at org.apache.tools.ant.Project.executeTarget(Project.java
:1339)
[sqlproc]     at org.apache.tools.ant.Project.executeTargets(Project.jav
a: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 Met
hod)
[sqlproc]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
dAccessorImpl.java:85)
[sqlproc]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
dAccessorImpl.java:58)
[sqlproc]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
ingMethodAccessorImpl.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






[ Post a follow-up to this message ]



    Re: Data transfer from Portal 6.0 to DB2  


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


 
06-20-07 12:24 PM

Nothing found yet?
I have exactly the same problem





[ Post a follow-up to this message ]



    Sponsored Links  




 





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


Most Popular forums 

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