Deployment Aborted !!!

[Amey-Mogare]

Hiii,

I am getting following exception while deployment.

Apr 15, 2008 4:14:55 PM /userOut/deploy (com.sap.ide.eclipse.sdm.threading.DeployThreadManager) [Thread[Deploy Thread,5,main]] ERROR:

[003]Deployment aborted

Settings

SDM host : WAS

SDM port : 50018

URL to deploy : file:/C:/DOCUME_{1/NEWUSER/LOCALS}1/Temp/temp42096asianpaints.com~BshopDic.sda

Result

=> deployment aborted : file:/C:/DOCUME_{1/NEWUSER/LOCALS}1/Temp/temp42096asianpaints.com~BshopDic.sda

Aborted: development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080415161035':No further description found.

Deployment exception : The deployment of at least one item aborted

Can anybody pls tell me what does it mean and how to rectify it?

regards,

Amey

[Former Member · Accepted solution]

Hi Amey,

I think it cannot determine sdm host (is empty). Please configure your engine/sdm

correctly !

Go through this thread i think it will be helpfull..

Regards,

Arun.

[Amey-Mogare · Accepted solution]

This is the Complete stack trace given in additional deployment log :-

This is showing some ERROR which I am not able to understand..

Pls pls help..

Apr 15, 2008 5:03:39 PM /userOut/deploy (com.sap.ide.eclipse.sdm.threading.DeployThreadManager) [Thread[Deploy Thread,5,main]] INFO:

[010]Additional log information about the deployment

<!LOGHEADER[START]/>

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

<!LOGGINGVERSION[1.5.3.7186 - 630]/>

<!NAME[/usr/sap/J2E/JC00/SDM/program/log/sdmcl20080415105138.log]/>

<!PATTERN[sdmcl20080415105138.log]/>

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

<!ENCODING[ISO8859_1]/>

<!LOGHEADER[END]/>

Apr 15, 2008 4:21:39 PM Info: -

---

Starting deployment -

---

Apr 15, 2008 4:21:39 PM Info: Error handling strategy: OnErrorStop

Apr 15, 2008 4:21:39 PM Info: Prerequisite error handling strategy: OnPrerequisiteErrorStop

Apr 15, 2008 4:21:39 PM Info: Update strategy: UpdateAllVersions

Apr 15, 2008 4:21:39 PM Info: Starting deployment prerequisites:

Apr 15, 2008 4:21:39 PM Info: Loading selected archives...

Apr 15, 2008 4:21:39 PM Info: Loading archive '/usr/sap/J2E/JC00/SDM/program/temp/temp42126asianpaints.com~BshopDic.sda'

Apr 15, 2008 4:21:51 PM Info: Selected archives successfully loaded.

Apr 15, 2008 4:21:51 PM Info: Actions per selected component:

Apr 15, 2008 4:21:51 PM Info: Update: Selected development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080415170147' updates currently deployed development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080414171647'.

Apr 15, 2008 4:21:51 PM Info: Ending deployment prerequisites. All items are correct.

Apr 15, 2008 4:21:51 PM Info: Starting: Update: Selected development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080415170147' updates currently deployed development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080414171647'.

Apr 15, 2008 4:22:00 PM Info: <!LOGHEADER[START]/>

Apr 15, 2008 4:22:00 PM Info: <!HELP[Manual modification of the header may cause parsing problem!]/>

Apr 15, 2008 4:22:00 PM Info: <!LOGGINGVERSION[1.5.3.7186 - 630]/>

Apr 15, 2008 4:22:00 PM Info: <!NAME[/usr/sap/J2E/JC00/SDM/program/log/jddilog20080415162151.log]/>

Apr 15, 2008 4:22:00 PM Info: <!PATTERN[jddilog20080415162151.log]/>

Apr 15, 2008 4:22:00 PM Info: <!FORMATTER[com.sap.dictionary.database.dbs.DbTraceFormatter(%s %m %-30l %24d)]/>

Apr 15, 2008 4:22:00 PM Info: <!ENCODING[ISO8859_1]/>

Apr 15, 2008 4:22:00 PM Info: <!LOGHEADER[END]/>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<<<<<<<<<<<<< Table Deployment >>>>>>>>>>>>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info:

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<< Analyze table BC_DDDBTABLERT >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<< Analyze table BC_DDDBRTX >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: >>> Analyze tables from archive in database ORACLE

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_BRAND.gdbtable

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: <<< Analyze table BIT_BRAND >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:51 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: Runtime XML of BIT_BRAND successfully written

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: Runtime XML of BIT_BRAND successfully written

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_BS.gdbtable

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: <<< Analyze table BIT_BS >>>

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: Table BIT_BS not found on DB

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: Action: CREATE

