cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

deploying dictionary project successfully fails !

Go to solution
Former Member

on ‎06-08-2005 4:03 PM

0 Kudos

Hi,

2 questions:

1) my NWDevStudio is lying - when deploying databasetables, I get the message - deployment finished successfully, but no tables are being generated on the J2EE.

the additional logfile says:

08.06.2005 16:52:55 /userOut/deploy (com.sap.ide.eclipse.sdm.threading.DeployThreadManager) [Thread[Deploy Thread,5,main]] INFO:

[001]Additional log information about the deployment

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7162 - 630_SP]/>

<!NAME[D:\usr\sap\BEP\JC00\SDM\program\log\sdmcl20050608145213.log]/>

<!PATTERN[sdmcl20050608145213.log]/>

<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %s: %m)]/>

<!ENCODING[Cp1252]/>

<!LOGHEADER[END]/>

Jun 8, 2005 4:52:13 PM Info: -

Starting deployment -

Jun 8, 2005 4:52:13 PM Info: Loading selected archives...

Jun 8, 2005 4:52:13 PM Info: Loading archive 'D:\usr\sap\BEP\JC00\SDM\program\temp\temp27261kasig.sda'

Jun 8, 2005 4:52:13 PM Info: Selected archives successfully loaded.

Jun 8, 2005 4:52:13 PM Info: Actions per selected component:

Jun 8, 2005 4:52:13 PM Info: Update: Selected development component 'kasig'/'sap.com'/'localhost'/'2005.06.08.15.51.11' updates currently deployed development component 'kasig'/'sap.com'/'localhost'/'2005.06.08.15.51.11'.

Jun 8, 2005 4:52:13 PM Info: Error handling strategy: OnErrorStop

Jun 8, 2005 4:52:13 PM Info: Update strategy: UpdateAllVersions

Jun 8, 2005 4:52:13 PM Info: Starting: Update: Selected development component 'kasig'/'sap.com'/'localhost'/'2005.06.08.15.51.11' updates currently deployed development component 'kasig'/'sap.com'/'localhost'/'2005.06.08.15.51.11'.

Jun 8, 2005 4:52:13 PM Info: <!LOGHEADER[START]/>

Jun 8, 2005 4:52:13 PM Info: <!HELP[Manual modification of the header may cause parsing problem!]/>

Jun 8, 2005 4:52:13 PM Info: <!LOGGINGVERSION[1.5.3.7162 - 630_SP]/>

Jun 8, 2005 4:52:13 PM Info: <!NAME[D:\usr\sap\BEP\JC00\SDM\program\log\jddilog20050608165213.log]/>

Jun 8, 2005 4:52:13 PM Info: <!PATTERN[jddilog20050608165213.log]/>

Jun 8, 2005 4:52:13 PM Info: <!FORMATTER[com.sap.dictionary.database.dbs.DbTraceFormatter(%s %m %-30l %24d)]/>

Jun 8, 2005 4:52:13 PM Info: <!ENCODING[Cp1252]/>

Jun 8, 2005 4:52:13 PM Info: <!LOGHEADER[END]/>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: $Id: //tc/DictionaryDatabase/630_VAL_REL/src/_dictionary_database_dbs/java/com/sap/dictionary/database/dbs/DbModificationManager.java#1 $

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<<<<<<<<<<<<< Table Deployment >>>>>>>>>>>>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info:

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: No action required for table

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<< Analyze table BC_DDDBTABLERT >>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: No action required for table

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: No action required for table

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<< Analyze table BC_DDDBRTX >>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: No action required for table

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: >>> Analyze tables from archive in database ORACLE

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: Next archive object : TEST_KASIG.gdbtable

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: <<< Analyze table TEST_KASIG >>>

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: No action required for table

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: Runtime XML of TEST_KASIG successfully written

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: Runtime XML of TEST_KASIG successfully written

