Java Dictionary issues (deployment, update errors)

Former Member · ‎09-07-2005

I'm using Netweaver Developer Studio 2.0.9 on Web AS 6.40 SP11.

After having attempted to use Java Dictionary with a JDO persistence layer on a real-life project, I'm having serious doubts about the advantages.

First of all, the inability to remove a dictionary project deployed on a server:

What if I want to make some tests on a development server? Starting up a project sometimes means trying out different schemas/names etc on the database, but after having deployed a dictionary project it is just stuck on the server. I can delete the tables, of course, but the dictionary project is just stuck there.

Second, what about migration:

Schemas changes, and sometimes so do the column types. The deployment process obviously cannot handle this, exiting with a "Table needs conversion" error. So the migration of table data lies externally to the dictionary projects, which seem to be in contradiction with its meaning.

But worst of all is that I've experienced several times where my dictionary just won't deploy. The errors always the same (I've tried deploying through both the SDM desktop and Netweaver):

[code]

Sep 7, 2005 10:52:09 AM Info: -

Starting deployment -

Sep 7, 2005 10:52:09 AM Info: Loading selected archives...

Sep 7, 2005 10:52:09 AM Info: Loading archive 'C:\usr\sap\KSP\JC00\SDM\program\temp\temp56150dk.thd.adresser dictionary.sda'

Sep 7, 2005 10:52:10 AM Info: Selected archives successfully loaded.

Sep 7, 2005 10:52:10 AM Info: Actions per selected component:

Sep 7, 2005 10:52:10 AM Info: Update: Selected development component 'dk.thd.adresser

dictionary'/'sap.com'/'localhost'/'2005.09.07.10.52.07' updates currently deployed development component 'dk.thd.adresser

dictionary'/'sap.com'/'localhost'/'2005.07.18.10.18.58'.

Sep 7, 2005 10:52:10 AM Info: Error handling strategy: OnErrorStop

Sep 7, 2005 10:52:10 AM Info: Update strategy: UpdateAllVersions

Sep 7, 2005 10:52:10 AM Info: Starting: Update: Selected development component 'dk.thd.adresser

dictionary'/'sap.com'/'localhost'/'2005.09.07.10.52.07' updates currently deployed development component 'dk.thd.adresser

dictionary'/'sap.com'/'localhost'/'2005.07.18.10.18.58'.

Sep 7, 2005 10:52:10 AM Info: <!~~LOGHEADER[START]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~HELP[Manual modification of the header may cause parsing problem!]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~LOGGINGVERSION[1.5.3.7181 - 630_SP]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~NAME[C:\usr\sap\KSP\JC00\SDM\program\log\jddilog20050907105210.log]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~PATTERN[jddilog20050907105210.log]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~FORMATTER[com.sap.dictionary.database.dbs.DbTraceFormatter(%s %m %-30l %24d)]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~ENCODING[Cp1252]/~~>

Sep 7, 2005 10:52:10 AM Info: <!~~LOGHEADER[END]/~~>

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 dbs-Info: $Id:

//tc/DictionaryDatabase/630_VAL_REL/src/_dictionary_database_dbs/java/com/sap/dictionary/database/dbs/DbModificationManager.java#1 $

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 dbs-Info: <<<<<<<<<<<<<< Table Deployment >>>>>>>>>>>>>

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 dbs-Info:

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Sep 7, 2005 10:52:10 AM Info:

Sep 7, 2005 10:52:10 AM Info: E R R O R ******* (DbMssTable)

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 mss-Error: setColumnsViaDb failed: <null>

Sep 7, 2005 10:52:10 AM Info:

Sep 7, 2005 10:52:10 AM Info: E R R O R ******* (DbModificationManager)

Sep 7, 2005 10:52:10 AM Info: 10:52:10 2005-09-07 dbs-Error:

Sep 7, 2005 10:52:10 AM Error: Aborted: development component 'dk.thd.adresser dictionary'/'sap.com'/'localhost'/'2005.09.07.10.52.07':

No further description found.

Sep 7, 2005 10:52:10 AM Error: -

At least one of the Deployments failed -

[/code]

This seems to be a problem when there's some sort of inconsistency between the deployed dictionary and the edited dictionary. But what the inconsistency is, no one knows. I have not been able to find anything which should lead to inconsistency. I haven't changed anything on the database tables on the server. So what are my options? To make a manual copy of the tables to temporary storage, delete the tables from the old Dictionary project, make a new Dictionary project, recreate the tables and make a manual copy of the data? Then I'm left with my old Java Dictionary project on the server, forever cluttering up the production server.

Why can't I simply remove the project from the server and start all over again?

Please, what am I missing here? Java Dictionay seems next to useless. Right now I'm tempted to stop using the dictionary and go back to manually creating the tables in the database.

Thanks,

Thomas

Former Member · ‎10-31-2006

Hi

I had a similar problem when importing into the test system with the CMS:

<i>Info:Oct 30, 2006 3:19:47 AM Info: 3:19:47 2006-10-30 dbs-Info: $Id: //tc/DictionaryDatabase/645_VAL_REL/src/_dictionary_database_dbs/java/com/sap/dictionary/database/dbs/DbModificationManager.java#4 $

Info:Oct 30, 2006 3:19:47 AM Info: 3:19:47 2006-10-30 dbs-Info: <<<<<<<<<<<<<< Table Deployment >>>>>>>>>>>>>

Info:Oct 30, 2006 3:19:47 AM Info: 3:19:47 2006-10-30 dbs-Info:

Info:Oct 30, 2006 3:19:47 AM Info: 3:19:47 2006-10-30 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Info:Oct 30, 2006 3:19:47 AM Info: 3:19:47 2006-10-30 dbs-Info: predefined action is: >>>null<<<