Apelon DTS / Discussion / Help: DTS with Intersystems Cache

bg2 - 2010-05-25

Does any one have instructions on how to configure DTS to work with Cache
(connection settings - class configuration )?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-25

https://sourceforge.net/apps/trac/apelon-dts/attachment/wiki/DTS%203.5%20Docu
ments/DTS%20Guidelines%20for%20InterSystems%20Cache.pdf

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-26

The first sections with Intersystems instructions worked great.

Run DTS\bin\kb\create\KBCreate.bat produced two SQLException errors which I
have a screen capture of (it's been a long time since I have "printed" from a
DOS command and don't remember the commands to capture the text to a file. Can
I send them to someone?

I tried to run the Cache import and it also produced errors.

Firstly the example shows 8 items to import but the file I have shows 13...
first is a dialog box about more than 8 items will be added to project. Items
will not automatically be opened.

Load started on 05/26/2010 14:53:22

Loading file C:\Program Files\Apelon\DTS
3.5\scripts\Cache\DTSCacheChangeImport.xml as xml

Imported class: User.DTSASSOCIATIONTYPE

Imported class: User.DTSCLASSIFYMONITOR

Imported class: User.DTSCONCEPTARCHIVE

Imported class: User.DTSConcept

Imported class: User.DTSINDEXABLECONCEPTPROPERTY

Imported class: User.DTSINDEXABLECONPROPARCHIVE

Imported class: User.DTSKind

Imported class: User.DTSNamespace

Imported class: User.DTSPROPERTYTYPE

Imported class: User.DTSQUALIFIERTYPE

Imported class: User.DTSSYNONYMCLASS

Imported class: User.DTSTERMPROPERTY

Imported class: User.DTSTerm

Load finished successfully.

Compilation started on 05/26/2010 14:54:29 with qualifiers 'cukd'

Compiling class User.DTSASSOCIATIONTYPE

Compiling class User.DTSCLASSIFYMONITOR

Compiling class User.DTSCONCEPTARCHIVE

Compiling class User.DTSConcept

Compiling class User.DTSINDEXABLECONCEPTPROPERTY

Compiling class User.DTSINDEXABLECONPROPARCHIVE

Compiling class User.DTSKind

Compiling class User.DTSNamespace

Compiling class User.DTSPROPERTYTYPE

Compiling class User.DTSQUALIFIERTYPE

Compiling class User.DTSSYNONYMCLASS

Compiling class User.DTSTERMPROPERTY

Compiling class User.DTSTerm

ERROR #5465: Foreign key 'User.DTSCONCEPTARCHIVE::conceptvinfk' target key
'User.DTSVersion' is invalid

ERROR #5465: Foreign key
'User.DTSINDEXABLECONPROPARCHIVE::indexableconpropvinfk' target key
'User.DTSVersion' is invalid

ERROR #5465: Foreign key 'User.DTSNamespace::authorityfk' target key
'User.DTSAuthority' is invalid

ERROR #5464: Foreign key 'User.DTSPROPERTYTYPE::propertynamespacefk' target
class 'User.DTSNamespace' is invalid

ERROR #5464: Foreign key 'User.DTSQUALIFIERTYPE::qualifiernamespacefk' target
class 'User.DTSNamespace' is invalid

ERROR #5464: Foreign key 'User.DTSTERMPROPERTY::termproppfk' target class
'User.DTSPROPERTYTYPE' is invalid

ERROR #5464: Foreign key 'User.DTSTerm::termnamespacefk' target class
'User.DTSNamespace' is invalid

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_ASSOCIATION_TYPE'

ERROR #5030: An error occurred while compiling class User.DTSASSOCIATIONTYPE

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_CLASSIFY_MONITOR'

ERROR #5030: An error occurred while compiling class User.DTSCLASSIFYMONITOR

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_Concept'

ERROR #5030: An error occurred while compiling class User.DTSConcept

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_INDEXABLE_CONCEPT_PROPERTY'

ERROR #5030: An error occurred while compiling class
User.DTSINDEXABLECONCEPTPROPERTY

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_Kind'

ERROR #5030: An error occurred while compiling class User.DTSKind

ERROR #5002: Cache error:
<SUBSCRIPT>FinalizeTableDefinition+257^%ocsSQLRTDict5 ^oddMAP("") : Error
finalizing SQL Projection of table 'SQLUser.DTS_SYNONYM_CLASS'

ERROR #5030: An error occurred while compiling class User.DTSSYNONYMCLASS

Detected 13 errors during compilation in 5.591s.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-26

The log from KBCreate.bat is written to DTS_HOME\bin\logs\kbcreate.log file.
You can get the error details from there and post it.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-27

Thanks! Here it is...

java.sql.SQLException:

at com.intersys.jdbc.CacheConnection.getServerError(CacheConnection.java:1152)

at com.intersys.jdbc.CacheConnection.processError(CacheConnection.java:1382)

at com.intersys.jdbc.InStream.readHeader(InStream.java:159)

at com.intersys.jdbc.CacheStatement.sendDirectUpdateRequest(CacheStatement.jav
a:597)

at com.intersys.jdbc.CacheStatement.Update(CacheStatement.java:576)

at com.intersys.jdbc.CacheStatement.executeUpdate(CacheStatement.java:534)

at com.apelon.common.util.db.dao.GeneralDAO.executeUpdate(Unknown Source)

at com.apelon.common.util.db.BaseTable.createTable(Unknown Source)

at com.apelon.common.util.db.BaseTable.create(Unknown Source)

at com.apelon.common.util.db.DbCreate.buildTables(Unknown Source)

at com.apelon.common.util.db.DbCreate.run(Unknown Source)

at com.apelon.common.util.db.DbCreate.main(Unknown Source)

2010-05-25 21:38:16.859 ERROR apelon.app
com.apelon.common.util.db.DbCreate.run() - Exception running DbAdmin

java.sql.SQLException: unable to copy data:

at com.apelon.common.util.db.BaseTable.create(Unknown Source)

at com.apelon.common.util.db.DbCreate.buildTables(Unknown Source)

at com.apelon.common.util.db.DbCreate.run(Unknown Source)

at com.apelon.common.util.db.DbCreate.main(Unknown Source)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-27

I have posted a patch jar to resolve this issue at this link -
http://sourceforge.net/apps/trac/apelon-
dts/wiki/dts35cachepatch

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-27

URL correction -

http://sourceforge.net/apps/trac/apelon-
dts/wiki/dts35cachepatch

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-27

Down loaded, created the patches folder in DTS 3.5\lib\ and ran kbcreate.bat

it still shows the two previous errors. Nothing in the log shows that it
picked up the new file.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-27

Did you put the kbcreatecacheconfig.jar in the patches folder?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-27

yep.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-27

It is working for me.

Did you select the option in the KBCreate to drop all tables?

You need to select the option to drop all tables. This is needed to get the
correct schema created.

If this also does not work, I suggest you to start from scratch.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-27

Can you confirm the directory should be "patches"? I selected "drop."

When you say start from scratch do you mean uninstal (delete all the
directories) and reinstall?

Thanks.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Abhay Sinha - 2010-05-27

If DTS is installed in "C:\Program Files\Apelon\DTS 3.5", the jar will go in
"C:\Program Files\Apelon\DTS 3.5\lib\patches" folder.

You can restart by creating a new "cache namespace" . You don't need to
reinstall DTS.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

bg2 - 2010-05-27

deleted and reinstall all the cache. Same two errors when running kbcreate.bat

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DTS with Intersystems Cache

Forums

Help

DTS with Intersystems Cache document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

DTS with Intersystems Cache