Apr 15, 2008 4:22:00 PM Info: 16:21:52 2008-04-15 dbs-Info: CREATE TABLE "BIT_BS"

Apr 15, 2008 4:22:00 PM Info: (

Apr 15, 2008 4:22:00 PM Info: "BSID" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "OEMID" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "UNITCODE" NVARCHAR2(10) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSNAME" NVARCHAR2(50) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSADDRESS" NVARCHAR2(500) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSSTATE" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSCITY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSPIN" NVARCHAR2(6) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSEMAIL" NVARCHAR2(100) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "BSTEL1" NVARCHAR2(20) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "BSTEL2" NVARCHAR2(20) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "BSMOBILE" NVARCHAR2(10) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "BSFAX1" NVARCHAR2(20) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "BSFAX2" NVARCHAR2(20) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "CREATED_AT" DATE NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "CREATED_BY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "CHANGED_AT" DATE NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "CHANGED_BY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:00 PM Info: "DATA1_BS" NVARCHAR2(100) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "DATA2_BS" NVARCHAR2(100) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "DATA3_BS" NVARCHAR2(100) DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "DATA4_BS" REAL DEFAULT ,

Apr 15, 2008 4:22:00 PM Info: "DATA5_BS" NVARCHAR2(1) DEFAULT

Apr 15, 2008 4:22:00 PM Info: )

Apr 15, 2008 4:22:00 PM Info: ALTER TABLE "BIT_BS"

Apr 15, 2008 4:22:00 PM Info: ADD PRIMARY KEY ("BSID", "OEMID", "UNITCODE")

Apr 15, 2008 4:22:00 PM Info: NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Apr 15, 2008 4:22:00 PM Info:

Apr 15, 2008 4:22:00 PM Info:

Apr 15, 2008 4:22:00 PM Info: E R R O R ******* (DbObjectSqlStatements)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Exception caught during SQL execution ORA-00936: missing expression

Apr 15, 2008 4:22:01 PM Info: CREATE TABLE "BIT_BS"("BSID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "OEMID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "UNITCODE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "BSNAME" NVARCHAR2(50) DEFAULT ' ' NOT NULL, "BSADDRESS" NVARCHAR2(500) DEFAULT ' ' NOT NULL, "BSSTATE" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSCITY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSPIN" NVARCHAR2(6) DEFAULT ' ' NOT NULL, "BSEMAIL" NVARCHAR2(100) DEFAULT ' ' NOT NULL, "BSTEL1" NVARCHAR2(20) DEFAULT ' ' , "BSTEL2" NVARCHAR2(20) DEFAULT ' ' , "BSMOBILE" NVARCHAR2(10) DEFAULT ' ' , "BSFAX1" NVARCHAR2(20) DEFAULT ' ' , "BSFAX2" NVARCHAR2(20) DEFAULT ' ' , "CREATED_AT" DATE NOT NULL, "CREATED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "CHANGED_AT" DATE NOT NULL, "CHANGED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "DATA1_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA2_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA3_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA4_BS" REAL DEFAULT , "DATA5_BS" NVARCHAR2(1) DEFAULT ' ' )

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbObjectSqlStatements)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Exception caught during SQL execution ORA-00936: missing expression

Apr 15, 2008 4:22:01 PM Info: CREATE TABLE "BIT_BS"("BSID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "OEMID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "UNITCODE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "BSNAME" NVARCHAR2(50) DEFAULT ' ' NOT NULL, "BSADDRESS" NVARCHAR2(500) DEFAULT ' ' NOT NULL, "BSSTATE" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSCITY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSPIN" NVARCHAR2(6) DEFAULT ' ' NOT NULL, "BSEMAIL" NVARCHAR2(100) DEFAULT ' ' NOT NULL, "BSTEL1" NVARCHAR2(20) DEFAULT ' ' , "BSTEL2" NVARCHAR2(20) DEFAULT ' ' , "BSMOBILE" NVARCHAR2(10) DEFAULT ' ' , "BSFAX1" NVARCHAR2(20) DEFAULT ' ' , "BSFAX2" NVARCHAR2(20) DEFAULT ' ' , "CREATED_AT" DATE NOT NULL, "CREATED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "CHANGED_AT" DATE NOT NULL, "CHANGED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "DATA1_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA2_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA3_BS" NVARCHAR2(100) DEFAULT ' ' , "DATA4_BS" REAL DEFAULT , "DATA5_BS" NVARCHAR2(1) DEFAULT ' ' )

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbModificationManager)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Statements could not be executed successfully

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbModificationManager)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Statements could not be executed successfully

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_CONTRACT.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: <<< Analyze table BIT_CONTRACT >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: Table BIT_CONTRACT not found on DB

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: Action: CREATE

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: CREATE TABLE "BIT_CONTRACT"

