Former Member

Sneak Preview Installation Error at "Deploy Online" Step (SQL Syntax Error)

Posted on Dec 30, 2004 at 12:20 AM 22 Views

Hi with problems again

As suggested in an earlier thread, I upgraded to 768 MB RAM and Java SDK 1.4.2_06. I have an MS Windows XP Professional Service Pack 2 system.

At the last step "Deploy Online" of Sneak Preview Installation, I encountered the error with the following log entry. I tried to deploy related archive manually from the SDM, but it gave the same error. Can anybody help me on this?

I wanna welcome the new year with NW 😊

Happy new year...

*--Serdar

Log Entry:

Dec 30, 2004 2:02:14 AM Info: Start logging to console

Dec 30, 2004 2:02:14 AM Info:

Dec 30, 2004 2:02:14 AM Info: ============================================

Dec 30, 2004 2:02:14 AM Info: = Starting to execute command 'deploy' =

Dec 30, 2004 2:02:14 AM Info: ============================================

Dec 30, 2004 2:02:14 AM Info: Starting SDM - Software Deployment Manager...

Dec 30, 2004 2:02:15 AM Info: tc/SL/SDM/SDM/sap.com/SAP AG/6.3004.00.0000.20040204183620.0000

Dec 30, 2004 2:02:16 AM Info: SDM operation mode successfully set to: Standalone

Dec 30, 2004 2:02:17 AM Info: Initializing Network Manager (50017)

Dec 30, 2004 2:02:17 AM Info: Checking if another SDM is running on port 50018

Dec 30, 2004 2:02:17 AM Info: -

Starting deployment -

Dec 30, 2004 2:02:18 AM Info: Loading selected archives...

Dec 30, 2004 2:02:18 AM Info: Loading archive 'D:\SAPWAS640\SAPinst_WAS\J2EE-CD\J2EE-ENG\ONLINE\SAPJTECHS04_0.SCA'

Dec 30, 2004 2:02:25 AM Info: Selected archives successfully loaded.

Dec 30, 2004 2:02:26 AM Info: Actions per selected component:

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.security.core.admin'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203163559.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.aii.ibtranslationclient'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.aii.proxy.framework'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.rprof.jddschema'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203163504.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'tc/SL/UTIL_JDD'/'sap.com'/'SAP AG'/'6.3004.00.0000.20031022133109.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: software component 'SAP_JTECHS'/'sap.com'/'SAP AG'/'1000.6.30.4.0.20040212152521': deploy

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.engine.docs.examples'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040205154547.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.engine.class.download'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040205154547.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.lcr.jddschema'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204183559.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.lcr.saprfc'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204183559.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'tc/uddi'/'sap.com'/'SAP AG'/'6.3004.00.0000.20031118214805.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'tc/wd/pdfsvrchal'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204185252.0000': deploy

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.jdo'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203164404.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.aii.util.rb'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.util.monitor.grmg'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203162838.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.mobile.clientinfo'/'sap.com'/'SAP AG'/'6.3004.00.0000.20031008103221.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'tc/SL/CMS/IDEClient'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040128131819.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'com.sap.lcr.namealloc'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204183559.0000': useexisting

Dec 30, 2004 2:02:26 AM Info: development component 'SQLTrace'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204181929.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.lcr'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204183559.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.aii.ibtransportclient'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.rprof.remoteProfile'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203163504.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/SL/UTIL'/'sap.com'/'SAP AG'/'6.3004.00.0000.20031022133109.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sapmarkets.mesyncjco'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203163438.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.ip.me.webconsole'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173114.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/wd/pdfobject'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040205111447.0000': deploy

Dec 30, 2004 2:02:27 AM Info: development component 'tc/uddi/dbschema'/'sap.com'/'SAP AG'/'6.3004.00.0000.20031118214805.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.lcrabapapi'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040114175434.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/sec/wssec/app'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203162810.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/sec/app'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203162810.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/wd/tools'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204185252.0000': deploy

Dec 30, 2004 2:02:27 AM Info: development component 'com.sapportals.htmlb.ear'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040114175417.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.util.monitor.jarm.j2ee'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040114180217.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/wd/corecomp'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204185252.0000': deploy

