Sybase Unwired Platform Deployment Error

[Former Member]

Hello,

I'm working on my first project using SUP 2.1. I connect the Hana DB and develop the MBO which is already working well. BUt when I try to deploy the project to My Unwired Server, I get an error : "An error occured deploying package, .pkg to server, My Unwired Server(Exception: Deploy error: runtime_error: -----Unknown error in server runtime: null)".

My Unwired server is running well in the Sybase Control center and ping succeeded in the SUP. I don't know what's going on, can anyone help me?

Thanks.

[Former Member · Accepted solution]

There are several reasons, for package deployment fail , if both attribute mapping and parameter mapping are identical in an MBO relationship or if the data sources bound to MBOs are not up and running, the Deployment wizard will fail.

Solution 1: Investigate the MBO to make sure it is configured correctly, then make corrections.For the example of identical mappings, avoid identical mapping in attributes and parametersthat have a relationship.

Solution 2: Make sure the data sources associated with the MBOs are up and running.

As per your statement that Ping succeeded then the 2nd solution is not relevant.Also check your relay server configurations and if possible try to design a sample application  without any relation ships on HANA DB tables and check whether the deployment succeeds or not if yes then it is problem with your MBO.otherwise you need to check your configurations.

Please let us know your feedback.

Thanks

Santosh

[Former Member · Accepted solution]

I tried another simple application. I used the data in the sampledb and the table "customer" drag and drop to develop a MBO. Then I try to deploy the project to my server. But the error occures again! I think there must be some where wrong about the server configuration.

The relay servers as you mentioned, I have not seen any in the SCC, is that normal?

I attach the error log that may help.