Apr 15, 2008 4:22:01 PM Info: (

Apr 15, 2008 4:22:01 PM Info: "CONTRACTID" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "BSID" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "AGREEMENT_ID" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "EXECUTIONDATE" DATE NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "CONTRACT_TYPE" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "INCREAMENT" REAL DEFAULT 0 NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "TENURE" NUMBER(10) DEFAULT 0 NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "INVESTMENTTYPE" NVARCHAR2(10) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "COMMITTERM" NVARCHAR2(10) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "ENTITY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "AMOUNT" FLOAT DEFAULT 0 NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "COMMITTYPE" NVARCHAR2(10) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "SCHEDULEDAMT" FLOAT DEFAULT 0 NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "PRICELISTDATE" DATE NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "DEALERCODE" NVARCHAR2(20) DEFAULT ,

Apr 15, 2008 4:22:01 PM Info: "CONTRIBUTION" REAL DEFAULT 0 ,

Apr 15, 2008 4:22:01 PM Info: "CONTRI_AMOUNT" FLOAT DEFAULT 0 ,

Apr 15, 2008 4:22:01 PM Info: "CREATED_AT" DATE NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "CREATED_BY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "CHANGED_AT" DATE NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "CHANGED_BY" NVARCHAR2(20) DEFAULT NOT NULL,

Apr 15, 2008 4:22:01 PM Info: "DATA1_CT" NVARCHAR2(100) DEFAULT ,

Apr 15, 2008 4:22:01 PM Info: "DATA2_CT" NVARCHAR2(100) DEFAULT ,

Apr 15, 2008 4:22:01 PM Info: "DATA3_CT" NVARCHAR2(100) ,

Apr 15, 2008 4:22:01 PM Info: "DATA4_CT" REAL DEFAULT ,

Apr 15, 2008 4:22:01 PM Info: "DATA5_CT" NVARCHAR2(10) DEFAULT

Apr 15, 2008 4:22:01 PM Info: )

Apr 15, 2008 4:22:01 PM Info: ALTER TABLE "BIT_CONTRACT"

Apr 15, 2008 4:22:01 PM Info: ADD PRIMARY KEY ("CONTRACTID", "BSID")

Apr 15, 2008 4:22:01 PM Info: NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbObjectSqlStatements)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Exception caught during SQL execution ORA-00936: missing expression

Apr 15, 2008 4:22:01 PM Info: CREATE TABLE "BIT_CONTRACT"("CONTRACTID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "AGREEMENT_ID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "EXECUTIONDATE" DATE NOT NULL, "CONTRACT_TYPE" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "INCREAMENT" REAL DEFAULT 0 NOT NULL, "TENURE" NUMBER(10) DEFAULT 0 NOT NULL, "INVESTMENTTYPE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "COMMITTERM" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "ENTITY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "AMOUNT" FLOAT DEFAULT 0 NOT NULL, "COMMITTYPE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "SCHEDULEDAMT" FLOAT DEFAULT 0 NOT NULL, "PRICELISTDATE" DATE NOT NULL, "DEALERCODE" NVARCHAR2(20) DEFAULT ' ' , "CONTRIBUTION" REAL DEFAULT 0 , "CONTRI_AMOUNT" FLOAT DEFAULT 0 , "CREATED_AT" DATE NOT NULL, "CREATED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "CHANGED_AT" DATE NOT NULL, "CHANGED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "DATA1_CT" NVARCHAR2(100) DEFAULT ' ' , "DATA2_CT" NVARCHAR2(100) DEFAULT ' ' , "DATA3_CT" NVARCHAR2(100) , "DATA4_CT" REAL DEFAULT , "DATA5_CT" NVARCHAR2(10) DEFAULT ' ' )

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbObjectSqlStatements)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Exception caught during SQL execution ORA-00936: missing expression

