Source Export System Copy Error: Fatal exception JSizeCheck

[Former Member]

Dear gurus,

This is the second one I am having this issue.

I give up on the first one and decide to re-install my SAP, but now I am having problem again.

Here's the platform I am using:

- SLES 11 SP3 for SAP

- Solution Manager 7.1 SPS10

- Kernel 7.21 EXT 64bit UC
- DB2 10.5FP1 LUW

- Latest SWPM70

What I do is exporting my source system using system copy.

It stopped in phase "Generate Java DBSIZE files" with this log:

jsizecheck.log:

ERROR: 2014-01-12 11:48:59 com.sap.inst.jsizecheck.SizeChecker run
Fatal exception during execution of JSizeCheck.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=SNAPSHOT_TBS_CFG;FUNCTION, DRIVER=3.66.46
  at com.ibm.db2.jcc.am.dd.a(dd.java:741)
  at com.ibm.db2.jcc.am.dd.a(dd.java:60)
  at com.ibm.db2.jcc.am.dd.a(dd.java:127)
  at com.ibm.db2.jcc.am.oo.c(oo.java:2763)
  at com.ibm.db2.jcc.am.oo.d(oo.java:2751)
  at com.ibm.db2.jcc.am.oo.a(oo.java:2200)
  at com.ibm.db2.jcc.am.po.a(po.java:7379)
  at com.ibm.db2.jcc.t4.ab.h(ab.java:141)
  at com.ibm.db2.jcc.t4.ab.b(ab.java:41)
  at com.ibm.db2.jcc.t4.o.a(o.java:32)
  at com.ibm.db2.jcc.t4.tb.i(tb.java:145)
  at com.ibm.db2.jcc.am.oo.ib(oo.java:2169)
  at com.ibm.db2.jcc.am.po.tc(po.java:3547)
  at com.ibm.db2.jcc.am.po.zc(po.java:3679)
  at com.ibm.db2.jcc.am.po.a(po.java:588)
  at com.ibm.db2.jcc.am.Connection.prepareStatementX(Connection.java:2379)
  at com.ibm.db2.jcc.am.Connection.prepareStatementX(Connection.java:2326)
  at com.ibm.db2.jcc.am.Connection.prepareStatement(Connection.java:1873)
  at com.sap.sql.jdbc.basic.BasicConnection.prepareStatement(BasicConnection.java:149)
  at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:1286)
  at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:257)
  at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareDirectStatement(CommonConnectionImpl.java:1191)
  at com.sap.sql.services.OpenSQLServices.prepareNativeStatement(OpenSQLServices.java:183)
  at com.sap.inst.jsizecheck.db6.Db6SizeProvider.readDatabaseSize(Db6SizeProvider.java:63)
  at com.sap.inst.jsizecheck.SizeChecker.checkSize(SizeChecker.java:276)
  at com.sap.inst.jsizecheck.SizeChecker.doRun(SizeChecker.java:211)
  at com.sap.inst.jsizecheck.SizeChecker.run(SizeChecker.java:174)
  at com.sap.inst.jsizecheck.JSizeCheck.startAppJob(JSizeCheck.java:279)
  at com.sap.inst.lib.app.CommandLineApp.doMain(CommandLineApp.java:111)
  at com.sap.inst.jsizecheck.JSizeCheck.main(JSizeCheck.java:314)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:331)
  at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)


INFO: 2014-01-12 11:48:59
JSizeCheck is stopped.

Tried to search notes and forum, but no similar case.

Please advise.

Regards,

[former_member45419 · Accepted solution]

Hi Bobby,

Pls refer below note & threads,

Note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis -

DB6: SQL0670N The row length of a table exceeds 4005 bytes

Regards

Nayeem

[Former Member · Accepted solution]

I haven't tried to apply DB correction notes, but it may be useful for my case.

But because I didn't have access to saprouter, I repeated the system copy with database-specific method.

Thankfully my hostname, SID, Sno is the same in source and target.

So there'll be no issue in Java stack.

[tariqmaqsood]

Hi

Although the thread is old and may not have any relevance for the poster anymore. But for future if anyone face similar issue the solution is provided in SAPNote below:

2022267 - System Copy, Dual Stack Split error: SQLSTAT=42884, SQLERRMC=SNAPSHOT_TBW_CFG

(although it says dual stack, but also works for single stack Java export).

[former_member570797]

Hi Tariq,

Thank you very much. I got the same error and it worked for me too.

Regards,

Dinesh

[Former Member]

Hi,

Can you please check what is the patch level of Core tools in you solman system.

check the Below note

1638425 - DB6: Error During Table Size Calculation

Thanks

Rishi Abrol

[Former Member]

core is SP13, so no problem.

Thanks.

[Former Member]

Looks like it is related to the Db2 authorizations for the user running the export.

Which user are you using to run the export?

1. ERROR: 2014-01-12 11:48:59 com.sap.inst.jsizecheck.SizeChecker run 
2. Fatal exception during execution of JSizeCheck. 
3. com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=SNAPSHOT_TBS_CFG;FUNCTION, DRIVER=3.66.46