Data Source compact display problem

[Former Member]

Hi ,

There is a CrossTabs in my app ( I'm developing my application in SAP BusinessObjects Design Studio, ver. 1.6 ).

Also I have a datasource (BEx). I need to use "compact display" mode. See picture 1.

Pict.1.

Also there is  activated hierarchy.

My cross tab in run-time looks correct, but then a press on a leaf (red rectangle on Picture 2) it occurs an error.

"On select" event just simple row:

APPLICATION.alert("1") ;

Pict. 2.

Pict. 3. Error message after click:

Here is a text from log:

"(Error: N/A 99998)" and many many other rows, but there is no directly information.

Then I change back mode to full view (NOT compact view), then it works correctly.

See next image (full view of cross tab):

Picture 4.

So, my question is what should I do in cross tab settings or datasource to fix this problem?

[TammyPowlas]

Are you running this locally?  Have you reviewed the logs?  Are you using SP1 for Design Studio?  If not I would apply SP1 first

[Former Member]

Tammy,

thank you for quick reply.

SP1 - yes. it is already has been installed.

Logs. there is only system technical information. top part of log is below:

!STACK 0

org.apache.axis2.AxisFault: getSAPAssertionTicket Исключение известного происхождения. (Error: N/A 99998)

  at com.businessobjects.dsws.Consumer.dswsExceptionDocToAxisFault(Consumer.java:876)

  at com.businessobjects.dsws.session.Session.getSAPAssertionTicket(Session.java:1329)

  at com.sap.ip.bi.zen.backends.bip.BiPlatformSystem.getSingleSignOnTicket(BiPlatformSystem.java:1626)

  at com.sap.ip.bi.zen.connectivity.backends.LogonInfoCompleter$1.getSSOTicket(LogonInfoCompleter.java:234)

  at com.sap.ip.bi.zen.connectivity.backends.PropertiesWithDynamicCreds.getUserProperty(PropertiesWithDynamicCreds.java:61)

  at com.sap.ip.bi.zen.connectivity.backends.PropertiesWithDynamicCreds.getProperty(PropertiesWithDynamicCreds.java:82)

  at com.sap.conn.jco.rt.DefaultDestinationManager.isPropertyValueEqual(DefaultDestinationManager.java:486)

  at com.sap.conn.jco.rt.DefaultDestinationManager.compare(DefaultDestinationManager.java:456)

  at com.sap.conn.jco.rt.DefaultDestinationManager.update(DefaultDestinationManager.java:234)

  at com.sap.conn.jco.rt.DefaultDestinationManager.searchDestination(DefaultDestinationManager.java:372)

  at com.sap.conn.jco.rt.DefaultDestinationManager.getDestinationInstance(DefaultDestinationManager.java:93)

  at com.sap.conn.jco.JCoDestinationManager.getDestination(JCoDestinationManager.java:83)

  at com.sap.ip.bi.base.application.service.rfcproxy.impl.jco3.connection.StandaloneConnectionFactoryJCO.createConnection(StandaloneConnectionFactoryJCO.java:258)

  at com.sap.ip.bi.base.application.service.rfcproxy.impl.jco3.connection.StandaloneConnectionFactoryJCO.createConnection(StandaloneConnectionFactoryJCO.java:56)

  at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getVirtualConnectionInternal(GenericConnectionPool.java:224)

  at com.sap.ip.bi.base.service.connection.impl.StandaloneConnectionPool.getConnectionInternal(StandaloneConnectionPool.java:59)

  at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getConnectionOrCreateOneIfRequested(GenericConnectionPool.java:179)

  at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getConnection(GenericConnectionPool.java:149)

  at com.sap.ip.bi.base.application.impl.ServiceManagement.fetchConnectionResource(ServiceManagement.java:928)

  at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServices(ServiceManagement.java:496)

[TammyPowlas]

Is this from the BI Platform?  I recommend following the steps outlined in this wiki for troubleshooting: Design Studio BI Platform Support - Business Intelligence (BusinessObjects) - SCN Wiki