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

Dismiss

Exception while transferring cloudscape to DB2

2 views

Skip to first unread message

eshwar_...@rediffmail.com

unread,

Jan 20, 2009, 11:48:30 AM1/20/09

Hi,

I am facing the below exception while running the below command when transferring data from cloudscape to DB2(remote).

WPSconfig.bat database-transfer -Drelease.DbPassword=db2admin - Dcustomization.DbPassword=db2admin -Dcommunity.DbPassword=db2admin -Djcr.DbPassword=db2admin -Dwmm.DbPassword=db2admin -Dfeedback.DbPassword=db2admin -Dlikeminds.DbPassword=db2admin

_*Exception:*_

*[sqlproc] Error during statement execution!*
*[sqlproc] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1216N G*
*raphic 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.j
ava: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.j
ava: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.j
ava: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.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(NativeMethodAcces
sorImpl.java:85)
[sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:58)
[sqlproc] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.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)
[sqlproc] _________________________________________________________
[sqlproc] Ant Database Properties:

[sqlproc] DbDomain specific settings (release):
[sqlproc] release.DbType = db2
[sqlproc] release.DbUrl = jdbc:db2:ITG10
[sqlproc] release.DbName = ITG10
[sqlproc] release.DbSchema = release
[sqlproc] release.DbUser = db2admin
[sqlproc] release.DbPassword = PASSWORD_REMOVED

[sqlproc] DbType specific settings (db2):
[sqlproc] db2.DbDriver = COM.ibm.db2.jdbc.app.DB2Driver
[sqlproc] db2.DbLibrary = C:\Program Files\IBM\SQLLIB\java\db2java.zip
[sqlproc] _________________________________________________________
[sqlproc] _________________________________________________________

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

Total time: 2 minutes 12 seconds

Thanks in advance,
Subrahmanyam Baratam.

joy.s...@tcs.com

unread,

Jan 21, 2009, 12:20:09 AM1/21/09

Hi,
this data type is not supported for this database codepage.you probably should create the db with UTF-8 as codepage to support this.

Thanks
addi

eshwar_...@rediffmail.com

unread,

Jan 21, 2009, 7:25:09 AM1/21/09

Hi Adi,

I had used UTF-8 only , when creating db and using DB2 v9.1.

ff...@us.ibm.com

unread,

Jan 21, 2009, 9:07:18 AM1/21/09

We need more information on this. Do you have a remote DB2? Is it 64bit? What platform do the DB2 and Portal reside on? Did you create the databases before you ran the command? Did you use the DDL provide in the InfoCenter?

-FF

The postings on this site are my own and do not necessarily represent the positions, strategies or opinions of IBM.

eshwar_...@rediffmail.com

unread,

Jan 21, 2009, 11:33:39 AM1/21/09

Hi Fanq,

Yes, I am working on remote DB2, DB2 & portal server were installed on different systems of platform Microsoft Windows-2000, we created the databases and they are created successfully.

We observed that after running the above command every thing is going fine, suddenly the exception SQL1216N occured when creating the below table & observed that the datatype of the column is VARGRAPHIC...and I am in confusion whether this is the cause, please can you guide me to resolve the issue.

*Exception:*

*[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 releas
WSRP_PROD (OID) ON DELETE CASCADE
[sqlproc] )

*[sqlproc] Error during statement execution!*

*[sqlproc] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1216N*
*raphic data and graphic functions are not supported for this database. SQLSTA*
*=56031*

[sqlproc] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLExcepti
(Unknown Source)
[sqlproc] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLExcepti
(Unknown Source)
[sqlproc] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_cod

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(Unknow

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

ava: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:133

[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget

ava: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:133

[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget

ava: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:133

[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget

[sqlproc] at org.apache.tools.ant.Project.executeTargets(Project.java:12

)
[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(NativeMethodAcc

sorImpl.java:85)
[sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
sorImpl.java:58)
[sqlproc] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM

hodAccessorImpl.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)
[sqlproc] _________________________________________________________
[sqlproc] Ant Database Properties:

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

sql files.

Total time: 3 minutes 53 seconds

ff...@us.ibm.com

unread,

Jan 22, 2009, 11:33:46 AM1/22/09

From what I understand, VARGRAPHIC only exists when the DB was created in UTF-16. I am not sure why it showed here. My suggestion is to drop the release DB and recreate it with the scripts given in the InfoCenter.

0 new messages