2012-03-30 10:16:39.528 WARN MMS Thread-282 [com.sybase.sup.admin.server.DomainAdminImpl]com.sybase.sup.admin.common.ServerException
at java.lang.Thread.run(Thread.java:662)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:310)
at com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:798)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke(DomainAdminImpl_DJC.java:133)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke_0(DomainAdminImpl_DJC.java:346)
at com.sybase.sup.admin.server.DomainAdminImpl.deployJar(DomainAdminImpl.java:280)
at com.sybase.sup.admin.server.DomainAdminImpl.deployWithArgs(DomainAdminImpl.java:379)
at com.sybase.sup.server.SUPDomain.incrementDomainVersion(SUPDomain.java:814)
at com.sybase.sup.server.SUPDomain.logException(SUPDomain.java:1132)
com.sybase.sup.admin.common.ServerException
2012-03-30 10:16:39.527 WARN MMS Thread-282 [com.sybase.sup.server.SUPDomain]problem opening C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\deploy\webapps\wsh\d1_70.zip
at java.lang.Thread.run(Thread.java:662)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:310)
at com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:798)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke(DomainAdminImpl_DJC.java:133)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke_0(DomainAdminImpl_DJC.java:346)
at com.sybase.sup.admin.server.DomainAdminImpl.deployJar(DomainAdminImpl.java:280)
at com.sybase.sup.admin.server.DomainAdminImpl.deployWithArgs(DomainAdminImpl.java:379)
at com.sybase.sup.server.SUPDomain.incrementDomainVersion(SUPDomain.java:804)
at com.sybase.sup.server.cluster.ClusterUtils.createDsyncDataZip(ClusterUtils.java:1030)
at com.sybase.sup.server.cluster.MMSClusterAdmin.createDomainSyncZip(MMSClusterAdmin.java:394)
at com.sybase.sup.server.cluster.MMSClusterAdmin.createSyncZip(MMSClusterAdmin.java:386)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at org.apache.tools.ant.taskdefs.Zip.execute(Zip.java:410)
at org.apache.tools.ant.taskdefs.Zip.executeMain(Zip.java:490)
at org.apache.tools.ant.taskdefs.Zip.getResourcesToAdd(Zip.java:973)
at org.apache.tools.ant.taskdefs.Zip.getResourcesToAdd(Zip.java:1138)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:98)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:126)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:176)
at org.apache.tools.ant.types.ArchiveScanner.getResource(ArchiveScanner.java:260)
at org.apache.tools.ant.types.ArchiveScanner.scanme(ArchiveScanner.java:319)
at org.apache.tools.ant.types.ZipScanner.fillMapsFromArchive(ZipScanner.java:70)
at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:143)
at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:262)
at org.apache.tools.zip.ZipFile.positionAtCentralDirectory(ZipFile.java:394)
at java.io.RandomAccessFile.seek(Native Method)
java.io.IOException: Negative seek offset
--- Nested Exception ---
... 33 more
at org.apache.tools.ant.types.ZipScanner.fillMapsFromArchive(ZipScanner.java:70)
at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:143)
at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:262)
at org.apache.tools.zip.ZipFile.positionAtCentralDirectory(ZipFile.java:394)
at java.io.RandomAccessFile.seek(Native Method)
Caused by: java.io.IOException: Negative seek offset
at java.lang.Thread.run(Thread.java:662)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:310)
at com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:798)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke(DomainAdminImpl_DJC.java:133)
at com.sybase.sup.admin.server.DomainAdminImpl_DJC.$invoke_0(DomainAdminImpl_DJC.java:346)
at com.sybase.sup.admin.server.DomainAdminImpl.deployJar(DomainAdminImpl.java:280)
at com.sybase.sup.admin.server.DomainAdminImpl.deployWithArgs(DomainAdminImpl.java:379)
at com.sybase.sup.server.SUPDomain.incrementDomainVersion(SUPDomain.java:804)
at com.sybase.sup.server.cluster.ClusterUtils.createDsyncDataZip(ClusterUtils.java:1030)
at com.sybase.sup.server.cluster.MMSClusterAdmin.createDomainSyncZip(MMSClusterAdmin.java:394)
at com.sybase.sup.server.cluster.MMSClusterAdmin.createSyncZip(MMSClusterAdmin.java:386)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at org.apache.tools.ant.taskdefs.Zip.execute(Zip.java:410)
at org.apache.tools.ant.taskdefs.Zip.executeMain(Zip.java:490)
at org.apache.tools.ant.taskdefs.Zip.getResourcesToAdd(Zip.java:973)
at org.apache.tools.ant.taskdefs.Zip.getResourcesToAdd(Zip.java:1138)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:98)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:126)
at org.apache.tools.ant.util.ResourceUtils.selectOutOfDateSources(ResourceUtils.java:176)
at org.apache.tools.ant.types.ArchiveScanner.getResource(ArchiveScanner.java:260)
at org.apache.tools.ant.types.ArchiveScanner.scanme(ArchiveScanner.java:319)
at org.apache.tools.ant.types.ZipScanner.fillMapsFromArchive(ZipScanner.java:74)

[Former Member · Accepted solution]

Hi

  It seems that every boy is facing same problem,can you check whether the filter classes are packaged along with your deployment file.It seems that there are schema mapping issues .May be it needs to be adressed by SAP, see if this below link can be of any help , the below link contains trouble shooting steps for sybase.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01206.0200/doc/pdf/sup_trouble.pdf

Thanks

Santosh

[Former Member · Accepted solution]

It always doesn't work for me. And in my case I don't think there's filter classes. I have only a MBO mapping a table from Hana DB. 

Here's the trace of the error I found from the eclipse error log:

org.eclipse.core.runtime.CoreException: Deploy error:
runtime_error:
----Unknown error in server runtime: null

at com.sybase.uep.tooling.deploy.uepserver.UEPDeploySession.deploy(UEPDeploySession.java:158)
at com.sybase.suade.deploy.core.operations.ExecuteDeploymentOperation.deployPackages(ExecuteDeploymentOperation.java:354)
at com.sybase.suade.deploy.core.operations.ExecuteDeploymentOperation.run(ExecuteDeploymentOperation.java:103)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

[Former Member · Accepted solution]

Haha, I solve the problem myself.

I see there's a line in the log of SCC:

2012-03-30 10:16:39.527 WARN MMS Thread-282 [com.sybase.sup.server.SUPDomain]problem opening C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\deploy\webapps\wsh\d1_70.zip

