Skip to Content
author's profile photo Former Member
Former Member

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

Hi with problems again

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

At the last step <b>"Deploy Online" of Sneak Preview Installation</b>, 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

<u><b>Log Entry:</b></u>

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

<b>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/tcwddispwda..

Reason: <--Localization failed: ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle', ID='Failed to deploy application sap.com/tcwddispwda. 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/tcwddispwda. 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/tcwddispwda. 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/tcwddispwda. 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)</b> 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/tcwddispwda. 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/tcwddispwda. 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/tcwddispwda..

Reason: <--Localization failed: ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle', ID='Failed to deploy application sap.com/tcwddispwda. 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/tcwddispwda. 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/tcwddispwda. 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/tcwddispwda. 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

(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</b>

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
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 11:31 PM

    Hi,

    regional settings of the machine should be English..

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 06, 2005 at 12:48 AM

    Hi again

    Still struggling with the same problem. Any comments???

    *--Serdar

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2005 at 05:38 AM

    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
    10|10000 characters needed characters exceeded

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.
You must be Logged in to submit an answer.

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