Apr 15, 2008 4:22:01 PM Info: CREATE TABLE "BIT_CONTRACT"("CONTRACTID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "BSID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "AGREEMENT_ID" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "EXECUTIONDATE" DATE NOT NULL, "CONTRACT_TYPE" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "INCREAMENT" REAL DEFAULT 0 NOT NULL, "TENURE" NUMBER(10) DEFAULT 0 NOT NULL, "INVESTMENTTYPE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "COMMITTERM" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "ENTITY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "AMOUNT" FLOAT DEFAULT 0 NOT NULL, "COMMITTYPE" NVARCHAR2(10) DEFAULT ' ' NOT NULL, "SCHEDULEDAMT" FLOAT DEFAULT 0 NOT NULL, "PRICELISTDATE" DATE NOT NULL, "DEALERCODE" NVARCHAR2(20) DEFAULT ' ' , "CONTRIBUTION" REAL DEFAULT 0 , "CONTRI_AMOUNT" FLOAT DEFAULT 0 , "CREATED_AT" DATE NOT NULL, "CREATED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "CHANGED_AT" DATE NOT NULL, "CHANGED_BY" NVARCHAR2(20) DEFAULT ' ' NOT NULL, "DATA1_CT" NVARCHAR2(100) DEFAULT ' ' , "DATA2_CT" NVARCHAR2(100) DEFAULT ' ' , "DATA3_CT" NVARCHAR2(100) , "DATA4_CT" REAL DEFAULT , "DATA5_CT" NVARCHAR2(10) DEFAULT ' ' )

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbModificationManager)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Statements could not be executed successfully

Apr 15, 2008 4:22:01 PM Info:

Apr 15, 2008 4:22:01 PM Info: E R R O R ******* (DbModificationManager)

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Error: Statements could not be executed successfully

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_CP.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: <<< Analyze table BIT_CP >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:53 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: Runtime XML of BIT_CP successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: Runtime XML of BIT_CP successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_DEALER.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: <<< Analyze table BIT_DEALER >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:54 2008-04-15 dbs-Info: Runtime XML of BIT_DEALER successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: Runtime XML of BIT_DEALER successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_DIVISION.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: <<< Analyze table BIT_DIVISION >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: Runtime XML of BIT_DIVISION successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: Runtime XML of BIT_DIVISION successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_INVESTMENT.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: <<< Analyze table BIT_INVESTMENT >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:55 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: Runtime XML of BIT_INVESTMENT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: Runtime XML of BIT_INVESTMENT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_OEM.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: <<< Analyze table BIT_OEM >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:56 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:57 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:57 2008-04-15 dbs-Info: Runtime XML of BIT_OEM successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:57 2008-04-15 dbs-Info: Runtime XML of BIT_OEM successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:57 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_PRODUCT.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: <<< Analyze table BIT_PRODUCT >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: Runtime XML of BIT_PRODUCT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: Runtime XML of BIT_PRODUCT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_REGION.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: <<< Analyze table BIT_REGION >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:58 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: Runtime XML of BIT_REGION successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: Runtime XML of BIT_REGION successfully written

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_UNIT.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: <<< Analyze table BIT_UNIT >>>

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:21:59 2008-04-15 dbs-Info: Runtime XML of BIT_UNIT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: Runtime XML of BIT_UNIT successfully written

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: Next archive object : dbtables/BIT_USER_MASTER.gdbtable

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: <<< Analyze table BIT_USER_MASTER >>>

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: predefined action is: >>>null<<<

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: No action required for table

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: Runtime XML of BIT_USER_MASTER successfully written

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: Runtime XML of BIT_USER_MASTER successfully written

Apr 15, 2008 4:22:01 PM Info: 16:22:00 2008-04-15 dbs-Info: Analysis and adjustment of tables finished with errors

Apr 15, 2008 4:22:01 PM Error: Aborted: development component 'BshopDic'/'asianpaints.com'/'J2E_BODYSHOP_D'/'20080415170147':

No further description found.

Apr 15, 2008 4:22:13 PM Error: -

---

At least one of the Deployments failed -

---

[Former Member · Accepted solution]

Hi,

From the stack its clear that some of your table creation statements are failing (May be dictionary project)

Pl try to execute the same sql statements from SQL+ and see the issue exists or not.

Regards

Ayyapparaj

[Amey-Mogare · Accepted solution]

Dear Ayyapparaj,

I have created a dictionary project and built it without any problem.

But while deployment above error is occurring.

regards,

amey

[Amey-Mogare · Accepted solution]

im trying to create the table using SQL developer but m getting

following error.

ORA:00936: missing expression

vendor code 936

what does it mean???

[Former Member · Accepted solution]

Hi,

Check the statement syntax and specify the missing component..

Regards,

Arun

[Amey-Mogare · Accepted solution]

But I have created table using Dictionary DC..

So how can i check for syntax errors?

Where do i have to look for it??

The erroneous create statement is available in above stack trace...

pls suggest..

[Amey-Mogare · Accepted solution]

Hi,

I dropped these two table and created them again with different name. and surprisingly they got deployed successfully...

regards,

Amey