So I delete this file. And then I redeploy the project and then it succeed. I don't know how.

Thanks anyway.

[Former Member · Accepted solution]

Hi

Good to hear finally you joined the club of people who connected SUP and HANA together, can you provide the document , we are also trying to connect SUP and HANA ,is there any config document for that ,it would be more helpful.and t

Thanks

Santosh

[Former Member · Accepted solution]

To configure the SUP working well with HANA, you have to follow the steps in this link:

Setting up SUP to work with HANA

[Former Member · Accepted solution]

Hi

Thanks for that information, I followed the steps ,but I am missing onelink where in we define JDBC connectionin Sybase Control Center, Under Connections, I chose JDBC from Pool type and database as DB2 template gave JDBC connection details , username and password but could not find what to give for Driver class , what do I need to give in the driver class where do I get the driver class for ngdbc.jar.

Awaiting your feedback.

Thanks

Santosh

[Former Member · Accepted solution]

Hi,

For me, in the field of Driver Class, I input: "com.sap.db.jdbc.Driver"

For the ngdbc.jar, normally you will find it under this directory: C:\Program Files\SAP\hdbclient\ after you installed the Hana Client.

[Former Member · Accepted solution]

Hi

  Ok, I will try with that , Yes the fle is present in the same path for me .Apart from his any configurations needed ,because I could not find the driver class any where does it need to be present in the same path where ngdbc.jar exists or it does not matter ,please let me know if any extra configuration is needed to load the class drivers,because I faced class could not be found exception when I tried  before.

If possible can you paste the screen shot of your "hdbclient" folder so that , I can match it with the my folder structure and  see if any thing is missing .

Thanks

Santosh

[Former Member · Accepted solution]

Hi

I was successfully able to connect both HANA and SUP.But when I dragged a table from HANA to build a mobile business object it throws me an error

"This operation may not valid SQL statements for a non-Sybase database, and requires manual

editing. do you want to continue?". looks like a simple warning that  may not matter, so I clicked "OK".

The following "Problem Occurred" window appears: "'Generate Mobile Business Object' has encountered a problem. In internal error occurred during: 'Generate Mobile Business Object'." the details reveals  java.lang.RuntimeException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "SCHEMAS": line 3 col 34 (at pos 72)

and the MBO does not create any Attributes and Operations.Request your help in this regard

Thanks

Santosh

[Former Member · Accepted solution]

Hi,

It seems that SUP doesn't work very well with Hana. So you can't directly drag and drop a table from the database. For me, I created the MBO manually (New ->Mobile Business Object), and then choose the connection profile and use the SQL query to bind the data. It works this way.

[Former Member · Accepted solution]

Hello

  Yes, I tried this way but the select operation and I did it using other operation and I gave my SQL query , while configuring properties for the Workflow diagram we have two options Invoke by object and invoke by operation I selected Invoke by operation and used the select operation which I defined , is it the same way or any other config needs to be done apart from this.

Thanks

Santosh

[Former Member · Accepted solution]

Hi

Thanks for your support,finally I was able to deploy my workflow app in Android emulator.

Thanks once again.

Santosh

[amey_baisane · Accepted solution]

Hello Santosh,

I have tried to open the link provided by Zhaochuan Ding

"Setting up SUP to work with HANA"

But it is borken.. Could you please provide me the link or any document with talks about the SAP HANA and SUP integration

Kind Regards,

-Amey

[former_member199619 · Accepted solution]

Hi Santosh,

"Setting up SUP to work with HANA" is broken link. Can you please provide me the correct link.

Regards,

Shyam

[hofmann]

Hi,

the DB driver is also configured and working on the server or only on the SUP Dev Workplace?

[Former Member]

I think the DB driver works well. I followed all the configurations in this link Setting up SUP to work with HANA. And in the SUP workspace -> Data Connections , I can see my Hana DB and the tables as well. In the SCC -> Domains -> Connections, I also see my Hana and Ping succeded.

So I think my configuration for the HANA DB has no problem.