Jun 8, 2005 4:52:13 PM Info: 16:52:13 2005-06-08 dbs-Info: Analysis and adjustment of tables successfully executed

Jun 8, 2005 4:52:13 PM Info: Finished successfully: development component 'kasig'/'sap.com'/'localhost'/'2005.06.08.15.51.11'

Jun 8, 2005 4:52:13 PM Info: -

Deployment was successful -

When a collegue does the same he gets some create table-sql statements and his really can deploy tables.

we could not find any differences between our dictionary projects - and both use NWDevStudio: Version: 2.0.10

2) is there a plugin available in NWDevStudio for checking sql?

any ideas appreciated,

thanx, matthias

Message was edited by: matthias kasig

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎06-08-2005 4:26 PM
0 Kudos

Hi,

If the deployment is fine then ideally it should create tables in MAXDB.

Please check once weather you are deploying on the correct engine or not ?

If that is fine then open SQL studio and check tables are created under SAPBEPDB domain or not.

Regards, Anilkumar

Show replies
Show replies
Former Member
‎06-08-2005 4:42 PM
0 Kudos

Hi Anilkumar,

I definitly deploy on the same machine as my collegue who can deploy and create tables. But my tables do not show up.

How do I access SQL Studio? My collegue checks with an extra eclipse installation - but i think this should be possible from my NWDevStudio.

Thanx for more answers,

matthias

Answers (1)

Answers (1)

Former Member
‎06-08-2005 4:48 PM
0 Kudos

Hi,

You can get the SQLStudio installation in the location


sapinst\opt\J2EE-CD\SAPDB\NT\SETUPS

I am not sure about the plugin

Regards, Anilkumar

Show replies
Show replies
Former Member
‎06-08-2005 6:31 PM
0 Kudos

hi,

i downloaded sql studio in different versions, but each time i try to connect to the db the sql studio crashes.

i am running win xp. the j2ee engine with the sapdb on win2000 server.

thanx for help,

matthias

Former Member
‎06-09-2005 4:37 AM
0 Kudos

Hi Kasig,

What data you are giving for connecting to the Database through SQL Studio?

regards,

Bhavik

Former Member
‎06-09-2005 9:31 AM
0 Kudos

Hi,

in Visual Admin we set under JDBC Connector a new DataSource node called sap.com/JDBC and this carries a node JDBC with following entries:

Name: JDBC

Driver Class: oracle.jdbc.driver.OracleDriver

Database URL: jdbc:oracle:thin:@localhost:1527:BEP

User: SAPBEPDB

Pass: password

sql studio asks for

server - database - user -password

in webdynpro I set

"jdbc:oracle:thin:@<IP>:1527:BEP",

"SAPBEPDB",

"password";

in sql studio i put:

server: <IP>:1527:BEP

DB: JDBC

User: SAPBEPDB

pass: password

this crashes...

why?

matthias

Former Member
‎06-09-2005 9:59 AM
0 Kudos

concerning my question 1)

my deployed tables now show up - a collegue watches the db with quantum 2.4.5 was eclipse plugin.

but i have no clue why...

strange thing. Because I did not deploy anymore. It's like during night somebody put my tables on the db.

apparently we've got EP Patchlevel 11 and NWDevStudio Patch 10. Should we patch the dev studio?

Former Member
‎06-09-2005 1:04 PM
0 Kudos

Hi Kasig,

Modify the values of parameters for connecting SQL Studio as follows:

Server : <IP of your WAS>

DB : BEP

User : SAPBEPDB

password : <password of J2EE Server>

regards,

Bhavik

Former Member
‎06-09-2005 1:27 PM
0 Kudos

hi,

i tried that already - crashes.

maybe i am totally wrong? i don't connect to a WAS but a J2EE.

Like my collegue I am using eclipse with quantum db plugin now. I also put the quantum db plugin in NWDevStudio, but it won't show up under "open perspective"--> other...

regards,

matthias

Ask a Question