Dec 30, 2004 2:02:27 AM Info: development component 'tc/wd/dispwda'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040205111447.0000': deploy

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.aii.util.xml'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sapportals.htmlb'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040114175417.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'synclog'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204181929.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.engine.services.webservices.tool'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040205154547.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.rprof.dbprofiles'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040203163504.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'com.sap.aii.util.misc'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040120173557.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: development component 'tc/sld/data'/'sap.com'/'SAP AG'/'6.3004.00.0000.20040204183559.0000': useexisting

Dec 30, 2004 2:02:27 AM Info: SDM configuration: Do not automatically start/stop J2EE Engine. Do not save current state of J2EE Engine now.

Dec 30, 2004 2:02:27 AM Info: Error handling strategy: OnErrorStop

Dec 30, 2004 2:02:27 AM Info: Update strategy: UpdateLowerVersions

Dec 30, 2004 2:02:27 AM Info: Starting to execute deployment action (deploy) for "tc/wd/dispwda".

Dec 30, 2004 2:02:27 AM Info: SDA to be deployed: D:\usr\sap\J2E\JC00\SDM\root\origin\sap.com\tc\wd\dispwda\SAP AG\6.3004.00.0000.20040205111447.0000\WebDynproDispWda.sda

Dec 30, 2004 2:02:27 AM Info: Software type of SDA: J2EE

Dec 30, 2004 2:02:28 AM Info: ***** Begin of SAP J2EE Engine Deployment (J2EE Application) *****

Dec 30, 2004 2:03:06 AM Info: Begin of log messages of the target system:

07/10/30 02:02:29 - ***********************************************************

07/10/30 02:02:31 - Start updating EAR file...

07/10/30 02:02:33 - EAR file updated successfully for 1172ms.

07/10/30 02:02:33 - Start deploying ...

07/10/30 02:02:37 - EAR file uploaded to server for 2413ms.

07/10/30 02:03:05 - ERROR: Not deployed. Deploy Service returned ERROR:

java.rmi.RemoteException: Cannot deploy application sap.com/tc_wddispwda..

Reason: <--Localization failed: ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle', ID='Failed to deploy application sap.com/tc_wddispwda. Reason = The SQL statement "insert into TC_WDRR_LAYERS (name, version, predecessor, order_index, deployable_object) values (?,?,?,?,?)" contains the syntax error[s]: Entry-SQL syntax error: a query must start with SELECT

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

', Arguments: []--> : Can't find resource for bundle java.util.PropertyResourceBundle, key Failed to deploy application sap.com/tc_wddispwda. Reason = The SQL statement "insert into TC_WDRR_LAYERS (name, version, predecessor, order_index, deployable_object) values (?,?,?,?,?)" contains the syntax error[s]: Entry-SQL syntax error: a query must start with SELECT

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

; nested exception is:

com.sap.engine.services.deploy.container.DeploymentException: <--Localization failed: ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle', ID='Failed to deploy application sap.com/tc_wddispwda. Reason = The SQL statement "insert into TC_WDRR_LAYERS (name, version, predecessor, order_index, deployable_object) values (?,?,?,?,?)" contains the syntax error[s]: Entry-SQL syntax error: a query must start with SELECT

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:469) at com.sap.engine.services.deploy.server.DeployServiceImplp4_Skel.dispatch(DeployServiceImplp4_Skel.java:1511)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:268)

at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:165)

at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:102)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:140)

Caused by: com.sap.engine.services.deploy.container.DeploymentException: <--Localization failed: ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle', ID='Failed to deploy application sap.com/tc_wddispwda. Reason = The SQL statement "insert into TC_WDRR_LAYERS (name, version, predecessor, order_index, deployable_object) values (?,?,?,?,?)" contains the syntax error[s]: Entry-SQL syntax error: a query must start with SELECT

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

at com.sap.engine.services.webdynpro.WebDynproContainer.deploy(WebDynproContainer.java:957)

at com.sap.engine.services.deploy.server.application.DeploymentTransaction.makeComponents(DeploymentTransaction.java:975)

at com.sap.engine.services.deploy.server.application.DeploymentTransaction.begin(DeploymentTransaction.java:586)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:301)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhases(ApplicationTransaction.java:332)

at com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:2945)

at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:454)

... 10 more

For detailed information see the log file of Deploy Service.

07/10/30 02:03:06 - ***********************************************************

Dec 30, 2004 2:03:06 AM Info: End of log messages of the target system.

