Problem creating application using Design Studio 1.5 on HANA

[former_member532630]

Hi All,

We are running HANA SPS09, path 095 and are trying to connect Design Studio 1.5 to SAP HANA, connectivity seems OK but as soon as we create an Application we are receiving an immediate error, see the error log below!

Has anyone experienced this before?

FYI, I installed DS 1.5 on a clean (new) system!

Thanks!

Event Details:

Plug-in: com.sap.ip.bi.zen.ui

Severity: Error!!

Message: Failed to create the application.

Exception Stack Trace:

com.sap.ip.bi.zen.connectivity. ConnectivityException: Error in HTTP communication

URL: http://(HANA-SystemName):8000/sap/bi/aas/rt/repo.xsjs

Response code: 500

Reason: "Failed to retrieve activation time of application TEST: devObject is null"

    at com.sap.ip.bi.zen.backends.hana.HanaSystem.callApi(HanaSystem.java:691)

    at com.sap.ip.bi.zen.backends.hana.HanaSystem.getLastModifiedTime(HanaSystem.java:425)

    at com.sap.ip.bi.zen.backends.hana.HanaSystem.createApplication(HanaSystem.java:343)

    at com.sap.ip.bi.zen.ui.internal.util.ExportImportHelper.importApplication(ExportImportHelper.java:612)

    at com.sap.ip.bi.zen.ui.internal.commands.NewApplicationHandler.createNewApplication(NewApplicationHandler.java:110)

    at com.sap.ip.bi.zen.ui.internal.commands.NewApplicationHandler$1.execute(NewApplicationHandler.java:57)

    at org.eclipse.ui.actions.WorkspaceModifyOperation$1.run(WorkspaceModifyOperation.java:106)

    at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

    at org.eclipse.ui.actions.WorkspaceModifyOperation.run(WorkspaceModifyOperation.java:118)

    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Session Data:

eclipse.buildId=@qualifier@

java.version=1.7.0_76

java.vendor=SAP AG

BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US

Framework arguments:  BusinessObjects Design Studio

Command-line arguments:  -os win32 -ws win32 -arch x86_64 BusinessObjects Design Studio

Event Details

Plugin: org.eclipse.equinox.ds

Severity: Info

Message: Could not bind a reference of component com.sap.ip.bi.base.application.DeclaredServiceActivator. The reference is: Reference[name = IActivatorBase, interface = com.sap.ip.bi.base.bundle.IActivatorBase, policy = dynamic, cardinality = 0..n, target = null, bind = addRICActivator, unbind = removeRICActivator]

[former_member532630 · Accepted solution]

Hi All,

Seems an Authorization issue, after granting all *xs* roles to user profile / role (in our case we created an Application role) the application creating is working as expected.

we'll need to determine which exact xs role was missing, once determined we'll update the correct answer.

Cheers,

Peer.

[PPaolo · Accepted solution]

Hello,

can you check if you added the package privileges for the "designstudio" package to your user?

You add the designstudio package in the user (or role) profile under Package Privileges and then you give the following rights:

REPO.READ

REPO.READ_IMPORTED_OBJECTS

REPO.ACTIVATE_IMPORTED_OBJECTS

REPO.MAINTAIN_IMPORTED_PACKAGES

This fixed the problem for me without adding the xs privileges (and btw this is specified in the DS1.5 on HANA user guide).

Hope that it helps

PPaolo

[dmitry_kuznetsov1 · Accepted solution]

Yes, Admin Guide, section 5.2 Setting Permissions for Analysis Applications

[chandrasekhar6 · Accepted solution]

Thank you lot Pierpaolo

[former_member193885]

Hi Peer,

Are you connecting to HANA in local mode or HANA Platform mode from DS?

Thanks.    

[former_member532630]

Hi,

HANA Platform mode.. SPS09 (095)

Thanks.

[former_member193885]

Can you check and make sure the HCO_INA_SERVICE delivery unit on HANA is also updated to the latest version of HANA SPS 9.

Second part of the document (this is for AO 2.0, but the steps are the same from a HANA standpoint) below has steps on importing this delivery unit.

[former_member532630]

Hi Deepu,

Both have been installed.. we have just found the issue.. will create a correct Answer as soon as we know exactly which roles where missing.

to be continued.

Thanks,

Peer.

[TammyPowlas]

Could it be some privileges are missing? See SAP Note http://service.sap.com/sap/support/notes/2141541 for details

Also SAP Note http://service.sap.com/sap/support/notes/2154859 provides a troubleshooting checklist for HANA/Design Studio

[former_member532630]

Thanks for the fast response, will investigate and test..

Especially the Privileges note looks promising, do believe I have already fixed all of SAP NOTE #2..

Will let you know asap, To be continued.

[former_member532630]

Hi Tammy,

Unfortunately, neither one of the SAP Notes have resolved the issue.

It looks we are missing some HANA and or Local Client Components, not sure! We'll keep investigating.

Thanks,

Peer.

[TammyPowlas]

Hi Peer - I am sorry to hear; you may want to open a SAP incident with SAP to investigate further; your version of HANA is supported in accordance with the Design Studio PAM

[Former Member]

Hi Peer

has installed it on our HANA environment a while back. Foeken, did you encounrer these issues?

Sjoerd

[former_member532630]

Hey Sjoerd,

Nice! Does it work?

Could be HANA, but I do believe we have all components installed (maybe a mis-config), could also be some client component maybe that came with a previous release (I installed a new DS 1.5 client on a new system).

Cheers,

Peer.

[abe_letkeman]

Thank you, Tammy.

For HANA rev 97 and design studio 1.5, note 2141541 resolved the authorization problem I had trying to search for data sources.

[chandrasekhar6]

Thank you so much Tammy