Dec 30, 2004 2:03:06 AM Info: ***** End of SAP J2EE Engine Deployment (J2EE Application) *****

Dec 30, 2004 2:03:06 AM Error: Execution of deployment action for "tc/wd/dispwda" aborted:

Caught exception during application deployment from SAP J2EE Engine's deploy service:

java.rmi.RemoteException: Cannot deploy application sap.com/tc_wddispwda..

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

; nested exception is:

SQL syntax error: the token "TC_WDRR_LAYERS" was not expected here

(message ID: com.sap.sdm.serverext.servertype.inqmy.extern.EngineApplOnlineDeployerImpl.performAction(DeploymentActionTypes).REMEXC)

Dec 30, 2004 2:03:06 AM Error: Deployment NOT successful for tc/wd/dispwda

Dec 30, 2004 2:03:06 AM Info: SDM configuration: Do not automatically start/stop J2EE Engine. Do not restore state of J2EE Engine now.

Dec 30, 2004 2:03:06 AM Info: -

Deployment was successful -

Dec 30, 2004 2:03:06 AM Info: Summarizing the deployment results:

Dec 30, 2004 2:03:06 AM Error: Admitted: D:\SAPWAS640\SAPinst_WAS\J2EE-CD\J2EE-ENG\ONLINE\SAPJTECHS04_0.SCA

Dec 30, 2004 2:03:06 AM Error: Processing error. Return code: 4

Add a comment

3 Answers

Sort by:

Votes

Newest

Oldest

Best Answer

This answer has been deleted.

This answer has been undeleted.

Former Member

Posted on Feb 10, 2005 at 11:31 PM

2
Hi,

regional settings of the machine should be English..
- Add a Comment
- Alert Moderator
- Share
Add a comment
10|10000 characters needed characters left characters exceeded
4 Comments
- Serdar Simsekler Former Member
  
  Feb 12, 2005 at 08:36 PM
  
  Hi Stefan
  
  My region was set to 'TR'. It seems SAP does not want to see Turkey in EU either :).
  
  *--Serdar
  
  ssimsekler@yahoo.com
  - Like 0
  - Share
  - Alert Moderator
Comment on This Answer

Comment
This answer has been deleted.

This answer has been undeleted.

Serdar Simsekler

Posted on Feb 06, 2005 at 12:48 AM

1
Hi again
Still struggling with the same problem. Any comments???
*--Serdar
- Add a Comment
- Alert Moderator
- Share
Add a comment
10|10000 characters needed characters left characters exceeded
3 Comments
- Daniel Da Vinci Serdar Simsekler
  
  Feb 06, 2005 at 09:43 PM
  
  Hi Serdar,
  
  I agree I believe that this problem is best suited to being posted here.
  
  Take a look at:
  
  sneak-preview-was-64-installation----second-last-s
  
  Interestingly this problem occurred for this user after changing the memory configuration on the host.
  
  Check that you did not use special characters in your passwords etc.
  
  If you did not then try stopping the installation (not reset) reboot the machine and try again... What happens if you try the "Retry" option in the error dialogue box? In the early installs problems like this could be resolved by hitting the retry option a few times, but there is no sense in doing this if it just throws the same error again and again...
  
  Good luck.
  - Like 0
  - Share
  - Alert Moderator
Comment on This Answer

Comment
This answer has been deleted.

This answer has been undeleted.

Former Member

Posted on Feb 09, 2005 at 05:38 AM

1
Hi Serdar,

If u want to install the Sneak Preview in Windows XP Environment, u need Service Pack 1 and not two.

Regards,

Sreenivas.
- Add a Comment
- Alert Moderator
- Share
Add a comment
10|10000 characters needed characters left characters exceeded
9 Comments
- Daniel Da Vinci Serdar Simsekler
  
  Feb 12, 2005 at 04:01 AM
  
  Lets not get carried away.. Broken heart? This is not a valentine day forum is it?? 😊
  
  Glad to see the problem is resolved for you.
  
  Cheers
  
  Daniel
  - Like 0
  - Share
  - Alert Moderator
Comment on This Answer

Comment

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.

Rules of Engagement

Know someone who can answer? Share a link to this question.

Attachments: Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.

Sneak Preview Installation Error at "Deploy Online" Step (SQL Syntax Error)

Add a comment

Assigned Tags

Related questions

3 Answers

Add a comment

Add a comment

Add a comment

Before answering